Sites anglophones


SQL SERVER – Limitation of ENABLE_PARALLEL_PLAN_PREFERENCE Hint

Publié le 29 août 2019 sur journey to sqlauthority
 

Earlier this week, I had written a blog post about SQL SERVER – Using Query Hint ENABLE_PARALLEL_PLAN_PREFERENCE and I received quite a few interesting emails. One of the emails was about the Limitation of ENABLE_PARALLEL_PLAN_PREFERENCE Hint. Le …

SQL in the City Streamed- the birthday edition

Publié le 29 août 2019 sur sqlservercentral.com
 

The post SQL in the City Streamed- the birthday edition appeared first on SQLServerCentral.

Key Rotation in TDE

Publié le 29 août 2019 sur sqlservercentral.com
 

Transparent Data Encryption (TDE) has been around for a long time. It first appeared in SQL Server 2008, and after a rocky start with some bugs, it has become a regularly used feature for many organizations. While not perfect, it does provide some prot …

DBA Training Plan 14: POP QUIZ!

Publié le 28 août 2019 sur brentozar.com
 

AH-HA! You didn’t know there would be one of these, did you, hotshot? You’ve been reading along in the series, just smiling and nodding, pretending you’re keeping up, but not really doing the homework. BUSTED! Put your books away and …

SQLskills at 24 Hours of PASS: Summit Preview 2019

Publié le 28 août 2019 sur sqlskills.com - glen berry
 

On September 10, 2019, SQLskills will have three slots in the free 24 Hours of PASS: Summit Preview 2019 event. I’ll be leading off with “Dr. DMV’s Troubleshooting Toolkit” at 12:00 UTC. Erin Stellato will present “Why You …

SQL SERVER – Security Risk of Public Role – Very Little

Publié le 28 août 2019 sur journey to sqlauthority
 

I like to do consulting for SQL Server Performance Tuning area because that is my favorite thing to do and I spend over 16 hours a day tuning my system. However, once in a while, during the Comprehensive Database Performance Health Check, I do receive …

Proactively monitor your SQL Server estate with SQL Monitor 9

Publié le 28 août 2019 sur sqlservercentral.com
 

The post Proactively monitor your SQL Server estate with SQL Monitor 9 appeared first on SQLServerCentral.

SQL Server Database Activity Based on Transaction Log Backup Size

Publié le 28 août 2019 sur sqlservercentral.com
 

The post SQL Server Database Activity Based on Transaction Log Backup Size appeared first on SQLServerCentral.

Updated First Responder Kit and Consultant Toolkit for August 2019

Publié le 27 août 2019 sur brentozar.com
 

sp_DatabaseRestore can now restore to Azure blobs and change the database owner after a restore, and everything else gets bug fixes. To get the new version: Download the updated FirstResponderKit.zip Azure Data Studio users with the First Responder Kit …

SQL SERVER – Using Query Hint ENABLE_PARALLEL_PLAN_PREFERENCE

Publié le 27 août 2019 sur journey to sqlauthority
 

I am not a big fan of using SQL Server query hints. The matter of facts, during the Comprehensive Database Performance Health Check, I always advise against using any query hints at all. Trust me there are so many different options you should experimen …

Graphical Tools for Accessing Azure Cosmos DB

Publié le 27 août 2019 sur sqlservercentral.com
 

The post Graphical Tools for Accessing Azure Cosmos DB appeared first on SQLServerCentral.

Fast and Reliable Development with Redgate Solutions for SQL Server

Publié le 27 août 2019 sur sqlservercentral.com
 

The post Fast and Reliable Development with Redgate Solutions for SQL Server appeared first on SQLServerCentral.

A Self-Tuning Fill Factor Technique for SQL Server – Part 2

Publié le 27 août 2019 sur sqlservercentral.com
 

Introduction Fill Factor is a parameter most of us have ignored because there is no definitive way to calculate what the correct value should be. Part 1 of this series describes a new technique to dynamically determine index fill factors for all indexe …

SQLintersection Fall 2019

Publié le 26 août 2019 sur sqlskills.com - paul randall
 

As we head towards our SQLintersection Fall 2019 in November (our 14th show), 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 t …

DBA Training Plan 13: Why Do Cached Plans Go Bad?

Publié le 26 août 2019 sur brentozar.com
 

It’s a little bit of a trick question: what could make a good query plan turn bad? In the last episode, we used sp_BlitzCache to spot the most resource-intensive, longest-running query plans in your server’s cache. Go run those queries agai …


Pages :