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

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

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

Extended Events and Data Types

Today is another one of those installments in the long-running TSQL Party held monthly (a.k.a TSQL2SDAY). This month we have an open invitation from Mike Donnelly (blog | twitter), asking...

Extended Events and Data Types

Today is another one of those installments in the long-running TSQL Party held monthly (a.k.a TSQL2SDAY).
This month we have an open...

T-SQL Tuesday #65 – Overcoming Variable Limitations in SQLCmd Mode

It’s time again for that T-SQL blog party T-SQL Tuesday, and this month’s host is Mike Donnelly (blog|@SQLMD). If you...