New Youtube Channel
Last year I noticed I was blogging way less than I should, in part because of new projects: work, personal stuff, local community activities, university projects... you name it.As...
2020-01-31
55 reads
Last year I noticed I was blogging way less than I should, in part because of new projects: work, personal stuff, local community activities, university projects... you name it.As...
2020-01-31
55 reads
Last year I noticed I was blogging way less than I should, in part because of new projects: work, personal stuff, local community activities, university projects... you name it.As...
2020-01-31
22 reads
You are working on a database development project, and you need to obtain the records before/after an INSERT, DELETE, UPGRADE or MERGE Statement to present it to the user...
2020-01-09 (first published: 2020-01-03)
1,101 reads
You are working on a database development project, and you need to obtain the records before/after an INSERT, DELETE, UPGRADE or MERGE Statement to present it to the user...
2020-01-03
30 reads
This is a very simple version of a Xmas tree using T-SQL, also is a good example to learn how recursive CTE works.So, if you are in front of...
2019-12-27
285 reads
This is a very simple version of a Xmas tree using T-SQL, also is a good example to learn how recursive CTE works.So, if you are in front of...
2019-12-27
23 reads
When you are in charge of databases with tons of objects, making a small change over an object can be difficult to replicate if you have a lot of...
2019-08-02 (first published: 2019-07-15)
1,312 reads
When you are in charge of databases with tons of objects, making a small change over an object can be difficult to replicate if you have a lot of...
2019-07-15
22 reads
SQL Server engine does an excellent job to optimize query performance and it has different methods to achieve this goal, one of these methods is the data caching.Data caching...
2019-07-16 (first published: 2019-07-05)
1,142 reads
SQL Server engine does an excellent job to optimize query performance and it has different methods to achieve this goal, one of these methods is the data caching.Data caching...
2019-07-05
54 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