Category Archives: Uncategorized

Demystifying AWS/EC2 Access Credentials

As of now, I have begun my pursuit of a career in the cloud technology or to the least be in the right frame of mind to cover database hosted in the cloud. For this purpose, I specifically chose to study … Continue reading

Posted in AWS, Uncategorized | Tagged , , , | Leave a comment

SQL Server 2016 : A New Beginning

A look into the all new version of a database management solution from Microsoft Continue reading

Posted in ms sql, Uncategorized | Tagged , , , , | Leave a comment

Wait Statistics……What to worry for?

Answering the message “Hi, yeah, the server is slow. Thanks. Bye.” Continue reading

Posted in ms sql, Performance Tuning, Troubleshooting, Uncategorized | Tagged , , , , , , , , | 1 Comment

Q&A Backup_001

Common questions regarding SQL Server backups Continue reading

Posted in backup, ms sql, Performance Tuning, Uncategorized | Tagged , , , , , , | Leave a comment

Transaction Tracking Continued

Second part in two part series blog regarding transaction tracking through logs and point in time restore Continue reading

Posted in Best Practices, ms sql, Troubleshooting, Uncategorized | Tagged , , , , , , , | Leave a comment

Finding a Transaction in the log for a particular user

As a DBA, this is a frequently asked question from the developers “When was a certain insert/update/delete performed on a specific table?” Or, It is simply required to know the time of the particular transaction so that it can be … Continue reading

Posted in ms sql, Troubleshooting, Uncategorized | Tagged , , , , , , , | Leave a comment

Recipe for Disaster

Happy New year to everyone. With a new year, here I start the year with a blog post talking about a common recipe for disaster waiting to happen with your SQL Servers. By default, SQL Server’s databases are installed on … Continue reading

Posted in Best Practices, ms sql, Performance Tuning, Troubleshooting, Uncategorized | Tagged , , , , , , , , , | Leave a comment