Re-blog – November 18 – November 24
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer...
2011-11-25
895 reads
Blog Posts
Destroying a Windows Cluster
I haven’t posted for a while but thought I’d dust off the blog and get a post out. I have...
2011-11-24
5,460 reads
MS DTC and sys.dm_tran_active_transactions
A sql reindex command was being blocked by two active transactions in MS DTC. Use
sys.dm_tran_active_transactions to report more detail on...
2011-11-24
2,245 reads
SQL Server 2012 licensing details
AdvertisementsMicrosoft’s SQL Server 2012 (AKA SQL Server code-name ‘Denali’), new details have been released http://www.microsoft.com/sqlserver/en/us/future-editions/sql2012-licensing.aspx.
1. What is new in SQL...
2011-11-24
4,481 reads
ALTER INDEX permissions
Developers like to have some control over the development process. An example is index building. Asking aDBA repeatedly for changes ...
2011-11-23
1,079 reads
DBA in Space: Behind the Scenes—Question 5
Part 1 of Question 5—The question.Part 2 of Question 5—The follow up to the question.This is a continuation of my...
2011-11-23
604 reads
DBCC WritePage
DBCC WritePage is a dangerous undocumented DBCC command. It’s useful in your sandbox to change data, crash objects, and do...
2011-11-23
2,872 reads
Running a TPC-C workload on SQL Server
I have a lot of customers with some impressive SQL Server workloads, those databases
are several hundred GB large, with several...
2011-11-23
8,008 reads
Speaking at Spring 2012 SQL Server Connections in Las Vegas
I am going to be one of the speakers at the Spring 2012 SQL Server Connections Conference in Las Vegas,...
2011-11-23
1,098 reads
SQL Deep Dives 2 on the Kindle
Since Deep Dives 2 came out, I had been putting off getting my copy of the e-book until I wanted...
2011-11-23
790 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