Data Orchestration
Steve talks data virtualization in the age of growing data sets and larger workloads
But the Database Worked in Development! Checking for Duplicates
As developers should not have access to production data, it’s possible that duplicate values can sneak in during migrations. In this article of the series, Phil Factor demonstrates a way to check for duplicates when unique constraints are disabled.
Stairway to U-SQL Level 1: Introduction to U-SQL and Azure Data Lakes
An introductory guide to querying files in Azure Data Lakes using Microsoft's U-SQL language.
Memory-Optimized TempDB Metadata in SQL Server 2019
For as long as I have worked with SQL Server, and on almost every system I've ever managed, tempdb has been a bottleneck in one way or another.
Introduction to Indexed Views in SQL Server
This article explains indexed views and provides an example that shows when they should be used to improve performance of a complex query.
Configure SQL Server Transparent Data Encryption with PowerShell
In this article Filip Holub looks at how to configure and enable transparent data encryption for a SQL Server database using PowerShell.
Monitor for errors in your SSAS, SSRS, SSIS, Agent and Full-Text services
Learn how to monitor for errors in your SSAS, SSRS, SSIS, Agent and Full-Text services
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers