Log shipping setup problem

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

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...

Urgent BIOS Update for Dell PowerEdge R810, R910 and M910 Servers

If you have an 11th generation Dell PowerEdge R810 , PowerEdge R910 server, or a PowerEdge M910 blade server, there is...

sys.sql_modules vs. INFORMATION_SCHEMA.Routines

Consider the following two queries meant to search for a keyword in SQL programmability objects.
select s.name +'.' + o.name, o.type_desc, m.definition

from sys.sql_modules...

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...

Visualize Wait stats with Microsoft Excel

In our blog post last week: Instance Wide Wait Stats we promised to show You how to visualize the collected...

SQL Server 2012: Certification Upgrade Info

As a follow-up to my SQL Server 2012: New Certification Info, Microsoft Learning has announced the certification tracks for the SQL Server...

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...

SQL Injection Tools

I wouldn’t recommend you use any of the tools in this article for attacking anyone, but they could help you...

Professional Productivity Books

Just as with the "soft skills" books, in my professional development presentation, I list the professional productivity books that I have found most helpful in my...