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.
Connecting – Level 4 of the Stairway to Azure SQL Database
Learn how to configure connectivity and firewall rules for your Azure SQL Database
SQL SERVER – Database Performance Analyzer – Table Tuning Advisors
I am a SQL Server Performance Tuning Expert who acts as a consultant for many organizations across the world who have performance tuning issues. I am often showed one or more of the tables of the system and asked to tune the system around those tables. …
Backup Checksum Feature in SSMS 18.0 Preview 4
I was pleasantly surprised to see a new “Backup checksum” checkbox in the Server Properties, Database Settings dialog page (as shown in Figure 1). This was something that I had been asking for for quite awhile, so I appreciate that it has b …
SQL Server Diagnostic Information Queries for September 2018
This month, I have added a separate set of queries for SQL Server 2019. I have also added two new queries to the SQL Server 2012 through SQL Server 2017 sets of queries. I have a T-SQL script that you can use to check whether your instance of SQL Serve …
New Class Week: Performance Tuning in 21 Demos
We first unveiled this class for the PASS Summit, but due to high demand, we’re doing an online version, too. You’re a developer or DBA who wants to tune indexes and queries to make your application go faster. You don’t like learning …
Renaming a Schema in SQL Server
If you have a schema you want to retire, here’s a method for moving all objects inside that schema to a new one.
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.
SQL Authority News – Microsoft Released SQL Server 2019 Preview
The wait is over. Microsoft has just announced SQL Server 2019 Preview in the Ignite conference. Lots of people were wondering if there is going to be any SQL Server 2018. The answer is Microsoft is going to skip this year as a release for SQL Server a …
What’s New in SQL Server 2019 System Tables
The free SQL Server 2019 preview download is out, and here are quite a few things to check out that aren’t documented yet: New System Objects Starting with new stored procedures: sys.sp_add_feature_restriction sys.sp_autoindex_cancel_dta sys.sp_a …
What’s New in SQL Server 2019’s sys.messages: More Unannounced Features
The system table sys.messages holds error messages that SQL Server needs to return to end users. When a new build comes out, I love checking this table to see what features Microsoft has coded, but isn’t quite ready to announce yet. When SQL Serv …
What’s New in SQL Server 2019: Faster Table Variables (And New Parameter Sniffing Issues)
For over a decade, SQL Server’s handling of table variables has been legendarily bad. I’ve long used this Stack Overflow query from Sam Saffron to illustrate terrible cardinality estimation:declare @VoteStats table (PostId int, up int, …
What’s New in SQL Server 2019: Adaptive Memory Grants
When you run a query, SQL Server guesses how much memory you’re going to need for things like sorts and joins. As your query starts, it gets an allocation of workspace memory, then starts work. Sometimes SQL Server underestimates the work you …
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.
Uploading On-Premise data to Azure Blob Storage using SSIS
Azure SSIS Feature pack can be used to upload the data over to Azure Storage account. In this article, Supriya Pande will describe how you can upload the data to Azure Blob Storage using SSIS task.