Reblog: July 25 to July 31
Photo credit – Travis
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time...
2014-08-01
573 reads
Speaker of the Month: August 2014
Speaker of the Month is now officially one year old.
I went back and reread my first post. The goals were...
2014-08-08 (first published: 2014-08-01)
7,055 reads
Friday Followup For August 1, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-08-01
314 reads
Website Pulse
Short blog post this time as Website Pulse contacted me a few weeks ago with a few questions about working...
2014-07-31
1,182 reads
An error occurred while executing batch. Error message is: Arithmetic Overflow
Recently an incident came across my desk where an end user was receiving an error trying to retrieve some records...
2014-07-31
2,498 reads
Log Shipping - Exclusive access could not be obtained because the database is in use
This story began as they almost always do - with a page at 4am local time...
--
'Alert: SQL Failed Jobs on InstanceName...
2014-07-31
10,842 reads
Please open this page in the Admin panel only
I am taking a slight deviation from the usual type of posts that I share. This time, I just want to share a quick and easy fix that I...
2014-07-30
8 reads
Please open this page in the Admin panel only
I am taking a slight deviation from the usual type of posts that I share. This time, I just want...
2014-07-30
1,401 reads
This Week in Awesome – Running at PASS, Cookie Jail, SQL Sats, Breakfast
If you’re in Seattle the week of November 2 – say, for example, you’re attending the PASS Summit that week – consider...
2014-07-30
1,036 reads
Building The SQLSaturday Orlando Marketing Plan–Part 27
Notes:
Email with the schedule went out this week, nice bump in registrations – we’re at 229 todayMailed the list twice (bad)...
2014-07-30
1,060 reads
Blogs
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
T-SQL Tuesday
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
Question of the Day
RegEx Functions II
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') AND BusinessEntityID IN (7,8)See possible answers