Partitioning Basics – Part 3 – Switching Data
This post follows on from Partitioning Basics – Part 2
In this final part, I want to go through how partitions can...
2014-06-24 (first published: 2014-06-20)
3,246 reads
The DBA Who Came In From The Cold
Partitioning Basics – Part 2 – Splitting/Merging Partitions
This post follows on from the previous post Partitioning Basics – Part 1
Let’s have a look at the partitions setup in...
2014-06-12
1,064 reads
Partitioning Basics – Part 1 – Creating Partitions
Partitioned tables can be a quick and efficient way to (amongst other things) archive data. In the next couple of...
2014-06-09 (first published: 2014-06-04)
5,096 reads
Error Log Management
Thought I’d write a quick post about managing error logs within SQL Server. Good error log management is essential for...
2014-05-09
2,433 reads
Database Design Guidelines For Developers
One of the developers that I work with asked me to write a “brief” (really brief) guide on database design....
2014-04-07 (first published: 2014-04-03)
25,871 reads
SQL Server 2014 RTM
The new version of SQL Server will be here on Tuesday.
(Someone at Microsoft has a sense of humour in releasing...
2014-03-30
1,517 reads
Index Fragmentation
So you’ve setup a bunch of indexes in your database to tune the queries coming in. They’re all running much...
2014-03-13
2,490 reads
Who are your victims?
Or….deadlock notifications.
In my previous post I talked about having your own database(s) and what information you could be collecting. One...
2014-02-11
600 reads
Your own personal space
Somewhere to relax, get away from it all (by all I mean pesky Developers wanting code deployed on a bleeding...
2014-01-30
1,029 reads
Shutting down multiple servers with Powershell
I’ve recently helped a company move their infrastructure to a new data centre. Part of this involved shutting down a...
2014-01-09
559 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