Author: Hemantgiri Goswami

Unexpected shutdown caused by ASR

In past few days I had two incidents and an outage, for just a few minutes. However, outage in a production environment is related to cost relatively and strictly. The server that had outage was because of failing over and…

Read More >

Script to Collect Database Information Quickly

As a DBA there are occasions where we are required to collect details from a database which can be used for further analysis. For example, getting the status of the database (i.e. File Size, Free Space, Status of the database,…

Read More >

SSAS– Resolving Target Machine Actively Refused

I’ve always wanted to get my hands on SSAS, SSIS and SSRS as I’ve often felt shorthanded in these areas. Yesterday I decided to play around with one of these and get my hands dirty – SSAS. A few months…

Read More >

SQL Server Risk Assessment – The PMP Way

Recently I had a chance to speak with my friend and colleague, Ashish Sharma. We were discussing Project Management topics (he recently passed PMP and ACP). Our discussion ended on a very interesting topic – RISK Assessment. Definition: According to…

Read More >

MSDB – Cleanup is necessary

Recently I have been asked to work on the task which is to reduce the size of a MSDB database. The MSDB has grown to 20 Gigs. Well, you would say, what is the big deal with that? 20 Gigs…

Read More >

Not so good news for MCM Aspirants

A few days back, late Friday (30th August 2013) MS has made an announcement – that they are cancelling the MCM Certification, not so good news for MCM aspirants. This announcement has upset many in the SQL Community including myself….

Read More >

How to Secure Microsoft SQL Server

Security! This is a top-of-mind word for every concerned person when it comes to storing,  accessing, and sharing data, databases, or database servers. When applications are running in a restricted area, they are less likely to be exploited. However, with the increasing popularity of the…

Read More >

How to Collect Cluster Information Using TSQL

Sometime back, I was involved in a project that consisted in collecting information for the servers we are supporting – creating an inventory of servers. Logging into each server and collecting information is a bit tedious when you have hundreds…

Read More >

Troubleshooting Oracle Link Server Issue

If you remember, I posted some tips about troubleshooting Link Server issue for Oracle earlier. Today I will be posting one more tip to the list aka extending Troubleshooting Oracle Link Server.

Read More >

How to Move Master Database to a New Location in SQL Cluster

Recently, we had a situation where a customer asked us to move Master Database from Local Drive to SAN drive. I have outlined the steps for the task.

Read More >
Page 2 of 3123