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

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

How Do You Visualize Abstractions?

#SQLNewBlogger
Some time ago, my kids asked me what I do for a living. I told them I work with databases.
“What’s...

Null, empty string, or zero?

The answer: It Depends.
One of the more common problems I encounter when managing data quality, especially in an ETL process,...

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

SQL New Blogger Digest - Week 2

I didn’t intend for last week’s digest to also be my post for week two of the challenge, but life got in the way and I wasn’t able to...