Should you run SSAS/SSIS/SSRS on the SQL Server?
When you’re building a new SQL Server, you’re going to see a few intriguing checkboxes during setup. It’s all free, right? Check everything! The services are all free, right? You can just check the boxes for Machine Learning Services, …
How to Apply Non-Standard SQL Formatting Using SQL Prompt
Like any good tool, SQL Prompt not only will format your code for you, but will also help you to format the code in an alternative manner, or to apply exceptions to certain parts of a SQL script, where the formatting applies by the current style isn’t …
Why Redgate is Running a Database Development Disasters Contest?
Kendra Little explains why Redgate would like to hear your stories of how the database has been left behind.
Frequently Asked Questions for SQL Server Performance Tuning Practical Workshop for EVERYONE
Earlier this week I announced my very first online training class open for (US, EU, Asia, and Everywhere) over here: SQL Server Performance Tuning Practical Workshop for EVERYONE – April 23, 2019, and so far I have received an amazing respon …
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 …