SQLSaturday Orlando 2018 – Planned for October 6
Just a quick note that we’ve reserved the date for our 12th SQLSaturday here in Orlando. It will be held...
2018-03-28
280 reads
Blog Posts
Stretch Databases for the Budget Poor DBA
The post Stretch Databases for the Budget Poor DBA appeared first on WaterOx Consulting.
2018-03-28
451 reads
TempDB Filling Up On Secondary Replicas
Have you ever had an issue where TempDB was filling up on your secondary replicas? Do those secondaries happen to...
2018-03-28 (first published: 2018-03-21)
3,894 reads
Webinar: Is the traditional data warehouse dead?
As a follow-up to my blog Is the traditional data warehouse dead?, I did a webinar on that very topic for...
2018-03-28
411 reads
Webinar: Is the traditional data warehouse dead?
As a follow-up to my blog Is the traditional data warehouse dead?, I did a webinar on that very topic for...
2018-03-28
101 reads
What’s the difference between Files and Filegroups?
tl;dr; Filegroups are a logical construct used to separate tables and indexes from each other, files are the physical construct...
2018-03-28
774 reads
AT TIME ZONE: The easy way to deal with time zones and daylight savings time
Watch this week's video on YouTube
Many people think daylight savings time was created to help align the hours that the sun is up with our waking hours so farmers...
2018-03-27
14 reads
AT TIME ZONE: The easy way to deal with time zones and daylight savings time
Watch this week's video on YouTube
Many people think daylight savings time was created to help align the hours that the sun is up with our waking hours so farmers...
2018-03-27
22 reads
DB_NAME() vs ORIGINAL_DB_NAME()
I’d never seen ORIGINAL_DB_NAME until recently and I thought it would be interesting to highlight it out, and in particular...
2018-03-27 (first published: 2018-03-15)
2,885 reads
How To Steal Data Using Second Order SQL Injection Attacks
One misconception some people have about SQL injection is that it can only happen when concatenating a user input parameter...
2018-03-27 (first published: 2018-03-20)
4,986 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