Features

Features

• Microsoft SQL Server 2016: Previews show promise for next year

  Microsoft SQL Server 2016 will be released next year. But in 2015, we've already had a glimpse into improved in-memory OLTP, security features, analytics and Stretch Database.  Continue Reading

• SQL Server 2005 end of life is closing in: Are you ready?

  Extended support for SQL Server 2005 ends in April. That's it. It's done. If your organization isn't prepared, your data could be at risk, cautions expert Robert Sheldon.  Continue Reading

• How to get started with PolyBase in SQL Server 2016

  With PolyBase, when you use SQL Server 2016 as your data source, you have easy access to Hadoop and Azure Blob Storage data from whatever environment you're working in.  Continue Reading

• SQL Server gets its first container management software

  DH2i's DxEnterprise is the first application container management software designed for SQL Server. Containerization boosts mobility and reduces downtimes.  Continue Reading

• SQL Server 2016 preview shows off new features, improvements

  Experts discuss the public preview of SQL Server 2016 and the best new features as early adopters ready themselves to put SQL Server 2016 into production.  Continue Reading

• How DH2i container management software can lower licensing fees

  Asante and Eversheds both cut SQL Server licensing costs using the new DH2i container management software, DxEnterprise. DH2i plans to compete with Microsoft.  Continue Reading

• SQL Server row-level security: How to implement in Azure SQL databases

  An expert offers an example of how to institute row-level security, a preview feature introduced recently by Microsoft for Azure SQL databases.  Continue Reading

• Vendors introduce three new SQL Server appliances

  If SQL Server appliances are on your radar, you have options, but the price tag is high. Do your homework before buying. Here are the current offerings.  Continue Reading

• Four points to consider for a SQL Server 2014 installation

  Upgrading to a SQL Server 2014 installation isn't always easy, but it has the features to make it worth your time. Here are some tips for avoiding the pitfalls along the way.  Continue Reading

• SQL Server database recovery tool retrieves by the table

  Kroll Ontrack's new SQL Server database recovery tool was developed from customer feedback. It recovers selected tables instead of the whole database.  Continue Reading

• SIOS SANLess cluster helps keep Epicure websites up and running

  Direct-sales food distributor Epicure deployed a new server cluster to keep its websites from being overwhelmed -- and saved money on SQL Server and storage in the process.  Continue Reading

• Scaling out or scaling up with Microsoft SSRS

  Basit Farooq explains the pros and cons of scaling out and scaling up when increasing the workload on the SQL Server Reporting Services (SSRS).  Continue Reading

• Troubleshoot SQL Server database performance with T-SQL

  Basit Farooq provides eight tips for optimizing T-SQL code to prevent SQL Server database performance bottlenecks and to tune database applications.  Continue Reading

• Built-in tools troubleshoot SQL Server memory usage

  Having enough memory is critical to SQL Server's performance. To ensure optimum SQL Server performance, you need to monitor SQL Server memory usage regularly. This article describes built-in tools that can make the job easier.  Continue Reading

• SQL Server monitoring tools help DBAs take back nights and weekends

  Many DBAs have to work more and more nights and weekends to fulfill zero-downtime demands. But tools for monitoring and managing SQL Server might free up some of that time.  Continue Reading