Monthly Archives: June 2016

Delete old files using powershell script

Posted on June 30, 2016 by vijred

Powershell script to delete old backup files

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

How to give access to Users in Secondary Always-On/Mirror Server

Posted on June 23, 2016 by vijred

When we need to provide access to users on a secondary database we will be able to create a login but not user on the read-only database. To address the problem we need to create the Login with same SID … Continue reading →

Posted in High Availability, SQL, SQL Query, SQL Server, Uncategorized | Tagged , , , , , | Leave a comment

How to insert a code snippet in SQL Server Management Studio

Posted on June 16, 2016 by vijred

This is one of the easy ways to get syntax of the new functionality we use. Code snippet can be included into SQL Server Management Studio (SSMS) in 3 different ways: * Ctrl+K and Ctrl+X * Edit Menu -> Intellisense … Continue reading →

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

Powershell script to check SQL instance name on all given SQL Server

Posted on June 9, 2016 by vijred

one of the repetitive script I use over years is to find the SQL instance name using list of Servers. Below is the small script which can be used to find the SQL instance name and the SQL service run … Continue reading →

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

Delphix for SQL Server

Posted on June 2, 2016 by vijred

I have learned about an interesting tool (https://www.delphix.com/) which is used to provide effective production copies to Developers in no time. This was implemented for Oracle environment for last couple of years. Now Delphix supports Always-On feature as well for … Continue reading →

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