We’ve been running SQL Server 2000 x86 on Windows Server 2003 R2 x64 for some time. While there have been a few issues here and there, monitoring SQL related counters can be troublesome whether you are local or remote. If you are local to the server when you open up performance monitor you will receive [...]
http://midnightdba.itbookworm.com/midnightdba/blog/post/How-do-you-keep-track.aspx Staying on Track can be hard, Jen McCown outlines a few ideas of how to keep up with tasks. http://www.red-gate.com/specials/ebooks/protecting_sqlserver_data.htm?utm_source=simpletalk&utm_medium=email&utm_content=ProtectingDataN20090921&utm_campaign=SQLtoolbelt Another free ebook from redgate. John Magnabosco talks about securing SQL Server Data. http://weblogs.sqlteam.com/tarad/archive/2009/08/31/DefragmentingRebuilding-Indexes-in-SQL-server-2005-and-2008.aspx Tara Kizer gives a new script for backups. http://sqlblog.com/blogs/linchi_shea/archive/2009/09/21/the-transact-sql-prime-directive.aspx Linchi Shea gives us a vision, or at least some good [...]
I know I’m a little late posting this as I’m sure you’ve already downloaded the free Ebook and read through it, but if you haven’t be sure to go grab a copy. It’s got some good stuff in it.
SQL Server Sprawl Includes a link to 2 free chapters from SQL Server 2008 Administration in Action. Also has a link to another option of scanning your network for SQL Servers using SQL Ping. SSMS Projects and Solutions Buck Woody talks about some options for using the Project features in SSMS. Auditing your Database Server [...]
From the site: 24 Hours of PASS is a series of live one-hour webcasts broadcast over a 24-hour period that focus on a host of SQL Server topics. The 24 one-hour presentations will begin at 00:00 GMT (UTC) on September 2, 2009 Be sure to take into account the whole GMT issue. Since I’m on [...]
Props to Brent Ozar for sending me this link for a comparison of Database tools. If nothing else it’s a good reference.
Came across a twitter post that made me remember how useful these things could be. For the visual learner it can go a long way in understanding how a join works. I’m linking to the one from the twitter post as well as. For the visual learner: http://www.codeproject.com/KB/database/Visual_SQL_Joins.aspx http://www.codinghorror.com/blog/archives/000976.html http://www.khankennels.com/blog/index.php/archives/2007/04/20/getting-joins/
I came accross a blog entry by Jason Massie regarding SQL RSS feeds and I decided it would be a good time to check out the RSS Reader in Outlook 2007. Fortunately, Outlook will let you import a list of feeds from an xml or opml file. I took the list from Jason and plugged [...]