Learn how to use Always Encrypted to encrypt SQL Server data along with some of the changes that have been made since its first release in 2016.

Valuable SQL Server Performance Tuning tips, tutorials, how-to's, scripts, and more for SQL Server DBAs.

Learn about Azure SQL Database compared to Snowflake and where you might use one versus the other along with performance and costs guidelines.

Resolve the issue of a SQL Server Always On Availability Group database not synchronizing with step by step instructions.

Learn how to improve the Data Quality for Healthcare, Clinical and Life Sciences Projects with Melissa Informatics.

This article covers various ways to split strings in SQL Server along with using OPENJSON and also a performance comparison of different approaches.

Learn different ways to use the SQL SUBSTRING function along with several different code examples of how this can be used.

Learn about new feature in SQL Server 2022 Wait at Low Priority that allows index creation to wait for resources to become available before executing.

Download and install SQL Server 2022 with a step by step process with easy to follow screenshots for each step.

SQL Query optimization with SQL Grease with the Enterprise dashboard, historical data, troubleshooting SQL Server Wait Stats and anomalies.

In this article we cover what data pipelines are, how they compare to ETL and some of the tools that are available.

Great resources for SQL Server DBAs learning about SQL Server Cloud Computing with these valuable tips, tutorials, how-to's, scripts, and more.

Review some questions and topics that may come up in an interview related to SQL Server Reporting Services along with many links for further learning.

In this article, we look at various ways of using T-SQL to do wildcard searches for data in SQL Server tables and views.

In this article, we look at how to use SSMS T-SQL to enter a predicate filter on a SQL Server Audit definition to allow filtering an audit.

In this article we look at different ways to load staging data using SSIS and whether you should use a Data Flow task or a Bulk Insert task.

Valuable SQL Server Performance Tuning tips, tutorials, how-to's, scripts, and more for SQL Server DBAs.

This article includes a backup script to automatically backup all databases in SQL Server with a couple of T-SQL commands.

Learn how Data Stewards can leverage Unison from Melissa Data to solve data quality issues for contact data.

In this article we look at the datetimeoffset data type in SQL Server and how this can be used to determine dates for different time zones.