Tips

Tips

• SQL Server, Hadoop both part of Analytics Platform System

  A need for data warehouses designed for large-volume data loading and complex analytical workloads led to Microsoft's Analytics Platform System.  Continue Reading

• Introducing row-level security in Azure SQL databases

  Row-level security, a new feature for Azure SQL databases, helps Microsoft database platforms get to the same level as Oracle and DB2.  Continue Reading

• Built-in tools for monitoring and optimizing OLAP cubes

  Optimizing online analytical processing performance is critical. Fortunately, tools are available to help monitor and improve how OLAP cubes perform.  Continue Reading

• Seven reasons to upgrade to SQL Server 2012

  Support for early versions of SQL Server has ended. But rather than upgrade to SQL Server 2014, companies are turning to SQL Server 2012. Here is why.  Continue Reading

• Top four tips for virtualizing your SQL Server instance

  The increasing need for SQL Server instances is raising costs. Basit Farooq shows you how to control the costs through effective virtualization.  Continue Reading

• The dark side of Microsoft SQL Server Express

  Don Jones explains why Microsoft SQL Server Express can be more dangerous than you'd think and why it might be worth it to invest in the paid edition.  Continue Reading

• 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

• Using Power BI to enhance SQL Server self-service business intelligence

  SQL Server DBAs and developers should be familiar with Power BI for Office 365. Here's an overview of what it does and how to use it.  Continue Reading

• Managing data with Enterprise Integration Management and SQL Server

  Microsoft tools for SQL Server can help build a comprehensive enterprise integration management platform.  Continue Reading

• 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