Here is a nice free tool from Red Gate called SQL Scripts Manager.
How to move SQL Server to a New Server?
Are you using SQL Server 2008 or are you planning to upgrade? Whatever the case is, if you are in any way associated with SQL Server you should have this book. It’s a Free ebook from Microsoft Press on SQL Server 2008 R2. Make sure to download it for free and keep it for reference.
Duplicate Rows in a table can be very irritating and cause for many headaches. So how can you identify duplicate rows in a table? SQL Server provides no visual tool or a built in function to show you the duplicate rows in a table, so you need to write your own query to get the duplicate rows.
If you are working with SQL Server and looking for a way to get the row count of all tables in your database, you can do that using this SQL Query.
This Query will display a list of all Tables in your database and a count of the number of Rows the table has.
If you need to trace all the connections from Applications and other Clients to your SQL Database you can do so with the following queries.
Working with SQL Server can be quite interesting. It’s a quite powerful tool and you can really be creative with what you can do with those SQL Queries.
FileStream allows you to store unstructured data (LOB) in the file system instead of the database.
SQL Server 2008 introduces many enhancements to Transact-SQL; Here is a list of some of those enhancements and a brief description of those enhancements.
System.ArgumentException: The SqlParameter is already contained by another SqlParameterCollection