It’s T-SQL Tuesday time, and this month’s host, Boris Hristov (blog|twitter) chose the topic of interviews. Over the time as a SQL Server...

This Thursday, 10AM GMT, I will be hosted by Dell’s Richard Douglas (blog|twitter) for a webcast. I will present my session called “Small...

Ever needed to install and configure an SQL Server instance environment, including the operating system? If you asked me to estimate the...

Earlier this week, I delivered a presentation called “Query Progress Tracking in SQL Server” to my local user group. Among other...

This script displays the last date and time of each backup type for each database. It’s useful when you need to know quickly when a...

Let’s say you are developing an SSIS package on your dev box to load data from an Excel file to SQL Server. For this example, let’s...

I don’t like the MERGE statement. The syntax is weird, it’s tricky in terms of locks, and it has a history of weird errors. The other day...

Here’s a newsflash: You may not thing so, but you are expensive. There’s no point in endless performance tuning. I love performance...

It’s 2014 now. I hope you had fun in new year’s eve. 2013 was an amazing and intense year. To recap it, I thought about sharing some of...

It’s 2014 now. I hope you had fun on New Year’s Eve. 2013 was an amazing and intense year. To recap it, I thought about sharing some of...