I’m Speaking at OPASS on May 28, 2015
I’ll be presenting Avoiding, Detecting, and Repairing Database Corruption and probably talking a little bit about career development during the...
2015-05-18
331 reads
Monday Morning SQL Break – May 18, 2015
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2015-05-18
522 reads
Still More Notes on the SQLSaturday Web Site–Registration
I’ll start by saying the intent of the notes isn’t to complain, at least too much. I’m looking for opportunities....
2015-05-18
373 reads
Precon this week! The Enterprise Scripting Workshop #SQLSaturdayBR
You are cordially invited to a fantastic precon event before SQL Saturday Baton Rouge! The Enterprise Scripting Workshop is on Friday,...
2015-05-18
568 reads
Come to Us or We’ll Come to You
No, that’s not a threat. It’s an offer to help out.
Redgate Software is very serious about the efforts we’re putting...
2015-06-01 (first published: 2015-05-18)
1,424 reads
Extending your metadata with Extended Properties
Ever wanted to put a comment on a table? Or maybe even a column? How about an expiration date on...
2015-05-28 (first published: 2015-05-18)
5,982 reads
How to Move MSDB & Model SQL Server system Databases ?
Steps of Moving MSDB & Model SQL Server system Database to new locaation:-
1) Check current location of MSDB & Model Databases by...
2015-05-18
3,289 reads
Outlier Detection with SQL Server, part 6.3: Visual Outlier Detection with Reporting Services Plots and SSDM Clustering
By Steve Bolton
…………When the goal is to illustrate how just how outlying an outlier may be, the efficiency with which...
2015-05-17
1,158 reads
Immersed in SQL Server at SQLskills
Over the last two years I have had the pleasure of attending all three SQLskills Immersion Event classes. This training is second to none in its quality and intensity....
2015-05-16
19 reads
Immersed in SQL Server at SQLskills
Over the last two years I have had the pleasure of attending all three SQLskills Immersion Event classes. This training...
2015-05-16
646 reads
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Force join by longest possible choice
Title pretty much says it. I want to join to a table that has...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
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