T-SQL Tuesday Retrospective #010: Indexes
(You can see previous T-SQL Tuesday retrospectives by visiting this link.) In September 2010, Michael J. Swart (blog | Twitter) invited us to talk about indexes. Indexes are strange...
2021-02-03
24 reads
Blog Posts
Azure SQL Database and Long-Term Backups
There is a new (ish) interface to looking and configuring backups for your Azure SQL Database. This can be found within the settings section of the SQL Server. As...
2021-02-02
94 reads
Daily Coping 1 Feb 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-02-02
11 reads
Daily Coping 2 Feb 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-02-02
8 reads
Data Lakehouse defined
As a follow-up to my blog Data Lakehouse & Synapse, I wanted to talk about the various definitions I am seeing about what a data lakehouse is, including a...
2021-02-02 (first published: 2021-01-25)
595 reads
Recovering Data from a Backup with SQL Data Compare
I had a customer recently ask about how to recover data from a backup file. I believe the request was for SQL Backup, but I knew there was another...
2021-02-02 (first published: 2021-01-25)
305 reads
Azure Platform Series “You have exceeded the maximum amount of scale changes within the past hour”
This blog post relates to where you might be doing scale operations of your app services or VMs in Azure and get the following error after doing quite a...
2021-02-01 (first published: 2021-01-23)
247 reads
SELECT * Hurts Performance, Badly
Quite a few years ago, I wrote a post about SELECT * and performance. That post had a bit of a click-bait title (freely admitted). I wrote the post...
2021-02-01 (first published: 2021-01-25)
696 reads
[Coping] Hidden Wounds
Through high school and college, I carried deep wounds due to what was going on at home. Only a handful of people outside of my family knew what what...
2021-01-29 (first published: 2021-01-20)
419 reads
Getting a New Remote Git Branch–#SQLNewBlogger
I was notified of a new PR at DataSaturdays, and I went to look at the changes. In this case, a lot of styling items in the code, which...
2021-01-29 (first published: 2021-01-13)
185 reads
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
Happy Holidays, Let's Do Nerdy Stuff
Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy...
UNISTR Escape
Comments posted to this topic are about the item UNISTR Escape
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
Question of the Day
UNISTR Escape
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