Cluster failover fails
you may get an error while trying to failover to another node cluster. to resolve this issue create an alias...
2013-10-16
895 reads
LogReader agent failed
You may get an error on log reader agent failed with following error: Cannot execute as the database principal because...
2013-10-16
840 reads
SQL Server 2014 CTP2 Available to Download
At the PASS Summit keynote today Quentin Clark announced that SQL Server CTP2 (which is public and the last public review) and is available right now to download here....
2013-10-16
23 reads
PASS Summit Report #4
One of the items that came up for discussion at the Chapter meeting today was the privacy policy for SQLSaturday....
2013-10-15
306 reads
PASS Summit Report #3
Started today with breakfast with the family after packing up all their clothes and stuffed animals for the trip home....
2013-10-15
427 reads
PASS Summit Report #2
Weather a bit cloudy today, a little rain and a little cool – not Seattle, but not Orlando either! Breakfast at...
2013-10-15
456 reads
SQL Server Diagnostic Information Queries for October 2013
I have made some minor updates and bug fixes for all of my SQL Server Diagnostic Information Queries for this...
2013-10-15
1,329 reads
DMV-15 : Pending I/O requests……..sys.dm_io_pending_io_requests
sys.dm_io_pending_io_requests DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms188762.aspx
Returns a row for each pending I/O request in SQL...
2013-10-15
1,396 reads
Attending the SQL PASS Summit?
Are you attending the SQL PASS Summit conference in Charlotte, NC this week? If so, let’s meet up! If not,...
2013-10-15
909 reads
SQL Server Performance Root Cause Analysis in 10 Minutes
This year I was honored to be selected by Dell Software to present a ten minute session in their booth...
2013-10-15
1,117 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