Topic: OLTP database management

Published 
3 min read

DBA essentials—SQL Server 2017 security, performance tuning, and more—inside out 

Whether you’re an experienced DBA with multiple certifications or just starting on your SQL Server DBA journey, you face challenges constantly for putting your organization’s data to work. To turn the next-to-impossible into the practical, you need a comprehensive resource at your fingertips: SQL Server 2017 Administration Inside Out, by William Assaf, Randolph West, Sven Aelterman, and Mindy Curnutt.
Published 
1 min read

Announcing a new update for mssql-cli: Special Commands 

We have released our first major update for mssql-cli since our recent Public Preview announcement in December. You can view the public preview announcement here. mssql-cli is a new and interactive command line query tool for SQL Server. This open source tool works cross-platform and is part of the dbcli community.
Published 
2 min read

The February release of SQL Operations Studio is now available 

UPDATE: SQL Operations Studio is now GA and renamed to Azure Data Studio. For the most up to date information please visit our monthly Azure Data Studio blog post and download and install the latest release here. We are excited to announce the February release of SQL Operations Studio is now available. Download SQL Operations Studio and review the Release Notes to get started.
Published 
3 min read

The December release of SQL Operations Studio is now available 

UPDATE: SQL Operations Studio is now GA and renamed to Azure Data Studio. For the most up to date information please visit our monthly Azure Data Studio blog post and download and install the latest release here. We are excited to announce the December release of SQL Operations Studio is now available. Download SQL Operations Studio and review the Release Notes to get started.
Published 
2 min read

Bring clarity to complex data with graph databases on SQL Server 2017 

SQL Server 2017, in addition to processing relational data, now fully integrates with graph database models, all on the same familiar system. This will bring clarity to the increasing amounts of data businesses generate every day. What’s the difference between graph and relational databases? Relational databases, like SQL Server, use foreign keys to manage relationships between entities and tables.
Published 
2 min read

Three years in a row – Microsoft is a leader in the ODBMS Magic Quadrant 

We’re happy to report that Gartner has positioned Microsoft in the Leaders Quadrant in the 2017 Magic Quadrant for Operational Database Management Systems again this year. This is the third year that Microsoft has been positioned farthest in completeness of vision and ability to execute in the operational database management systems market. At Microsoft, we’re dedicated to helping both enterprises and individuals realize their full potential.
Published 
2 min read

What’s new in SQL Server Management Studio 17.3 

We are excited to announce the release of SQL Server Management Studio (SSMS) 17.3! Download SSMS 17.3 and review the Release Notes to get started. SSMS 17.3 provides support for almost all feature areas on SQL Server 2008 through the latest SQL Server 2017, which is now generally available. In addition to enhancements and bug fixes, SSMS 17.
Published 
2 min read

SQL Server 2017 and Red Hat Enterprise Linux offer 

This post was authored by John ‘JG’ Chirapurath, General Manager, Data Platform Marketing. Microsoft has heard from you, our customers, that your data estate gets bigger, more complicated, and more diverse every year. You need solutions that work across platforms, whether on-premises or in the cloud, and that meet your data workloads where they are.
Published 
1 min read

Six reasons to consider SQL Server 2017—especially if you’re on Linux 

“Data is currency” is the rule of thumb in business. As with money, business data must be accessible, accurate, and usable across disparate contexts if an organization is to realize greater ROI while keeping costs under control. CIOs understand that the need to manage data—its location, composition, and utility—is as important as managing a balance sheet.