How to create a database on a network share
If for any reason you need to place the database on a network share and by default this option is off you can follow the way described below: A...
2015-10-12
44 reads
If for any reason you need to place the database on a network share and by default this option is off you can follow the way described below: A...
2015-10-12
44 reads
If for any reason you need to place the database on a network share and by default this option is...
2015-10-12
1,415 reads
Continuation from the previous 67 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is focusing on some...
2015-10-11
461 reads
Continuing from previous post , this post will discuss a few scenarios on hash collisions.
The following "in memory" table with a hash...
2015-10-11
613 reads
Thanks for attending my session on window functions in TSQL. I hope you learned something you can take back and...
2015-10-10
472 reads
A few months back I created a blog post showing that you can indeed create and use indexed views on any core SQL server edition. It has proved to...
2015-10-10
14 reads
A few months back I created a blog post showing that you can indeed create and use indexed views on...
2015-10-10
206 reads
A few months back I created a blog post showing that you can indeed create and use indexed views on...
2015-10-10
465 reads
In the previous blogs we saw how to encrypt data using symmetric and asymmetric keys. We saw how to use...
2015-10-10
832 reads
In the previous blog we learnt about symmetric key encryption. We also learnt through an example how data is stored...
2015-10-10
3,682 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