Browse by Tags
All Tags »
database (
RSS)
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 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...
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...
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...
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...
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...
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...
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...
