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

Excel Power Map vs. Power BI Globe Map visualization

[2016-02-02] PowerMap in Excel is a great tool with good design and comprehensive user experience. I’ve started using it about...

Limitation of In-Memory OLTP in SQL Server 2016 – Seed and Increment value other than 1 not supported

Hi friends, in this blog we will discussed another limitation of In-Memory OLTP that seed and increment value other than...