Notes from SQL Server Premier Field Engineer

New training from Microsoft

Microsoft made SQL Server 2008 Microsoft Certified Master (MCM) Readiness Videos available on their...

Author: yuriyt Date: 01/08/2011

Creating useful statistics from _WA_Sys stats

You probably well aware that keeping statistics up-to-date is essential for SQL Server performance....

Author: yuriyt Date: 06/17/2010

Moving large tables between environments

Hello readers! Couple of days ago I had to move large table (~43 mln rows) from production...

Author: yuriyt Date: 06/02/2010

SQL Server system information

I guess many of you are familiar with build in SQL server function @@version, which you can use to...

Author: yuriyt Date: 01/30/2010

Embeding XML into XML using FOR XML option

Hello, everyone!Today I am going to chat briefly about the question a co-worker asked me about.The...

Author: yuriyt Date: 01/29/2010

Maximum sizes and numbers for SQL Server

While working with SQL Server you've probably heard certain restrictions like 'There can be at most...

Author: yuriyt Date: 01/10/2010

TSQL coding patterns I

With this post I will start writing some small TSQL coding patterns and tricks which make daily life...

Author: yuriyt Date: 01/05/2010

Visited from

<a href="http://www4.clustrmaps.com/counter/maps.php?url=http://blogs.msdn.com/sqlpfe/"...

Author: yuriyt Date: 12/06/2009

Automatically refreshing your Excel reports

Many organization have lots of Excel reports and pivot tables whose data comes from SQL Server. As...

Author: yuriyt Date: 10/23/2009

Interpreting SQL Server execution plans

As many of you may know, most of the time performance problems with SQL server come from bad...

Author: yuriyt Date: 10/05/2009

Indexing fact tables

Recently I was working on datawarehouse project during which i had to automate generation of indexes...

Author: yuriyt Date: 08/25/2009

SQL Server 2008 failover clustering whitepaper

Microsoft finally published SQL Server 2008 failover clustering whitepaper which can be found here

Author: yuriyt Date: 07/13/2009

Microsoft SQL Server 2008 Virtual Labs

Hi guys! While travelling around Australia and helping Microsoft customers to get work done with SQL...

Author: yuriyt Date: 04/25/2009

SQL Server 2008 SP1 is out

and can be downloaded here

Author: yuriyt Date: 04/08/2009

SQL Server 2008 books online update is available

It can be downloaded here

Author: yuriyt Date: 02/04/2009

SQL Server User Group in Sydney CBD

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */...

Author: yuriyt Date: 01/27/2009

Free SQL Server 2005 High Availability EBook

Here is a cool perk from Red-Gate: a free EBook by Alan Hirt ‘Pro SQL Server 2005 High Availability’...

Author: yuriyt Date: 01/08/2009

'Priority boost' sp_configure option and SQL Server failover clustering

Hello again !This is yet another post on SQL Server failover clustering. Hope you don't mind :).I...

Author: yuriyt Date: 01/08/2009

Renaming SQL Server cluster resource group

I was recently asked by a customer who just installed SQL Server 2005 with SP2 on 3 node failover...

Author: yuriyt Date: 01/08/2009

Tools to troubleshoot SQL Server - part 1

Good day, everyone! With this post I will start a series of posts describing tools which everyone of...

Author: yuriyt Date: 01/04/2009

Beware of special characters in cluster resource/group names

Hello my fellow readers! I want to bring to your attention one small thing which will likely save...

Author: yuriyt Date: 01/02/2009

SQL Server 2005 SP3 available

Micrsoft SQL Server 2005 SP3 is now available for download here . Fixes and changes made in SP3 are...

Author: yuriyt Date: 01/02/2009

Internals viewer for SQL Server

Hi guys!Hope you had great holidays! Since Christmas and New Year are past us, let me resume...

Author: yuriyt Date: 01/01/2009

Acting on SQL Server errors

Some of you might have faced the situation when there is an error in the SQL Server error log or...

Author: yuriyt Date: 12/24/2008

Detecting volume/disk partition alignment issues

Hello everyone! As a first practical post, today I will talk about disk partition alignment to...

Author: yuriyt Date: 12/23/2008

Here we go ...

Hello everyone! My name is Yuriy Toropov. I am a SQL Server Premier Field Engineer (PFE) at...

Author: yuriyt Date: 12/23/2008