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

Script Corner - Date format

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

Mentoring starts

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

Automated Restore Script Output for Ola Hallengren’s Maintenance Solution

Intro
This blog post is designed to be useful to two different audiences:
Those implementing Ola Hallengren’s Maintenance Solution for the first timeThose...

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

SQL Prompt – Killing the Detail Box

I love SQL Prompt and use it constantly. When I don’t have it, my code writing process slows to spurts...

Have you tried DLM Dashboard?

DLM Dashboard is a new product from Redgate Software that’s free. Free as in beer, which should be attractive to...

Types of NoSQL databases

A NoSQL database provides a mechanism for storage and retrieval of data that is modeled in means other than the...

Quickly Check If SSL For SQL Is Enabled - WaterOx Consulting

Reading Time: 2 minutesTo quickly check SSL is configured on your SQL Server you can...
The post Quickly Check If SSL...

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