2019-10-10
22 reads
2019-10-10
48 reads
Split data into N equal groups
In this blog post, you will get the query to “Split data into N equal groups” using SQL Server and you will also see the practical implementation of the...
2019-10-10
94 reads
Split data into N equal groups
In this blog post, you will get the query to “Split data into N equal groups” using SQL Server and you will also see the practical implementation of the...
2019-10-10
786 reads
Weekly reading #28
September is over. This was not a good month for us. We had to cancel the conferences planned for September and were not able to write as much as...
2019-10-10
26 reads
Weekly reading #28
September is over. This was not a good month for us. We had to cancel the conferences planned for September and were not able to write as much as...
2019-10-10
64 reads
How to Reduce the Risk of SQL Database Corruption
Introduction:
Today we are going to learn how to prevent SQL database corruption. Let’s start with some facts about how database corruption can occur actually. The SQL database corruption could...
2019-10-09
372 reads
I’m Speaking at Microsoft Ignite 2019
I’m happy to be speaking at Microsoft Ignite this year. I have an unconference session and a regular session, both focused on accessibility in the Power Platform. The regular...
2019-10-09
49 reads
Speaker at SQL Saturday# 908 – Denver 2019
I’m very happy to announce that this will be my second time participating as speaker at the SQL Saturday# 908 in Denver! Here are the details of the session...
2019-10-09
49 reads
Just Getting Specific Files in PoSh–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Just a quick one today, but a tip...
2019-10-18 (first published: 2019-10-09)
240 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
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