Experiments with full text search
Would a crazy idea using full text thesaurus and phonetic keys actually have worked?
Consulting 102 – Why Do I Give 100% Guarantee of My Service? – SQL Server Performance Tuning
This is the second of my 5 part series on my over 10 years of experience in Comprehensive Database Performance Health Check consulting engagement. Here are the five blog posts that are the essence of my consulting business. You can also call it my busi …
What happens when you cancel or kill a resumable index creation?
SQL Server 2019 adds resumable online index creation, and it’s pretty spiffy:CREATE INDEX IX_DisplayName ON dbo.Users(DisplayName) WITH (ONLINE = ON, RESUMABLE = ON, MAX_DURATION = 1); Those parameters mean: ONLINE = ON means you’ve got the …
Getting Comfortable Writing Code in Azure Data Studio
Learn some of the ins and outs of working with Azure Data Studio to develop SQL code.
Consulting 101 – Why Do I Never Take Control of Computers Remotely? – SQL Server Performance Tuning
This is the first of a 5 part series on my 10 years of experience in Comprehensive Database Performance Health Check consulting engagement. Here are the five blog posts that are the essence of my consulting business. You can also call it as my business …
24 Hours of PASS (April 2019): 20 Years of PASS!
The next 24 Hours of PASS will have the opportunity to celebrate the first 20 years of the international association of professionals and data management experts. PASS is the acronym of Professional Association of SQL Server, PASS was established on 19 …
How Does QUOTED_IDENTIFIER Works in SQL Server? – Interview Question of the Week #217
Question: How Does QUOTED_IDENTIFIER Works in SQL Server? Answer: If you search on the internet, you may find quite lots of notes about it. So in this blog post, I will explain in very simple words. First, let us see the following example where I have …
SQL SERVER – Read Only Routing Error: Client Unable to Establish Connection Because an Error was Encountered During Handshakes Before Login
I have helped many clients in deploying Always On Availability Group. Based on their requirement they keep using additional features provided by availability groups. This time they wanted to use always-on availability group read-only routing feature. T …
SQL Server Reporting Services Lookup, LookupSet and MultiLookup Functions
I noticed the Lookup function in SQL Server Reporting Services. In this tip we look at all three SSRS lookup functions: Lookup, LookupSet and MultiLookup.
SQL in the City Summits – UK, US & Down Under
Redgate are inviting senior data professionals to attend one of the upcoming SQL in the City Summit events taking place in April, May and June. If you’re interested in learning how your business can benefit from implementing Compliant Database De …
SQL SERVER – When You Should Not Attend SQL Server Performance Tuning Practical Workshop for EVERYONE?
So far many of you know that my SQL Server Performance Tuning Practical Workshop for EVERYONE is extremely popular and it is almost full when I am writing this email. I can now accommodate a maximum of 5 individuals in the class as we are reaching capa …
Updated First Responder Kit and Consultant Toolkit for March 2019
This month, just half a dozen bug fixes, plus a new parameter for sp_BlitzCache to search the plan cache for specific strings. To get the new version: Download the updated FirstResponderKit.zip Azure Data Studio users with the First Responder Kit …
Backup your Reporting Services Encryption Key
If you run SQL Server Reporting Services, part of your DR plan needs to include a backup of the encryption key for SSRS. This sadly is an all to often overlooked part of the solution, even though it is incredibly easy to do. If you don’t have a b …
Extended Events in Azure Data Studio
I was prompted to dig into using Extended Events in Azure Data Studio (ADS) after the latest release came out from the Tools Team this past Monday. After you download and install ADS, and connect to an instance, you’ll want to navigate to t …
Help us define the state of SQL Server monitoring in 2019
Last year we ran the industry’s first ever state of SQL Server monitoring survey, the results not only gave great insight for the community but helped us shape our product development to ensure we were meeting the needs that you were asking for. …