Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
New training from Microsoft
Microsoft made SQL Server 2008 Microsoft Certified Master (MCM) Readiness Videos available on their...
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....
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...
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...
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...
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...
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...
Date: 01/05/2010
Visited from
<a href="https://www4.clustrmaps.com/counter/maps.php?url=https://blogs.msdn.com/sqlpfe/"...
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...
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...
Date: 10/05/2009
Indexing fact tables
Recently I was working on datawarehouse project during which i had to automate generation of indexes...
Date: 08/25/2009
SQL Server 2008 failover clustering whitepaper
Microsoft finally published SQL Server 2008 failover clustering whitepaper which can be found here
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...
Date: 04/25/2009
SQL Server 2008 SP1 is out
and can be downloaded here
Date: 04/08/2009
SQL Server 2008 books online update is available
It can be downloaded here
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 */...
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’...
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...
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...
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...
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...
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...
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...
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...
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...
Date: 12/23/2008
Here we go ...
Hello everyone! My name is Yuriy Toropov. I am a SQL Server Premier Field Engineer (PFE) at...
Date: 12/23/2008