Free Articles and Tutorials: Microsoft SQL Server
This page contains a listing of free articles and tutorials.
Microsoft SQL Server
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.
Blog
