Monthly Archives: June 2016

Delete old files using powershell script

Powershell script to delete old backup files Advertisements

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

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

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

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

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

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