Skip to main content

Expert Insights


SQL Server

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.

Concurrency Blog by Concurrency Blog

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...

Amy Cousland by Amy Cousland

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....

Amy Cousland by Amy Cousland

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...

Concurrency Blog by Concurrency Blog

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...

Seth Bauer by Seth Bauer

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...

Concurrency Blog by Concurrency Blog

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 ...

Concurrency Blog by Concurrency Blog

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...

Concurrency Blog by Concurrency Blog