-
Recent Posts
Archives
- December 2016 (1)
- May 2016 (1)
- March 2016 (1)
- February 2016 (4)
- January 2016 (2)
- December 2015 (3)
- November 2015 (4)
- October 2014 (1)
- March 2014 (2)
- February 2014 (7)
Tag Archives: sql server
SQL Server 2016 : A New Beginning
A look into the all new version of a database management solution from Microsoft Continue reading
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 database, DBA, ms sql, performance, performance tuning, Query, SQL, sql server, troubleshoot
1 Comment
Q&A Backup_001
Common questions regarding SQL Server backups Continue reading
Posted in backup, ms sql, Performance Tuning, Uncategorized
Tagged backup, database, DBA, ms sql, Query, SQL, sql server
Leave a comment
A Guide To SQL Server Maintenance Plans
General guidelines towards the best approach in creating a maintenance plan for your SQL Server Continue reading
Posted in backup, Best Practices, configuration, ms sql, Performance Tuning, Troubleshooting
Tagged backup, database, DBA, maintenance plan, ms sql, Ola Hallengren, performance, performance tuning, SQL, sql server
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 database, DBA, ms sql, Query, recovery, SQL, sql server, troubleshoot
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 database, DBA, ms sql, Query, recovery, SQL, sql server, troubleshoot
Leave a comment
SHRINK – The Evil Doctor
Every DBA faces the day to day challenge of making best use of the available resources. And on this note, it’s very obvious that storage is the one aspect that is quite tough to handle at times. Now there are … Continue reading
Posted in Best Practices, configuration, ms sql
Tagged auto-shrink, database, DBA, dbcc shrinkfile, ms sql, shrink, shrink database, SQL, sql server
Leave a comment