It seems like just a few weeks ago that I went over the 2018 results with Gene Kim. That was an exciting few weeks for me, running over the report in prep and then having the opportunity to host a webinar with Gene Kim. Exciting times, but it's been almost a year and the 2019 […]
Kathi Kellenberger addresses the retirement of the Microsoft Professional Program in the latest SImple Talk Editorial. Stop by and let her know your thoughts.
Phil Factor demonstrates the correct use of the RETURN keyword in stored procedures or batches, to pass back a non-zero RETURN code to the calling process, informing it of the error. He also explains some of its misuses.
In this tip we look at a way to stop the execution of a SSIS data flow task that is running by executing an outside process to stop the data flow immediately.
SQL Clone 4 introduces a new access control feature called Teams, allowing granular control over the SQL Server instances, images and clones to which each group of users has access. Here James Murtagh explains how Teams makes it easier to manage the safe distribution of database copies throughout the organization, to the various teams that need them for development, testing, training or analysis.
The business pressures can often change how we work, or even how we build our software. A few notes on Github from Steve Jones.
Step through a demonstration illustrating a sample deployment of SQL Server 2019 Always On Availability Group cluster on Azure AKS. You'll discover how to leverage the Microsoft Azure-hosted managed Kubernetes service referred to as AKS.
Over 800 SQL Server professionals took part in the 2019 State of SQL Server Monitoring survey. Travis Hoffacker takes a look at the report and advises what is now expected of a third-party monitoring tool based on the responses from the community.
Gail Shaw issues a rallying call for the SQL Community to adopt the Scientific Method when investigating and reporting on SQL Server behavior.
Greg Moore demonstrates how to work with the Get-Credential PowerShell cmdlet and secure strings when authenticating to an SFTP server.
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...
By Brian Kelley
If you don't have a plan, you'll accomplish it. That's not a good thing.
By Steve Jones
Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity...
Comments posted to this topic are about the item Where Your Value Separates You...
Comments posted to this topic are about the item Fixing the Error
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
On SQL Server 2025, I have a database that has this collation: SQL_Latin1_General_CP1_CI_AS. I decide I want to run this code:
SELECT UNISTR('*3041*308A*304C*3068 and good night', '*') AS 'A Classic';
I get this error:Msg 9844, Level 16, State 4, Line 24 The char/varchar input type uses an unsupported collation. Only a UTF8 collation is supported with char/varchar input type in UNISTR function.What is the easiest way to fix this error? See possible answers