Manage

SQL Server Database Modeling and Design

• Five tips to avoid a performance bottleneck or other SQL Server snares

  Basit Farooq provides five tips for SQL Server users, from avoiding a hardware performance bottleneck to dealing with database design.Continue Reading

• Microsoft SQL Server training: What you need to know

  Learn about the SQL Server database and how to make the most of SQL Server training in this essential guide.Continue Reading

• SQL CONSTRAINT clauses: FOREIGN KEY, CHECK and DEFAULT

  In SQL Server, SQL CONSTRAINT clauses let you control values entered into a column. Learn about FOREIGN KEY, CHECK and DEFAULT constraints here.Continue Reading

• SQL CONSTRAINT clauses: PRIMARY KEY and UNIQUE

  In SQL Server, SQL CONSTRAINT clauses let you control the kinds of values that get entered into a column. Learn about two of them here.Continue Reading

• Set database constraints using SQL Server Management Studio Table Designer

  In addition to creating tables and adding columns, SQL Server Management Studio Table Designer can also set constraints.Continue Reading

• SQL Server's Data Quality Services makes cleanup a cinch

  SQL Server Data Quality Services is Microsoft’s newest data-cleansing tool. Expert Denny Cherry examines the upcoming SQL Server 2012 feature and delves into its components and processes.Continue Reading

• SQL Server Denali, R2, XP: What sizzles, what doesn’t this summer

  With the latest SQL Server Denali CTP out, Microsoft exec Mark Kromer discusses updates and addresses blogosphere buzz about what Denali’s not running on.Continue Reading

• Top reasons to get started with SQL Server Denali

  The upcoming SQL Server Denali is chock-full of new features, such as super-fast column-store indexes and a new Web-based reporting tool. But what does it mean for businesses?Continue Reading

• Finally, development across platforms in Microsoft Visual Studio 2010

  Microsoft says Project Juneau, its toolset for Microsoft Visual Studio 2010 expected to be rolled out with the upcoming SQL Server Denali, will break new ground in development.Continue Reading

• Top tips and tricks for SQL Server database development

  Check out these handy database development best practices, with tips on dealing with batch updates, stored procedures and more.Continue Reading

• Managing the development lifecycle with Visual Studio Team System 2008

  Learn how Visual Studio Team System 2008 Database Edition can add and modify objects, generate deployment scripts and manage the development lifecycle of your SQL Server databases.Continue Reading

• Enforcing data integrity in a SQL Server database

  Find out how primary keys, foreign keys and constraints can keep your SQL Server data consistent in this excerpt from "A Developer's Guide to Data Modeling for SQL Server, Covering SQL Server 2005 and 2008" by Eric Johnson and Joshua Jones.Continue Reading

• SQL Server and data manipulation in T-SQL

  Learn about stored procedures, parameters, triggers and how other T-SQL code functions allow for the manipulation of data in this excerpt from "A Developer's Guide to Data Modeling for SQL Server, Covering SQL Server 2005 and 2008" by Eric Johnson ...Continue Reading

• SQL Server 2008 data types: Datetime, string, user-defined and more

  Find out about data types available in SQL Server 2008 and how to use them, including datetime, string and user-defined data types, in this excerpt from "A Developer's Guide to Data Modeling for SQL Server, Covering SQL Server 2005 and 2008" by Eric...Continue Reading

• Physical data storage in SQL Server 2005 and 2008

  Learn the fundamentals of data storage in SQL Server 2005 and 2008, including tables, views and data types, in this excerpt from "A Developer's Guide to Data Modeling for SQL Server, Covering SQL Server 2005 and 2008" by Eric Johnson and Joshua ...Continue Reading