Tips

Tips

• Nine T-SQL best practices

  Choosing the right data type and avoiding dynamic SQL are two of the nine T-SQL best practices that author Basit Farooq explains here.  Continue Reading

• SQL Server views: Creating indexes and adding base data

  SQL Server views allow you to give information to users without compromising security. Find out how to create indexes on them and add base data.  Continue Reading

• SQL Server views: What they are and how to create them

  SQL Server views can help DBAs provide information to users while still controlling data access. Find out how.  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

• How to work around Azure database migration limitations

  Performing a successful Azure database migration is no easy task. There are plenty of limitations and missing features, and this is how you make do.  Continue Reading

• Using SQL Server Management Studio Table Designer to create a table

  Creating a table correctly in SQL Server can be pretty tricky, but using SQL Server Management Studio Table Designer makes it easier.  Continue Reading

• Manage your SQL Server databases with SQL DMVs

  SQL DMVs (dynamic management views) can help simplify administration of SQL Server databases. Find out how with detailed examples.  Continue Reading

• Five best practices for SQL Server hosting

  If you decide to run SQL Server in a hosted environment, how can you make sure it will operate smoothly? Read this tip to find out.  Continue Reading

• Six SQL Server management tools you can't live without

  Expert Ashish Kumar Mehta lists six important SQL Server management tools, including BIDS, SSMS and SSDT.  Continue Reading

• SQL 2014 features: Partitioned indexes and memory-optimized tables

  In this second of a two-part series on SQL 2014 features, Bob Sheldon dives into partitioned indexes and memory-optimized tables.  Continue Reading

• SQL 2014 features: Extended buffer pool and columnar indexes

  Two major SQL Server 2014 features are its ability to extend the buffer pool and its implementing of clustered columnar indexes for improved querying.  Continue Reading

• Up or out? Deciding on SQL Server scalability

  SQL Server scalability brings with it many questions, but prime among them is this: Should you buy more servers or bulk up the ones you have?  Continue Reading

• Configuring and implementing a SQL Server contained database

  Learn how to implement and configure contained databases in SQL Server 2012.  Continue Reading