Browse by Tags

SQL Server Replication upgrade practices - choose optimal upgrade option
04 November 09 04:39 PM | ssqa.net | with no comments

SQL Server Upgrade task needs a thorough planning and testing before you deploy the process in production environment. In this regard when performing an upgrade to a replicated environment, DBAs must make sure that all changes have been applied to all...

Filed under: sql server, replication, database, testing, upgrade, best practice

SQL Server Upgrade issues - How to evaluate potential issues?
09 June 09 06:17 PM | ssqa.net | with no comments

During the end of March 2009 I have presented a session " Upgrading To SQL Server 2005 & 2008: Notes & Best Practices" in SQLBits IV conference at Manchester. The session covered a brief tour on SQL Server Upgrade options, methodology...

Filed under: sql server, 2008, 2005, performance, database, problems, sqlbits, solution accelerator, tools, upgradebest practice

[OT] UK Government Helps You - Beware its a SPAM*
26 November 08 08:49 AM | ssqa.net | with no comments

Wednesday, November 26, 2008 1:33 AM SQL Master Edit UK Government Helps You - Beware its a SPAM* With reference to the subject line: [UK Government Helps You] as stated its a SPAM email that you might get in this Credit Crunch season that SPAMMERs are...

Filed under: best practices, database, government, spam

SQL Server 2005 and Disk drive allocation unit size to 64K - any benefit or performance?
28 April 08 04:28 PM | ssqa.net | 1 comment(s)

You may be aware that or seen within your Database platform about slower disk performance than expect having multiple disks in Windows Server 2003 environment when you use a hardware-based redundant array of independent disks (RAID) or a software-based...

Filed under: sql server, performance, best practices, database, benefits, data file, sizes, 64k, allocation

TSQL to change collation of database, whats new in SQL 2008 then?
12 March 08 08:10 AM | ssqa.net | 1 comment(s)

How can you change collation of a database? How do you check the existing collation setup on a database & tables? By using the below TSQL: --For database select databasepropertyex(db_name(),'collation') as collation_name go --Tables select column_name...

Filed under: sql server, database, tsql, table, change, indexes, setup, collation, installation, constraint, bcp

SQL Server 2008 - Declarative Management Framework (DMF) concepts - SQLBits presentation
03 March 08 06:57 AM | ssqa.net | 1 comment(s)

01st March 2008, Saturday @ Aston Lakeside Conference center, Birmingham - UK. It was a good turnout to my session this morning at 09:30 on the topic : SQL Server 2008 – Declarative Management Framework concepts & database problem solutions with policy...

Filed under: sql server, performance, database, conference, problems, framework, sqlbits, dmf, agenda, concepts

SQL Server 2005 Index Optimization Best Practices
19 February 08 07:04 AM | ssqa.net | 3 comment(s)

Do you have a maintenance window to perform database reindexing? Have you ever performed full set of re-organize and re-index process on a bigger database? Do you know there are best practices to deploy in this regard? On large database systems, with...

Filed under: sql server, ssqa, 2005, performance, best practices, reorganize, optimization, database, statistics, blogs, index, dbreindex, reindex