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

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

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

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

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

Backup Database Object

I saw this question in one of forums on backing up i.e. scripting out a database object. The problem is...

Better Living Thru Powershell: Update Statistics in Parallel

As part of a project I’m currently involved with, we’re migrating a database to SQL Server 2008 and performing some...

Book Review: American Icon: Alan Mulally and the Fight to Save Ford Motor Company

American Icon: Alan Mulally and the Fight to Save Ford Motor Company ($18 at Amazon) was a good read, with...

Choosing the Right Microsoft Reporting Technology Part 5: Power View

In part five of this on going series about choosing the right reporting tool we will discuss the newest of...

ColoradoSQL–April 2012

All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...