Free Articles and Tutorials: SQL Server
This page contains a listing of free articles and tutorials.
Here we provide a list of free articles and tutorials of tips and tricks that will make you more effective with SQL Server.
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.
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.
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.