Microsoft SQL Server Administration News
July 09, 2015
Microsoft opened the preview of Azure SQL Data Warehouse, a petabyte-scale, distributed columnar data warehouse service with massively parallel processing.
May 12, 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
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
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.
Microsoft SQL Server Administration Get Started
Bring yourself up to speed with our introductory content
A need for data warehouses designed for large-volume data loading and complex analytical workloads led to Microsoft's Analytics Platform System. Continue Reading
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
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
Evaluate Microsoft SQL Server Administration Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
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
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
Asante and Eversheds both cut SQL Server licensing costs using DH2i's new container management software, DxEnterprise. DH2i plans to compete with Microsoft. Continue Reading
Manage Microsoft SQL Server Administration
Learn to apply best practices and optimize your operations.
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
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
Stretch Database, a new feature in SQL Server 2016 often called StretchDB, lets companies "stretch" their databases to store infrequently used data in the cloud while keeping heavily used data on-premises. Continue Reading
Problem Solve Microsoft SQL Server Administration Issues
We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.
Basit Farooq provides eight tips for optimizing T-SQL code to prevent SQL Server database performance bottlenecks and to tune database applications. Continue Reading
Basit Farooq presents his top three SQL Server third-party tools for identifying and resolving SQL Server bottlenecks. Continue Reading
Ashish Mehta shows two ways – with T-SQL and with SSMS -- to make a user-defined server role in SQL Server 2012. Continue Reading