Presenting with SQL Server Management Studio
Short one this week as it’s the usual madness on the lead up to Xmas!
One of the cool things that...
2016-12-14
728 reads
T-SQL Tuesday #85 Part Deux: Backup Myth Restoring Differential Backups
Welcome to T-SQL Tuesday #85 being hosted this month by Kenneth Fisher (blog|@SQLStudent144). This month’s topic is “Backup and Recovery”....
2016-12-13
731 reads
SQL in the City Prep
I’m at the Redgate Software offices this week. I come over to visit the company, my boss and our department,...
2016-12-13
500 reads
T-SQL Tuesday #85: Backup and Recovery
It’s that time of the month… the time when all of the T-SQL bloggers have a party and blog about...
2016-12-13
398 reads
Nintendo NES Classic Edition giveaway! #SQLFamily
I’ve managed to get my hands on a Nintendo NES Classic and I’m going to give it away. The details...
2016-12-13
721 reads
T-SQL Tuesday #85: Backup Log With NoRecovery
Welcome to T-SQL Tuesday #85 being hosted this month by Kenneth Fisher (blog|@SQLStudent144). This month’s topic is “Backup and Recovery”....
2016-12-13
784 reads
T-SQL Tuesday #85 – Backup & Recovery
Shout out to Kenneth Fisher (b|t) for hosting this month's #tsql2sday. This month is about backup and recovery and here...
2016-12-13
416 reads
Geek Sync Tomorrow: Surviving the Holidays with SQL Server
Tomorrow (December 14, 2016) at 12 PM Eastern I’m giving a webinar on preparing for your SQL Server farm for...
2016-12-13
333 reads
DBA Myths: You can only restore one differential backup
Ok, I know I’m hosting T-SQL Tuesday this month but I still had post I wanted to share.
The basic steps...
2016-12-13
474 reads
T-SQL Tuesday #85–Cross Version Restores
It’s T-SQL Tuesday time, and this month Ken Fisher hosts. His topic is backups, and while I’m sure there will...
2016-12-13
603 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers