Welcome to TechNet Blogs Sign in | Join | Help

March 2009 - Posts

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 Read More...
Posted Tuesday, March 31, 2009 6:40 PM by josebda | 0 Comments
Filed under: ,

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 were Read More...
Posted Tuesday, March 31, 2009 3:59 PM by josebda | 2 Comments
Filed under:

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 Read More...
Posted Tuesday, March 31, 2009 11:23 AM by josebda | 1 Comments
Filed under: ,

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, Read More...
Posted Monday, March 30, 2009 6:07 PM by josebda | 0 Comments
Filed under:

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 were Read More...
Posted Sunday, March 29, 2009 5:00 PM by josebda | 1 Comments
Filed under:

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 during Read More...
Posted Friday, March 27, 2009 5:53 PM by josebda | 1 Comments
Filed under: ,

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 Read More...
Posted Thursday, March 26, 2009 5:45 PM by josebda | 0 Comments
Filed under:

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 Read More...
Posted Thursday, March 26, 2009 4:09 PM by josebda | 0 Comments
Filed under:

SQL Server 2008 Resource Governor

Here are some notes on “SQL Server 2008 Resource Governor” 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 Read More...
Posted Thursday, March 26, 2009 2:05 PM by josebda | 0 Comments
Filed under:

SQL Server 2008 Policy-based Management

Here are some notes on “SQL Server 2008 Policy-based Management” 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 Read More...
Posted Thursday, March 26, 2009 12:03 PM by josebda | 0 Comments
Filed under:

SQL Server 2008 Spatial Data

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 taken Read More...
Posted Thursday, March 26, 2009 10:02 AM by josebda | 1 Comments
Filed under:

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 Read More...
Posted Wednesday, March 25, 2009 4:24 PM by josebda | 2 Comments
Filed under: ,

SQL Server 2008 T-SQL Improvements

Here are some notes on "SQL Server 2008 T-SQL Improvements" 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, I might Read More...
Posted Tuesday, March 24, 2009 4:08 PM by josebda | 1 Comments
Filed under:

SQL Server 2008 Merge

Here are some notes on "SQL Server 2008 Merge" 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, I might have added Read More...
Posted Tuesday, March 24, 2009 2:17 PM by josebda | 0 Comments
Filed under:

SQL Server 2008 New Date and Time Types

Here are some notes on "SQL Server 2008 New Date and Time Types" 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, Read More...
Posted Tuesday, March 24, 2009 2:13 PM by josebda | 0 Comments
Filed under:

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, Read More...
Posted Tuesday, March 24, 2009 1:56 PM by josebda | 0 Comments
Filed under:

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 were Read More...
Posted Tuesday, March 24, 2009 11:51 AM by josebda | 2 Comments
Filed under:

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 Read More...
Posted Monday, March 23, 2009 6:53 PM by josebda | 1 Comments
Filed under:

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 the Read More...
Posted Monday, March 23, 2009 6:18 PM by josebda | 3 Comments
Filed under:

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, Read More...
Posted Friday, March 20, 2009 6:53 PM by josebda | 1 Comments
Filed under:

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, I Read More...
Posted Friday, March 20, 2009 4:39 PM by josebda | 1 Comments
Filed under:

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 Read More...
Posted Friday, March 20, 2009 11:54 AM by josebda | 1 Comments
Filed under:

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, Read More...
Posted Thursday, March 19, 2009 6:35 PM by josebda | 1 Comments
Filed under:

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 might Read More...
Posted Thursday, March 19, 2009 3:45 PM by josebda | 0 Comments
Filed under:

Book Chapter on Improving SQL Server Performance

I stumbled upon a great document on how to improve SQL Server performance. It's actually a chapther in a book on "Improving .NET Application Performance and Scalability" from a "Patterns and Practices" prescriptive guidance. Here's a summary of what it Read More...
Posted Thursday, March 19, 2009 11:46 AM by josebda | 1 Comments
Filed under:

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 Read More...
Posted Thursday, March 19, 2009 9:15 AM by josebda | 0 Comments
Filed under:

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, I Read More...
Posted Wednesday, March 18, 2009 4:19 PM by josebda | 0 Comments
Filed under: , ,

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 might Read More...
Posted Wednesday, March 18, 2009 11:24 AM by josebda | 0 Comments
Filed under: , ,

SQL Server 2008 Graphical Execution Plans

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 Read More...
Posted Wednesday, March 18, 2009 10:10 AM by josebda | 0 Comments
Filed under: , ,

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 taken Read More...
Posted Tuesday, March 17, 2009 5:53 PM by josebda | 1 Comments
Filed under: , ,

SQL Server 2008 Indexing

Here are some notes on "SQL Server 2008 Indexing" I took while attending an advanced class taught by Kimberly Tripp ( http://sqlskills.com/AboutKimberlyLTripp.asp ). Please note that, although these notes were taken during the class, I might have added Read More...
Posted Tuesday, March 17, 2009 1:23 PM by josebda | 0 Comments
Filed under: , ,

SQL Server 2008 File-related Optimizations

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 multiple Read More...
Posted Tuesday, March 17, 2009 9:59 AM by josebda | 2 Comments
Filed under: ,

To BLOB or Not To BLOB: Large Object Storage in a Database or a Filesystem

While attending a class on SQL Server, I was introduced to a paper from Microsoft Research (authors are Russell Sears, Catharine Van Ingen and Jim Gray) that discusses whether to store large objects in a filesystem or in a database, depending on the size Read More...
Posted Monday, March 16, 2009 4:29 PM by josebda | 0 Comments
Filed under: , ,

SQL Server 2008 Data Compression

SQL Server 2008 introduced a new feature to compress data stored in tables, indexes and indexed views. It basically uses a few different techniques to save space when storing data. You can set compression to NONE, ROW or PAGE (page includes ROW-level Read More...
Posted Monday, March 16, 2009 3:49 PM by josebda | 1 Comments
Filed under: ,

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 Read More...
Posted Monday, March 16, 2009 12:00 PM by josebda | 1 Comments
Filed under: ,

New White Paper on Hyper-V and SQL Server Consolidation at Microsoft

A new white paper on how Microsoft IT is combining Hyper-V and SQL Server has just been published. This comes from a team that provides thousands of SQL Server instances for internal applications. It includes a lot of interesting new information, including Read More...
Posted Wednesday, March 11, 2009 2:43 PM by josebda | 1 Comments

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 Read More...
Posted Tuesday, March 10, 2009 8:10 PM by josebda | 4 Comments

Technical Articles and White Papers on SQL Server

I will be attending an advanced SQL Server training in a couple of weeks and the instructors recommended some pre-reading. I'm sharing here a subset of those recommendations that point to articles and white papers published by Microsoft, grouped by category: Read More...
Posted Thursday, March 05, 2009 4:27 PM by josebda | 0 Comments
Filed under: , ,

Microsoft Partners: nominate your solution for a global award!

The 2009 Worldwide Partner Conference is coming later in the year (July 13–16 in New Orleans), but the WPC Awards program is already opened for nomination. If you are a Microsoft Partner with an awesome solution built on Microsoft technologies, it's time Read More...
Posted Thursday, March 05, 2009 12:16 PM by josebda | 0 Comments
Filed under:

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 you Read More...
Posted Sunday, March 01, 2009 8:21 AM by josebda | 0 Comments
 
Page view tracker