Announcing Columnstore Indexes Script Library
Today, the 3rd of July 2015 marks the 2rd anniversary of my very first Columnstore Indexes blog post in the...
2015-07-05
469 reads
Run SQL Server In A Container Today July 2015
Containers are one of the big things at the moment, Microsoft has recently announced that they will be bringing official...
2015-07-03
811 reads
FOR JSON Clause With INCLUDE_NULL_VALUES Option In SQL Server 2016
Hi folks, Today we learn how to format query using FOR JSON clause with INCLUDE_NULL_VALUES option in SQL Server 2016....
2015-07-03
354 reads
010 – Ayman El-Ghazali - WaterOx Consulting
Reading Time: 2 minutesThe community makes it all happen! In WOxPod!, episode # 009 –...
The post 010 – Ayman El-Ghazali appeared first...
2015-07-03
590 reads
Speaker of the Month: June 2015
With my travel schedule, I don’t always get out to events where I can see a community speaker. Sometimes, I...
2015-07-03
579 reads
Speaking engagements for August and September
August and September are going to be some busy weeks!
In those two months I will be speaking on three SQLSaturday...
2015-07-03
551 reads
How to drop a Temporal Table
No no, I didn’t say temporary, but temporal! SQL Server 2016 introduces a great new feature called Temporal Tables. Or...
2015-07-03
2,785 reads
Making Changes to Many Forms In Access
Although generally I prefer to create custom interfaces for my databases using fully developed programming languages like Python or C#....
2015-07-03
515 reads
I’m Speaking! Omaha SQL Server/BI User Group
Well, it has finally happened. In the 7+ years that I helped to run the Omaha SQL/BI User Group, I...
2015-07-02
572 reads
Defining Foreign Keys at Table Create Time
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2015-07-13 (first published: 2015-07-02)
2,405 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
RegEx Functions IV
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', 'i') AND BusinessEntityID IN (7,8)See possible answers