▼
Thursday, 24 October 2013

Find Orphan SQL Users and Fix using ALTER USER

›
For years i have been using syslogins and sysusers tables in a cursor to find orphan users and sp_change_users_login to fix orphan user...
4 comments:
Friday, 11 October 2013

Store Perfom Data Collector data to SQL Server

›
As a DBA we frequently run perfmon on our servers to monitor performance of the SQL Servers, In this section I am going to write how to ...
6 comments:
Tuesday, 17 September 2013

PowerShell to Enable and Configure Database Mail across various SQL servers

›
Recently I was asked to configure Database Mail on all SQL Servers in one of my client environment, Instead of using SSMS or TSQL I trie...
2 comments:
Wednesday, 4 September 2013

Analysis Service connectivity error due to SQL Browser service

›
  Today some of my SSIS packages were failing to connect to Analysis servicesserver with the following error,    Analysis Services P...
5 comments:
Thursday, 15 August 2013

PowerShell to Script SQL Analysis Service Database(XMLA Script) and ReApply on a different Server

›
Similar to my   post last month to script and reapply DB service database objects ( http://www.sqltechnet.com/2013/06/powershell-to-scri...
5 comments:
Monday, 22 July 2013

PowerShell Script to find OS Edition and Total RAM on a Server

›
Copyright © 2013 Vinoth N Manoharan.The information provided in this post is provided "as is" with no implied warranties or gu...
3 comments:
Tuesday, 25 June 2013

Configure SSIS to SQL Server 2012 Cluster

›
SQL Server Integration services are not cluster aware by default, the following article shows a documented steps by Microsoft on how to c...