Objects dependency check up in SSMS

It’s a very good practice that you check the dependencies of the other objects when you change an object. Many developers just don’t do it, even when the change(s)...

Simple Way to Decrypt SQL Server Stored Procedure

When stored procedures are created in SQL Server, their entire text body is accessible to all those who have the...

SQL Server Random Workload Generator

Hello Dear Reader!  Before I start this blog I want to give credit to Jonathan Kehayias (@SQLPoolBoy | Blog).  He’s an Microsoft Data Platform MVP, MCM,  part of the...

SQLSaturday Pensacola Up Next For Me, Baton Rouge on the Horizon

Looking forward to the triumphant return of SQLSaturday Pensacola on June 4, thrilled that this start-of-summer tradition is back! This has been...

The Mysterious Black Box of R - For the SQL Server Guy

Took a class from Jamey Johnston @ SQLSaturday #516 in Houston. Lots of great information covered. Follow him for a much...

Minimum Memory Grant Query Hint

This month Wendy Pastrick is the host for T-SQL Tuesday #78. This month we have to “learn something new and blog...

Power BI Takeover–Webinar Recording and Q&A

Last week I did a little experimental webinar that was outside our (Pragmatic Works) norm.  Instead of our traditional 1...

Speaking about Power BI @ ITPROceed 2016

I’m delighted to announce that I’ll be giving a session at this year’s ITPROceed. For those who don’t know this...

Minion CheckDB Beta

Come meet Codex! We’ve had many of you asking to be part of the Minion CheckDB beta and now is...

Re-Evaluating Best Practices

I was reading a blog post from my friend Randolph West (b/t) on Best Practices and a thought struck me.

Starting...