Keep Learning and Keep Sharing. All the posts are informative for learning and to carry day to day DBA tasks.

Microsoft SQL Server 2005 Service Broker helps developers build scalable, secure database applications. This new technology, a part of the Database Engine, provides a message-based communication platform that enables independent application components to perform as a functioning whole. Service Broker includes infrastructure for asynchronous programming that can be used for applications within a single database or a single instance as well as for distributed applications.

Service Broker reduces application development time by providing much of the infrastructure that is necessary to build a distributed application. Service Broker also makes it easy to scale your application up or down to accommodate the amount of traffic the application receives.

/*when more users are logged in..if we have e forced logged in*/

How to find the Index health status by running the query in SQL Server Indexs created on the table of a database plays the most importa…

How to find the database growth in SQL Server Can we find the database growth and find out at what is the percentage of growth of the da…

Enable and disable service broker in SQL Server

How to Enable and disable service broker in SQL Server Microsoft SQL Server 2005 Service Broker helps developers build scalable, secur…

Network Error Occured in SQLNCLI file x64 while in…

Find the latest backup of databases in a SQL Serve…

Find locks issued by the User sessions in SQL Serv…

Query to find mail profiles created in SQL Server

Query to troubleshoot the Service broker issues in…

Find out the statistics update datetime in SQL Ser…

Copy logins from one SQL Server to Another SQL Ser…

Find last LSN applied on a database in SQL Server

Remap the user of a database to a login in SQL Ser…

Number of objects related to schema in SQL Server

Statistics of physical database files in the SQL S…

Enable and disable service broker in SQL Server

Find the protocol used by the session to connect t…

Automate database backup of SQL Server Express Edi…

Find the Orphan users in a database of SQL Server

Find the size of the table in a database of SQL Se…

find the linked servers created in the instance of…

create new error log file without restarting SQL S…

Automate backups in SQL Server with TSQL Script

Read backup file for particular transaction in SQL…

Read LDF for Particular Transaction in SQL Server

Find the total extents and pages used by the datab…

how to find my login privileges in SQL Server

Multiple conditions in Where In Clause of SQL Serv…

Kill all the existing user connections in SQL Serv…

Never put the DB into Single user Mode using GUI M…

Put the database into single user mode in SQL Serv…