Sites anglophones

SQL Server 2017 CU3 adds tempdb spill diagnostics in DMVs and Extended Events

Publié le 11 janvier 2018 sur

Where have you been all my life? Whenever I’m teaching people about query tuning, two things come up almost without fail: parameter sniffing and tempdb spills. They’re not mutually exclusive — some queries will seemingly alw …

GDPR – A guide for the perplexed

Publié le 11 janvier 2018 sur

If a picture paints a thousand words then can GDPR regulation be represented in diagram form? Could doing so make it easier to comply with the regulation by making it easier to understand?

What is database DevOps, and why is it important for DBAs?

Publié le 11 janvier 2018 sur

Over the past 20 years, the concept of database DevOps has always been around, but the ability to automate tasks hasn’t been as simple for the database as it has been for application development. Database DevOps tools have now emerged, however, a …

Difinity 2018 – Auckland, New Zealand – Pre-Con on SQL Server Performance Tuning

Publié le 11 janvier 2018 sur journey to sqlauthority

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

Publié le 10 janvier 2018 sur - paul randall

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

Publié le 10 janvier 2018 sur - glen berry

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

Publié le 10 janvier 2018 sur - paul randall

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

Publié le 10 janvier 2018 sur

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

Publié le 10 janvier 2018 sur

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

Publié le 10 janvier 2018 sur

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?

Publié le 10 janvier 2018 sur journey to sqlauthority

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

Publié le 9 janvier 2018 sur

You look just like a snake when you crawl like a worm. You can download the updated 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

Publié le 9 janvier 2018 sur - glen berry

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

Publié le 9 janvier 2018 sur - glen berry

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

Publié le 9 janvier 2018 sur

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 …

Pages :