Tips

Tips

• Some new Windows Azure integration features in SQL Server 2014

  Microsoft is all about the cloud SQL Server 2014, especially if it's Microsoft's own cloud. That's why there is built-in Azure integration.  Continue Reading

• Dive deep into SQL Server 2014 in-memory OLTP

  Probably the biggest feature of the upcoming release, SQL Server 2014 in-memory OLTP has benefits that DBAs should know about. Learn how to set it up.  Continue Reading

• Five Windows Azure alternatives for SQL Server

  Just because you're an SQL Server shop doesn't mean you can't explore the cloud. Check out these five Azure alternatives to see what's out there.  Continue Reading

• SQL Server Availability Groups gets boost with SQL 2014

  AlwaysOn Availability Groups gets improvements in SQL Server 2014, from clustering to the cloud.  Continue Reading

• Does SQL Server database size affect performance?

  Of course SQL Server database size matters, but there are steps DBAs and IT managers can take to mitigate growing data and maintain good performance.  Continue Reading

• Defining half a dozen daily SQL Server DBA responsibilities

  Being a SQL Server DBA means you have a lot on your plate. Find out six of the most important DBA responsibilities you should be doing every day.  Continue Reading

• 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