Tags : #sqlserver

28

Dec

Azure Log Analytics (OMS) Agent now collects SQL Server audit logs

https://blogs.msdn.microsoft.com/sqlsecurity/2017/12/28/azure-log-analytics-oms-agent-now-collects-sql-server-audit-logs/Source: https://blogs.msdn.microsoft.com/sqlsecurity/2017/12/28/azure-log-analytics-oms-agent-now-collects-sql-server-audit-logs/   We are happy to inform that the Azure Log Analytics (OMS) Agent is now capable of pushing SQL Server audit logs into Azure Log Analytics (OMS), supporting SQL Server both on-premises, as well as on Azure VMs. READ MORE

19

Dec

The December release of SQL Operations Studio is now available
The December release of SQL Operations Studio is now available

This post is authored by Alan Yu, Program Manager, SQL Server.

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.

SQL Operations Studio is a data management tool that enables you to work with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux. To learn more, visit our GitHub.

SQL Operations Studio was announced for Public Preview on November 15th at Connect(), and this December release is the first major update since the announcement.

The December release includes several major repo updates and feature releases, including:

Migrating SQL Ops Studio Engineering to public GitHub repo Azure Integration with Create Firewall Rule Windows Setup and Linux DEB/RPM installation packages Manage Dashboard visual layout editor “Run Current Query with Actual Plan” command

For complete updates, refer to the Release Notes.

Migrating SQL Ops Studio Engineering to public GitHub repo

To provide better transparency with the SQL Operations Studio community, we have decided to migrate the Github internal branch to the public repo. This means any bug fixes, feature developments, or even test builds can be publicly viewed before an

13

Dec

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. Foreign keys adequately query one-to-many relationships; however, as relationships between various data entities become more complex, queries also become more complex and performance may diminish as a result.

In these cases, developers may opt for graph database models to manage complex relationships and enable operational agility. In a graph database, edges are heterogeneous in nature—a single edge can be used to connect different type of nodes to each other. This is not easy to achieve using foreign keys in a relational database. For example, consider a social graph where a person (node) likes another person (edge) or organization (node) or restaurant (node). Here the same ‘likes’ edge is used to connect three different types of nodes and entities to each other—person to person; person to organization; and person to restaurant.

So, how do graph databases work?

Graph databases are comprised of a

12

Dec

Try mssql-cli, a new interactive command line tool for SQL Server

This post is authored by Alan Yu, Program Manager, SQL Server.

We are excited to announce the Public Preview release of mssql-cli, a new and interactive command line query tool for SQL Server. This open source tool works cross-platform and is a proud member of the dbcli community.

See the install guide to download mssql-cli and get started.

Read on to learn more about mssql-cli features, how to submit feature requests or issues, and our open source collaboration story to bring you this great tool.

mssql-cli auto-completion that is context aware

Features

Mssql-cli is a new and interactive command line tool that provides the following key enhancements over sqlcmd in the Terminal environment:

T-SQL IntelliSense Syntax highlighting Pretty formatting for query results, including Vertical Format Multi-line edit mode Configuration file support

Mssql-cli aims to offer an improved interactive command line experience for T-SQL. It is fully open source under the BSD-3 license, and a contribution to the dbcli organization, an open source suite of interactive CLI tools for relational databases including SQL Server, PostgresSQL, and MySQL. The command-line UI is written in Python and the tool leverages the same microservice backend (sqltoolsservice) that powers the VS Code SQL extension,

11

Dec

Centennial apps/desktop bridge, SQL Server and error “The data area passed to a system call is too small.”

https://blogs.msdn.microsoft.com/sql_server_team/centennial-appsdesktop-bridge-sql-server-and-error-the-data-area-passed-to-a-system-call-is-too-small/Source: https://blogs.msdn.microsoft.com/sql_server_team/centennial-appsdesktop-bridge-sql-server-and-error-the-data-area-passed-to-a-system-call-is-too-small/   The title of the blog may throw someone off a little. After all, SQL Server is not a centennial app and the error message doesn’t appear to have anything to do with SQL Server. So please bear READ MORE

11

Dec

What’s new in SSMS 17.4: SQL Vulnerability Assessment
What’s new in SSMS 17.4: SQL Vulnerability Assessment

This post is authored by Ronit Reger, Senior Program Manager, SQL Data Security and Alan Yu, Program Manager, SQL Server

