Re-blog – August 5-August 11
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Oddly enough,...
2011-08-11
471 reads
Blog Posts
Reset Identity Column in SQL
I’ll be honest, I am partially writing this because I always forget how to reset the identity column on a...
2011-08-11
1,330 reads
Seeking Volunteers for the Nomination Committee
We have a few changes in the election process for PASS this year, one of them is that we have...
2011-08-11
651 reads
SQL MCM Training – Day 3
Nothing to say about today, Jonathan did really a great job describing Extended Events
and Baselining/Benchmarking to us, and his boss...
2011-08-11
1,066 reads
Summit 2011
Call me a slacker. I have been postponing registering for Summit 2011. I wanted to be sure that I had the week available in order to attend. I finally...
2011-08-11
6 reads
Summit 2011
Call me a slacker. I have been postponing registering for Summit 2011. I wanted to be sure that I had...
2011-08-11
505 reads
We Are TOTALLY Amused: A T-SQL Error
This has to be the best error I’ve ever seen:
Msg 195, Level 15, State 10, Line 2
‘SUM’ is not a...
2011-08-11
836 reads
When was the Last Time You Removed an Index Because it was Never Used?
Indexes can be great for boosting the performance of a query, but if an index is never used, it can...
2011-08-11
1,161 reads
Call for Speakers for the SQL Track at the Tallahassee Code Camp
The annual Code Camp is coming up on October 1st in Tallahassee and our local SQL group is trying to...
2011-08-10
799 reads
Denali & CTP 3
I have Denali installed on a virtual machine on my laptop and I’m working through evaluating it. Actually, I’m working...
2011-08-10
668 reads
Blogs
Ten Years of PowerShell
Ten years ago, I published a post about filming a Pluralsight Play by Play...
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...
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