Quick script to find Published Articles in Transactional Replication
Quick script to list out all of your published articles for Transaction and Snapshot Replication in SQL Server 2005+.
Another SSWUG mention found…
Seems I was quoted in another SSWUG email daily newsletter a while back and missed it myself (I think I was on vacation….)
I got SSWUG Published ;)
A recent request from the SSWUG email newsletter asked how we as DBAs approach and handle application/service consolidation on your SQL Server servers. I have a pretty strong feeling and approach to this topic and emailed my experience to SSWUG…..and to my surprise (for the 2nd time I just heard from another DBA friend of…
Check “Long Running Operations” Stored Procedure
Download a script to create a SQL Server 2005+ compliant Procedure to return details for long running operations/processes.
SQL Server Version/Build Lookup site
Just posting a fantastic resource link today. SQLSecurity.com keeps a nearly always up to date listing, complete with links to KB Articles and the MS product pages, for SQL Server Versions/Builds. This one is my personal favorite of all the SQL Server build lookup pages online.
Do you Tweet?
I finally broke down and decided to open a Twitter account and hope to use it professionally to share SQL Server knowledge. I don’t have enough interesting to follow yet, but I’m hopeful I can find a way to begin leveraging both the blog and the Twitter account to become more involved in the SQL…
SQL Server 2008 & the SQL Server Surface Area Configuration Tool
Where is the Surface Area Configuration tool go in SQL Server 2008. It’s gone! But wait, there’s another way to satisfy this deep seeded craving of the true SQL DBA.
Wichita, KS SQL Users Group
Looking for a SQL Server Users Group in or near Wichita, KS? Me too. There doesn’t appear to be one any closer than KC. I hope to change that.
Locate Startup Stored Procedures
Find SQL Server Startup Procedures. SQL Server allows for stored procedures to be executed upon start up, allowing you to set any number of configuration options or start specific traces as soon as SQL starts up. Use this TSQL to locate any existing procedures on your server that are enabled to run at startup.
Changing SQL Server Agent Jobs Owners
Wrote a quick fix-it today for changing the owner of a SQL Agent Job from one login to another…..