Marketing Materials for PASS Chapters
I brought this back with me from SQLSaturday South Florida. It’s postcard sized and laminated, and information dense in a...
2015-06-15
416 reads
See Two Queries at Once in SSMS
I’m writing this post as a way to help motivate the #SQLNewBloggers out there. Read the bottom for a few...
2015-06-15
2,602 reads
Notes From SQLSaturday #379
Notes from the trip:
Made the trip down without stopping and without getting stuck in traffic – a first!Attended speaker dinner on...
2015-06-15
354 reads
Sneak Preview – Podcast 008 - WaterOx Consulting
Reading Time: 1 minutesLet’s Play A Game! So, just to tickle your fancy, here is...
The post Sneak Preview – Podcast 008...
2015-06-15
418 reads
Adventures with NOLOCK
Some of the beauty of being a database professional is the opportunity to deal with our friend NOLOCK. For one reason or another this query directive (yes I am calling...
2015-06-15
8 reads
Adventures with NOLOCK
Some of the beauty of being a database professional is the opportunity to deal with our friend NOLOCK. For one reason...
2015-06-25 (first published: 2015-06-15)
3,428 reads
Columnstore Indexes – part 56 (“New DMV’s in SQL Server 2016”)
Continuation from the previous 55 parts, the whole series can be found at http://www.nikoport.com/columnstore/
Before starting to dive into the specific...
2015-06-15
681 reads
SQL Server 2016 – Stretch Databases
One of the feature I’ve been interested in that’s coming with SQL Server 2016 is the stretched database. The ability...
2015-06-15
532 reads
SQL Server 2016 – Stretch Databases
One of the features I’ve been interested in that’s coming with SQL Server 2016 is the stretched database. The ability...
2015-06-25 (first published: 2015-06-15)
5,557 reads
Rename a database
Renaming a database isn’t something you do frequently but it does have bit of a gotcha. First of all let’s...
2015-06-15
610 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