Sites anglophones


SQL SERVER – Enable Lock Pages in Memory LPIM

Publié le 16 septembre 2019 sur journey to sqlauthority
 

One of my recent clients had a very interesting situation of memory pressure, which we detected during the Comprehensive Database Performance Health Check. In most of the cases, my clients have either CPU pressure issue or the disk/IO issue. However, i …

A fresh new look for Redgate University

Publié le 16 septembre 2019 sur sqlservercentral.com
 

The post A fresh new look for Redgate University appeared first on SQLServerCentral.

Working with React Components

Publié le 16 septembre 2019 sur sqlservercentral.com
 

The post Working with React Components appeared first on SQLServerCentral.

How to List All DML Triggers Created or Modified in the Last N Days in SQL Server? – Interview Question of the Week #242

Publié le 15 septembre 2019 sur journey to sqlauthority
 

Question: How to List All DML Triggers Created or Modified in the Last N Days in SQL Server?Answer: Before we talk more let us see the script to list all All DML Triggers Created or Modified in the Last N Days in SQL Server.SELECT o.name as [Trigger Na …

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 …


Pages :