Loading Non Duplicated Data Using SSIS
Learn how you can easily load data from a file that isn't duplicated, discarding those rows that are.
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.
Blogs
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Forums
SQL Server Showing Out of Space But Plenty of Drive Space
We have a SQL Server installed. We have a 500GB drive for the database....
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
Restoring Azure Key Vault Keys and Validating SQL Server TDE Recovery: Level 7 of the Stairway to TDE
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Restoring Azure Key Vault Keys...
Question of the Day
Creating a JSON Document IV
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers