This week I am going to tell you a story. A story of a friend of mine who always come…
Administration
I have often seen many people get confused about High Availability[HA] and Disaster Recovery [DR]. HA and DR both serve…
Recently one of our customers has some space issue on one of the production server. This server hosts production CRM…
Last week I have seen an interesting behaviour, and this has happened to two of our client. The lsass.exe causes…
I have been a DBA for years now, and I have been using SQL Server Management Studio aka SSMS and believe…
Today I am going to talk about an issue that gives me an idea of writing a post about trace…
This week, today, the post will cover an interesting script. I believe there is already a method that gives us…
This morning, a friend of mine called me. He runs a development company and developing .Net based applications. He told me…
Last weekend, I had another issue reported by the client which was a really quick solution however it needed a service…
I was fine Sunday, I was tired enough and feeling asleep, my eyes were burning and I was feeling hard…
I am pretty sure that you all take care of the backups of all your databases in your production environment….
In recent past, one of the reader emailed and asked me a question – How to Improve Service Broker performance? Let…
Last week when I was working on weekend for a customer I have experienced an odd behavior. I was working on…
This weekend while I was holding a pager, I got an interesting pager – SQL Server won’t start after a…
With SQL Server 2014 Microsoft has introduced Memory Optimized table which is also known as In-Memory OLTP. As it is…
I have seen questions – How to patch Always On Availability group or sometimes, what are the steps to patch…
As you all are aware that most of the integrity checks are scheduled to run during the weekend and our…
I was talking to a friend few days back about upgrading an SQL Server to new version, we discussed about…