SQLSaturday Porto Edition 2014 Selection Process Results & Voting
This blog post is a continuation of the initial announcement almost a month ago about the session selection process that...
2014-07-25
213 reads
SQLBits XII Recap
There are different type of events – good ones, great ones, mediocre ones, bad ones & excellent ones.
There is a technological event...
2014-07-25
208 reads
Webinar Q&A: Getting Started with Change Data Capture
Yesterday I presented about Change Data Capture for the Pragmatic Works Free Training on the T’s. I covered the basics...
2014-07-25
1,472 reads
Speaking on ETL Security
I will be giving a presentation on ETL (Extract, Transform, Load) security at two user groups in the coming weeks.
Securing...
2014-07-25
881 reads
Reblog: July 18 to July 24
Photo credit – Husso
I’ve always been a fan of the feeling when I find an old blog post that’s got just...
2014-07-25
815 reads
A Question From The NomCom
One of the many things we’re discussing going into the 2014 PASS election is what the planned two official campaign...
2014-07-25
664 reads
Friday Followup For July 25, 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-07-25
367 reads
Thank You SQLBits!
Just a very quick post to say thank you to all the organisers, speakers, helpers, sponsors, venue staff, caterers, party...
2014-07-25
135 reads
Thank You SQLBits!
Just a very quick post to say thank you to all the organisers, speakers, helpers, sponsors, venue staff, caterers, party...
2014-07-25
633 reads
Clustered Columnstore Indexes – part 35 (“Trace Flags & Query Optimiser Rules”)
Continuation from the previous 34 parts, starting from http://www.nikoport.com/2014/07/20/clustered-columnstore-indexes-part-34-deleted-segments-elimination/
This blog post is about controlling some of the Columnstore Indexes behaviours...
2014-07-24
386 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