Good things should be appreciated–SQL sentry Plan Explorer TIP #95

Although , It is out of box but I would like to share here. I am very choosy in food. When...

Mentoring starts

Just would like to take a moment to say thank you to Paul Randal, who is busy with his own...

Received 2nd MVP Award for SQL Server - Zum 2. Mal ausgezeichnet mit dem MVP-Award für SQL Server

Script Corner - Date format

Every now and then we will need to convert datetime to string for display, and would you remember all the...

SQL Server 2014 SP1 released, and revoked

Just a brief note today to point to an article by Time Ford on SQLMag.com announcing that SQL Server 2014 SP1 has...

Stupid T-SQL Tricks – Part 3: A Zodiacal SQL

Today we’ll learn how you can use T-SQL to calculate your zodiac sign from your birthdate.
“Heeeeeere’s Johnny!” – Ed McMahon introducing...

Trust No One Implicitly

At the Charlotte BI Group meeting last night, one of the questions I was asked after I gave my talk...

Audit who Dropped the Database

In the first article on this topic (which can be read here), I discussed the problem of having a database...

Deleting Files Older than X Hours with PowerShell

(aka "OMG I can't believe I am actually finally writing a #PowerShell blog post").

--

I currently have a situation at a...

HammerDB Performance Collection with SQL Server

Recently, my friend Mike Fal ( b | t ) released a PowerShell script that can sample the counter inside SQL Server that...