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...
WhatsApp:0817819444 Jl. Raya Ngunut I No.100, Lingkungan 6, Ngunut, Kec. Ngunut, Kabupaten Tulungagung, Jawa...
WhatsApp:0817819444 Jl. Raya Durenan - Bandung, Genengan, Bandung, Kec. Bandung, Kabupaten Tulungagung, Jawa Timur...
Comments posted to this topic are about the item Server-level Roles
In SQL Server 2025, can I alter a fixed server role?
See possible answers