Rights Required for Creating Extended Events Sessions

What rights are required in SQL Server to create and view an Extended Events session?

In SQL Server 2008 and 2008R2, a user had to be granted CONTROL SERVER to create and run sessions. CONTROL SERVER is roughly equivalent to sysadmin. The difference is that if you grant someone CONTROL SERVER and you don’t want them to access something, you can issue an explicit DENY. Having to do that for a large number of objects would be a pain, though.

by Concurrency Blog Aug 27, 2015

SQL Server 2016 Backup and Restore Enhancements

Backups and restores are the bread and water of a DBA’s job. With each new version of SQL Server, Microsoft continues to add enhancements to backups and restores. With SQL Server 2016, here is what y...

by Amy Cousland Aug 11, 2015

SQL Server 2016 Security Features to Look Forward To

“Psychiatric Hospital Loses Backup Data”…”Cardinals Sack Employee After Hack”…”LastPass Takes Steps to Protect Enterprise Partners in Wake of Data Breach” Headlines such as these are all too common....

by Amy Cousland Aug 4, 2015

What Should I Monitor in Availability Groups, and How?

Availability Groups contain a lot of moving parts. Planning for them is an involved process, and deploying them involves many steps. However, the real work with AGs begins once you start using them e...

by Concurrency Blog Jul 30, 2015

Creating a Listener for a Multi-Subnet Hybrid or Azure Availability Group

A listener is an important component of a SQL Server Availability Group (AG). It enables applications to connect to a DNS name, regardless of which AG replica is the primary. While SQL Server Managem...

by Concurrency Blog Jul 28, 2015

Power BI Analysis Services Connector Rises to the Top

The Power BI Analysis Services Connector (Tabular) is a feature that I’ve been working with throughout the preview of Power BI ever since it was introduced in early March of 2015. Coming from the SQL...

by Seth Bauer Jul 27, 2015

3 Keys to Configuring Azure Virtual Machines for Use in SQL Server Availability Groups

One of the great features of SQL Server AlwaysOn Availability Groups is that they can span multiple data centers – including Azure. You can create an Availability Group with all replicas on-premises,...

by Concurrency Blog Jul 16, 2015

3 Keys to Creating Azure Virtual Machines for SQL Server

When you’re looking to create Azure virtual machines to install SQL Server, it’s best to do some pre-planning. Much like you wouldn’t install SQL Server by clicking Next, Next, Next on every installa...

by Concurrency Blog Jul 14, 2015

Get Your Hands on the SQL Server 2016 Preview!

In the last two months, at Build and Ignite, Microsoft offered a taste of the new features and capabilities they would bring to SQL Server 2016. Now is your chance to download the bits and check out ...

by Concurrency Blog Jun 3, 2015

Learn Something New With Hands-On Labs!

This week, I re-discovered Microsoft's TechNet Virtual Labs. These are fully-functional labs set up with Microsoft technologies to help you learn something new or brush up your skills in a safe envir...

by Concurrency Blog Jun 2, 2015