Category Archives: Uncategorized

SQL latest available patch reference

Best source for latest SQL Server patches: https://sqlserverbuilds.blogspot.com/ Ref 2: https://technet.microsoft.com/en-us/library/ff803383.aspx (Hotfix information is not updated) Option 3: https://sqlserverupdates.com/ Advertisements

Posted in Uncategorized, SQL Server | Tagged , , | Leave a comment

How to Point in time Restore Azure SQL Database after deleting the database

Azure SQL Database has feature to restore the database to point in time when the database is live. When we have to move the database to different Server we end up deleting the database from old server, we can not … Continue reading

Posted in Azure, Powershell, SQL, SQL Server, Uncategorized | Tagged , , , , | 2 Comments

catalog

This Catalog is the index for different blog posts in structured order Azure . Azure.Pricing: https://vijredblog.wordpress.com/2016/09/15/azure-database-pricing-tier-selection/ . Azure.Powershell : Frequently used Azure SQL Powershell Commands: https://vijredblog.wordpress.com/2017/07/27/frequently-used-azure-powershell-commands/ Point in Time Restore on Deleted DB: https://vijredblog.wordpress.com/2018/05/23/how-to-point-in-time-restore-azure-sql-database-after-deleting-the-database/ . Azure.SQL . AZURE.SQL.Frequently User SQL … Continue reading

Posted in Azure, Powershell, SQL, Uncategorized | Tagged , | Leave a comment

How to mound Azure File Service on local machine

You can mound Azure File service account folder on local machine as a drive (Mount point). How to do it: Open Azure Portal (https://portal.azure.com) Open File Service account (Storage account -> Account -> Files ) Click on Connect button You … Continue reading

Posted in Azure, Uncategorized | Tagged , | Leave a comment

Powershell Workflow for Runbooks, Inline Script

Powershell workflow is the best way to program parallel processing using Powershell and/or in Azure run books. Though the syntax is similar, there are few differences you need to be aware of. Start with below link when you create your … Continue reading

Posted in Azure, Powershell, Uncategorized | Tagged , , , , , , | Leave a comment

DBATools.IO – Powershell for SQL DBAs

DBATools.IO was one of the best things I started using in 2017 and I wanted to master this in 2018! https://dbatools.io/functions/ includes the list of all commands in dbatools module! Start using it if you have not started already.

Posted in Powershell, SQL, Uncategorized | Tagged , , | Leave a comment

SQL Alwayson Preferred Node workaround, Fallback script

We have Always-On configured between Node-1, Node-2 with Auto Failover enabled. Unfortunately one minor functionality was partially impacted when AG is primary on Node-2. Business is very particular about not changing it to Manual Failover mode. End up creating a … Continue reading

Posted in Script, SQL, SQL Query, Uncategorized | Tagged , , , , | Leave a comment