Links for 092509

Posted by admin | Posted in Links for the Week, SQL General, SQLServerPedia Syndication | Posted on 25-09-2009

0

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 thoughts on how it should be.

http://www.brentozar.com/archive/2009/09/how-to-deliver-a-killer-tech-presentation/
Brent Ozar gives us presentation tips. Everyone should want to be the best.

http://sqlblog.com/blogs/kevin_kline/archive/2009/09/18/new-post-on-my-sqlmag-blog-free-dmv-monitoring-tools.aspx

Kevin Kline gives us some DMV tools.

Links for the Week

Posted by admin | Posted in General, Links for the Week, SQL General, SQLServerPedia Syndication | Posted on 07-08-2009

0

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
Colin Stasiuk covers auditing options in SQL Server 2008 as well as previous options.

Microsoft SQL Server Team Blogs
Kevin Kline covers the topics of Blogs from the Microsoft SQL Server Team and also provides some useful links to other resources.

SQL Server Consolidation Tips
Thomas LaRock writes his third tip about SQL Server Consolidation tips. Part 1 and Part 2 are also linked.

SSIS Configuration Files
Jamie Thomson covers a tip on editing the .dtsConfig file. I prefer to use a table to store my configurations and I highly recommend looking at this method.

Document your Environment
Jonathan Kehayias covers the importance of documentation. I would love to see more examples of this on the blogs as well.

I’m Certified, Now What?
Steve Jones covers the topic of what comes after becoming certified.

Elegance of Database Design
Andy Leonard continues to cover the topic of Database Design.

Q&A with Louis Davidson and Paul Nielsen on Database Design
Schema design is important, and these two SQL Server MVPs discuss the need for Normalization.

Free eBook from Quest Software
Marlon Ribunal finds a great eBook offering from Quest Software.