Hi Friends, I have finally decided to go with another batch for SQL Server Database Administration from May 2018. This would be 4-month course for 5 days per
Being a DBA, I know the pain of a long running job creating performance issues for other jobs and user sessions. For my current organization, I have created
It is not easy to find out right backups for restore activity when people are watching you during database crash situation. So I have created below TSQL script
Recently I was working on a SQL query in my inventory database, and was greeted with below error message:- Cannot resolve the collation conflict between “Latin1_General_CI_AS” and “SQL_Latin1_General_CP1_CI_AS”
Restoring multiple databases can be painful especially when each of them have multiple database file(s). Four years back, I wrote TSQL script that would accept database backup path,
When it comes to Disaster Recovery Setup, every DBA has its own preference. I personally prefer Log Shipping since it involves very little effort to setup. Log shipping
I often see DBAs/developer struggling to find what’s wrong with query. The first step in troubleshooting queries is finding out information like batch text, query text, batch execution