Microsoft SQL Server Management Issues

New & Notable

Download this free guide

Free Resource: Hive vs. Spark vs. Presto

While SQL is the common langue of many data queries, not all engines that use SQL are the same—and their effectiveness changes based on your particular use case. So what engine is best for your business to build around? Compare Hive, Spark, and Presto to see which is best for you.

Corporate E-mail Address:
You forgot to provide an Email Address.
This email address doesn’t appear to be valid.
This email address is already registered. Please login.
You have exceeded the maximum character limit.
Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

Microsoft SQL Server Management Issues News

May 07, 2019 07 May'19
Microsoft expands Azure cloud database options

A raft of expansions across Microsoft's Azure cloud database tier adds capabilities that target high-end workloads and shops that prefer open source options.
February 12, 2019 12 Feb'19
Talend Stitch tools load data to Azure SQL Data Warehouse

Cloud data warehouses see serious data transformation work moving to the cloud. Talend's first integration with Stitch, which it recently bought, reflects the trend.
November 30, 2018 30 Nov'18
Faster R&D pace complicates SQL Server upgrades for users

Microsoft is updating SQL Server and Azure SQL Database more quickly than it did in the past -- and keeping up with the new releases can be a tough task for DBAs.
November 29, 2018 29 Nov'18
Microsoft data platform gets new cloud, on-prem features

Microsoft released a second preview of SQL Server 2019 and said users can now run applications in either on-premises SQL Server systems or its Azure SQL Database cloud service.

Microsoft SQL Server Management Issues Get Started

Bring yourself up to speed with our introductory content

Microsoft SQL Server

Microsoft SQL Server is a relational database management system, or RDBMS, that supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments Continue Reading
5 FAQs on SQL Server containers and how to manage them

Running SQL Server in containers creates new challenges for database administrators. The answers to these questions can guide you through some of them. Continue Reading
Microsoft Azure SQL Database nears parity with SQL Server

Microsoft is adding functionality to Azure SQL Database to enable users to migrate more SQL Server applications to the cloud platform and run bigger databases on it. Continue Reading

Evaluate Microsoft SQL Server Management Issues Vendors & Products

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

SQL Server in Azure database choices and what they offer users

SQL Server databases can be moved to the Azure cloud in several different ways. Here's what you'll get from each of the options for migrating SQL Server to Azure. Continue Reading
SQL Server vs. MySQL: Learn the differences

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
Pros and cons of using SQL Server audit triggers for DBAs

Using triggers to capture audit information in SQL Server can be instrumental in keeping track of database use and changes. But they aren't a perfect fit for all cases. Continue Reading

Manage Microsoft SQL Server Management Issues

Learn to apply best practices and optimize your operations.

Key features to create a SQL Server audit trail in databases

SQL Server offers a set of built-in auditing tools that can help make the process of tracking logins and other database activities easier for database administrators. Continue Reading
SQL Server performance tuning best practices for DBAs

Tuning database performance is a complex process, but consultant Joey D'Antoni details a list of SQL Server performance tuning best practices that can make it easier. Continue Reading
SQL Server auditing best practices: 3 key questions for DBAs

Acing a SQL Server database audit starts with careful monitoring of how sensitive data is accessed and used so you can answer the top questions that auditors ask. Continue Reading

Problem Solve Microsoft SQL Server Management Issues Issues

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

Migrating SQL Server to Microsoft Azure SQL Database as a service

Microsoft Azure SQL Database compatibility problems disappeared in V12, clearing the path for a SQL database migration to the cloud. Here's how to make the move. 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
Top four tips for virtualizing your SQL Server instance

The increasing need for SQL Server instances is raising costs. Basit Farooq shows you how to control the costs through effective virtualization. Continue Reading