Save Money On Your Azure Monthly SQL Database Bill
Microsoft gives you two purchasing models for your Azure SQL Databases (SQL DB), a DTU and a vCore based model...
2018-09-05 (first published: 2018-08-22)
2,247 reads
Microsoft gives you two purchasing models for your Azure SQL Databases (SQL DB), a DTU and a vCore based model...
2018-09-05 (first published: 2018-08-22)
2,247 reads
Microsoft has long given us DBA tools and suggestions to help tune databases, to fix queries with indexes, and many...
2018-08-28
517 reads
Starting in SQL Server 2012 and in Azure SQL Database, Microsoft introduced the concept of a contained database. A contained...
2018-07-11 (first published: 2018-07-05)
2,913 reads
July 1st is a day all Microsoft Most Valuable Professionals (MVP) wait patiently at their computers hitting F5 over and...
2018-07-02
331 reads
I typically don’t write opinion posts, but given recent events I thought it was important to follow up on one of my tweets....
2018-06-29 (first published: 2018-06-14)
2,266 reads
Ever seen the below error? Until this week I hadn’t. So, I figured I’d take a little time and introduce...
2018-06-28 (first published: 2018-06-20)
10,643 reads
A few weeks ago, I wrote Part 1, 2 and 3 of this series, which was a beginner’s guide to Always Encrypted. In part...
2018-06-25 (first published: 2018-06-13)
2,575 reads
Following up on my last post about the Cardinality Estimator let’s talk about column statistics and how they work and...
2018-05-30
587 reads
Sometimes people speak “SQL” and expect you know all the terminology. In recent a conversation about query plans I was...
2018-05-24
891 reads
In SQL Server the query optimizer uses a cardinality estimator to answer data SELECTIVITY questions like the ones below. The...
2018-05-02
367 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