SQL SERVER – Enable Lock Pages in Memory LPIM
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
The post A fresh new look for Redgate University appeared first on SQLServerCentral.
Working with React Components
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
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
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
(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
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
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
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
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
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
The post Goodbye to the Microsoft Professional Program appeared first on SQLServerCentral.
Optimize Your SQL by Reformulating the Spec
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)
The post Neglecting to Use, or Misusing, the RETURN Keyword (BP016) appeared first on SQLServerCentral.
The Data-Philes Team Meet the Time Traveler
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 …