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 Administration 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.
September 30, 2016
The big data movement has frozen out many data professionals who are versed in SQL. Microsoft's U-SQL programming language tries to get such folks back in the data querying game.
April 28, 2016
Two database industry experts discuss infrastructure and analytics trends to consider for database upgrades following the end of SQL Server 2005 extended support.
Microsoft SQL Server Administration Get Started
Bring yourself up to speed with our introductory content
The increasing adoption of cloud database services has captured the attention of Oracle and Microsoft as they try to hold their spots at the top of the database market. Continue Reading
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
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
Evaluate Microsoft SQL Server Administration Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
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
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
Manage Microsoft SQL Server Administration
Learn to apply best practices and optimize your operations.
Microsoft is at work on a delicate technology refresh affecting database tuning and architecture, as well as data integration and business intelligence. Continue Reading
SQL Server 2017 adds support for Linux and a variety of other new features that could justify upgrades to the revamped database platform, even coming so soon after the 2016 release. Continue Reading
As many in IT have learned the hard way, building software containers for systems like SQL Server can be tough. That's where Dockerfiles come in to help automate the process. 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