Scripting out SQL Server Logins

I regularly move logins between servers.  Mostly this is between production and our DR site.  I’ve used the code in KB246133 many, many times but it’s pretty limited.  I started with that and wrote the script below. There is a user-defined function that’s created in master.  You…

Lessons from a SAN Failure

At 1:10AM Sunday morning the main SAN at one of my clients suffered a “partial” failure.  Partial means that the SAN was still online and functioning but the LUNs attached to our two main SQL Servers “failed”.  Failed means that SQL Server wouldn’t start and the MDF and…

SQL Server Links - 19 January 2010

The Bit Bucket (Greg Low): IDisposable : Stored Procedures - Time for a real contract? [sqlblog.com/blogs/greg_low/] Interesting case of watching log file growth during a perf test [www.sqlskills.com/BLOGS/PAUL/] Improvement in minimizing lockhash key collisions in SQL Server 2008R2 and its impact on concurrency…

SQL Server Links - 8 Dec 2009

I’ve been posting links to interesting blog posts in the SQLTeam.com Newsletter for over a year now.  I going to try posting them here also. Oh what job was it? A procedure to search your jobs for a particular string [www.sqlservercentral.com/blogs/james_howards_sql_blog/…

Cost to Compile a Query

It’s pretty easy to determine the CPU and disk resources that a given query or stored procedure will use.  It’s more difficult to determine the resources that were used to compile that query plan.  You can start by looking at sys.dm_exec_cached_plans.  It has a…

SQL Server sites I visit

Google Reader just introduced functionality to create “bundles” of feeds.  I subscribe to roughly 60 SQL Server blogs that I read on a regular basis.  You can download an OPML file of these.  More interestingly you can just subscribe to the individual RSS feeds of these sites.  If you subscribe…