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