SQL Server v.Next : STRING_AGG Performance, Part 2
Aaron Bertrand starts digging deeper into the performance of string concatenation methods STRING_AGG and FOR XML PATH.
Azure SQL Data Warehouse with PowerShell
We will teach how to create a new SQL Azure Data Warehouse using Powershell
DevOps and Database Lifecycle Management
Database Lifecycle Management (DLM) aims to provide a roadmap of what is required, and when, to deliver and maintain effective databases that can respond quickly to business change. How...
The Elusive Conditional WHERE Clause
What's this, a conditional WHERE clause that doesn't use dynamic SQL?
Hyper-V and PowerShell: The Basics
Because it is important with maintaining Virtual Machine environments to be able to repeat routine tasks completely accurately, Windows PowerShell has grown in importance for the job. Now you can manage the Hyper-V environment via PowerShell without needing to use the Hyper-V Manager console. It opens up many opportunities for automation.
Changing Linked Server Passwords
How to article on changing passwords for linked servers via TSQL and SSMS.
The New SQL Server 2016 Edition Limits
There are some changes to memory limits in SQL Server 2016 SP1 Standard Edition.
Importance of Performing DBCC CHECKDB on all SQL Server Databases
The SQL Server model database is one of the core system databases, but it seem to get less attention in terms of importance. This post from Simon Liew will demonstrate the havoc the model database can cause when database integrity checks exclude the model database and corruption goes undetected.
Azure DWH part 2: Get Started with Azure Data Warehouse
In this article, we will learn how to use Visual Studio to query Azure SQL Data Warehouse tables and how to create a new table.
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
Have you done a Mid year check in?
Comments posted to this topic are about the item Have you done a Mid...
From SQL Server On-Premises to Claude Desktop: How I built a Full MCP Pipeline
Comments posted to this topic are about the item From SQL Server On-Premises to...
Independence Day 2026
Comments posted to this topic are about the item Independence Day 2026
Question of the Day
Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers