The first three levels of this series have been the lead-up to this level, automating the database deployment with Azure Pipelines. First, we started with an introduction to Azure DevOps and the Git client. Next, SQL Source Control was introduced to manage a database’s schema and manually deploy changes from the database to source control […]
A stagnant career can be stifling, and it can make you unhappy at work, where you spend a lot of time. Steve has a few thoughts on how to avoid that.
Cardinality estimation (CE) is a process used by the query optimizer to estimate the number of rows returned by a query or sub-part of a query. These estimates rely on two underlying things: statistics about the data and a set of assumptions—known as the model.
Welcome to part twenty of the plansplaining series. It has been a long time since I last wrote a plansplaining post, partly because of my health, but also for a large part because I was out of ideas. But recently I decided to dig a bit deeper into a feature that was released in SQL Server 2017 and that I had so far not played with: SQL Graph.
This article examines how GitHub Copilot might be used when working with T-SQL Code.
Steve reminds people today that the recommendations from execution plans aren't always what you want to use when tuning your database.
If you aspire to drive Database DevOps at your company, regardless of the sector you work in, this webinar provides a unique opportunity to learn from experts in the finance sector who have successfully paved the way. Join us December 6th.
Learn about various PowerShell commands that can be used to administer virtual machines on Amazon AWS.
Someone generated a fake speaker profile for their conference, which Steve finds disturbing.
Learn the basics of how to work with objects in Cassandra, a NoSQL database.
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