SQL Server: Understanding the Data Page Structure
We all know very well that SQL server stores data in 8 KB pages and it is the basic unit...
2012-08-15 (first published: 2012-08-12)
8,815 reads
We all know very well that SQL server stores data in 8 KB pages and it is the basic unit...
2012-08-15 (first published: 2012-08-12)
8,815 reads
Some time there will be situation in application , where a
grid is populated with data and user has option to edit...
2012-08-09 (first published: 2012-08-01)
6,360 reads
As part of security audit of login's, we have discussed earlier about the orphan users , listing server level and database level role...
2012-08-07
5,510 reads
What will happen if you lost all your administrator account by mistake ? As per the best practice you have disabled...
2012-08-06
8,009 reads
Last Friday evening, I forced to look into a procedure which is using Recursive Common Table (CTE) . The procedure was...
2012-08-06
12,297 reads
In my last post, we have discussed about the orphaned users and fixing the orphaned users. The next step in...
2012-08-05
10,550 reads
In my last post , we have discussed about orphaned uses and how to find out the orphaned users. In this...
2012-08-02
1,458 reads
Orphaned user is a common problem in SQL server world.When I was working on internal security audit of our production...
2012-08-02
1,732 reads
Think about a scenario : People are complaining about your production database server.Many users are getting continuous time out error. Rest...
2012-08-01 (first published: 2012-07-30)
3,771 reads
In my earlier post I have explained about various quorum settings available in Microsoft windows 2008 cluster environment. While we plan to...
2012-07-23
15,410 reads
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
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