Automatic database restore
Often times database administrators were asked to restore production database backup to UAT or development environment, sometimes it will needed...
2015-07-10
1,012 reads
Often times database administrators were asked to restore production database backup to UAT or development environment, sometimes it will needed...
2015-07-10
1,012 reads
SQLKover update: When I read this old blog post of mine, all I can think about is: Power Query to...
2015-07-10
1,350 reads
This is my 100th blog post here at LessthanDot!
(I’m not lying, check for yourself)
I started blogging at the end of...
2015-07-10
529 reads
During my time at SQL Saturday in Philadelphia (Early June), Chris Bell invited me to be a guest on his...
2015-07-09
707 reads
I keep getting questions around what core features are missing in Standard Edition of SQL Server,and why there is a...
2015-07-09
1,170 reads
In release of SQL Server 2016 CTP 2.0 another new feature that is released is Dynamic Data Masking. Using Dynamic...
2015-07-09
616 reads
Here is an overview of the articles I published in the secondt quarter of 2015.
INTENSE SCHOOL
Book Review: Query Tuning & Optimization by...
2015-07-09
537 reads
Server storage is one of the most important things for SQL Server performance. Chances to utilize a lot of RAM and...
2015-07-09
3,494 reads
Recently, When we were delivering session on “SQL SERVER” one of the persons asked why we require Aliasing so I...
2015-07-09
470 reads
In my previous post on running SQL Server in a container I showed how you could use the Spoon (https://spoon.net)...
2015-07-08
1,350 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