Pages

▼
Sunday, 21 May 2006

Installing SQL Server 2005 Service Pack 1 on all SQL instances via CMD

›
When it comes to installing SQL Server 2005 Service Packs on various instances rapidly, we can do it by executing the Service Pack setup wit...
Friday, 14 April 2006

How to remove 'sa' account from 'sysadmin' fixed server role in SQL Server 2000

›
When it comes to securing the databases, we need to have a small number of accounts with 'sysadmin' fixed server role, which means t...
Tuesday, 14 March 2006

How to uninstall SQL Server 2005 instances successfully

›
With the passing of days, the number of people asking me how to uninstall SQL Server 2005 instances successfully is on increase. I would lik...
Sunday, 5 February 2006

Improving the performance by using 'Boost SQL Server Priority' option

›
Boost SQL Server Priority is one of the many options that we can configure at SQL Server instance level in order to improve the performance...
Tuesday, 10 January 2006

Exploring ROW_NUMBER function in SQL Server 2005

›
Some of the SQL Server 2005 new features are the Ranking functions which are used to analyse data. Among these functions we have, for instan...
Wednesday, 7 December 2005

The power of PIVOT in SQL Server 2005

›
With the arrival of SQL Server 2005, we have many new features available to make the most out of it. Today's post is going to be about o...
Monday, 21 November 2005

How to connect to SQL Server 2005 much faster via SQL Management Studio

›
While connecting with SQL Server 2005, we have to deal with the 'splash' screen and then indicate, basically, the following informat...