Inventory SQL Server Agent Jobs for all Instances with PowerShell
The post Inventory SQL Server Agent Jobs for all Instances with PowerShell appeared first on SQLServerCentral.
DevOps falling short?
The post DevOps falling short? appeared first on SQLServerCentral.
SQL SERVER – 2 SQL Server Courses on Pluralsight
The year 2019 has been wonderful for me as I was fortunate to publish 2 SQL Server Courses on Pluralsight.Analyzing SQL Server Query PlansUsing Memory-optimized Tables and Native Stored ProceduresIf you are into the area of the SQL Server Performance T …
Fixing MLS Python Services to Load the Runtime
Recently I went to work on a SQL Server 2017 instance and couldn’t get the Python runtime to load. I’d keep getting this error: A strange error for me to see, and one that didn’t quite make sense. How can the runtime not launch? However, restarting the …
Where SQL Server monitoring fits into your tech stack
The post Where SQL Server monitoring fits into your tech stack appeared first on SQLServerCentral.
Glenn’s Tech Insights For October 23, 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 …
How to Think Like the SQL Server Engine: What’s the Tipping Point?
In our last episode, I’d expanded our query to include DisplayName and Age – two columns that weren’t in our nonclustered index:SELECT LastAccessDate, Id, DisplayName, Age FROM dbo.Users WHERE LastAccessDate > ‘2018-09-02 04:00’ OR …
SQL SERVER – Group By Orders Data by Columns Ascending
SQL Server fundamentals can never get old. Just the other day, while working with a client on Comprehensive Database Performance Health Check, the DBA asked me an interesting question referring to my older blog post How to Know If Index is Forced on Qu …
Troubleshoot Slow RDS SQL Servers with Performance Insights
The post Troubleshoot Slow RDS SQL Servers with Performance Insights appeared first on SQLServerCentral.
Spring 2020 classes in Chicago, early-bird through end of 2019
I’ve just released our Spring 2020 in-person classes in Chicago for registration! They will be at our main event hotel as usual in Oakbrook Terrace, and all classes have an early-bird price that expires on 1/1/2020, with an extra $100 discou …
How to Think Like the SQL Server Engine: What’s a Key Lookup?
In our last couple of queries, we’ve been using a simple query to find the Ids of everyone who accessed the system since mid-2014:SELECT Id FROM dbo.Users WHERE LastAccessDate > ‘2014-07-01′ ORDER BY LastAccessDate; But Ids alone aren’t …
SQL SERVER – Upgrade Error: The Specified Service Does Not Exist as an Installed Service
Even though SQL 2008 R2 support has been ended there are many clients running this version. Few of my clients are planning to upgrade as soon as possible. One of my clients was doing an in-place upgrade of SQL Server 2008 R2 instance to SQL Server 2014 …
Introduction to the Partition By Window Function
The post Introduction to the Partition By Window Function appeared first on SQLServerCentral.
Automating Schema Comparisons with SQL Compare Projects and PowerShell
The post Automating Schema Comparisons with SQL Compare Projects and PowerShell appeared first on SQLServerCentral.
Digging into Azure SQL Database Hyperscale Edition
This article will look deeper at the Azure SQL Database – Hyperscale edition, which was moved into General Availability (GA) in May 2019. This followed a bit of a preview time, when I first learned about how it worked in detail. I was impressed with th …