How to Become a SQL Server Database Administrator
I wrote How to Become a SQL Server Database Administrator (email address required for download) a few years ago as a project...
2017-04-03
529 reads
SQLAndy
April Fools 2017
Each year I try to something fun for April 1st, though it’s hard to do well. Trying to be funny...
2017-04-01
503 reads
Why I’m Changing to MySQLAndy
From time to time we all have to examine our path and decide if we need to make adjustments. Looking...
2017-04-01
414 reads
Notes from the March 2017 MagicPASS Meeting
I was a last minute volunteer to speak at the March meeting and used it as a chance to talk...
2017-03-31
620 reads
Applying SQL Service Pack on Encrypted Drives
I have a server that uses a third party disk encryption product. It’s configured so that the SQL service account...
2017-03-30
688 reads
SSMS – Not a Valid Value for Property Width
I’ve had this happen a couple of times with a recent build of SSMS. Something went wrong – resolution change maybe...
2017-03-29
1,249 reads
Orlando Code Camp 2017
I’ll be attending and speaking at Orlando Code Camp on April 8th. Come by and say hello if you’re attending,...
2017-03-27
411 reads
Reading the January 2017 PASS Minutes
I’ve been catching up on stuff this week, including reading the January 2017 minutes. It was in-person meeting so a...
2017-03-27
369 reads
Reviewing the PASS 2017 Budget
I did a quick review of the 2017 PASS Budget. It’s not a page turner, but it has a lot...
2017-03-27
368 reads
A Note on Configuring HP SSD’s
Sharing this without a supporting link, might help someone. During a recent move from SAN to local SSD the storage...
2017-03-24
427 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