Database deployments, like the sheep of exasperated hill-farmers, often find strange and unexpected ways to self-destruct. Phil Factor describes the most common things that can go wrong, and how a reliable automated database build process can prevent messy accidents.
2019-10-03
In this tip we look at how to use an If Condition activity in an Azure Data Factory pipeline for conditional logic.
2019-10-02
Learn how a calculated value can be added to a table with the missing key values filled in.
2019-10-01
1,891 reads
In this tip we look at how to create a Pareto Chart which applies the Pareto principle aka the 80/20 rule using Power BI Desktop.
2019-10-01
SQL Monitor 9.1 offers a new PowerShell Alert API to control and fine tune your alert configuration, across a group of servers, and a new Server Permissions Overview table, which summarizes who has access to a server via a “super-privileged” server-level role. Here Redgate's Rebecca Woof dleves into the details.
2019-10-01
The Development component of SQL Change Automation now integrates directly into SQL Server Management Studio as well as Visual Studio. This allows teams to collaborate seamlessly during development, regardless of their preferred IDE. Other new features include new data compare options for PowerShell and static code analysis.
2019-10-01
Learn how you can secure your TDE environment by separating your key from the server using Extensible Key Management.
2019-09-30
9,342 reads
Last September Redgate University opened its doors online, since then, with their selection of getting started courses they have been helping customers get up and running with their tools. Now, along with a brand-new look, new courses have been added to help you advance your skills past the basic usage of the tools. Come and check it out and leave your suggestions for future courses.
2019-09-30 (first published: 2019-09-16)
Robert Sheldon continues his DevOps series with a look at security, privacy, and compliance. He recommends that these critical areas are tackled early in the DevOps pipeline.
2019-09-30
An account of a recent encounter we had with a peculiar wait event which was initially misdiagnosed.
2019-09-27 (first published: 2017-10-10)
5,848 reads
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy...
Comments posted to this topic are about the item UNISTR Escape
Comments posted to this topic are about the item Celebrating Tomorrow
In SQL Server 2025, I run this command:
SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";
What is returned? (assume the database has an appropriate collation)
A: 
B: 
C: 
See possible answers