Carving up CHECKDB
This is a technique that I am using from Paul Randal – concept of splitting CHECKDB: CHECKALLOC, CHECKCATALOG and CHECKTABLE – here...
2015-05-16
188 reads
Quick Installs with Chocolatey–Screen Capture
I have been looking for a new screen capture tool. I used to use Snagit, but it felt too heavyweight...
2015-05-15
915 reads
003 – The Data Guild - WaterOx Consulting
Reading Time: 5 minutesAre you an Apprentice DBA? in WOxPod!, episode # 003 – The...
The post 003 – The Data Guild appeared first...
2015-05-15
512 reads
I Am Grateful For…
I’m almost done reading the book Connected (will be by the time this is published). It’s fascinating although, at least so...
2015-05-15
508 reads
How To Get Fired from an ETL Developer Job
Through the course of my 8-someodd years of building and fixing ETL processes, I’ve had the opportunity to see a...
2015-05-15
2,069 reads
Speaking at SQL Saturday Rochester this weekend!
I’ll be presenting my session Easing into Scripting with Windows PowerShell this Saturday, May 16th at SQL Saturday Rochester.
SQL Saturday is a free, all-day event for learning about SQL Server and...
2015-05-15
8 reads
Getting Database Properties – DatabasePropertyEx()
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2015-05-14
2,743 reads
Stairway to Virtualization Level 2 up at SQL Server Central
Yesterday the next installment of the Stairway to Virtualization series went live on SQL Server Central! This level focuses on...
2015-05-14
454 reads
Speaking at 24 Hours of PASS
I’m thrilled to announce that I’ve been selected to present as part of the next 24 Hours of PASS! The...
2015-05-14
475 reads
Database Growth
Last week I got into a conversation with a colleague about how SQL Server grows the database. We were both fairly...
2015-05-14
1,200 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