Buffer Pool Extension in SQL Server 2014 part 4: benchmark testing for update operations
One of my previous articles was devoted to carrying out a range of tests to compare speed of data read...
2015-09-10 (first published: 2015-09-04)
1,854 reads
One of my previous articles was devoted to carrying out a range of tests to compare speed of data read...
2015-09-10 (first published: 2015-09-04)
1,854 reads
Feast or famine.
The last several months I just haven’t seen that many speakers, let alone that many community speakers. Then,...
2015-09-04
459 reads
Beyond the metadata in the the catalog views and DMVs, there are a few more objects that come in handy when dealing with Extended Events. I call these the...
2015-09-04
22 reads
So far, in this series, I have discussed the means to view the metadata associated with Extended Events. I also demonstrated...
2015-09-10 (first published: 2015-09-04)
995 reads
After a short little break on Hekaton series, we are now back with the 5th post.
Two new index types...
2015-09-04
758 reads
In the upcoming release of SQL Server Analysis Services 2016, one of the new features you’ll see is the ability...
2015-09-09 (first published: 2015-09-03)
2,141 reads
A few years ago Andy Warren had this idea for a networking dinner. We had been chatting about all the...
2015-09-03
883 reads
I was toying around with the new SQL Server 2016 CTP release and I wanted to run a few SSIS packages...
2015-09-03
5,490 reads
Running session metadata, while it can be still be viewed in the catalog views, is exposed via DMVs. Putting it a slightly different way, if I query DMVs that...
2015-09-03
16 reads
In the previous article, I wrote about getting into some of the metadata to take a peek at session metadata...
2015-09-08 (first published: 2015-09-03)
1,335 reads
By Steve Jones
I wrote about Flyway Desktop Object History in a previous tip. This feature has...
By Arun Sirpal
AgentDBA (the database agent I have been building) has more than 1000 automated tests,...
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers