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

700 reads

Blogs

Using SQL Alerts to Spot Suspicious Activity in SQL

By davidfowler-42596

SQL doesn’t really give us too many tools out of the box to allow...

How to Change the Browser Used by SSMS for AAD Auth

By Meagan Longoria

Did you know that you can change the browser used by SQL Server Management...

Typing with Your Tongue Part 2: Voice Access

By DataOnWheels

A few months ago, I wrote a post on how I use voice technology...

Read the latest Blogs

Forums

DC migration SQL DB suggestion

Hi All, Our server team is planning to move secondary data centre from one...

SSDT import into a table from .csv corruption

Hello everyone, I am importing from a csv file into a table. Everything works...

Login failures while connecting from Linux to SQL on windows

Hi all, The app server is running on Linux. SQL server is running on...

Visit the forum

Question of the Day

Contained Availability Groups

See possible answers