A Perfect Solution to Resolve SQL Server Error 211
SQL Server Schema is basically a collection of SQL Objects that includes the tables, related columns, its entries, or other components. Due to this, it becomes easy for a...
2018-04-30
19 reads
Blog Posts
Bring Your Own Key to Azure SQL Database TDE
I have previously written about using Transparent Data Encryption (TDE) with Azure Key Vaule as a great way to store...
2018-04-30 (first published: 2018-04-19)
2,106 reads
Finding Untrusted Foreign Keys and Constraints
In the previous blog, we discussed the Foreign Keys Constraints and how the CHECK Constraints are useful to verify the...
2018-04-30 (first published: 2018-04-19)
3,144 reads
Guide for Setting up Telegraf to Monitor InfluxDB
Problem
If you been reading this series you are used to looking at Windows and SQL Server but who knows what...
2018-04-30
1,761 reads
Guide for Setting up Telegraf to Monitor InfluxDB
Problem
If you been reading this series you are used to looking at Windows and SQL Server but who knows what...
2018-04-30
204 reads
Security: Create and view Audit Logs
It is important to have a secure environment, enforcing the least privilege principle in your servers and databases, but this...
2018-04-30
5,384 reads
Shiny Tech Syndrome
This is the name I give to anyone who, whilst learning a new technology, suddenly thinks it’s the best thing...
2018-04-30
365 reads
SQL Server Removing Outliers With Standard Deviation
When running aggregations for reporting in some situations outliers can throw out the numbers.
For example lets say we have a...
2018-04-30
371 reads
Export data from Cosmos DB to SQL Server
Cosmos DB is Microsoft’s latest NoSQL database offering low latency, high scalability and geo-distribution to any Azure region. Read Microsoft...
2018-04-29
2,603 reads
Introduction to Azure Cosmos DB
What is Azure Cosmos DB?
Cosmos DB started as an internal project – “Project Florence” – at Microsoft in 2010. It is a...
2018-04-29
399 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