Reblog: May 30 to June 5
Photo credit – Jenn and Tony Bot
Sometimes old stuff is just as cool as new stuff. Over the past few years,...
2014-06-06
772 reads
5300 PASS Voters for 2014 Election
I was catching up on reading the minutes of PASS Board meetings and found the following except in paragraph 2...
2014-06-06
376 reads
D-Day, Family, Vets, and Life
Today is the 70th anniversary of D-Day, a day worth remembering and celebrating to be sure. I like that we...
2014-06-06
389 reads
Examining PAGEIOLATCH waits
In a previous article we looked at CXPACKET waits, a wait type that is can be on the top of your...
2014-06-06
741 reads
Speaker of the Month, June 2014
It’s not like I can’t find plenty of great presentations here in the US, but, while I was over in...
2014-06-06
753 reads
Friday Followup For June 6, 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-06-06
394 reads
Examining PAGEIOLATCH waits
In a previous article we looked at CXPACKET waits, a wait type that is can be on the top of...
2014-06-06
11,505 reads
Attaching All Databases with PowerShell–Refactoring out Write-Host
Someone posted a note to me on Twitter that noted that Write-Host is not recommended for your scripts. I checked...
2014-06-05
1,047 reads
Natively Compiled Procedures and Execution Plans
The combination of in-memory tables and natively compiled procedures in SQL Server 2014 makes for some seriously screaming fast performance....
2014-06-05
1,368 reads
Miscellaneous Notes on the PASS NomCom and General Election
Interesting day yesterday. A spirited discussion on Twitter, a challenging post from candidate Mark Broadbent, and a couple good threads...
2014-06-04
650 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