SQL Server MERGE statement usage and examples
In this tip we look at how to use MERGE compared to running separate INSERT and UPDATE statements.
2018-09-26
3,483 reads
Additional Articles
Adaptive Query Processing in SQL Server
Adaptive query processing is the latest query processing feature introduced in the SQL Server database engine, available in SQL Server (starting with SQL Server 2017 (14.x)) and Azure SQL Database. Read on to learn more.
2018-09-25
2,801 reads
Questions About HIPAA That You Were Too Shy to Ask
As a data professional or developer, you will likely have questions about how HIPAA impacts you and your day to day responsibilities. Rebecca Edwards answers common questions about HIPAA that you were too shy to ask.
2018-09-24
2,261 reads
Adding User Comments to Reports in SQL Server Reporting Services
In this tip we look at a new feature in SQL Server Reporting Services that allows users to leave comments about reports.
2018-09-21
2,383 reads
2018-09-21
1,949 reads
Advanced Testing of Your PowerShell Code with Pester
Testing your PowerShell scripts is just as important as testing any code. In this article, Robert Cain demonstrates how to use the testing tool, Pester, to perform unit, integration, and acceptance testing.
2018-09-20
2,439 reads
Azure SQL Database High Availability
Site-wide or region-wide disasters, while undoubtedly more impactful, happen considerably less frequently than downtime resulting from scheduled maintenance events or isolated hardware and software faults. This article provides an overview of the high availability features of Azure SQL Database that mitigate risks affecting services within an individual Azure datacenter, rather than an entire Azure region.
2018-09-18
2,171 reads
Examples and Function for Using SQL Server LIKE Operator and Wildcard Characters
In this tip we look at different examples of how to use the LIKE operator to get the correct results when strings contain wildcard characters. We will also look a function to make this easier to do.
2018-09-17
4,254 reads
Single-Column-Key Missing Index Recommendations are Usually Wrong.
When Clippy suggests an index with only one key, look closer.
2018-09-14
2,975 reads
How to Linux for SQL Server DBAs — Part 1
As running SQL Server on Linux becomes more common, DBAs must learn and become comfortable with the Linux OS. In this article, Kellyn Pot'Vin-Gorman demonstrates how to create a SQL Server instance running in Linux via a Docker container.
2018-09-13
3,067 reads
Blogs
Advice I Like: Failure
By Steve Jones
If it fails where you thought it would fail that is not a failure....
Logged in as a member of an Azure AD Group Error while Deploying DACPAC
Quite a long title for a short blog post ??While deploying a DACPAC (from...
Data Conferences – Worth Every Dollar
By Kevin3NF
Some of the best career enhancers you can buy. Why I Go to...
Forums
A Place where AI Technology Shines
Comments posted to this topic are about the item A Place where AI Technology...
Question of the Day
Getting the Object Code
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.uspGetBillofMaterials')) AS [Object Definition]; GOSee possible answers