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="https://www4.clustrmaps.com/counter/maps.php?url=https://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