14 years of Summit…

I have been trying to get my blogging going again after a gap of two months. It has been incredibly...

SSIS ForEach Enumerator File Order

I saw on slack recently a question about how the ssis file enumeraror orders (or more specifically doesn't order) files. I have been thinking about ssis quite a lot...

SQLCLR vs. SQL Server 2017, Part 5: “Trusted Assemblies” – Valid Use Cases?

In the previous post in this series on SQLCLR in SQL Server 2017 — Part 4: “Trusted Assemblies” — The Disappointment — we...

Working with the registry in SQL Server – adding trace flags to startup parameters

In a recent post, I introduced you to how to work with the registry directly from within SQL Server. Continuing...

A Trip Across the Pond for the Community Hub

The Redgate Community Hub is out, and people are starting to use it. It’s a an idea that we think...

DBCC CHECKDB Azure SQL Database

Who should be running DBCC CHECKDB for Azure SQL Database? Should it be Microsoft or should customers be scheduling it?...

Checklist: DR Plan Sanity Check

If a disaster struck tomorrow, are you ready for it? Are you sure you thought of everything? I cannot count...

CISL 1.5.0 is released

I am glad to share that the 1.5.0 release of the CISL (Columnstore Indexes Scripts Library) is finally released.

The biggest...

Truncate vs Delete in SQL Server: What’s the Difference?

I’ve been using TRUNCATE TABLE to clear out some temporary tables in a database. It’s a very simple statement to...

HTTP 403 error – PowerShell Remoting, Different Domains and Proxies

On my day to day work I use Nagios monitoring software. I want to add some custom SQL Server scripts...