Monthly Archives: March 2016

Simple Methods to Recover master.mdf File Password

Overview MS SQL Server is the relational database management system used to store information in form of tables, views, indexes, triggers, constraints and stored procedures. Master Database File (MDF) is the main database file with the file extension .mdf used … Continue reading

Posted in Security, SQL, T-SQL | 1 Comment

Different ways to find Data, log and DB Size

Different ways to get the size of the data , log files and Databases Using Counters Querying sysaltfiles & sys.databases Querying sys.master_files   SELECT instance_name AS DatabaseName, [Data File(s) Size (KB)]/1024.00 [DataInMB], [LOG File(s) Size (KB)]/1024.00 [LogInMB], [Data File(s) Size (KB)]/1024.00 … Continue reading

Posted in SQL, sysfiles | Tagged , , | 4 Comments

Get the Total Item Size for an Exchange database

Hey there! This one is for those Exchange admins who think it is a sin to use hands for something that a computer can do—those Exchange admins love their PowerShell console more than the Exchange Management Console. There are some … Continue reading

Posted in Exchange | Leave a comment

Find failed SQL Job in last 24 Hours using Powershell

This post is based on the request to get failed SQL jobs in last 24 hours and output should be displayed in a HTML format. The verification of SQL job steps code is taken from the below blog. http://www.sqlservercentral.com/blogs/sqlsandwiches/2012/01/29/find-failed-sql-jobs-with-powershell/ The … Continue reading

Posted in PowerShell, SQL, T-SQL | Tagged , | 12 Comments