Category Archives : #SQLServer



Azure SQL Vulnerability Assessment – now with PowerShell support!   You can now manage your SQL Vulnerability Assessments at scale using the new SQL VA PowerShell cmdlets. The cmdlets can be found in the Azure Resource Manager module, AzureRM 6.6.0, within the AzureRM.Sql package. Take a look READ MORE



SQL Server Availability Groups – Enhanced Database Level Failover   Database level health detection failover (DB_Failover) option for Availability Groups was introduced in SQL Server 2016 with the objective to provide a mechanism for availability groups to failover, if one or more databases in the availability had READ MORE



Behavior Change for VSS Backups on VMs with Basic Availability Groups   This week we released SQL Server 2016 SP2 CU2 and SQL Server 2017 CU9. In this blog, I’d like to go into a little more detail on one of the fixes that is part of these CUs READ MORE



Tiger Team at Data Platform Summit 2018
Tiger Team at Data Platform Summit 2018   Tiger Team (@mssqltiger) represented by (Tejas Shah and Sourabh Agarwal) will be presenting about the recent investments in SQL Server at the Data Platform Summit (#DPS10), Asia’s Premier Data & Analytics Conference taking place on 9-11 August READ MORE



The July release of SQL Operations Studio is now available

We are excited to announce the July 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 June release is the eighth major update since the announcement. If you missed it, the June release announcement is available here.

Highlights for this release include the following.

SQL Server Agent preview extension Job configuration support SQL Server Profiler preview extension Improvements Combine Scripts Extension Wizard and Dialog Extensibility Social content Fix GitHub Issues

For complete updates, refer to the Release Notes.

SQL Server Agent configuration

As part of our story of bringing over SSMS features and improving user experience, we are excited to introduce SQL Agent configuration support.

Summary of changes include:

Added view of Alerts, Operators, and Proxies and icons on left pane Added dialogs for New Job, New Job Step, New Alert, and New Operator Added Delete Job, Delete



SQL Server 2008 end of support is the first step to tomorrow’s database

Today, Takeshi Numoto blogged about the upcoming SQL Server 2008 and 2008 R2 end of support. If youve been thinking about what to do with your SQL Server 2008 and 2008 R2 databases, youre not alone. These databases reach end of support on July 9, 2019, and many organizations have started planning in earnest for this milestone.

Which brings us to Will, a database admin at that development shop downtown. Bucking the job-hopping trends of today, Wills been a stalwart for his company, wrangling data for them since the mid-2000s. He remembers leading the installation of SQL Server 2008. Back then, connections were speedy, requests processed swiftly. Security, efficiency, and good clean design existed in abundancethere was a place for every byte and every byte was in its place. App developers loved Will because he made sure their data was right where they needed it, when they needed it. What an idyllic, peaceful time!

A lot has happened in the decade since. Over the years, Wills information transfer network has grown and evolvedforking and pooling and spidering as it has had to make new, less-efficient references. The schema, once so clear, is now muddied and confusing, obscuring paths for formerly



Predicate Pushdown and why should I care?
Predicate Pushdown and why should I care?   If you follow this blog, you know that in the last couple years, we have been adding more information to showplan, to make it a one-stop-shop for all your query performance troubleshooting insights. You can see more READ MORE



SQL Server 2008 and 2008 R2 are reaching end of support. What’s next?

SQL Server 2008 and 2008 R2 have had a tremendous run. But all good things come to an end, right? On July 9, 2019, Microsoft will end Extended Support, which means no more updates or support of any kind, potentially leaving you vulnerable to security and compliance issues.

The good news is, you still have plenty of time and options to avoid any heartburn caused by the technology circle of life. And well lay out all of those options for youin a webinar on July 12.

In this webinar, well show you:

how to migrate your applications and data to make the transition more than just an upgrade how to avoid business disruptions and adopt the most current security technologies the advantages of moving your legacy platforms to SQL Server 2017 and Azure the range of guidance and resources available to help, no matter which path you choose

We want this transition to be as seamless and pain-free as possible for you. Register now and find out all the ways weve come up with to make that happen.



PowerShell cmdlets for managing SQL Vulnerability Assessments   We are pleased to announce the availability of PowerShell cmdlets for managing SQL Vulnerability Assessments for your SQL Servers. The cmdlets can be used to run assessments programmatically, export the results and manage baselines. To get started, READ MORE



Re-platforming and modernizing your data workloads with SQL Server on Linux

This post is authored by Marko Hotti, Senior Product Marketing Manager, SQL Server.

Today, were excited to introduce a free e-book, SQL Server on Linux: A guide to re-platforming and modernizing your data workloads. This is the thirdin a series oftechnical e-books helping you get the most out of your database. With SQL Server 2017, you can harness the latest capabilities of SQL Server on the platform of your choicewhether thats Windows, Linux, or even containers.

In this guide, you getthe technical details for preparing your Linux system for SQL Server installation, managing a mixed environment, and migrating your existing data and databases. The e-book addresses flexibility, performance, and security with your data platform, whether youre a database architect, administrator, or developer working with data.

Here’s whats covered:

An overview of SQL Server on Linuxunderstand platform options, features, pricing, and more. Getting the most out of SQL Server on Linuxreview our planning considerations to prepare your Linux system to best support your business goalssuch as performance optimization, high availability, or enterprise-grade security. Tools and managementget a rundown of the many tools available from Microsoft that make managing your mixed environment easier. Migrations and upgradesdiscover the tools and services available