Category: General
-
Migrating Access Database to SQL Server
I recently received a call from one of my friend asking me, what is the easiest way to migrate a database from ACCESS to SQL Server? I was curious on answering his question and just went for a search in internet to find it was much simple than what I expected. This article describes the…
-
Cross Domain Windows Authentication for SQL Server databases
There are many acquisitions these days and the DBA and sysadmins have a great tasks of doing a cross-domain authentication to their servers and databases. System admins have various options to connect interdomain where as DBA has to look up for it. Here is a solution that one can try using to access databases in…
-
Short Cut Keys
I have always googled out for finding any shortcut key to be used in SQL Server that gave me an idea to post this. I have gathered all the SQL Server 2000 and 2005 shortcuts with the help of books online and internet here. Hope this helps you.
-
Difference between TRUNCATE and DELETE command
Lets see the difference between DELETE and TRUNCATE command as below
-
SQL 2005 Edition Comparison
Introduction: SQL Server 2005 comes with different editions with each having features that are either available in the other or not. This document lists the comparison of the features available between the different editions.