Presenting Azure Vs. Working With Azure
I have a real infatuation with Azure. I’m especially interested in the Platform as a Service (PaaS) offerings in and...
2017-11-15
300 reads
The Scary DBA
All Day Query Tuning Class at SQLSaturday Virginia
March 23rd, 2018, I’ll be teaching an all day class on Query Tuning Tools in Richmond Virginia. I hope to...
2017-11-14
364 reads
The GDPR and You
Ever heard of the General Data Protection Regulation? If not, go and read the Wiki. I’ll wait.
I can already hear...
2017-11-13
305 reads
Extended Events and Profiler: XE Profiler
There’s a war on in the SQL Server world. On the one side is Profiler (although, really, everyone uses Trace...
2017-11-07
430 reads
Inside My PASS Summit
As you read this, I’m in Seattle for the PASS Summit 2017. I have four roles that I satisfy at...
2017-10-30
564 reads
PASS Summit and Redgate Software
Next week is the PASS Summit. I’m so excited about it I could pop. Part of why I’m excited is...
2017-10-25
322 reads
Database Fundamentals #14: Modifying Data Through SSMS
I’ve said it before, but I feel I should repeat myself. Using the SSMS GUI for data entry and data...
2017-10-16
518 reads
Database Fundamentals #13: Data Entry Through T-SQL
T-SQL provides lots of functions that help to make data entry through T-SQL much more powerful. Over time you won’t...
2017-10-23 (first published: 2017-10-11)
1,871 reads
Database Fundamentals #12: Adding Data with SSMS GUI
In the previous Database Fundamentals, I argued that you should be learning T-SQL, yet the very next post I’m showing...
2017-09-25
483 reads
Azure, PowerShell, Databases and the PASS Summit
I am quite honored to say that I am speaking at the single largest and most important Microsoft Data Platform...
2017-09-19
430 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