Tips

Tips

• SQL Server encryption features in SQL Server 2014

  Learn about SQL Server encryption features and enhancements in SQL 14, including Transparent Data Encryption and encrypting backups.  Continue Reading

• The SQL Server 2012 Fast Track Data Warehouse reference architecture

  Microsoft has released guidelines for a hardware-software configuration that maximizes SQL Server 2012 performance. Learn about what it entails.  Continue Reading

• Five SQL Server 2012 business intelligence features

  The BI Semantic Model and Data Quality Services: These are two of the five SQL Server 2012 BI features that highlight this database release.  Continue Reading

• Digging through SQL Server OLAP storage models

  Learn how to distinguish among the three SQL Server OLAP storage models and decide which one is best in different use cases.  Continue Reading

• Examining SQL Server 2012 data warehouse appliances

  Take a look at some HP and Dell SQL Server 2012 data warehouse appliances to see if any might fit your business needs.  Continue Reading

• Eight key SQL Server 2014 features

  In-memory OLTP and columnar storage are just two of the eight key SQL Server 2014 features, according to this tip.  Continue Reading

• A good SQL Server DBA resume includes knowing the language of business

  Learning how technology affects the business will boost any SQL Server DBA resume out there, according to consultant Chris Presley.  Continue Reading

• SQL Server backup best practices

  Backup compression and using differential backups are just two of the important SQL Server backup best practices described in this tip.  Continue Reading

• 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