This post is part 3 of at least a 4 post article on my First Timer view of the SQL PASS Summit as I experienced it personally. If you missed the first posts, click here. Day 3 Day 3 for me, Day 2 of the Summit (Thursday) rolls around and today I’ve gotten up a…
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…
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)).
How do you normally provide SQL Server passwords to end users? Email, IM, a sticky note? Here’s another way if you’re anal about security like me.
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 …
You have transactions stuck in the Transaction Log; the log won’t truncate; the log won’t shrink; the database is in Simple Recovery Mode; What do you do? (SQL Server 2008; DBCC LOGINFO; DBCC OPENTRAN;)
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.
Manage your SQL Server services via Configuration Manager remotely. Never RDP onto a server again just to check which services are installed and how they’re configured.
This script will not only leverage SQL Server 2005+’s ability to recommend missing indexes, but will give you the create statement to create them.
Seems I was quoted in another SSWUG email daily newsletter a while back and missed it myself (I think I was on vacation….)
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…
Download a script to create a SQL Server 2005+ compliant Procedure to return details for long running operations/processes.
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.
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.
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.
Wrote a quick fix-it today for changing the owner of a SQL Agent Job from one login to another…..