Notification for missing database backups

I got a question today about sending notifications from SQL Server when there are databases which have not been backed up in the past 24 hours.

The solution is simple – schedule an SQL Server Agent job which uses Database Mail to send emails if there are missing backups. All you have to do in the

Continue reading […] Notification for missing database backups […]

 

Book review: SQL Performance Tuning techniques using wait statistics, Types and Queues

The real professional inspiration comes not from quantity but from quality. This becomes even more obvious by the thin book written by Rick A. Morelan and Pinal Dave on ‘SQL Performance Tuning techniques using wait statistics, Types and Queues’.

 

The topic is indeed one of the most often misunderstood and underestimated ones in performance tuning; and

Continue reading […] Book review: SQL Performance Tuning techniques using wait statistics, Types and Queues […]

 

SSIS package ignores the decimal points value

Background: I am importing data from a csv file to SQL Server. Some of the columns in the csv file are obviously of the decimal data type and look like 123,12.

Problem: I wrote a SSIS package to import the data, everything imports without error, but the data in the table does not contain anything but

Continue reading […] SSIS package ignores the decimal points value […]