Author Archives: uday arumilli

How to connect SQL Server from Excel

How to connect SQL Server from Excel This post can help you in understanding “How to connect SQL Server from Excel Workbook”. There are situations where we need to export data from SQL Server to Excel file. There are multiple … Continue reading

Posted in SQL Development | 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 , , , , , , , , , , | 4 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