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

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

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

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

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

Upcoming speaking events

Back in March I did my first “feature length” presentation at SQL Saturday Iceland
At that point I’d done a few...

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

DBCC CloneDatabase for SQL Server 2012

Dear All,In case you are wondering, title of the post is not a typo 🙂 DBCC CloneDatabase is going to be available for SQL Server 2012 :)For folks who...

DBCC CloneDatabase for SQL Server 2012

Dear All,In case you are wondering, title of the post is not a typo 🙂 DBCC CloneDatabase is going to be available for SQL Server 2012 :)For folks who...

DBCC CloneDatabase for SQL Server 2012

Dear All,

In case you are wondering, title of the post is not a typo 🙂 DBCC CloneDatabase is going to be...