Nagaraj Venkatesan

I am Nagaraj (aka Raj), a SQL Server Database Administrator for one of the busiest OLTP systems in Singapore. Being a SQL Enthusiast for over 10 years now, I love to explore and share more and more on SQL Server.

Backup log Truncate_Only in SQL Server 2008

by Nagaraj Venkatesan

SQL and SQL Only

BACKUP LOG <db_name> WITH truncate_only command, used for clearing the log file, is deprecated in SQL Server 2008. So this post will explain option...

2010-11-16

1,675 reads

Finding CPU Pressure - dm_os_schedulers DMV

by Nagaraj Venkatesan

SQL and SQL Only

The last post dealt with checking CPU pressure using wait_stats DMV. But, to get a complete picture of CPU Pressure,...

2010-11-09

794 reads

Blogs

Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations

By MarlonRibunal

Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...

Rambling about Data on Wheels – origins, branding, expansion

By DataOnWheels

I have been asked many times about how the name “Data on Wheels” came...

Think Twice Before Enabling Fabric’s Inbound Network Protection

By Meagan Longoria

Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...

Read the latest Blogs

Forums

AI Observability Challenges in FinOps as a DBA

Comments posted to this topic are about the item AI Observability Challenges in FinOps...

Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL

By abdalah.mehdoini

Hello everyone , I am planning to migrate a database from SQL Server 2014...

SQL Agent Job Automated Change Capture Process

By James Greaves

Comments posted to this topic are about the item SQL Agent Job Automated Change...

Visit the forum

Question of the Day

Finding a Database Master Key

Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?

See possible answers