Category: Automation

  • SQL DBA Cheatcode : 15 Things about SQL Server Error logs

    SQL DBA Cheatcode : 15 Things about SQL Server Error logs

    Today I am writing about some good facts about SQL Server Error logs.   SQL Server maintains its own error logs that contain messages describing informational and error events. “Error logs” is just the name but it contains warnings, error, information messages. 1. How to View SQL Server Error Log file location EXEC xp_readerrorlog 0,1,”Logging…

  • Backup of OLAP Database using Powershell

    Backup of OLAP Database using Powershell

    In this article I would like to explain another method to take the backup of OLAP databases via PowerShell. It will help out to take the backup of multiple OLAP databases with a specified retention period. In Tsql, XMLA function is applied however it is a bit puzzling to initiate the similar process for more than…

  • Proactive Monitor of System Database Files

    Proactive Monitor of System Database Files

    Dear Readers, Today I am writing about a very common problem of Outages that are caused by system database data/log files growth. Problem: generally, we face this issue when system database file is filled up and it can impact to Business an unexpected downtime. This applies to those environments where monitoring/alerting mechanism is not configured properly or not…

  • March towards SQL Server : Day 8 – SQL DBA Interview Questions Answers – All about SQL Server Tools and Executables

    March towards SQL Server : Day 8 – SQL DBA Interview Questions Answers – All about SQL Server Tools and Executables

    This blog is all about the SQL Server related tools and executables which are used by all level of DBAs for various tasks. 1) What is SSMS? SSMS stands for SQL Server Management Studio. SQL Server Management Studio (SSMS) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server.…

  • SQL DBA Cheatcode Part 3 : Few Important Queries for any DBA

    SQL DBA Cheatcode Part 3 : Few Important Queries for any DBA

    In continuation of our DBA Cheatcode series :-   I started this series on Queries\T-SQL commands that we use in our day to day operations or those queries which should be handy for any SQL DBA(Junior or senior) out there. In this series, I’ll try to share as many queries as I have or I…