script system object in resource database

When I troulbshooting the logshipping problem, I found many logshipping store procedure can not be found in the master or...

Spend two hours with me at #sqlsat107.

In just two days SQL Saturday 107 will be in full swing.  Tomorrow begins their precon with the infamous Kalen...

SQL Server 2012 Performance Test: Gap Detection

Next up on the SQL Server 2012 Performance testing circuit: Gap Detection. You know, where you find missing values from...

Tribal knowledge is no knowledge

I've run across several incidents in the last couple of months regarding something that is typically called "tribal knowledge." This is...

Using sys.dm_exec_requests to find a blocking chain and much more

As with every good DBA's toolbox, my blocking list query using sys.dm_exec_requests is evolving.

I've added the following features:

The query execution...

Welcome IIF() to SQL Server Family

IIF() function is new to SQL Server family of functions. It is a brand new logical function being introduced with SQL Server 2012 that allows you to perform IF..THEN..ELSE...

Why Isn’t There A Deployment Server Edition For SSIS Projects?

Andy Leonard blogged about a gotcha when creating SSIS projects using SSDT yesterday. He showed that you can use any...

Custom TDS Endpoints: Listening on multiple ports

Last time, I talked about how clients communicate with SQL Server through TDS endpoints and how to disable endpoints to...

Log shipping setup problem

Last week, our log shipping setup had a problem, so I spent some time to dig into the log shipping....

Microsoft Certified Solutions Associate – SQL Server 2008 Core / Windows Server® 2008

Yesterday, I received two mails from the Microsoft Certification Program Team about two new certification earned:
1. Microsoft Certified Solutions Associate...