Default trace security auditing [SQL Server]

The Default trace enabled can provides us valuable information about the running server, but it isn’t well-documented. What is the default trace? The default trace is enabled by default in SQL Server and is a minimum weight trace which consists by

Tagged with:
Posted in Scripts, Security

NodeRunner process in SharePoint 2013

The node runner application used by SharePoint 2013 preview for search related process slows down the system due to memory leak issues. To fix this issue follow the below 2 steps 1. Open SharePoint PowerShell window and execute the below

Tagged with: ,
Posted in Issues, Sharepoint

Introducing Cloud Witness – [SQL Server]

We know that when we create a Cluster environment between two sites, we must take care about Quorum Witness. If you need automatic failover SLA in your company, the best way is to separate the (Quorum) FileShare Quitness at a

Tagged with: ,
Posted in Cluster, High Availability

Error while installing the Pre-requisite for SharePoint Server 2013

When I was trying to install the SharePoint 2013 pre requisite on Windows Server 2008 R2 Std SP1, I got an error message: 2015-02-02 11:14:27 – “C:\Windows\system32\cscript.exe” “C:\Windows\system32\iisext.vbs” /enext “ASP.NET v4.0.30319” 2015-02-02 11:14:29 – Install process returned (-2146646015) 2015-02-02 11:14:29

Tagged with: ,
Posted in Issues, Sharepoint

Alert – Databases do not have Transaction log backups

The SP below sends alert when there are no transaction log backups in the last 90 minutes.

Tagged with: ,
Posted in Alerts, Backup, Scripts

How to list all objects and indexes [SQL Server]

Today I had to list which objects belongs to which filegroup. It’s a simple and useful script that you can take from system catalogues: sys.filegroups, sys.indexes, sys.database_files and sys.data_spaces. Take a look this sample In the next post I’m going to share

Tagged with: , ,
Posted in Scripts, SQL Server Tips

How to monitor Timeout and Changes Roles from Availability Groups with Alerts

Agent alert can send alerts by email when occur some action/timeout between databases in your Availability Group Environment. It allows you to become proactive. The following script shows how to create these alerts. You can also configure to execute another

Tagged with: , , , , ,
Posted in Administration, Alerts, AlwaysOn, Scripts