hcdbs.com

tomaslind.net

Insurance Archives - Tomas Lind

http://tomaslind.net/category/insurance

About – Tomas Lind. Posts in Category ‘ Insurance. Calculating Earned Premium in SQL Server. In most business, when a company receives payment for a sold product, that payment can be considered an income. But to an insurance company, only the part of the premium that has been earned (Earned Premium) can be considered as … Read more →. High Coast Database Solutions. High Coast Database Solutions. Toggl Time entries to SQL Server. From PowerShell to SQL Server tables. Split strings to columns.

tomaslind.net

Tips & Tricks Archives - Tomas Lind

http://tomaslind.net/category/sql-server/tips-tricks

About – Tomas Lind. Posts in Category ‘ Tips and Tricks. Toggl Time entries to SQL Server. Toggl is a very simple to use cloud based time tracking application. Time entries on projects and clients can be submitted through the web page or through mobile and desktop applications. Time spent by the team can be viewed in … Read more →. Split strings to columns. A short demo on how to split strings with delimiters into columns. Send email when log or data file grows. Sysdm exec cached plans. This post contain...

tomaslind.net

Sending HTML tables in mail from SQL Server - Tomas Lind

http://tomaslind.net/2015/06/26/sending-html-tables-in-mail-from-sql-server

About – Tomas Lind. Sending HTML tables in mail from SQL Server. This post contains a template for sending HTML tables via mail in T-SQL. A prerequisite is that you have created a Database Mail Profile. If you don’t have an email server available, you can use Gmail instead as demonstrated here. The system stored procedure msdb.dbo.sp send dbmail. Let’s start with some sample data. Run the following script to create a database and table with some sample customer data:. HTML Email Demo Customers Table.

tomaslind.net

Calculating Earned Premium in SQL Server - Tomas Lind

http://tomaslind.net/2015/06/30/calculating-earned-premium-in-sql-server

About – Tomas Lind. Calculating Earned Premium in SQL Server. In most business, when a company receives payment for a sold product, that payment can be considered an income. But to an insurance company, only the part of the premium that has been. Earned Premium) can be considered as income. The rest is the. Premium, or the premium reserve. How the premium is earned vary between insurance products and industries. Here I’ll show a couple of methods and how they are calculated in SQL Server. 3,28 * 180 = 591.

tomaslind.net

Capturing Blocked Queries - Tomas Lind

http://tomaslind.net/2015/05/15/capturing-blocked-queries

About – Tomas Lind. In a previous post. I presented a solution for monitoring and logging long running queries in SQL Server. In this post I’ll show an extended version of that solution that also sends an email when a request has been blocked for more than 20 seconds. Be sure to read the the original post. About long running queries before implementing the solution outlined here. Note that the goal with this solution, and the one for long running queries, is to catch blocks that affect the user experienc...

tomaslind.net

Dynamic Management Objects Archives - Tomas Lind

http://tomaslind.net/category/sql-server/dynamic-management

About – Tomas Lind. Posts in Category ‘ Dynamic Management Objects. Dynamic Management Views and Objects. Sysdm exec cached plans. The dynamic management view sys.dm exec cached plans returns information on query plans currently in memory. This information can be useful for a lot of reasons: checking total memory allowed for cached plans, which plans aren’t getting reused, searching for certain query plan … Read more →. Capturing Long Running Queries. Mass editing of SQL Server objects. Some server wide ...

tomaslind.net

Alerts Archives - Tomas Lind

http://tomaslind.net/category/sql-server/alerts

About – Tomas Lind. Posts in Category ‘ Alerts. In a previous post, I presented a solution for monitoring and logging long running queries in SQL Server. In this post I’ll show an extended version of that solution that also sends an email when a request has been blocked … Read more →. SQL Server Alert not firing. When you set up SQL Server alerts on your SQL Server instance, make sure to run some tests to verify that they are actually firing when errors occur. Script to configure SQL Server Alerts.

tomaslind.net

How to fill in gaps in time series - Tomas Lind

http://tomaslind.net/2015/07/07/how-to-fill-in-gaps-in-time-series

About – Tomas Lind. How to fill in gaps in time series. In some cases it is necessary to have an unbroken time series, for instance to have all days during a year. But what if some days are missing from the data? How can we fill in gaps in time series? By using a Numbers function. In T-SQL, we can fill in the gaps in a serie of values. A common example is a time series of days, but any incrementing series of values can use the method I’ll describe in this blog post. And returns that many rows. DECLARE @S...

tomaslind.net

T-SQL - Tomas Lind

http://tomaslind.net/t-sql

About – Tomas Lind. Leave a Reply Cancel reply. Required fields are marked *. Notify me of new posts by email. High Coast Database Solutions. High Coast Database Solutions. Toggl Time entries to SQL Server. From PowerShell to SQL Server tables. Split strings to columns. How to align columns in Notepad. Swedish Standard Industrial Classification (SNI koder). Automate BPA Server (2). Change Data Capture (CDC) (3). Dynamic Management Objects (9). Master Data Services (MDS) (4). System Stored Procedures (11).