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.
SQL SERVER – Selecting Random n Rows from a Table
Every day I spend a good amount of time with different customers helping them with SQL Server Performance Tuning issues. Today we will discuss the question asked by a developer at the organization where I was engaged in Comprehensive Database Perf …
[Video] Office Hours 2018/9/19 (With Transcriptions)
This week, Brent, Tara, Erik, and Richie discuss moving views between databases, Cluster Quorum File Share on AlwaysOn, checking for corruption, rebooting/restarting SQL server after applying cumulative updates, how many drive letter to use for a VM, d …
How to Escape a Single Quote in SQL Server? – Interview Question of the Week #192
Question: How to Escape a Single Quote in SQL Server? Answer: Yesterday, I had an opportunity to visit a SQL User Group in Bangalore, India, and during the event, I had received a very simple question from a college student. As soon as he asked th …
Leaked: SQL Server 2019 Big Data Clusters Introduction Video
Psst – you’re probably not supposed to see this yet, but look what @WalkingCat found: SQL Server 2019 Vision pic.twitter.com/zbjI28FYSu — WalkingCat (@h0x0d) September 21, 2018 What the video says Growing volumes of data create deep p …
SQL SERVER – Query to Find the Longest Running Function – Function Elapsed Time
I love my job of SQL Server Performance Tuning and Optimization consultant as every single day I walk into the customer door (well, to be honest, it is actually virtual door of GoToMeeting), I face new challenges and learn new ways to tune SQL Server. …
6 DBA Lessons I Wish Someone Would Have Taught Me Earlier
I was talking to a DBA friend of mine, reminiscing about some of the hard lessons we learned early on in our career. The more we talked, the more we realized that there should probably be a one-page cheat-sheet that you’re required to read before …
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.
Learning R in SQL Server
Learn about the new R Services in SQL Server 2016
SQL SERVER – Restoring SQL Server 2017 to SQL Server 2005 Using Generate Scripts
Let me answer the first question first – There is no way to backup and restore SQL Server 2017 to SQL Server 2005 with the help of any tools. In this blog post, we will learn about how we can generate scripts to achieve this task. However, there …