Introduction to SQL Server 2012 – Webcast Resources

First, I would like to thank everyone for joining my webcasts today. Very much appreciated. Secondly, I would like to...

Parsing Glenn Berry’s Diagnostic Information Queries With PowerShell

Do It In Bulk
I usually don’t run queries on just one server. Most of the time I need to get...

PASS Business Analytics Conference Live Blog

Apologies if you went to my site this morning to see my blog from the bloggers table at PASS Business Analytics...

Reblog: April 5 to April 11

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer...

SQL Saturday#197–Omaha Recap

This was the second SQL Saturday hosted in Omaha.  I loved to see how the event grew from the first...

SQL Server – Add Date/Time to output file of BCP / SQLCMD (2)

Last time I posted about How you can add date/time to output file name, in which I used xp_cmdshell to...

UNPIVOT a table using CROSS APPLY

I generally spend part of each day looking through http://www.stackoverflow.com, http://dba.stackexchange.com or http://www.sqlservercentral.com. I read through questions that have already...

Entertainment for the Traveling Consultant (UltraViolet Review)

Like many of us, I have a collection of favorite movies. These include Ghostbusters, Stripes, Serenity, and dozens more. I...

I See BI People

A tweet from Ted Krueger (Blog | @Onpnt) this morning…
I’m surrounded by BI people!!!!#passbac
— Ted Krueger (@onpnt) April 11, 2013

inspired a little creativity…

 
You...

PowerShell – CHECK, START and STOP SQL Services of a remote servers

Replace a valid server name in the following examples. Try to do a testing on your local machine and understand...