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
87 reads
Blog Posts
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
776 reads
Upcoming SQLpassion Online Trainings
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2019-10-10
8 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
51 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
18 reads
How I applied 13 cumulative updates in 12 minutes
Twitter is a strange place. I mean, aside from all the outrage practice and animal videos. Last week I sent out a tweet about how I used dbatools to...
2019-10-09 (first published: 2019-10-04)
725 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
369 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
47 reads
Instantaneous Transaction Rollback with SQL 2019
If you’ve read about the Accelerated Database Recovery feature in SQL Server 2019 you could be forgiven for thinking it’s just about speeding up database recovery time in case...
2019-10-09 (first published: 2019-09-25)
957 reads
Leveraging WHILE LOOP
WHILE LOOP can be used for batch processing and can be helpful if you are dealing with huge data processing. Recently I did an analytics project where I had...
2019-10-09
28 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
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
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
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