Microsoft SQL Server Administration
New & Notable
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.
Microsoft SQL Server Administration Get Started
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
Evaluate Microsoft SQL Server Administration Vendors & Products
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
Manage Microsoft SQL Server Administration
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
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.
-
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