Generate Restore script for multiple databases
Restore script for moving databases from prod to dev with different path / logical name etc.
2014-08-14 (first published: 2014-05-30)
4,921 reads
Taranjit Singh
Blogs
Using SQL Alerts to Spot Suspicious Activity in SQL
SQL doesn’t really give us too many tools out of the box to allow...
How to Change the Browser Used by SSMS for AAD Auth
Did you know that you can change the browser used by SQL Server Management...
Typing with Your Tongue Part 2: Voice Access
By DataOnWheels
A few months ago, I wrote a post on how I use voice technology...
Forums
Azure SQL database AAD user management
I have an Azure SQL DB where I have set up the Azure active...
Use a recursive CTE to produce 1 update statement using dynamic SQL
I want to be able to generate 1 merge statement rather than loop through...
Query to Update balance based on columns from two different rows.
Hello All, Below is the my existing table structure from which I am trying...
Ask SSC