The SQL Server IDENTITY property lets you specify a counter of values for a specific column of a table. You can use it to let the system generate unique numeric values for the table column of your choice. Learn more.
Read More
A NULL in the CREATE TABLE statement specifies that a special value called NULL is allowed in the column. Learn how these values differ from all other values in a SQL Server database.
Read More
A SQL Server foreign key is a column or group of columns in one table that contains values that match the primary key values in the same or another table. Learn more.
Read More
The task of maintaining integrity constraints can be handled by the user in application programs or by the DBMS. Learn more about SQL Server CREATE TABLE and declarative integrity constraints.
Read More
A NULL value in SQL Server is a special value that may be assigned to a column. This value normally is used when information in a column is unknown or not applicable. Learn more.
Read More
Since SQL Server 2008, you can debug SQL code using the existing debugger. And SQL Server 2012 enhances the functionality of the SQL Server Management Studio Debugger with several new features. Learn more.
Read More
Basic preparation before installing SQL Server 2012 will ensure you make the best configuration choices for your environment. Learn more.
Read More
The entity-relationship (ER) model is used to design relational databases by removing all existing redundancy in the data. Learn more.
Read More
The goal of good database design can usually be fulfilled if all tables of a database are in the third normal form. Learn more about normal forms and normalization.
Read More
Learn about a nearly bullet-proof ETL solution using SQL Server Change Tracking (CT).
Read More
SQL Server Checksum page verification provides better protection against corruption than TornPageDetection. Learn some important considerations when using Checksum.
Read More
Learn about the kind of information and tools you need to effectively perform root cause analyses of Oracle database performance problems, and why Trace Event 10046 and Oracle Statspak aren’t sufficient.
Read More