Helping Database Administrators
Let’s be honest. Database administration is not all that tough. Set up your backups. Test them. Get consistency checks on...
2013-06-07 (first published: 2013-06-04)
1,766 reads
The Scary DBA
Using PowerShell to move files to Azure Storage
I was searching all over the place to try to find out how to move files into Azure Storage. Most...
2013-06-03
2,375 reads
Microsoft Teched 2013 Keynote
Welcome to Teched 2013
We’re starting off with some type of James Bond video. Chase scene with a really cool car....
2013-06-03
874 reads
Painting the US Red
We are bringing Red Gate, through the free SQL in the City event, to the United States again this year.
This...
2013-05-29
816 reads
SMO vs Invoke-Sqlcmd in Azure
I’m working on a series of Powershell scripts for the pre-conference seminars on Windows Azure SQL Database that I’m going to be...
2013-05-28
1,070 reads
A Little Azure Fun on Friday
You know how we’ve always heard that sp_msforeachtable and other similar undocumented functions may not be supported in future versions...
2013-05-24
726 reads
PASS Summit 2013 is Looking Cloudy
No, this isn’t some complaint about PASS or the Summit. This is an announcement that not only will I be...
2013-05-22
656 reads
Microsoft Lync Through the Web
Get an invite to a Microsoft meeting? Are they using the new Lync interface? And, you don’t have a paid...
2013-05-21
782 reads
Azure does Powershell too
Or, I guess it might be more appropriate to say that Powershell does Azure. Regardless, there are a set of...
2013-05-23 (first published: 2013-05-20)
1,935 reads
Book Review: Business in the Trenches
I’m trying to improve.
That’s at just about everything too. I know I don’t know enough or have enough skills to...
2013-05-09
734 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