New & Notable
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
Microsoft SQL Server Tools and Utilities News
September 26, 2017
Microsoft SQL Server 2017 becomes available in October. In addition to a version that runs on Linux, new features include support for Python-based analytics.
March 22, 2017
So far, data has been left out of the DevOps discussion. But DevOps for databases could grow if tools like Redgate's bundle embedded in Visual Studio 2017 carry through on their promises.
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.
November 07, 2012
Microsoft plans to offer new in-memory database capabilities with the next release of SQL Server.
Microsoft SQL Server Tools and Utilities Get Started
Bring yourself up to speed with our introductory content
SQL Operations Studio simplifies routine administration of SQL Server and Azure SQL databases, making database development and management easier for users who aren't full-time DBAs. Continue Reading
You can create SQL Server databases manually, but knowing how to do a scripted database setup is valuable. Here are the steps involved in executing a create database script. Continue Reading
Microsoft SSIS (SQL Server Integration Services) is an enterprise data integration, data transformation and data migration tool built into Microsoft's SQL Server database. Continue Reading
Evaluate Microsoft SQL Server Tools and Utilities Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
SQL Server 2017 on Linux gives IT shops greater flexibility, but there are some limitations and changes to the way high availability and failover are performed on Linux vs. Windows. Continue Reading
Here are the basics you need to know to use the graph database features added in SQL Server 2017 to represent the relationships between different data elements in a graph structure. Continue Reading
There are two options for deploying SQL Server on the Azure cloud. Here's a look at how they differ to help you choose between using Azure SQL Database and running SQL Server on an Azure VM. Continue Reading
Manage Microsoft SQL Server Tools and Utilities
Learn to apply best practices and optimize your operations.
Putting off SQL Server administration tasks can lead to database problems. Enact these often-neglected maintenance items to help keep your SQL Server systems running smoothly. Continue Reading
Docker containers can make the SQL Server deployment process more efficient and flexible. Here's what they are and how to get started on creating containers for SQL Server databases. Continue Reading
Consultant Michael Otey provides a step-by-step guide to upgrading from SQL Server 2014 to the 2016 release using the SQL Server Installation Center and Microsoft's upgrade wizard. Continue Reading
Problem Solve Microsoft SQL Server Tools and Utilities Issues
We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.
MySQL and Microsoft SQL Server relational databases have their pros and cons. Weigh the differences between SQL Server and MySQL features, costs, functionality and more. 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
Basit Farooq presents his top three SQL Server third-party tools for identifying and resolving SQL Server bottlenecks. Continue Reading