13

Dec

Cloud storage now more affordable: Announcing general availability of Azure Archive Storage

Today we’re excited to announce the general availability of Archive Blob Storage starting at an industry leading price of $0.002 per gigabyte per month! Last year, we launched Cool Blob Storage to help customers reduce storage costs by tiering their infrequently accessed data to the Cool tier. Organizations can now reduce their storage costs even further by storing their rarely accessed data in the Archive tier. Furthermore, we’re also excited to announce the general availability of Blob-Level Tiering, which enables customers to optimize storage costs by easily managing the lifecycle of their data across these tiers at the object level.

From startups to large organizations, our customers in every industry have experienced exponential growth of their data. A significant amount of this data is rarely accessed but must be stored for a long period of time to meet either business continuity or compliance requirements; think employee data, medical records, customer information, financial records, backups, etc. Additionally, recent and coming advances in artificial intelligence and data analytics are unlocking value from data that might have previously been discarded. Customers in many industries want to keep more of these data sets for a longer period but need a scalable and cost-effective solution

Share

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,

Share

12

Dec

Bookmarking Contest: Dec. 12th – Dec. 27th
Bookmarking Contest: Dec. 12th – Dec. 27th

https://powerbi.microsoft.com/en-us/blog/bookmarking-contest-dec-12th-dec-27th/Source: https://powerbi.microsoft.com/en-us/blog/bookmarking-contest-dec-12th-dec-27th/           Earlier this week, we announced an update to the new “Bookmark” feature in Power BI Desktop, and we’re excited to see what you do with it! So, today we’re kicking off our “Bookmark” READ MORE

Share

12

Dec

How cloud speed helps SQL Server DBAs
How cloud speed helps SQL Server DBAs

A few years ago, the Microsoft SQL Server product team introduced a new cloud Platform-as-a-Service (PaaS), Azure SQL Database, which shares the SQL Server code base. Running a cloud-first service required significant changes to the legacy SQL Server engineering model which took years of investment in order to fully enable. With these engineering model changes came big benefits which positively impacted both Azure SQL Database and SQL Server.

Even if you are a SQL Server database administrator who isn’t using Azure SQL Database today, you’ll still be seeing benefits from Microsoft’s investments in the cloud. This blog post will review how engineering model transformations, driven by cloud requirements, resulted in several improvements in how we build, ship and service SQL Server. 

Features arrive faster

In the earlier days of SQL Server (2005 through 2012), SQL Server had roughly three-year long engineering cycles. For each planned release of SQL Server, a significant amount of planning would go into the up-front design, using a waterfall-like software development process coordinated across different teams. This included the generation of functional specification documentation by program managers, design specifications by developers and automated testing code developed by testers. 

Once SQL Server finally shipped, customers could take years to

Share

12

Dec

Azure Monitor: Send monitoring data to an event hub
Azure Monitor: Send monitoring data to an event hub

With Azure Monitor’s diagnostic settings you can set up your resource-level diagnostic logs and metrics to be streamed to any of three destinations including a storage account, an Event Hubs namespace, or Log Analytics. Sending to an Event Hubs namespace is a convenient way to stream Azure logs from any source into a custom logging solution, 3rd party SIEM product, or other logging tool.

Previously, you could only route your resource diagnostic logs to an Event Hubs namespace, in which an event hub was created for each category of data sent. Now, you can optionally specify which event hub within the namespace should be used for a particular diagnostic setting. This is helpful if you are routing multiple types of logs to a single endpoint, for example, a SIEM connector. Rather than having to configure that endpoint to read from multiple event hubs, you can simply route all log types to a single event hub and have your endpoint listen to that one source.

You can try this out today in the Azure Portal by creating or modifying a diagnostic setting and selecting “Stream to an event hub”.

This can also be set up using a Resource Manager template.

Share

12

Dec

Announcing Power BI Premium support for larger datasets
Announcing Power BI Premium support for larger datasets

https://powerbi.microsoft.com/en-us/blog/announcing-power-bi-premium-support-for-larger-datasets/Source: https://powerbi.microsoft.com/en-us/blog/announcing-power-bi-premium-support-for-larger-datasets/           Power BI Premium now supports uploading Power BI Desktop (.PBIX) files that are up to 10 GB in size – a x10 increase compared to before.

Share

12

Dec

Microsoft expands scope of Singapore MTCS certification

I am pleased to announce the renewal of the Singapore Multi-Tier Could Security (MTCS) Certification Level 3. As part of its commitment to customer satisfaction, Azure has adopted the MTCS standard to meet different cloud user needs for data sensitivity and business criticality. Azure has maintained its MTCS certification for the fourth consecutive year. This year, the scope has increased by 30% catching up with the latest ISO 27001 scope covering the latest data storage and analytics services including Data Lake Store, Data Lake Analytics, SQL Server Stretch Database, Azure Cosmos DB, Azure Container Service, etc.

Developed by the Infocomm Media Development Authority (IMDA) of Singapore, the MTCS Standard 584:2015 is the world’s first cloud security standard that covers three different tiers of security requirements spanning different service types including PaaS, IaaS and SaaS.  The standard comprises a total of 535 controls closely mapped to ISO 27001 Information Security Management System (ISMS) standard, covering basic security in Level 1, more stringent governance and tenancy controls in Level 2, and reliability and resiliency for high-impact information systems in Level 3.

The MTCS standard seeks to drive cloud adoption across industries by giving clarity around the security service levels of Cloud Service

Share

11

Dec

Microsoft Azure preview with Azure Availability Zones now open in France

The preview of Microsoft Azure in France is open today to all customers, partners and ISVs worldwide giving them the opportunity to deploy services and test workloads in these latest Azure regions. This is an important step towards offering the Azure cloud platform from our datacenters in France.

The new Azure Regions in France are part of our global portfolio of 42 regions announced, which offer the scale needed to bring applications closer to users and customers around the world. We continue to prioritize geographic expansion of Azure to enable higher performance and availability, meet local regulatory requirements, and support customer preferences regarding data location. The new regions will offer the same enterprise-grade reliability and performance as our globally available services combined with data residency to support the digital transformation of businesses and organizations in France.

The new France Central region offers Azure Availability Zones which provide comprehensive native business continuity solutions and the highest availability in the industry with a 99.99% virtual machines uptime SLA when generally available. Availability Zones are fault-isolated locations within an Azure region, providing redundant power, cooling, and networking for higher availability, increased resiliency and business continuity. Starting with preview, customers can architect highly available

Share

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

Share

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

Share