Tag Archives: sql server

SQL Server 2016 : A New Beginning

Posted on May 15, 2016 by sskarki

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

Wait Statistics……What to worry for?

Posted on March 1, 2016 by sskarki

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

Posted on February 22, 2016 by sskarki

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

Posted on February 15, 2016 by sskarki

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

Posted on February 6, 2016 by sskarki

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

Posted on February 1, 2016 by sskarki

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

Posted on January 11, 2016 by sskarki

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