Welcome to the world (new face) of Knowledge Sharing Network.
To track the older blog posts refer to our historical knowledge sharing site  and you will find this as your destination for SQL Server knowledge pool.

Follow SQLMaster on Twitter SqlServer-QA.net - Knowledge Sharing Network (@sqlmaster)

database - SQL Server Knowledge Sharing Network (@sqlmaster)

Browse by Tags

All Tags » database (RSS)

SQL Server Setup Portal - a preview and planning of what you are about to setup?

There is a myth (rather a wrong impression) in database world that SQL Server setup is pretty easy, what you do is insert setup-media into drive and click next....next.....next, well it is not!!! .... read here ...

SQL Server Replication upgrade practices - choose optimal upgrade option

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...

SQL Server Upgrade issues - How to evaluate potential issues?

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...

[OT] UK Government Helps You - Beware its a SPAM*

Wednesday, November 26, 2008 1:33 AM 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 targeting the...
Posted by ssqa.net | with no comments

SQL Server 2005 and Disk drive allocation unit size to 64K - any benefit or performance?

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...

TSQL to change collation of database, whats new in SQL 2008 then?

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...

SQL Server 2008 - Declarative Management Framework (DMF) concepts - SQLBits presentation

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...

SQL Server 2005 Index Optimization Best Practices

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...