Great User Group Meeting Tuesday, Now on to Madison and SQL Saturday #118

Minnesota SQL Server User Group Meeting Review (4/17/12) First of all, I have to thank the awesome speakers who presented...

More IMPORTANT miscellaneous info

 
This is a first blog for this month, yes I was busy with Powershell quiz and some other personal stuff.

Okay,...

PowerShell: Using Exponents and Logs to Format Byte Sizes

In a recent Scripting Games event, I had to format some byte values into their most appropriate size according to...

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

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