Some useful commands and sp for Transaction Replication
This blog is having some useful commands we use for replication and troubleshooting.
>>Some useful commands and stored procedures
How it works:
Log...
2009-10-23
18,557 reads
Some useful commands and sp I use for Transaction Replication:
I write several blog about replication and mansion commands and stored procedure related to transaction replication, but I would like...
2009-10-23
1,343 reads
PASS Summit One Week Away
It’s just a week and a couple of days before I’ll be hopping a plane for Seattle and the 2009...
2009-10-23
590 reads
Just Submitted Session for South Florida Code Camp
I can’t wait until Feb 27 when Code Camp is right in my backyard! I just submitted my session for...
2009-10-23
369 reads
SQLLunch – Accidental DBA and Performance Data Collector
If you haven’t had a chance to attend the SQL Lunch Live Meeting learning series then sign in Monday at...
2009-10-23
880 reads
Another Year, Another Missed PASS Summit
This year I was really looking forward to going to the PASS Summit. It's worth every penny in the knowledge you'll...
2009-10-23
1,670 reads
Download the Free eBook “The SQL Server Tacklebox”
Rodney Landrum, SQL Server MVP, is the author of the new book, The SQL Server Tacklebox: Essential Tools and Scripts...
2009-10-23
585 reads
Not Pointing Fingers - Microsoft and Sidekicks
Someone posted a note on Twitter about the Sidekick fiasco. Apparently the servers that lost data weren't Microsoft servers. They...
2009-10-23
811 reads
Sydney SQL Server Users Group Draws Big Crowd
On Tuesday, October 13, I spoke at the Sydney SQL Server Users Group, presenting on “How to Get the Most...
2009-10-23
500 reads
PASS Update #18
Eric Wisdahl posted some questions on my last update, and I thought I’d reply here to make my answers more...
2009-10-22
803 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
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