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
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
Microsoft SQL Server Management Studio (SSMS) is an integrated environment to manage a SQL Server infrastructure. Continue Reading
In-Memory OLTP is a Microsoft in-memory technology built into SQL Server and optimized for transaction processing applications. 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
Get equipped to take advantage of the addition of graph database features in SQL Server 2017 to use graph structures to represent the relationships between different data elements. 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.
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
The job isn't over after a successful SQL Server installation. These SQL Server best practices will help you optimize your new SQL Server installation from the start. Continue Reading
TRUNCATE TABLE and DELETE are T-SQL statements with similar functions, but that doesn't make them interchangeable. They operate differently and use different amounts of SQL Server resources. 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