Data Engineering – Learn from the experts
-
Enable Disable Remote connections Via DOS or T-SQL
Ive seen in forums seeking to enable disable Remote connections via DOS prompt T-SQL. Ive searched google for this topic and didnt get any article on this topic, so i decided to write a procedure to change Remote connections via T-SQL so that this can be called from DOS.
-
Database Tuning Advisor – DTA
The Database Engine Tuning Advisor is a new tool in Microsoft SQL Server 2005 that enables you to tune databases for improved query processing. Database Engine Tuning Advisor examines how queries are processed in the databases you specify and then it recommends how you can improve query processing performance by modifying physical design structures such…
-
Upgrading SQL 2005 Evaluation to Enterprise Edition Without Uninstalling
Can we upgrade SQL 2005 Evaluation edition to SQL 2005 Enterprise edition without uninstalling the evaluation edition? This seems to be lingering in the minds of many DBA and hence I thought of explaining it in simple terms. Yes it is possible to perform the operation without uninstalling Trial edition of SQL 2005 prior to…
-
Migrating Moving SQL2005 db to SQL2000 db
There are lot of ways by which we can migrate SQL2000 to SQL2005 where we can easily copy SQL2000 databases to SQL2005. While migrating lower to higher version its possible to migrate easily, but in some cases if needed to revert back SQL2000 its a question in everybodys mind that is it possible to do…
-
How to Rebuild System Databases in SQL Server 2005
We need to rebuild the system databases if the master database is corrupted or damaged. Let us discuss in detail how to rebuild system databases in SQL server 2005. Step 1: Take a full backup of all the System and User databases prior to rebuilding the system databases as we need to restore it later…
Got any recommendations?