SQL Server 2008 R2 SP1 Cumulative Update 4
On December 19, 2011, Microsoft released SQL Server 2008 R2 SP1 Cumulative Update 4 (CU4), which is Build 10.50.2796. I...
2011-12-26
3,062 reads
Dynamic Sorting in SSRS
Introduction
Many times while developing any report we come across a situation where we need to SORT the TABLE columns or...
2011-12-30 (first published: 2011-12-26)
21,200 reads
SQL Server A to Z – YEAR
SELECT 'Happy '+ DATENAME(dw, GETDATE())Welcome to the penultimate installment of SQL Server A to Z (it’s not often I get to...
2012-01-02 (first published: 2011-12-26)
2,307 reads
Twas The Week After Christmas....
Holiday Greetings to all you DBA's and SQL Server professionals! This blog goes out to all of you who are on-call...
2011-12-26
2,281 reads
Modifying SQL Server Synonyms – this time with Powershell
So, how do you recover from the Holidays? Hot Cocoa by the fire? Relaxing evening with your spouse watching an...
2011-12-26
1,618 reads
SQL Server – How to identify service pack installed
Identifying current service pack installed for SQL Server can be difficult if you don’t know which command to use! Most...
2011-12-25
2,795 reads
SQL Server 2012 RC0 and beyond
Since the stable and mainly feature-complete versions of SQL Server 2012 have been available, I have been heads-down on multiple...
2011-12-25
747 reads
Top 10 SQL Server Posts for 2011
2011 is nearly over. It’s time to list the Top 10 viewed SQLServer-DBA.com posts for the year , based on Views.
System...
2011-12-24
829 reads
SQL Server 2012 (“Denali”): New Security Features
SQL Server 2012 has many new security features, and three of the bigger new features are: Default Schema for Windows Groups,...
2011-12-23
1,971 reads
Re-blog – December 16 – December 22
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2011-12-23
528 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