Windows Azure SQL Database Backups
You can get backups of your WASD databases. But, if you want them to be transactionally consistent, you need to...
2013-04-04
924 reads
You can get backups of your WASD databases. But, if you want them to be transactionally consistent, you need to...
2013-04-04
924 reads
Microsoft has stated pretty clearly that they’re putting code on Azure first, ahead of the desktop. Which makes one wonder...
2013-03-27 (first published: 2013-03-25)
3,635 reads
Laws of Thermodynamics
TANSTAAFL
Gods of the Copybook Headings
All magic comes with a price
Winter Is Coming
My adult years started with a pretty...
2013-03-20
862 reads
GAAAAAAAHHHHH!!!!
I feel slightly better, but only slightly.
I started watching Star Trek: The Next Generation on Netflix just to unwind my...
2013-03-18
1,126 reads
Every day, out in the SQL Server forums, the same questions come up again and again: why is this query running slow? Why isn't my index getting used? In order to arrive at the answer you have to ask the same return question in each case: have you looked at the execution plan? Grant Fritchey provides the only dedicated and detailed book on this essential topic.
2013-03-15
50,929 reads
The greatest part of my job is that I get to travel all over the world to present different technical...
2013-03-11
1,172 reads
I jumped at the opportunity to write a chapter for this book, Pro SQL Server 2012 Practices, because of all...
2013-03-04
1,701 reads
I earned my nickname. I’m proud of it. I am the Scary DBA. I don’t really like to advertise my...
2013-02-27
1,530 reads
In just a couple of weeks I’ll be flying down to Richmond, VA to speak at SQL Saturday #187. I’ll...
2013-02-25
886 reads
Want to start a fight between a bunch of DBAs or database developers? Ask them where the comma should be...
2013-02-18 (first published: 2013-02-13)
3,549 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