Quality Provides Traction/Velocity
Quality is a driver for productivity. Or so say I. What do you think.
Quick Testing with SQL Clone Images
Steve Jones explains how SQL Clone can be used to create multiple copies of a database for different testing scenarios, while using just a fraction of the disk space. For example for developers to experiment in sandbox environments, with full copies of large databases, without the hassle and delays of restoring backups or copying database files.
The Power of the Data Model
A data model is far more powerful than simply a set of build instructions for DBAs. It can be used to shape business thought and actions for the benefit of all.
Office Hours Webcast 2017/02/01
In this edition of Office Hours, Brent, Erik, and Richie discuss AlwaysOn Availability Groups, execution plans, speeding up log shipping, applying wrong service packs, their favourite high availability solutions, and more.
Azure DWH part 4: How to import data to Azure DWH using SSIS
In this article, we will use SSIS to import a CSV file to Azure SQL Data Warehouse.
Problems With Database Problems
The GitLab crisis has Steve Jones thinking about two things: competence and care.
The Second Career
From a well-built cockney who knew how to avoid wheel clamps, to an ex-member of an elite anti-riot unit, some of the best DBAs have a surprising diversity of skills and experiences, according to Phil Factor.
How to Build Your First SQL Server Virtual Lab in Windows Azure
If you are a DBA who hasn't so far dived in head-first into using Azure, it is worth setting up an Azure 'Virtual Lab' environment the easy way, using a template. This will then allow you to experiment, try things out with SQL Azure, and get familiar with Resource Groups. Joshua shows how to build a virtual lab, from the ground up in the first of a series that aims to give you a grounding in Azure.
Moving Through Five Years
An updated editorial. The five years are almost up for the prediction that IT departments would be eliminated. Read Steve Jones thoughts on where we are today.
Query Performance Tuning – A Methodical Approach
Learn how to approach performance tuning in this piece from SQL Server MCM and MVP, Gail Shaw.
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