Blog - Title

March, 2009

  • The Basics of the Windows Server 2008 Distributed File System (DFS)

    Overview In this blog post, we’ll cover the basics of the Distributed File System (DFS) in Windows Server 2008, which offers users simplified access to a set of file shares and helps administrators easily maintain the file server infrastructure behind...
  • SQL Server 2008 Fragmentation

    Here are some notes on "SQL Server 2008 Fragmentation" I took while attending an advanced class on SQL Server taught by Paul Randal http://sqlskills.com/AboutPaulSRandal.asp ). Please note that, although these notes were taken during the class, I might...
  • SQL Server 2008 Indexing Best Practices

    Here are some additional notes on "SQL Server 2008 Indexing Best Practices" I took while attending an advanced class on SQL Server taught by Kimberly Tripp ( http://sqlskills.com/AboutKimberlyLTripp.asp ). Please note that, although these notes were...
  • SQL Server 2008 Locking

    Here are some notes on "SQL Server 2008 Locking" I took while attending an advanced class on SQL Server taught by Kimberly Tripp ( http://sqlskills.com/AboutKimberlyLTripp.asp ). Please note that, although these notes were taken during the class, I...
  • SQL Server 2008 Replication

    Here are some notes on “SQL Server 2008 Replication Overview” I took while attending an advanced class on SQL Server taught by Greg Low (from http://sqlblog.com/blogs/greg_low/ and http://www.sqldownunder.com/ ). Please note that, although these notes...
  • SQL Server 2008 SQLOS

    Here are some notes on “SQL Server 2008 SQLOS” I took while attending an advanced class on SQL Server taught by Gert Drapers (from http://dbproj.com/ and http://blogs.msdn.com/gertd/ ). Please note that, although these notes were taken during the class...
  • SQL Server 2008 I/O Performance

    Here are some notes on “SQL Server 2008 I/O Performance” I took while attending an advanced class on SQL Server taught by Greg Low (from http://sqlblog.com/blogs/greg_low/ and http://www.sqldownunder.com/ ). Please note that, although these notes were...
  • SQL Server 2008 Change Tracking (CT) and Change Data Capture (CDC)

    Here are some notes on "SQL Server 2008 Change Tracking (CT) and Change Data Capture (CDC)" I took while attending an advanced class on SQL Server taught by Paul Nielsen (from http://www.sqlserverbible.com ). Please note that, although these notes...
  • SQL Server 2008 Transactional Replication

    Here are some notes on “SQL Server 2008 Transactional Replication” I took while attending an advanced class on SQL Server taught by Greg Low (from http://sqlblog.com/blogs/greg_low/ and http://www.sqldownunder.com/ ). Please note that, although these...
  • SQL Server 2008 Service Broker

    Here are some notes on “SQL Server 2008 Service Broker” I took while attending an advanced class on SQL Server taught by Greg Low (from http://sqlblog.com/blogs/greg_low/ and http://www.sqldownunder.com/ ). Please note that, although these notes...
  • SQL Server 2008 Partitioning

    Here are some notes on "SQL Server 2008 Partitioning" I took while attending an advanced class on SQL Server taught by Kimberly Tripp ( http://sqlskills.com/AboutKimberlyLTripp.asp ). Please note that, although these notes were taken during the class...
  • SQL Server 2008 Optimize for Ad Hoc Workloads

    SQL Server will create a plan for each batch you execute. If that plan is deemed to be "safe", it's stored in the plan cache for re-use. However, you use a lot of ad hoc queries only once, you will end up with a lot of cached plans that are really never...
  • SQL Server 2008 Database Compression

    Here are some notes on “SQL Server 2008 Database Compression” I took while attending an advanced class on SQL Server taught by Greg Low (from http://sqlblog.com/blogs/greg_low/ and http://www.sqldownunder.com/ ). Please note that, although these notes...
  • SQL Server 2008 Backup and Restore

    Here are some notes on "SQL Server 2008 Backup and Restore" I took while attending an advanced class on SQL Server taught by Paul Randal http://sqlskills.com/AboutPaulSRandal.asp ). Please note that, although these notes were taken during the class...
  • SQL Server 2008 Pages

    Here are some notes on "SQL Server 2008 Pages" I took while attending an advanced class on SQL Server taught by Paul Randal ( http://sqlskills.com/AboutPaulSRandal.asp ). Please note that, although these notes were taken during the class, I might have...
  • SQL Server 2008 Indexing for JOINs

    Here are some notes on "SQL Server 2008 indexing for JOINs" I took during an advanced class I attended taught by Kimberly Tripp ( http://sqlskills.com/AboutKimberlyLTripp.asp ). Please note that, although these notes were taken during the class, I...
  • SQL Server 2008 Merge Replication

    Here are some notes on “SQL Server 2008 Merge Replication” I took while attending an advanced class on SQL Server taught by Greg Low (from http://sqlblog.com/blogs/greg_low/ and http://www.sqldownunder.com/ ). Please note that, although these notes...
  • SQL Server 2008 Database Checking

    Here are some notes on "SQL Server 2008 Database Checking" I took while attending an advanced class on SQL Server taught by Paul Randal ( http://sqlskills.com/AboutPaulSRandal.asp ). Please note that, although these notes were taken during the class...
  • SQL Server 2008 DR, Testing, Waits and Queues

    Here are some notes on “SQL Server 2008 DR, Testing, Waits” I took while attending an advanced class on SQL Server taught by Ron Talmage (from http://www.solidq.com/na/MentorDetail.aspx?Id=38 ). Please note that, although these notes were taken during...
  • SQL Server 2008 XML Indexing

    Here are some notes on "SQL Server 2008 XML Indexing" I took while attending an advanced class on SQL Server taught by Adam Machanic ( http://sqlblog.com/blogs/adam_machanic/default.aspx ). Please note that, although these notes were taken during the...
  • SQL Server 2008 Client Design

    Here are some notes on "SQL Server 2008 Client Design" I took while attending an advanced class on SQL Server taught by Adam Machanic ( http://sqlblog.com/blogs/adam_machanic/default.aspx ). Please note that, although these notes were taken during...
  • SQL Server 2008 Hierarchies and HierarchyID

    Here are some notes on "SQL Server 2008 Hierarchies and HierarchyID" I took while attending an advanced class on SQL Server taught by Paul Nielsen (from http://www.sqlserverbible.com ). Please note that, although these notes were taken during the class...
  • SQL Server 2008 Storage

    Here are some notes on “SQL Server 2008 Storage” I took while attending an advanced class on SQL Server taught by Greg Low (from http://sqlblog.com/blogs/greg_low/ and http://www.sqldownunder.com/ ). Please note that, although these notes were taken...
  • IT Administrator scripts, WMI samples and witty comments

    Microsoft keeps a number of scripting examples at the Technet Scripting Center. These are mostly focused at administrators that need to write code every once in a while, as opposed to the MSDN references, focused mostly at full-time developers. If...
  • SQL Server 2008 Statistics

    Here are some notes on "SQL Server 2008 Statistics" I took while attending an advanced class on SQL Server taught by Kimberly Tripp ( http://sqlskills.com/AboutKimberlyLTripp.asp ). Please note that, although these notes were taken during the class...