The Curse of Working With A DBA
I no more than finished my rant from last week than I started thinking about all the reasons why a...
2014-06-30
1,642 reads
Make BOL your friend
One of the most powerful tools we have as users of SQL Server is Books Online (BOL). Whether you work...
2014-06-30
4,070 reads
Introduction to Spinlocks in SQL Server
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-06-30
4,083 reads
I like to move it, move it. Upload and download binary data to or from SQL Server using standard tools
Imagine that you have a huge collection of Hello Kitty images (I do).
One day you make a decision to organize...
2014-06-30
1,958 reads
Rename or Change SQL Server Standalone Default Instance
Today, We will go through with the steps of renaming or changing SQL Server Standalone Instance.
Step 1 : Check Current Instance...
2014-06-30
22,859 reads
Speaking at SQL PASS Summit 2014
I am honored to be selected to deliver 2 sessions at the SQL PASS Summit 2014. I will be delivering...
2014-06-29
1,321 reads
Building The SQLSaturday Orlando Marketing Plan-Part 21
Been busy the past week, not as much time on this as I’d have liked:
Received the “retro” flyer with the...
2014-06-27
1,137 reads
Speaking at PASS Summit 2014
I am excited and humbled to be speaking at the PASS Summit for my second year in a row! There...
2014-06-27
1,164 reads
Reblog: June 20 to June 26
Photo credit – Travis
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time...
2014-06-27
1,364 reads
PASS Summit Session Selection
Let’s make it democratic. Let’s ensure we get solid sessions from key people. And let’s save a ton of work...
2014-06-27
1,285 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