Missing options in the SSMS Extended Events UI due to poor design
While I was writing about the new features of the Extended Events UI in SQL Server 2012, I realized that I hadn’t written about the
While I was writing about the new features of the Extended Events UI in SQL Server 2012, I realized that I hadn’t written about the
With the release of SQL Server 2012, one of the big marketing pushes by Microsoft was the new AlwaysOn features that were a part of
While working on a chapter I am writing, I was going through the ALTER SERVER CONFIGURATION topic in the Books Online and noticed some really
This topic came up on a forum post recently, and after responding a couple of times to the thread I had to jump into one
In my last blog post, I provided a script that queried the XML for the resource monitor ring buffer entries in sys.dm_os_ring_buffers to identify when
Properly configuring SQL Server is an important factor in having a stable environment that performs well. While there is a lot of good guidance available
I’ve been asked questions about these two features a number of times in the last year where the specific concepts for them have been severely
The sqlserver.sql_text action in Extended Events is one of the worst named objects in Extended Events. The name suggests that you are going to get
With the growing popularity of Extended Events in SQL Server 2012 with the UI enhancements that I’ve blogged about on a number of posts (SQL
Traditionally questions about how much memory SQL Server needs were aimed at how to appropriately set the ‘max server memory’ sp_configure option in SQL Server,
This past week at the SQL Server Connections Conference in Las Vegas, I was asked about the permissions required for managing Extended Event Sessions in
While teaching last week at our Tampa Immersion Event, I mentioned the support for SMB as a storage in SQL Server 2012, which is allows
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.