SQL Family: The Wonder Years

Last week, Bill Wolf aka @SQLWareWolf and I somehow got onto the topic of High School pictures. So in jest, I...

Text Mining Loch Ness Monster Sightings

Text Mining with RapidMiner for Loch Ness Monster Sightings
Text mining involves pulling root words from text in a system.  In...

Azure SQL Database monitoring

Even though an Azure SQL Database stores all data on the Azure cloud, it does not mean that your options for managing...

Changing to simple recovery to clear the log.

Clearing out a full transaction log is a common problem. A quick search will find you dozens of forum entries...

CROSS APPLY v InLine Functions

While working on the Advent of Code problems in SQL, I ran across something interesting. Day 4 involves hashing, which...

How Bad Are Your Indexes?

In my last post "Copying SSIS packages With DTUTIL" I described a "gotcha" where the dynamic management views (DMVs) had...

Loading a Text File from T-SQL

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

On the addition of useless where clauses

I remember a forum thread from a while back. The question was on how to get rid of the index...

SQL Server Security Principals Lightning Round Presentation

Thanks for attending tonight's joint meeting of the Baton Rouge .NET/SQL/PowerBI User Groups, which was sponsored by Idera!

I presented a...

and other pointless query rewrites

In a similar vein to last week’s blog post… I heard an interesting comment recently. “Change that Column != 2 to...