posts - 219, comments - 411, trackbacks - 27

My Links

Advertisement

News

Follow billgraziano on Twitter

Article Categories

Archives

Post Categories

Consulting

SQL Server

KCTechBlog Syndication

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 can create it in any database you want but you’ll need to update the script.  The function converts varbinary hashed passwords to a string representation. It keeps the password intact for SQL Server logins. It scripts both Windows logins and SQL Server logins. ...

posted @ Thursday, July 08, 2010 11:09 AM | Feedback (2) | Filed Under [ SQL Server Stuff Utilities KCTechBlog Syndication ]

ClearTrace Supports Statement Level Events

One of the requests I get on a regular basis is to capture the performance of statement level events.  The latest beta has this feature available.  If you’re interested in this I’d like to get some feedback. I handle the SP:StmtCompleted and the SQL:StmtCompleted events.  These report CPU, reads, writes and duration. I’m not in any way saying it’s a good idea to trace these events.  Use with caution as this can make your traces much larger. If there are statement level events in the trace file they will be...

posted @ Friday, March 12, 2010 7:26 AM | Feedback (0) | Filed Under [ ClearTrace KCTechBlog Syndication ]

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 LDF files mostly showed a zero file size.  But they were online and responding and most other LUNs were available.  I’m not sure how SANs know to fail at 1AM on a Saturday night but they seem to.  From a personal standpoint this worked out poorly: I was out with...

posted @ Friday, February 26, 2010 8:29 AM | Feedback (2) | Filed Under [ SQL Server Stuff KCTechBlog Syndication ]

SQL Server Blogs I Read

Peter Larsson recently scrubbed his laptop but didn’t bring over his favorites and made a plea for interesting SQL Server related blogs.  My reading list of SQL Server blogs and sites is up to 83 sites in Google Reader and I thought I’d share my list in hopes of finding more.  Here’s the link to the OMPL file that you can import into a feed reader: SQL Server Blogs OPML file. Below is the complete list of SQL Server blogs I read regularly.  If you’re writing about SQL Server and not on that list please use the contact me...

posted @ Friday, February 05, 2010 7:16 AM | Feedback (2) | Filed Under [ SQL Server Stuff KCTechBlog Syndication ]

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 [blogs.msdn.com/sqlserverstorageengine/] Microsoft and Intel Push One Million iSCSI IOPS [blog.fosketts.net] The Truth About Hyper-V Memory Overcommit [www.vcritical.com] A Few Useful Queries for SQL Server 2008 Integrated Full Text Search (iFTS) [glennberrysqlperformance.spaces.live.com] SYS2 DMVs on CodePlex [sqlblog.com/blogs/davide_mauri/] Intel Nehalem-EX and Database Performance [glennberrysqlperformance.spaces.live.com] ...

posted @ Tuesday, January 19, 2010 9:02 AM | Feedback (0) | Filed Under [ SQL Server Stuff KCTechBlog Syndication ]

Powered by:
Powered By Subtext Powered By ASP.NET