SQL Server: Tips and Tricks

1. How to Change a Column to Allow NULL in SQL Server

   If you have a column in a SQL Server table that does not allow NULL values and you need to change it to allow NULLs, here is how you do it.

   Read Article
2. How to Check Case-Sensitivity in SQL Server

   SQL Server is, by default, case insensitive; however, it is possible to create a case-sensitive SQL Server database and even to make specific table columns case sensitive. The way to determine if a database or database object is to check its "COLLATION" property and look for "CI" or "CS" in the result.

   Read Article
3. How to Install Northwind on SQL Server

   Northwind was originally created as a sample database for Microsoft Access. Microsoft also included it with SQL Server 2000. Although later versions of SQL Server did not include the Northwind database, you can easily install it.

   Read Article