Problem solve
Get help with specific problems with your technologies, process and projects.
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