Focusing on a Different S Curve

At the beginning of the year, I took a step back and looked at how far my career had grown. In large part because of the incredible data community,...

Book Review – Scalable Data Analytics with Azure Data Explorer

I recently finished the book Scalable Data Analytics with Azure Data Explorer (Modern ways to query, analyze, and perform real-time data analysis on large volumes of data), written by...

How To Identify The Grain

Creating a data warehouse can be challenging. Identifying the grain is one of the most important parts of having a quality data...

T-SQL Tuesday #165: Database Job Titles Roundup

This month I prompted bloggers to talk about what database job titles mean to them. Thank you to all who posted on this topic! Don’t worry; if you still...

Fill Out The State of the Database Landscape Survey and Maybe Win

If you’re like me, you sometimes wonder how different other environments are from the one I work in. Well, the ones I used to work in. These days I...

SQL Server Patching

Why should you patch your SQL Server instances? Compliance, stability, security, reliability, functionality, and more. Microsoft regularly releases updates to SQL Server known as Cumulative Updates (CUs). Cumulative updates...

How to check if powershell is running as administrator with elevated privileges

How to check if powershell is running as administrator with elevated privileges

In case it's not clear from the title, I am referring to...

Yet another newsletter

I’ve been thinking about starting a newsletter for a while now. I want to focus on summaries and what stood out for me from among the many cool talks...

Decrypting Stored Procedures The Cumbersome Way

I had a client that was struggling with some encrypted stored procedures. They needed to decrypt them, which I know is a pain in the #@$%@#$@#$#@. I had to...

Finding a History of Database Snapshots, Taken and Restored

This is a question that’s come up twice this morning, firstly where can we find a history of database snapshots and secondly where can we find a history of...