We are excited to announce the release of SQL Server Management Studio (SSMS) 17.4!

Download SSMS 17.4 and review the Release Notes to get started.

SSMS 17.4 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.4 comes with an exciting new feature: SQL Vulnerability Assessment!

What is Vulnerability Assessment?

SQL Vulnerability Assessment (VA) is your one-stop-shop to discover, track and remediate potential database vulnerabilities. It can be used as an excellent preventative security measure, providing visibility into your security state and offering actionable steps to investigate, manage and resolve security issues and enhance your database fortifications. It is designed to be usable even for non-security-experts – getting started and seeing an initial actionable report takes only a few seconds.

Vulnerability Assessment report in SSMS

VA truly enables you to focus your attention on the highest impact actions you can take to proactively improve your database security stature! In addition, if you have data privacy requirements, or need

11

Dec

SQL Vulnerability Assessment now available for SQL Server 2012 and up

https://blogs.msdn.microsoft.com/sqlsecurity/2017/12/11/sql-vulnerability-assessment-now-available-for-sql-server-2012-and-up/Source: https://blogs.msdn.microsoft.com/sqlsecurity/2017/12/11/sql-vulnerability-assessment-now-available-for-sql-server-2012-and-up/   SQL Vulnerability Assessment has been available for preview on Azure SQL Database for a couple of months, and has now been released on SSMS 17.4, supporting scanning of SQL Server 2012 and up. Whether on-premises or on READ MORE

07

Dec

New in SSMS – Always On Availability Group Latency Reports
New in SSMS – Always On Availability Group Latency Reports

https://blogs.msdn.microsoft.com/sql_server_team/new-in-ssms-always-on-availability-group-latency-reports/Source: https://blogs.msdn.microsoft.com/sql_server_team/new-in-ssms-always-on-availability-group-latency-reports/   With SQL Server 2012 we introduced Always On Availability Groups, and the Always On Availability Group Dashboard in SQL Server Management Studio (SSMS). This dashboard can be utilized by database administrators to view the current health of READ MORE

30

Nov

Azure Database Migration Service Preview brings the “lift and shift”

It’s time to get excited—the Azure Database Migration Service Public Preview is here to help you move on-premises SQL Servers to the cloud with near-zero downtime.

There’s never been a better time to start migrating your database to the cloud. Getting ahead in business today means moving to the cloud so that your company can grow and succeed.

The Azure Database Migration Service Preview is the quickest and easiest way for businesses to migrate on-premises databases to the cloud. It’s a fully managed migration service designed to work together with our time-tested migration engines such as the Data Migration Assistant, the Database Experimentation Assistant, and SQL Server Migration Assistant. These tools are tuned to ensure the best migration experience, whether upgrading from legacy versions of Microsoft SQL Server or moving from sources such as Oracle, Sybase, DB2, MySQL, and others. The new service uses a guided, easy-to-implement process to streamline tasks. Regular operations can continue normally during the migration.

Azure Database Migration Service Public Preview uses this functionality to provide rich orchestration capabilities that enable you to organize your databases into project(s) and perform source assessment, schema and data conversion, and validation activities. These activities can be assigned to one

29

Nov

SQL Server 2017: The world’s first enterprise-class diskless database

This post is authored by Bob Ward, Principal Architect, and Jamie Reding, Senior Program Manager and Performance Architect, Microsoft Database Systems Group.

Perhaps you saw the keynote at the recent PASS 2017 Summit where Microsoft demonstrated the performance of the world’s first enterprise-class “diskless database”. This demonstration showed how Microsoft, Hewlett Packard Enterprise (HPE), and SUSE Linux Enterprise Server partnered together to deliver > 5x performance on analytic queries directly against storage at up to 50 percent of the cost.

Recently HPE published a new world record 1TB TPC-H benchmark result¹ using this configuration with their DL380 Gen10 Server showing 1,009,065 QphH at an incredible price/performance of $0.47 USD per QphH. Performance and price are achieved by combining the power of SQL Server 2017, HPE’s scalable persistent memory, and SUSE Linux Enterprise 12 SP3 Persistent Memory Support.

HPE’s scalable persistent memory is a new innovation which combines standard memory with the persistence of standard storage. It allows database engines like SQL Server 2017 to retrieve data from its data files in a matter of seconds.

To see this technology in action, check out this video. To learn more about this amazing result and technology, read HPE’s blog post and SUSE’s