Databases in Azure… Where to begin? Create a Database and log in!
Ready to create your first Database in Azure. Here are the step by step instructions with plenty of definitions and terms.
2019-10-23 (first published: 2016-06-16)
6,054 reads
Michael Morin
Windowing Functions: Tell me when that changes
Windowing functions aren't just for analyzing numbers/dates. Using windows functions to analyze when a character field changes is a little know resource
2017-03-17 (first published: 2016-02-17)
12,135 reads
Databases in Azure: Copy and Exports
Toady we are going to make a copy and export your DB to Azure Storage. Lets get started.
2016-07-19
1,550 reads
Finding Special Characters within Character Strings
Special Characters can lead to many problems. Identifying and reporting on them can save a lot of headache down the road.
2016-04-08 (first published: 2014-08-19)
147,408 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