Om Agarwal's contributions

This article describes the most important Interview question for every DBA.

In this article we are describing SQL Server Profiler Terminology and Architecture.

This article describes SQL Server database file Groups.

This article provides a comprehensive guide on creating a new user account in Windows 7. It explains the benefits of having multiple user accounts on a single computer and outlines the process step by step, from accessing the Control Panel to configuring the new account's settings.

In this article I describe SQL Server database files.

In this blog, covers the basics of Differential Backups in SQL Server.

In this blog, covers the basics of full backups in SQL Server.

In this article I am explaining how to do backup and restore using a SQLCMD and T-SQL command prompt.

In this article determines content and explores the password policies implemented for Windows 7 systems, delving into the security measures, authentication guidelines, and access control mechanisms.

In this blog I am explaining two methods for a comma separated list from column using COALESCE and STUFF function in select statement.

This article explains Dynamic Management Views (DMVs) in SQL Server 2008 R2. This provides the current information about the procedures of the service and the server health.

In this blog I am determining the Schema of a objects and How to change the schema of a objects in SQL Server using below given Query. This query show all Schema of a objects in Existing database and we can change the schema of a objects of any database.

Database Mail in SQL Server 2008 R2 enables sending emails directly from SQL Server using SMTP. It supports job alerts, query results, and file attachments, ensuring consistent, scalable, and secure email delivery. Configuration involves enabling Database Mail, setting up profiles, and testing email functionality.

If you want to directly stops SQL Server by T-SQL (without execution Checkpoint Databases).

In this blog we can enable and disable all login for security reasons.

Today I discuss Reindexing and Reorganized in SQL Server 2008.

Today I am determining the owner of the Database and change the owner of a database in SQL Server below given Query.

Today I discuss the new features Change Data Capture in SQL Server 2008.

In this article, I highlight a small feature of Temporary Stored Procedures in SQL Server. Temporary Stored Procedures are similar to normal Stored Procedures, and are two kinds of temporary Stored Procedures, local and global.

In this blog I will explain how to Free Disk Space in SQL Server with TSQL Code.

It's easy to set up. A standby database is easy to maintain and troubleshoot. It can be used for reporting purposes and configured for log shipping in one or more servers, for instance.