Don’t Forget RoboCopy
On occasion you have to find means to get around an issue. John Morehouse shows why Robocopy can be a useful tool in testing circumstances.
2019-05-03
Administration
Find-and-Replace for SQL Server Agent Jobs
Once in a while you might need to make common changes to a lot of SQL Server Agent Jobs.
2019-05-03
Is Your Availability Group ‘REALLY’ Ready To Failover?
You know what it’s like, you need to fail your AG over but is it safe to fail over? Even if your AG says it is, there are other thing to consider...
2019-05-03
497 reads
Minimal Logging with INSERT…SELECT into Heap Tables
Achieving minimal logging with INSERT...SELECT can be a complicated business.
2019-05-02
No, This is not a Bug in T-SQL
Gail Shaw keeps seeing this in all sorts of places. People getting an unexpected result when working with a subquery, typically an IN subquery, and assuming that they’ve found...
2019-05-02
Generate script to recreate indexes
For me, this particular code to generate a script to recreate indexes has more practical use in a replication environment.
For example, the default replication setting is to exclude the...
The...
2019-04-26
Slow inserts across a linked server?
Linked Servers offer a great way to connect two SQL Servers together, allowing remote querying and DML operations. Frequently, this is used to copy data from production to reporting....
2019-04-25
Proposed SQL Server defaults: optimize for ad hoc workloads
A few months ago I suggested that the following settings should be the default for most SQL Server instances: Set cost threshold for parallelism to 50 Disable lightweight pooling...
2019-04-24
Enable a Named Instance to Connect on 1433
My default setup for a few years is to only use named instances, usually with a standard SQL2014 or SQL 2016 as the name of the instance. Recently, I...
The...
2019-04-22
Shrinking a large database with limited outage windows
Yes, I realize you shouldn’t shrink your database (data files or log files), but I recently had a case where ... Continue reading
The post Shrinking a large database with...
2019-04-22
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
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
SQL Art: I Made a Christmas Card In SSMS
Comments posted to this topic are about the item SQL Art: I Made a...
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