ASP.NET 5 Unit Testing With xUnit.net
This post is part of a series on ASP.NET 5, the index for this can be found here ASP.NET 5...
2015-05-19
51 reads
Slides & demos from SQL Saturday Rochester
Slides & demos from my SQL Saturday Rochester presentation “Easing into Scripting with Windows PowerShell” have been posted on the SQL Saturday site.
Thank you to everyone who came out for...
2015-05-19
10 reads
Database In Recovery Update
Many moons ago, I published a post that contained a script to aid in easing the anxiety that comes when a database is “In Recovery”. When I pulled that...
2015-05-18
6 reads
Database In Recovery Update
Many moons ago, I published a post that contained a script to aid in easing the anxiety that comes when...
2015-05-18
484 reads
Why Test Table MetaData Tests with tSQLt
I wrote at SQLServerCentral about using tSQLt to check table metadata. In essence we are testing the API of our...
2015-05-18
680 reads
Counting the number of rows in a table
Don’t be fooled by the title of this post: while counting the number of rows in a table is a...
2015-05-25 (first published: 2015-05-18)
9,269 reads
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
330 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
521 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
372 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
567 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
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...
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