The OUTPUT Clause for the MERGE Statements
In this article, I will provide a set of examples to showcase the use of OUTPUT clause within the MERGE statement and how to capture the OUTPUT clause results into an archive table.
Benefits of Data Masking highlighted in Gartner’s 2018 Market Guide
Gartner released their 2018 Market Guide for Data Masking, providing an in-depth analysis of the market with recommendations and representative vendors – including Redgate. Gartner says that "Test data (or copy data) virtualization is a technology that is increasingly popular, when used in combination with SDM (Static Data Masking), to speed up the provisioning of and updates to target environments, in addition to significantly reducing the amount of storage required by these environments.”
What does Azure SQL DB Automatic Index Tuning actually do, and when?
Azure SQL DB’s Automatic Tuning will create and drop indexes based on your workloads. Brent's latest blog post shows how to enable it and explains what it actually does.
Introducing SQL+ Dot Net
SQL+.net is the first real innovation in data access for quite some time, and was built exclusively for SQL developers.
Back to Basics; Masking Address Data
Protecting Personable Identifiable Information is central to the compliance of numerous regulations which your organization may be subject to. In this article Grant Fritchey starts with the basics of obfuscating address data with the data masking technology in SQL Provision.
The Performance of Window Aggregates Revisited with SQL Server 2019
T-SQL window functions have been a fantastic addition to the T-SQL language. In this article, Kathi Kellenberger reviews how optimizations available in SQL Server 2019 can improve the performance of these functions.
Transform your SQL Server permissions
SQL Census helps users understand who has access to their SQL Servers (including Active Directory groups) and simplify existing SQL Server permissions. A new feature reworks discrete user permissions into database roles, giving users the same effective rights in a more controllable structure. Download and use SQL Census (in preview) for free.
The Data Incident
Google and Microsoft have plans for dealing with data incidents. Steve thinks you should as well.
One-way and Two-way Tabulation Example in SQL Server - Part 2
In this tip we demonstrate how to use dynamic SQL and stored procedures to simplify the computation with SQL of one-way and two-way tabulations.
Blogs
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
Forums
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...
SSoL Support on the OS
Comments posted to this topic are about the item SSoL Support on the OS
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers