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 ...

READ MORE +
0
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 ...

READ MORE +
0
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 ...

READ MORE +
0
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 ...

READ MORE +
0
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 ...

READ MORE +
0