Expert Insights

blog

SQL Server


Comparing Extended Events in SQL Server and Azure SQL Database

An exciting new feature of Azure SQL Database is the implementation of Extended Events (XEvents). I use XEvents in SQL Server to track information about many things – query performance, deadlocks, Availability Group status, and more. Until October, they were missing from SQL Database, but they are now in preview!

Kim Claditis by Kim Claditis

What’s New for SQL Server in Azure – December 2015

For months, http://portal.azure.com was in preview mode. I’ve watched the new “blades” develop over time, with changes to the functionality. On December 2, Microsoft announced the Azure Portal was in General Availability status.

Kim Claditis by Kim Claditis

Schedule Extended Events Session Start or Stop

When creating an Extended Events session, you may want to start it at a later time, or stop it at a specific time. This ability isn't built into the CREATE SESSION statement, but it can easily be accomplished by using ALTER SESSION and SQL Server Agent.

Kim Claditis by Kim Claditis

Microsoft BI Announcements from SQL PASS Summit 2015

SQL PASS started off with a bang following the Keynote. There was new type of session introduced this year called the “Foundation Sessions”. The first of these session types presented was for BI and was led by James Phillips, Microsoft’s CVP of BI (and now more).

Seth Bauer by Seth Bauer

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