Problem solve

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

• 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

• Database index design and optimization: Some guidelines

  What are the latest tips and tricks for database design and optimization? Check out this tip from Basit Farooq to learn more. Continue Reading

• Top five features in SQL Server Developer Tools

  SQL Server Developer Tools, also known as Project Juneau, made its debut in this summer’s Denali preview. Read up on five SSDT features.Continue Reading

• Warned about table changes in SSMS? Here’s a workaround

  Editing tables in SQL Server Management Studio and getting this warning, “Saving changes is not permitted”? It happens when the table needs to be re-created. But don’t fret. This change in SQL Server 2008 R2 can be undone with a simple tweak.Continue Reading

• SQL Server merge replication using IIS

  In older versions of SQL Server, securely replicating data between sites or companies was not easy to do. Microsoft SQL Server merge replication simplifies the process using Internet Information Services (IIS).Continue Reading

• Where to look next for BI applications? Try the cloud

  PowerPivot, SQL Azure and ‘Dallas’ combine to create BI applications in the cloud. Is that integration seamless and is it even for you?Continue Reading

• Microsoft brings PHP integration to SQL Server Reporting Services

  PHP isn’t just a Linux language anymore. With the help of a new SDK, developers can incorporate the scripting language with SQL Server reports.Continue Reading

• Open source tool simplifies database synchronization for SQL Server

  A free tool for Microsoft SQL Server could help take the time out of syncing up public and development databases.Continue Reading

• Optimizing SQL Server indexes -- even when they're not your indexes

  When created and maintained correctly, indexes help SQL Server retrieve data quickly. See how to ensure your SQL Server environment is running up to speed.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

• A first look at Visual Studio Team System 2008 Database Edition

  Visual Studio 2008 Database Edition is designed to simplify database development and better manage development lifecycles. Check out the new features in Microsoft's 2008 version of VSDB.Continue Reading