Microsoft SQL Server Administration

SQL Server Administration

+ Show More

July 09, 2015 09 Jul'15
Limited public preview opens for Azure SQL Data Warehouse

Microsoft opened the preview of Azure SQL Data Warehouse, a petabyte-scale, distributed columnar data warehouse service with massively parallel processing.
May 12, 2015 12 May'15
SQL Server 2016 preview announced for summer 2015

Microsoft CEO Satya Nadella announced the SQL Server 2016 preview for this summer. Its new features model the ethos of "mobile first, cloud first."
March 24, 2015 24 Mar'15
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.
November 25, 2014 25 Nov'14
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.

Bring yourself up to speed with our introductory content

Microsoft Azure Blob Storage database backup and restore

With Microsoft Azure Blob Storage Service, you can easily perform database backup and restore. Here is a step-by-step approach to using the service. Continue Reading
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
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

Weigh the pros and cons of technologies, products and projects you are considering.

Understanding the Microsoft Sync Framework

An expert explains the Microsoft Sync Framework, a platform for synchronizing heterogeneous data distributed across applications, services and devices. 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
Top three third-party SQL Server security auditing tools

For most companies, SQL Server's security auditing tools aren't always enough to meet regulation requirements. The answer is third-party products. Continue Reading

Learn to apply best practices and optimize your operations.

How to set up the new SQL Server data encryption feature

If you're tired of decrypting data to perform operations on it, the new SQL Server data encryption feature Always Encrypted may be the answer. Continue Reading
Two ways to encrypt database backups with SQL Server

SQL Server 2014 provides two features that let database administrators easily encrypt database backups. An expert provides two demos that show you how. Continue Reading
SQL Server 2016 features boost cloud, security and analytics support

In a podcast, SearchSQLServer's Jessica Sirkin discusses the noteworthy features in SQL Server 2016, reactions from early users and issues to consider in thinking about upgrading. Continue Reading

We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.

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
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
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