Category Archives: SQL Server DBA

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

1000 Plus SQL Server Interview Questions and Answers

1000 Plus SQL Server Interview Questions and Answers SQL THE ONE Book Preview The book “SQL THE ONE” contains 1000 Plus SQL Server Interview Questions and Answers. This post takes you through the SQL THE ONE book preview and insights. … Continue reading

Posted in High Availability, Interview Q&A, Performance Tuning, SQL Development, SQL Server DBA | Tagged , , , , | 3 Comments