Author Archives: vijred

How to operate multiple objects in SSMS (F7)

While working on a service restoration, we had to resume data movement on 100+ random databases. Generating TSQL is the best option but UI will be very quick and reliable. Biggest challenge with SSMS UI will be to perform the … Continue reading

Posted in SQL, SQL Server, SSMS, Uncategorized | Tagged , , | 1 Comment

Frequently used MSSQL Commands

 

Posted in commands, SQL Server, Uncategorized | Tagged , , , , , | 1 Comment

Best practices being DEVOPS in IT

Index: MSSQL Index naming recommendations:   PK_ for primary keys UK_ for unique keys IX_ for non clustered non unique indexes UX_ for unique indexes <index or key type>_<table name>_<column 1>_<column 2>_<column n>  

Posted in SQL Server, Uncategorized | Tagged , , | 1 Comment

Command to find domain group members

Related: https://vijredblog.wordpress.com/2016/04/21/activedirectory-group-user-membership-validation-tool/ (Active Directory Helper)

Posted in commands, Productivity, Uncategorized | Tagged , , , , , | Leave a comment

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/

Posted in SQL Server, Uncategorized | Tagged , , | 1 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