Implementing Partial Backups and Restores (via Leveraging Partitions)
[read this post on Mr. Fox SQL blog]
Continuing on with my Partitioning post series, this is part 5.
The partitioning includes several major...
2015-07-06
1,779 reads
It is OK its NULL only TIP #103
We always take NULL very lightly. Like if we are designing database then whether it is necessary or not we...
2015-07-15 (first published: 2015-07-06)
2,728 reads
Execute All Packages Within SSIS Project Catalog
The SSIS Project Deployment Model is great! It really is the best thing since sliced bread! I specifically appreciate the...
2015-07-15 (first published: 2015-07-06)
2,814 reads
FOR JSON Clause Mode With ROOT Option In SQL Server 2016
Hi friends, we will continue with FOR JSON clause in this blog and today we will learn formatting of query...
2015-07-06
381 reads
But I Don’t Have a Test Server…
I frequently see statements on forums along the lines of “I don’t have a test server, so I’m going to...
2015-07-10 (first published: 2015-07-06)
3,149 reads
New Extended Events for 2016
As we begin to get a grasp of all that is available with SQL Server 2016 and all of the new features, it is a great idea to see...
2015-07-06
39 reads
New Extended Events for 2016
As we begin to get a grasp of all that is available with SQL Server 2016 and all of the...
2015-07-06
1,272 reads
Adding a new keyboard shortcut in SSMS.
I love keyboard shortcuts. I’d rather keep my hands on the keyboard than move back and forth to the mouse....
2015-07-13 (first published: 2015-07-06)
2,774 reads
10 Best Advices to Choose an SQL Consulting Firm
Managing SQL Server can be exhausting, so more and more companies today choose either to delegate this task to some...
2015-07-06
718 reads
Columnstore Indexes – part 58 (“String Predicate Pushdown”)
Continuation from the previous 57 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have previously blogged on the predicate...
2015-07-05
841 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