Useful URLs for SQL DBAs – Foundation

1)      SQL Server Architecture

http://blog.sqlauthority.com/2012/08/30/sql-server-beginning-of-sql-server-architecture-terminology-guest-post/

2)      SQL Server Transaction Log Architecture and Management

http://msdn.microsoft.com/en-us/library/jj835093.aspx

3)      About transaction log and its truncation in SQL Server

http://www.codeproject.com/Articles/380879/About-transaction-log-and-its-truncation-in-SQL-Se

4)      Truncating the Transaction Log

http://msdn.microsoft.com/en-us/library/aa174538(v=sql.80).aspx

5)      Checkpoints and the Active Portion of the Log

http://msdn.microsoft.com/en-us/library/ms189573(v=sql.105).aspx

6)      How to Identify Blocking in SQL Server

http://www.mssqltips.com/sqlservertip/2429/how-to-identify-blocking-in-sql-server-2005-and-2008/

http://blog.sqlauthority.com/2010/10/06/sql-server-quickest-way-to-identify-blocking-query-and-resolution-dirty-solution/

7)   Does a full backup truncate the log?

http://www.sqlservercentral.com/Forums/Topic567010-357-1.aspx#bm1311005

8)   Full Backups & Transaction Logs Backup – There’s Something about SQL!

http://blogs.technet.com/b/beatrice/archive/2008/07/24/full-backups-transaction-logs-backup.aspx

9) TempDB Related

http://msdn.microsoft.com/en-us/library/ms190768.aspx

http://msdn.microsoft.com/en-us/library/ms176029.aspx

http://blogs.msdn.com/b/deepakbi/archive/2010/04/14/monitoring-tempdb-transactions-and-space-usage.aspx

http://msdn.microsoft.com/en-us/library/ms175527.aspx

http://msdn.microsoft.com/en-us/library/ms345368.aspx

http://technet.microsoft.com/library/Cc966545

10) SQL Server Best Practices

http://technet.microsoft.com/en-us/sqlserver/bb671430.aspx

11) SQL Server Replication

http://www.replicationanswers.com/default.asp 

Please share your favorite URLs that will be useful for other DBAs.

Category: SQL Server Basics

Advertisements

Leave a comment

Filed under sql server 2008, sql server 2012

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s