Rohit Garg

I, Rohit Garg, am working as Consultant in IT Company. I am having an around 5 years of experience in MSSQL server & other Microsoft technologies. I am working as DBA in Microsoft SQL Server from last 5 years in e-Commerce, Telecom, Finance domain. In this tenure, I got a chance of working as Database administrator, Developer and trainer on SQL server 2000 to SQL Server 2012. I am holding Master’s degree in Computer Science along with certification in SQL Server & .Net. I like to learn new things by hand-on experience on regular basis. This journey is so far is delightful & valuable with the addition of wonderful friends.

All authors

Blog Post

How to find/modify SQLServer Agent logfile location?

1. To get the location of SQLServer Agent log file, the log file is called SQLAGENT.out
DECLARE @AGENT_ERRORLOG NVARCHAR(255)
EXECUTE MASTER.DBO.XP_INSTANCE_REGREAD N’HKEY_LOCAL_MACHINE’,
N’SOFTWAREMICROSOFTMSSQLSERVERSQLSERVERAGENT’,
N’ERRORLOGFILE’,
@AGENT_ERRORLOG...

2013-01-31

7,722 reads

All authors

Blogs

T-SQL Tuesday #193 – Notes to my past self and from my future self

By

It has been a while since my last T-SQL Tuesday blog. When I saw...

T-SQL Tuesday #193 – Notes to past and future me

By

The last T-SQL Tuesday of the year is hosted by my good friend Mike...

A Note and a Message: T-SQL Tuesday #193

By

This month Mike Walsh hosts T-SQL Tuesday. It’s been quite some time since he...

Read the latest Blogs

Forums

What is the PRODUCT

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What is the PRODUCT

Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform

By John Miner

Comments posted to this topic are about the item Metadata Driven Pipelines (Incremental Load):...

Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Metadata Driven Pipelines (Incremental Load):...

Visit the forum

Question of the Day

What is the PRODUCT

In SQL Server 2025, what does this return? 

CREATE TABLE Numbers
( n INT)
GO
INSERT dbo.Numbers
(
n
)
VALUES
(1), (2), (3)
GO
SELECT PRODUCT(n)
FROM dbo.Numbers

See possible answers