Sites anglophones


Let’s Start with Architecture

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

In my last article, I mentioned that I had a system to monitor my servers and that I used it to gauge the current health of my production environment and to help me to predict if things were going to go wrong in the near future.  Let’s start …

New Release: SQL Clone 4

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

The post New Release: SQL Clone 4 appeared first on SQLServerCentral.

Calling all user group leaders! We want to present for you again in 2019!

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

So far this year, we at SQLskills have presented remotely (and a few in-person) to 42 user groups and PASS virtual chapters around the world, and we have 6 more scheduled! Now we’re into the second half of 2019, we’d like to sched …

Research Paper Week: Automatic Indexing in Azure SQL DB

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

Before I give you the link to the next research paper in this week’s series, I wanna give you a few questions to think about: If you had to build something to automatically add indexes to SQL Server databases, where would you start? What data wou …

SQL SERVER – Identify Database File with Maximum IO Issues

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

Every day is a new challenge day for me as a SQL Server Performance Tuning Consultant. The other day, I have received an interesting email from an existing client of Comprehensive Database Performance Health Check. His question was related to files wit …

Integrating Redgate SQL Code Guard with SonarQube

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

The post Integrating Redgate SQL Code Guard with SonarQube appeared first on SQLServerCentral.

Research Paper Week: Query Execution in Column-Oriented Database Systems

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

This week, I’m sharing some of my favorite papers that I’ve read. Sometimes they’re about future technologies that haven’t shipped yet – and may never ship! Sometimes, like this one, they’re not from Microsoft at all …

Microsoft SQL Server and Ransomware Viruses

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

The epidemic of viruses that encrypt files and then extort money from users has already become global. One of the first was the WannaCry virus, released in 2017. Its clones and modifications followed. What if your files got affected by this plague (Ran …

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

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

Introduction So what’s all the fuss about Fill Factor? It is a SQL Server parameter I’ve ignored for 20+ years. The main reason was/is I’ve had no idea about what value to use. There is just no documented definitive guidance. Back in …

Using SQL Monitor to manage a growing server estate

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

The post Using SQL Monitor to manage a growing server estate appeared first on SQLServerCentral.

Research Paper Week: Plan Stitch: Harnessing the Best of Many Plans

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

Those of you who follow me on Instagram, Twitter, or Facebook know I’m taking most of August off for vacation. Erika and I spent the last couple of weeks in Telluride, had a brief stop in Sacramento for SQL Saturday, and this week we’re tou …

Some Comparative CPU-Z Benchmark Scores

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

About a month ago, I built a new desktop gaming system based on an AMD Ryzen R7-3700X 8C/16T processor. I mainly use that system to play World of Tanks at 2K (2560 x 1440), and this new system has significantly higher frame rates at 2K (typically 95-12 …

SQL SERVER – Removing Extra TempDB Files

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

I am fortunate to work on different challenges every week for SQL Server Performance Tuning. The other day I ended up a very interesting situation while working with Comprehensive Database Performance Health Check, with TempDB files. Let us understand …

Memories of DR testing

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

With the introduction of the GDPR, a lot of our prospective clients are demanding more and more information regarding data disposal, retention and usage practices. Both our new and existing clients want to look at our internal ecosystem and understand …

Simple SQL Change Automation Scripting: The Release Object

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

The post Simple SQL Change Automation Scripting: The Release Object appeared first on SQLServerCentral.


Pages :