Category Archives: SQL Server DBA

SQL Server SME Interview Experience

SQL Server SME Interview Experience This post “SQL Server SME Interview Experience” can help you in understanding and answering the most common question for a SQL Server DBA or Developer. A few days back I got an email from one … Continue reading

Posted in Interview Q&A, SQL Development, SQL Server DBA | Tagged , , , , , , , , , | 2 Comments

How to Script Login and User Permissions in SQL Server

How to Script Login and User Permissions in SQL Server Migrating login and user permissions to a new instance is one of the most common tasks for a SQL DBA. This post “How to Script Login and User Permissions in … Continue reading

Posted in SQL Scripts, SQL Server DBA | Tagged , , , , , , , , , , | Leave a comment

SQL Server Transactions Per Day

SQL Server Transactions Per Day This post can help you in capturing SQL Server Transactions per day. Sometimes we need to capture the average number of transactions per day / hour / minute. Below is the T-SQL script that can … Continue reading

Posted in SQL Development, SQL Scripts, SQL Server DBA | Tagged , , , , , , , , , , | 2 Comments