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-20 (first published: 2012-08-12)
8,659 reads
We all know very well that SQL server stores data in 8 KB pages and it is the basic unit...
2012-08-20 (first published: 2012-08-12)
8,659 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,318 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,483 reads
What will happen if you lost all your administrator account by mistake ? As per the best practice you have disabled...
2012-08-06
7,985 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,276 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,500 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,431 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,711 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,733 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,320 reads
The AI revolution isn’t coming – it’s here. Companies are racing to integrate artificial...
Introduction Do you remember the effort of tidying up your BI and reporting systems,...
By Steve Jones
I needed to back up a PostgreSQL database as a part of the repro...
Hey, I've previously used this or something like this: RESTORE DATABASE [DBNAME] FROM DISK...
Last week I downloaded and applied the newest CU31 patch to our lower environment...
Hi All, I can see many tables under MasterDataServices like below in an...
I have this data in a table?
CatIDCatName 3MonitorsWhat is returned when I run this code?
SELECT CHOOSE(catid, 'Laptops', 'PCs') FROM dbo.Categories AS cSee possible answers