Tag: dba
-
Transfer Jobs and Logins using SSIS
We can use SQL Server Integration Services to transfer the logins and jobs from SQL 2005 to another SQL 2005 or SQL 2008. This comes in handy when its difficult to script each of the jobs . Firstly we need to create an SSIS package.
-
Intellisence
What is Intellisense? IntelliSense is Microsoft’s implementation of auto completion, best known for its use in the Microsoft Visual Studio integrated development environment. This feature is now included in SQL Server 2008 and this is available from SSMS 2008. When this feature is enabled it will auto complete functions, syntax, database names etc.
-
SQL Server 2005 Default trace
The Default Trace is implemented to audit certain events in the system. To verify if the default trace is running, run following query:
-
Installing SQL Server 2008
Microsoft has released its RTM version of SQL server 2008 on August 06th 2008. Hope we are ready for next migration, this article will help you to install SQL server 2008.
-
Introduction to Notification Services
I have been a Core Server Side SQL Server DBA for more than half a decade. This was the first application side task that I handled from the SQL Server front. I would like to thank my friends Chakravarthy and Poornima for giving me this wonderful opportunity to work on Notification Services. I dont claim…