Microsoft SQL Server Administration

Microsoft SQL Server Administration News

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.
November 08, 2018 08 Nov'18
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.
October 31, 2018 31 Oct'18
PASS Summit 2018 spotlights new demands on SQL Server DBAs

This year's PASS Summit comes as SQL Server 2019 looms and the cloud becomes a bigger factor. PASS board member Tim Ford talks about key trends ahead of it.

Bring yourself up to speed with our introductory content

SQL (Structured Query Language)

SQL (Structured Query Language) is a standardized programming language that's used to manage relational databases and perform various operations on the data in them. Continue Reading
data aggregation

Data aggregation is any process whereby data is gathered and expressed in a summary form. Continue Reading
database replication

Database replication is the frequent electronic copying of data from a database in one computer or server to a database in another -- so that all users share the same level of information. Continue Reading

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

What are Windows virtualization-based security features?

Microsoft Hyper-V on Windows comes with advanced protection schemes, including several virtualization-based security features the company introduced in Windows Server 2019. Continue Reading
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
How SQL Server DevOps processes help break down data silos

DevOps can help organizations dismantle data silos in SQL Server and other database systems -- and replace organizational silos with cross-functional teams. Continue Reading

Learn to apply best practices and optimize your operations.

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL queries that incorporate OUTER JOINs. Continue Reading
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

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

Boost Windows Server performance with these 10 tips

A small investment in time to execute these Windows Server performance tuning tips and techniques can optimize server workloads for more satisfactory results. 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
How to resolve and avoid deadlocks in SQL Server databases

Deadlocks are a real hindrance to SQL Server users, but database administrators can avoid them by taking steps to limit them and stop them from recurring. Continue Reading