Sites anglophones


September 2019 Trainings – 21 Essential Scripts: Performance Tuning

Publié le 14 septembre 2019 sur journey to sqlauthority
 

I will be delivering four classes on my most popular training on 21 Essential Scripts: Performance Tuning in Europe in the month of September 2019. Here is the quick schedule and how you can register for the class.DateLocationRegistration LinkSept …

Glenn’s Tech Insights For September 13, 2019

Publié le 13 septembre 2019 sur sqlskills.com - glen berry
 

(Glenn’s Tech Insights… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally releva …

MySQL Preferred Engine – MyISAM or InnoDB

Publié le 13 septembre 2019 sur journey to sqlauthority
 

Most of my time is spent working with my clients on the Comprehensive Database Performance Health Check. The best part of the health check engagement is that I get to meet many new people and share lots of different stories. Recently I was asked by one …

Monitoring TempDB Contention using Extended Events and SQL Monitor

Publié le 13 septembre 2019 sur sqlservercentral.com
 

The post Monitoring TempDB Contention using Extended Events and SQL Monitor appeared first on SQLServerCentral.

Why You Need Query Store, Part III: Proactively analyze your workload

Publié le 12 septembre 2019 sur SQLSkills.com - Erin Stellato
 

 The amount of data collected by Query Store pales in comparison to the amount of data available in all of SQL Server that could be captured.  But the quality of the data overshadows the quantity, or lack thereof.  While most people targ …

DBA Training Plan 20: Planning Your Next Server

Publié le 12 septembre 2019 sur brentozar.com
 

When the business decides it’s time to give up fixing the old server because it’s not fast enough or reliable enough, stop. The worst thing you can do is jump directly to the hardware vendor’s site, check a few boxes, and order a new …

SQL SERVER Management Studio 18 – Enable Dark Theme

Publié le 12 septembre 2019 sur journey to sqlauthority
 

We are all techies and we love to use a dark theme in our IDEs. I get quite often a question about how to enable dark theme in SQL Server Management Studio during Comprehensive Database Performance Health Check. Let us see how we can change the theme a …

Goodbye to the Microsoft Professional Program

Publié le 12 septembre 2019 sur sqlservercentral.com
 

The post Goodbye to the Microsoft Professional Program appeared first on SQLServerCentral.

Optimize Your SQL by Reformulating the Spec

Publié le 12 septembre 2019 sur sqlservercentral.com
 

Introduction As SQL developers, we try to implement the most concise and well-performing SQL code that conforms to the specification we are given. We also tend to think of performance tuning in terms of crafting the best table indices, avoiding scalar …

Neglecting to Use, or Misusing, the RETURN Keyword (BP016)

Publié le 12 septembre 2019 sur sqlservercentral.com
 

The post Neglecting to Use, or Misusing, the RETURN Keyword (BP016) appeared first on SQLServerCentral.

The Data-Philes Team Meet the Time Traveler

Publié le 11 septembre 2019 sur simple-talk.com
 

The year is 1999, somewhere in Cambridge, UK. Kathi, a member of the Data-Philes team, is reading a memo sent from her manager. The memo talks about someone who disrupted a project management meeting in London. He claims he is from 20 years in the futu …

How to Set Up Your Own Mastering Class VM

Publié le 11 septembre 2019 sur brentozar.com
 

When you buy one of my Live Class Season Passes, you can save a lot of money this week by building your own VM to follow along with the labs. Or, you might just wanna re-run the labs later to see if you can do a better job, or if you’re still mas …

Why You Need Query Store, Part II: Plan forcing

Publié le 11 septembre 2019 sur SQLSkills.com - Erin Stellato
 

We hear a lot about all the data that Query Store captures, but it is tempting to argue that the best part of Query Store is the ability to force a specific plan for a query.  Arguably, if the data didn’t exist, we would have a harder time f …

SQL Server 2019 Graph Database and SHORTEST_PATH

Publié le 11 septembre 2019 sur simple-talk.com
 

My crystal ball seems to be working again: The new addition to SQL Server 2019, shortest_path, was the subject of many of the technical sessions I delivered as one of the missing features of SQL Server Graph Database. I will use an example that is simi …

Understanding State of SQL Server Monitoring 2019 Report

Publié le 11 septembre 2019 sur journey to sqlauthority
 

In 2018, Redgate launched the industry’s first-ever report into the state of SQL Server monitoring. It contained responses from over 600 SQL Server professionals giving them a unique insight into how they monitor their estates, the technologies t …


Pages :