Tip Tips for Effective Database Maintenance
Inserting into Linked Servers
Recently I was trying to help someone on Microsoft Newsgroups with issue with Linked Server. When inserting into Linked Server directly via the SQL Statement
Default Schema in SQL 2005/SQL 2008
When you create a new AD group login in SQL Server and then create the Database user based of that login it is not possible
Activity Monitor in SQL 2008 …
It disappeared … So it seems; it no longer shows up under Management -> Activity Monitor. Even on-line books state it is there. I still
INSERTED and DELETED Logical Tables
The INSERTED and DELETED logical tables that exist in SQL Server and allow for handling the data when information is inserted, updated and deleted in
"No description found" Error when modifying Maintenance Plans
When you are trying to modify a maintenance plan; sometimes you might get “No Description Found” error and you cannot do any work in SSIS
SQL Canada (SQLCAN) 