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,673 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

Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables

By Eduardo Pivaral

Every PostgreSQL migration eventually hits the same fork in the road. The database is...

A Spread of Vacation

I’m off on vacation today. Which is a little weird as I just got...

How AgentDBA Identifies Backup Failures

Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...

Read the latest Blogs

Forums

Calculating Geometric Mean in Power BI

By Dinesh Asanka

Comments posted to this topic are about the item Calculating Geometric Mean in Power...

TempDB Facts I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item TempDB Facts I

Have you done a Mid year check in?

Comments posted to this topic are about the item Have you done a Mid...

Visit the forum

Question of the Day

TempDB Facts I

Can I set Accelerated Database Recovery on tempdb?

See possible answers