Execution Plan Cost Estimates
It’s been emphasized over and over that the costs of operations within an execution plan, and the estimated costs of...
2013-09-11
1,731 reads
The Scary DBA
New Windows Azure Virtual Labs
Getting started with new technologies can be a pain. That makes all the new labs that Microsoft just posted extremely...
2013-09-10
590 reads
Developers Rate Azure One of Their Favorite Tools
Yeah, Azure.
How we program, what we program and where we program is changing. All the time. This excellent article lays...
2013-09-09
1,269 reads
Speaker of the Month: September 2013
This is my second post in what I hope will be an ongoing series. You can see the rules for...
2013-09-06
863 reads
sp_executesql, Parameters and Parameter Sniffing
I’m honestly not crazy about dynamic T-SQL within stored procedures. There are just a few too many opportunities to mess...
2013-09-05
1,529 reads
Azure Capabilities Expand
But then, the capabilities in Azure are always expanding. Here’s the new stuff that was just released in a blog...
2013-09-04
625 reads
My Next Phone May Be a Nokia
I really like my Windows Phone. Yes, there are not as many apps as on a Droid or iPhone. But...
2013-09-03
544 reads
One for My SQL Sisters
Women, for the entire male half of the population, I apologize.
Those who know me well recognize, pretty easily, that I...
2013-08-30
1,786 reads
Windows Azure SQL Database and Throttling
When I present on Windows Azure SQL Database, one of the biggest concerns comes up around throttling. Just the concept...
2013-08-29
1,532 reads
Learn Query Tuning in Dallas
I am excited to be able to tell you about an all day seminar that I’ll be putting on prior...
2013-08-28
639 reads
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Question of the Day
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