This blog series on Audit/Compliance/Security, this is first blog where we would discuss about GRC and different audits and other important information, later we will discuss each audit frameworks...
2026-07-21
83 reads
As Open Source – PostgreSQL and AI is a growing and powerful DB system, AWS and Google already have AWS Aurora and Google AlloyDB, which are Cloud Native PostgreSQL...
2026-07-15 (first published: 2026-07-14)
105 reads
When you have a project or system, it has to be optimized, tuned, and we must ensure it is consistently performing better. For this, we should use the Lean...
2026-07-14
34 reads
The soul of project management is Process Group(PG) and Knowledge Area(KA). they are related and grouped as follows: Process Group[49] Knowledge Area with Process I will write detail blog...
2026-07-13
40 reads
Google has contributed a lot of stuff/enhancement on its portfolio, google is no longer a search engine. it is a Major IT company in the industry. having strong base...
2026-05-28
46 reads
In previous posts, we looked at the SQL Server engine. for us DBAs, the SSMS plays an important role for handling/Managing SQL Server. we have been using these tools...
2026-05-14 (first published: 2026-05-13)
52 reads
These days everything is changing to AI World, IT roles are getting changed and it is going towards AI ways, everyone in IT should be aware of AI –...
2026-05-07
49 reads
This week has training on AI – Cyber security experts – Omar Santos and Aamir Lakhani- with great knowledge . during the session learned about OpenClaw and more. I...
2026-04-29 (first published: 2026-04-17)
375 reads
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE which is introduced on SQL Server 2008, TDE is at rest has limitation as data...
2026-04-13 (first published: 2026-04-04)
286 reads
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this feature encrypts a physical layer of Database files Data/log files protection at Disk / storage...
2026-04-04 (first published: 2026-04-03)
52 reads
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
Comments posted to this topic are about the item Implementing Type 4 Slowly Changing...
Comments posted to this topic are about the item Server-Level Table sizes
I run this code on SQL Server 2022.
CREATE TABLE Drink
(
drinkid INT NOT NULL
CONSTRAINT DrinkPK PRIMARY KEY CLUSTERED,
drinkname VARCHAR(20),
rating NUMERIC(2, 1)
)
GO
INSERT INTO Drink
(
drinkid,
drinkname,
rating
)
VALUES
(1, 'Margarita', 4.5),
(2, 'Mojito', 4.3),
(3, 'Old Fashioned', 4.7),
(4, 'Martini', 4.4),
(5, 'Cosmopolitan', 4.2)
GO
ALTER INDEX drinkpk ON dbo.drink DISABLE
GO
SELECT * FROM dbo.Drink
GO
What is the result? See possible answers