Free Articles and Tutorials: Microsoft SQL Server

This page contains a listing of free articles and tutorials.

Microsoft SQL Server

SQL Server: Tips and Tricks

Here we provide a list of free articles and tutorials of tips and tricks that will make you more effective with SQL Server.

Read Article

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

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

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