Tag: cookbook

SQL Saturday #269 – Exeter 2014, first event in this year in UK: Let’s cook ‘best SQL Server DBA practices’

TweetHere is the first SQLSaturday event happening in UK on 22nd March 2014, having a pre-conference training sessions on 21st March 2014. On Saturday I’m going to talk about a topic: Let’s cook ‘best SQL Server DBA practices’ In this session…

SQL Server has encountered 1234 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file

TweetYou might have come across about this message within your DBA life, if its a recurring issue then do not ignore as it says informational message in the SQL Server error log. Since SQL Server 2008 version this is officially…

SQL Server Data platform upgrade Techniques, best practices & notes from the field – SQLSaturday #208 -Riyadh #SQLSatRiyadh

TweetA big week ahead indeed, speaking at SQL Saturday conference for the first time… and one more first time is ..in Riyadh, Saudi Arabia. SQLSaturday Riyadh – event will be held (for the first time in the Middle East) in…

SQL Server DBA trade: handy tools for monitoring and troubleshooting

TweetDo you know how many Monitoring Tools and Resources available in SQL Server? Well,neither its an interview question nor testing your knowledge on how you are managing your data platform. Monitoring Tools and Resources are essential for performance tuning &…

SQL Server Operability recipe – Handy list of PERFMON counters to capture IO stress testing results

Tweet  I treat Scalability and Performance like a two-side coin whenever the SQL Server operability consulting is involved. The Scalability and Performance is guaranteed when the reliable storage is configured at the hardware level. In general, the storage configuration and management…

SQL Server data platform upgrade – Why upgrade and how best you can reduce pre & post upgrade problems?

TweetSQL Server upgrade, let it be  database(s) or instance(s) or both the process and procedures must follow best practices in order to reduce any problems that may occur even after the platform is upgraded. The success of any project relies upon…