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 …
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. …
Dynamically Generate Replication Tasks with Biml and Custom Connectors
This article walks through using Biml with 3rd party connectors to replicate external data to SQL Server in SSIS.
Microsoft Unveils Azure Backup for SQL Server
Azure Backup for SQL Server allows organizations to centralize backup and restore across a fleet of SQL Server instances.
SQL SERVER – Stretch Database – Free Trial Subscriptions Can Provision Basic, Standard S0 through S3 Databases, up to 100 eDTU Basic or Standard Elastic Pools and DW100 Through DW400 Data Warehouses
I wrote a blog earlier about my first experience (and error encountered) with “Stretch Database” feature. In this blog I would talk about the error – Free Trial subscriptions can provision Basic, Standard S0 through S3 databases, up t …
The Curious Case of… unstoppable DBCC CHECKDB
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working …
Glenn’s Tech Insights For March 20, 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 fix the error “String or binary data would be truncated”
First, let’s see the error happen: let’s create a table with small fields, and then try to insert more data than it holds.CREATE TABLE dbo.CoolPeople(PersonName VARCHAR(20), PrimaryCar VARCHAR(20)); GO INSERT INTO dbo.CoolPeople(PersonName, …