Features

Features

• 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

• Enbridge Inc. to virtualize all its servers

  Energy company Enbridge Inc. is in the process of virtualizing all of its servers to increase flexibility and cut costs. Not everyone is happy with this new direction.  Continue Reading

• SQL Azure automatic backup keeps it 'business as usual'

  Robert Sheldon explains the business continuity features added to SQL Azure, including automatic backup, self-service restore, manual copy, and export and geo-replication. These features are meant to keep the data available, even when the system ...  Continue Reading

• How to provision a SQL Server virtual machine on Azure

  Basit Farooq provides two different methods for provisioning a SQL Server virtual machine on Windows Azure. He also explains the benefits of the Windows Azure virtual machine and how to migrate from on-premises to Windows Azure.  Continue Reading