Difinity 2018 – Auckland, New Zealand – Pre-Con on SQL Server Performance Tuning
It is indeed fun to let you know that I will be presenting at Difinity 2018 (12-14 February, 2018), New Zealand 3 different sessions on SQL Server Performance Tuning. SQL Server Performance Tuning is my favorite topic and I will get the opportunit …
SQLintersection Spring 2018
As we head towards our 11th SQLintersection in March, I’m excited to say that it’s once again our most diverse, complete, and information-packed show yet! One of the pieces of feedback we hear over and over is that attendees love SQLinterse …
SQL Server Diagnostic Information Queries for January 2018
This month, there are more minor updates to the all of the versions of the queries, primarily in the comments and documentation. There are also links for the Spectre/Meltdown hotfixes for SQL Server 2008 SP4 and SQL Server 2008 R2 SP3. I often make add …
New Pluralsight course: Automatic Tuning in SQL Server 2017 and Azure SQL Database
Erin’s latest Pluralsight course has been published – SQL Server: Automatic Tuning in SQL Server 2017 and Azure SQL Database. It’s 90 minutes long, and from the course description: There’s a whole new world of aut …
SQL Server 2017 CU3 adds CXCONSUMER waits, doesn’t mention it
The revolution will not be documented At the PASS 2017, Pedro Lopes (don’t call him low-pez) from Microsoft mentioned that a new parallelism wait was getting added soon. That wait, if you’re too darn tootin’ lazy to click, is called C …
How SQL Monitor Monitors Azure-based SQL Server Failover Cluster Instances
This article will show you how to set up SQL Monitor to monitor Azure-based clustered instances right alongside your on-premise clusters.
Stairway to SQL Server Agent – Level 4: Configuring Database Mail
Examines the database mail system configuration in depth. You will learn how to configure database mail to work with SMTP mail systems, and get some troubleshooting tips.
SQL SERVER – 2017 – How to Remove Leading and Trailing Spaces with TRIM Function?
TRIM Function has haunted SQL DBA for ages. If you have been using SQL Server for a while, you will totally agree with me over here. In this blog post we will see how the new feature TRIM of SQL Server 2017 works in few simple words. SQL Server DBAs an …
First Responder Kit Release: It’s Too Cold Not To Do A Release
You look just like a snake when you crawl like a worm. You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #1310: @CferMN reported quite an odd conversion error! Turns out, division was a better idea than multi …
Performance Effects of Meltdown and Partial Spectre Fixes on Intel Core i7-7500U Laptop
I have a fairly recent vintage HP Spectre x360-13w023dx laptop (slightly over a year old) that has an Intel Core i7-7500U (Kaby Lake-U) processor, 16GB of DDR4 RAM, and a 512GB Samsung PM961 M.2 NVMe SSD that is running Windows 10 Professional Version …
SQL Server 2017 CU3 Released on January 4, 2018
On January 4, 2018, Microsoft released SQL Server 2017 CU3, which is Build 14.0.3015.40. By my count, this CU has sixteen public hotfixes, many of which are for the SQL Engine or SQL performance. There are also some new manageability and programmabilit …
SQL Server 2017 CU3 adds execution statistics for scalar-valued, user-defined functions
Estimated Plans Need Not Apply This is, of course, only available in actual plans. All together now: If a query uses one or more user-defined scalar functions (such as T-SQL functions or CLR functions), a significant portion of query execution time may …
Free eBook: SQL Server Internals: In-Memory OLTP
In this free ebook Kalen Delaney introduces and explains how the 2016 In-Memory OLTP engine works. The Hekaton internals knowledge offered in this book will help you migrate existing tables or databases to Hekaton, and get faster performance from your …
Azure DWH part 23: Data Mining
SQL Server on-premises includes a module to create Data Mining models. We will show how to create them using ASDW.
SQL SERVER – Introduction to Log Space Usage DMV – sys.dm_db_log_space_usage
It has been quite a while since SQL Server 2017 has been introduced, however just recently I have been seeing interest for this project. Lots of users are just switching to SQL Server 2017 and I believe that is normal. In the year 2017 during my Compre …