Goals 2012
As I have wanted to do each year, here is my goals post for 2012. Last year I set out to do this very same thing but was very...
2012-02-08
7 reads
2012-02-08
1,162 reads
AlwaysOn: Configuring Secondary Read-Only Access
Now that you have AlwaysOn configured and your first Availability Group (AG) created, it’s time to start leveraging those secondary...
2012-02-10 (first published: 2012-02-08)
10,294 reads
AlwaysOn: Configuring Secondary Read-Only Access
Now that you have AlwaysOn configured and your first Availability Group (AG) created, it’s time to start leveraging those secondary...
2012-02-08
1,100 reads
Using Reporting Services as your Software Frontend
Microsoft SQL Server Reporting Services is an excellent and easy-to-use platform for creating, viewing, managing, and subscribing to reports of...
2012-02-08
689 reads
Not enough storage is available to complete this operation
This message appears in the TDP SQL dsmsched file. It’s usually associated with low levels of contiguous memory
BackupVirtualDeviceSet::SetBufferParms: Request large...
2012-02-08
3,458 reads
Computed Columns and Divide by Zero
I have a few posts on computer columns, the basics of computed columns, using CASE in a computed column, and...
2012-02-07
4,517 reads
SQLBits9
SQLBits9 – “Query across the Mersey” was held in the majestic Adelphi hotel. This was my first SQLBits experience and was...
2012-02-07
1,000 reads
Denali
Is all set to be officially known as SQL 2012 and will be finally released in....... 2012!
Announced at the PASS...
2012-02-07
855 reads
Simple XML exist performance enhancement
I came across this really simple best practice from BOL for the xml method exist which when used will give...
2012-02-07
1,279 reads
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
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...
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