Using the Wait Statistics Report in Azure Data Studio
Azure Data Studio, which used to be called SQL Operations Studio, has a bunch of extensions available, including one called Server Reports from Microsoft. Last year they took my wait stats query (from here) and made it into a report as part of Ser …
How fast can a $21,468/mo Azure SQL DB load data?
In my last post, I explored how fast a $5,436/mo Azure SQL DB Hyperscale could load data. I’d had a client who was curious about spinning up their dev environment up there to see how query plans might look different. Well, as long as I was runnin …
Stairway to Server Management Objects (SMO) Level 1: Concepts and Basics
Learn how to get started working with SMO and PowerShell.
Provisioning Multiple Masked Databases
Addressing common challenges, Redgate’s Chris Unwin explains how to create multiple masked copies of a database, delivered as a group with SQL Provision.
SQL SERVER – New Parallel Operation Cannot be Started Due to Too Many Parallel Operations Executing at this Time
One of my clients contacted me via my On Demand (50 Minutes) offering and they were seeing below error message in ERRORLOG – New parallel operation cannot be started due to too many parallel operations executing at this time. Here is the complete …
How fast can a $5,436/mo Azure SQL DB Hyperscale load data?
A client asked, “How quickly could we spin up a full copy of our database in the new Azure SQL DB Hyperscale?” Their database size wasn’t too far off from the 340GB Stack Overflow database, so I decided to migrate that to Hy …
Infrastructure Planning for a SQL Server Data Warehouse
In this tip we look at some things you should think about when planning for a SQL Server data warehouse.
Using Computed Columns
Although computed columns are from the beginning of SQL Server, not everyone knows how to use them. This article will help you better understand how it works.
The Whys and Wherefores of Untrusted or Disabled Constraints
Phil Factor explains what causes this issue, the problems it will cause and how to avoid the problem
First Online Open for All Class: SQL Server Performance Tuning Practical Workshop for EVERYONE – April 23, 2019
I have been delivering SQL Server Performance Tuning Practical Workshop for various organizations and it has been an extremely popular class so far. I get lots of requesting that I should deliver it for individuals. The only reason, I never schedu …
The Performance of Window Aggregates Revisited with SQL Server 2019
In 2005 and 2012, Microsoft introduced a number of windowing functions in SQL Server, like my favourite function LAG. These functions perform well, but, in my opinion, the main benefit is making complicated queries easier to write. I’ve been fasc …
Create, Protect and manage non-production databases with SQL Provision
SQL Provision allows teams to create a secure, scalable and repeatable process for managing data as it moves through your SQL Server estate, without causing administrative burdens. Tony Davis explains how SQL Provision can work alongside your existing …
SQL SERVER – Cannot Drop the Assembly ‘ISSERVER’, Because it Does not Exist or You do not Have Permission
As they say – There are more ways than one to skin a cat. In this blog we will find another method to fix an error which you might see during SQL upgrades – Cannot drop the assembly ‘ISSERVER’, because it does not exist or you d …
What Microsoft's Open Source PostgreSQL Acquisition Portends for SQL Server
Microsoft’s acquisition of Citus Data expands on the Azure commitment to open source and may provide horizontal scaling for SQL Server.
What is Consolidation of Index? – Interview Question of the Week #212
Question: What is Consolidation of Index? Answer: In the recent SQL Server Performance Tuning Practical Workshop, I was asked this question and the answer to this question is really not as straight forward as want to have. Here is an example of wh …