Category: Tricks and Tips

SQL PASS Summit 2011 – A First Timers View

SQL PASS Summit 2011 – A First Timers View

So, as promised, I’m lightly documenting my experience as a first timer at the SQL PASS Summit. In the next few posts, I’ll be specifically covering the 2011 Summit, held in Seattle, WA. I’ll break it up by day, beginning with travel and what to expect. Also, there are plenty of other articles out there…

Read More Read More

Procedure to Validate SQL Server Replication Convergence

Procedure to Validate SQL Server Replication Convergence

Today I’m posting a turn-key solution for those of you out there supporting SQL Server replication. The purpose of the stored procedure created by the script provided below is simply to leverage a little-known, but very useful, tool provided by Microsoft for the sake of convergence validation (all your table based articles are identical between the publisher and subscriber(s)).

SQL Agent Jobs owned by individual users – Quick Fix

SQL Agent Jobs owned by individual users – Quick Fix

Today I’m sharing a “quickly whipped script” to change the owner of SQL Agent Jobs to SA (or another of your choosing), so if the individual job owner were to leave the company and their AD account dropped, the job wouldn’t just begin failing. Feel free to use/modify/redistribute for any reason. SET NOCOUNT ON  …

Read More Read More

SSMS 2008 Bug Displaying SQL Server 2005 Database Objects

SSMS 2008 Bug Displaying SQL Server 2005 Database Objects

SSMS 2008 has a nasty little bug that Microsoft doesn’t seem to want to fix until the next major release of SQL Server. Less privileged users cannot see all of the 2005 SQL Server databases and objects in schemas for which are not their default schema. Permissions must be granted on the SQL Server 2005 databases for the users to re-enable something that works just fine in SSMS 2005.

I got SSWUG Published ;)

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…

Read More Read More

SQL Server Version/Build Lookup site

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.

Locate Startup Stored Procedures

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.