Category Archives: SQL Scripts

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 , , , , , , , , , , | 2 Comments

Get the Next and Previous Row Value in SQL Server

Get the Next and Previous Row Value in SQL Server This post can help you to get the next and previous row Value in SQL Server using T-SQL. We had a requirement to get the previous row information and compare … Continue reading

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

SQL Server Date and Time related Interview Questions

SQL Server Date and Time related Interview Questions This post can help you in answering SQL Server Date and Time related Interview Questions.  Below is the list of queries which are recently asked in SQL Server Developer interviews. These are … Continue reading

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