User Posts: Amit Kumar
SQL DBA Cheatcode : SQL Server properties

SQL DBA Cheatcode : SQL Server properties

In this article I am trying to outline about some important server properties which can help you out at the time of auditing and trace history of SQL Server. It has been checked ...

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
PowerShell : Copy a table from one server to another

PowerShell : Copy a table from one server to another

In general, a DBA like us gets requests to copy a table data from one SQL Server instance to another. In that case, a DBA first sees the amount of data present in the table and ...

READ MORE +
0
How to check SQL Server connection without SSMS?

How to check SQL Server connection without SSMS?

There are times when you need to verify SQL Server Connectivity from a machine there is no SQL Server Management Studio or any tool available. Not to worry, there are many ways to ...

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
Browsing All Comments By: Amit Kumar