New & Notable
Microsoft SQL Server Administration News
March 21, 2018
Count ObjectRocket among those pursuing Azure MongoDB deployments. This open source NoSQL database continues to find traction on the web and in the cloud.
January 17, 2018
Microsoft has responded to the Spectre and Meltdown chip vulnerabilities with patches and other fixes. But IT teams need to sort out SQL Server performance issues they may create.
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.
Microsoft SQL Server Administration Get Started
Bring yourself up to speed with our introductory content
Microsoft now lets SQL Server databases run in Docker containers, a capability that depends on using volumes to store data in a persistent way outside the containers. Continue Reading
From SQL Server Machine Learning Services to the SQL Server Operating System, there's a lot to know about SQL Server. Test your SQL Server knowledge with our quiz. Continue Reading
U-SQL is a Microsoft query language that combines a declarative SQL-like syntax with C# programming, enabling it to be used to process both structured and unstructured data in big data environments. Continue Reading
Evaluate Microsoft SQL Server Administration Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
Azure Cosmos DB brings a new element to the database lineup of Microsoft's cloud platform, offering multiple data models and a scalable environment for distributed applications. Continue Reading
Here's a list of notable trends related to SQL Server that IT teams should be ready for over the next 12 months. Among them: increased use of the cloud, AI, Linux and containers. Continue Reading
Using cloud databases is now more a matter of when than if at many companies. There's also the question of how, as Microsoft, Oracle and AWS square off against one another. Continue Reading
Manage Microsoft SQL Server Administration
Learn to apply best practices and optimize your operations.
The set of GDPR compliance tools that Microsoft offers for SQL Server is designed to make it easier for users of the database software to adhere to the EU's new data rules. Continue Reading
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
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.
SQL datetime functions DATEPART, GETDATE and DATENAME can retrieve the date and time or other individual parts of a value. Here's how to master these T-SQL tools. Continue Reading
DATEADD and DATEDIFF SQL functions allow you to easily perform calculations, like adding a time interval from a datetime value. Here's how to use those functions for that and more. Continue Reading
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