Querying the Plan Cache
I love working with indexes, and I need to know what’s using them to work on them intelligently. Most of...
2015-12-08 (first published: 2015-12-01)
2,023 reads
I love working with indexes, and I need to know what’s using them to work on them intelligently. Most of...
2015-12-08 (first published: 2015-12-01)
2,023 reads
Over the Thanksgiving holiday, I read a book entitled The Phoenix Project. This book has been in my Kindle library...
2015-12-04 (first published: 2015-12-01)
1,538 reads
Today I had a need to manually trigger and sustain a Blue Screen of Death (BSOD) inside a Windows Server...
2015-11-30
846 reads
It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on...
2015-11-30
844 reads
You have an on call, you have a business continuity plan, you have a disaster recovery plan but what happens...
2015-12-07 (first published: 2015-11-30)
2,458 reads
My previous post was focused on controlling read operations. With the latest enhancements to the row-level security, it is now possible...
2015-12-03 (first published: 2015-11-29)
2,841 reads
Continuation from the previous 72 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Since the very first version of SQL...
2015-11-28
985 reads
There was a time I worked in a company any we lived in the command line. This was in the...
2015-11-27
1,118 reads
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5...
Duplicate indexes, one of the most pointless things you can do to a table that...
2015-11-27
992 reads
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5… Duplicate indexes, one of the most pointless things you can do to a table that just adds pure overhead. No one likes them...
2015-11-27
12 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...
Telp/WA 628217555651 Jl. Dr. Ir. H. Soekarno No.37-39, Klampis Ngasem, Kec. Sukolilo, Surabaya, Jawa...
Telp/WA 62817825533 Jl. Brawijaya No.8, Pocanan, Kec. Kota, Kota Kediri, Jawa Timur 64123
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