Blog - Title

March, 2009

TechNet Blogs > Jose Barreto's Blog > March, 2009
Live Now on Server & Tools Blogs
Menu
Tags
More ▼
Archives
Archives
More ▼
Blog - News

All messages posted to this blog are provided "AS IS" with no warranties, and confer no rights.

Information on unreleased products are subject to change without notice.

Dates related to unreleased products are estimates and are subject to change without notice.

The content of this site are personal opinions and might not represent the Microsoft Corporation view.

The information contained in this blog represents my view on the issues discussed as of the date of publication.

You should not consider older, out-of-date posts to reflect my current thoughts and opinions.

© Copyright 2004-2012 by Jose Barreto. All rights reserved.

Follow @josebarreto on Twitter for updates on new blog posts.

Sort by: Most Recent | Most Views | Most Comments
Excerpt View | Full Post View
  • Jose Barreto's Blog

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

    Posted over 4 years ago
    by
    • 6 Comments
    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...
  • Jose Barreto's Blog

    SQL Server 2008 Locking

    Posted over 4 years ago
    by
    • 0 Comments
    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...
  • Jose Barreto's Blog

    SQL Server 2008 Partitioning

    Posted over 4 years ago
    by
    • 1 Comments
    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...
  • Jose Barreto's Blog

    SQL Server 2008 Backup and Restore

    Posted over 4 years ago
    by
    • 1 Comments
    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...
  • Jose Barreto's Blog

    SQL Server 2008 Indexing Best Practices

    Posted over 4 years ago
    by
    • 1 Comments
    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...
  • Jose Barreto's Blog

    SQL Server 2008 Service Broker

    Posted over 4 years ago
    by
    • 2 Comments
    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...
  • Jose Barreto's Blog

    SQL Server 2008 Replication

    Posted over 4 years ago
    by
    • 0 Comments
    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...
  • Jose Barreto's Blog

    SQL Server 2008 Fragmentation

    Posted over 4 years ago
    by
    • 1 Comments
    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...
  • Jose Barreto's Blog

    SQL Server 2008 Change Tracking (CT) and Change Data Capture (CDC)

    Posted over 4 years ago
    by
    • 2 Comments
    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...
  • Jose Barreto's Blog

    SQL Server 2008 I/O Performance

    Posted over 4 years ago
    by
    • 0 Comments
    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...
  • Jose Barreto's Blog

    SQL Server 2008 Transactional Replication

    Posted over 4 years ago
    by
    • 0 Comments
    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...
  • Jose Barreto's Blog

    SQL Server 2008 Database Compression

    Posted over 4 years ago
    by
    • 1 Comments
    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...
  • Jose Barreto's Blog

    SQL Server 2008 Merge Replication

    Posted over 4 years ago
    by
    • 1 Comments
    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...
  • Jose Barreto's Blog

    SQL Server 2008 XML Indexing

    Posted over 4 years ago
    by
    • 1 Comments
    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...
  • Jose Barreto's Blog

    SQL Server 2008 Statistics

    Posted over 4 years ago
    by
    • 0 Comments
    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...
  • Jose Barreto's Blog

    SQL Server 2008 Storage

    Posted over 4 years ago
    by
    • 1 Comments
    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...
  • Jose Barreto's Blog

    SQL Server 2008 Pages

    Posted over 4 years ago
    by
    • 1 Comments
    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...
  • Jose Barreto's Blog

    SQL Server 2008 Database Checking

    Posted over 4 years ago
    by
    • 1 Comments
    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...
  • Jose Barreto's Blog

    SQL Server 2008 Optimize for Ad Hoc Workloads

    Posted over 4 years ago
    by
    • 0 Comments
    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...
  • Jose Barreto's Blog

    SQL Server 2008 SQLOS

    Posted over 4 years ago
    by
    • 0 Comments
    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...
  • Jose Barreto's Blog

    SQL Server 2008 Hierarchies and HierarchyID

    Posted over 4 years ago
    by
    • 0 Comments
    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...
  • Jose Barreto's Blog

    SQL Server 2008 DR, Testing, Waits and Queues

    Posted over 4 years ago
    by
    • 2 Comments
    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...
  • Jose Barreto's Blog

    SQL Server 2008 Graphical Execution Plans

    Posted over 4 years ago
    by
    • 0 Comments
    I'm attending a SQL training and looking at indexing closely. One thing that becomes important is understanding how SQL executes queries. Understanding the graphical execution plans becomes extremely important. While looking for a good reference, I found...
  • Jose Barreto's Blog

    SQL Server 2008 File-related Optimizations

    Posted over 4 years ago
    by
    • 2 Comments
    While attending training today, I learned some file-related optimizations for SQL Server 2008. Some of those will also apply to previous versions of SQL Server. 1) No performance gain in multiple log files There is a common misconception that having...
  • Jose Barreto's Blog

    SQL Server 2008 Spatial Data

    Posted over 4 years ago
    by
    • 1 Comments
    Here are some notes on “SQL Server 2008 Spatial Data” 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...
Page 1 of 2 (40 items) 12