Speaking at the first Belgian SQLSaturday!
I’m delighted to announce that I’ll be giving a session at the very first SQLSaturday (aka SQLSaturday 505) in Belgium....
2016-02-15
497 reads
I’m delighted to announce that I’ll be giving a session at the very first SQLSaturday (aka SQLSaturday 505) in Belgium....
2016-02-15
497 reads
A few weeks back, the folks at Apress Publishing sent me a copy of the book Expert Performance Indexing in...
2016-02-11 (first published: 2016-02-02)
2,073 reads
One of the smaller announcements amidst the gazillion new features of SQL Server 2016, is that SSMS is now a...
2016-02-03
620 reads
Recently I got my hands on a copy of Extending SSIS with .NET Scripting, written by SQL Server MVP Joost...
2016-01-29 (first published: 2016-01-21)
2,860 reads
SQLKover update: For some reason, this was my most popular blog post on the old LTD site. Over 110,000 views. People...
2016-01-28
859 reads
Here is an overview of the articles I published in the final quarter of 2015:
Integrated Logging with the Integration Services Package...
2016-01-22
493 reads
It’s the second Tuesday of the month and you know what that means! T-SQL Tuesday time! If you don’t know...
2016-01-20 (first published: 2016-01-12)
1,383 reads
It’s the time of the year again: the obligatory “how was the past year” blog post, combined with “what do...
2015-12-29
792 reads
Just a small blog post about how I used sp_BlitzIndex for the first and how awesome that was. sp_BlitzIndex is one...
2015-12-10 (first published: 2015-12-07)
3,226 reads
Installing and configuring SQL Server Master Data Services (MDS) is like a box of chocolates: you never know what you’re...
2015-12-01 (first published: 2015-11-24)
4,455 reads
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
Comments posted to this topic are about the item Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers