Notes from SQL Server Premier Field Engineer
Microsoft made SQL Server 2008 Microsoft Certified Master (MCM) Readiness Videos available on their...
Date: 01/08/2011
You probably well aware that keeping statistics up-to-date is essential for SQL Server performance....
Date: 06/17/2010
Hello readers! Couple of days ago I had to move large table (~43 mln rows) from production...
Date: 06/02/2010
I guess many of you are familiar with build in SQL server function @@version, which you can use to...
Date: 01/30/2010
Hello, everyone!Today I am going to chat briefly about the question a co-worker asked me about.The...
Date: 01/29/2010
While working with SQL Server you've probably heard certain restrictions like 'There can be at most...
Date: 01/10/2010
With this post I will start writing some small TSQL coding patterns and tricks which make daily life...
Date: 01/05/2010
<a href="https://www4.clustrmaps.com/counter/maps.php?url=https://blogs.msdn.com/sqlpfe/"...
Date: 12/06/2009
Many organization have lots of Excel reports and pivot tables whose data comes from SQL Server. As...
Date: 10/23/2009
As many of you may know, most of the time performance problems with SQL server come from bad...
Date: 10/05/2009
Recently I was working on datawarehouse project during which i had to automate generation of indexes...
Date: 08/25/2009
Microsoft finally published SQL Server 2008 failover clustering whitepaper which can be found here
Date: 07/13/2009
Hi guys! While travelling around Australia and helping Microsoft customers to get work done with SQL...
Date: 04/25/2009
and can be downloaded here
Date: 04/08/2009
It can be downloaded here
Date: 02/04/2009
Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */...
Date: 01/27/2009
Here is a cool perk from Red-Gate: a free EBook by Alan Hirt ‘Pro SQL Server 2005 High Availability’...
Date: 01/08/2009
Hello again !This is yet another post on SQL Server failover clustering. Hope you don't mind :).I...
Date: 01/08/2009
I was recently asked by a customer who just installed SQL Server 2005 with SP2 on 3 node failover...
Date: 01/08/2009
Good day, everyone! With this post I will start a series of posts describing tools which everyone of...
Date: 01/04/2009
Hello my fellow readers! I want to bring to your attention one small thing which will likely save...
Date: 01/02/2009
Micrsoft SQL Server 2005 SP3 is now available for download here . Fixes and changes made in SP3 are...
Date: 01/02/2009
Hi guys!Hope you had great holidays! Since Christmas and New Year are past us, let me resume...
Date: 01/01/2009
Some of you might have faced the situation when there is an error in the SQL Server error log or...
Date: 12/24/2008
Hello everyone! As a first practical post, today I will talk about disk partition alignment to...
Date: 12/23/2008
Hello everyone! My name is Yuriy Toropov. I am a SQL Server Premier Field Engineer (PFE) at...
Date: 12/23/2008