This project demonstrates a real-world database support scenario where a reporting SQL query was performing inefficiently due to missing indexes and non-optimized SQL joins. The objective of this ...

CPU issues have long been the bane of database and system administrators. I have worked on enterprise databases since the mid-1980s and seen three significant eras for CPU architecture and ...

I have a SQL server that only recently started failing with timeout exceptions. It is an older box and we are using it for more and more things. Before I write it off as a hardware/perf issue, I ...

The latest version of SQL Monitor, the popular SQL Server monitoring tool from Redgate, now lets users analyse SQL Server problems faster and easier – and gives them the ability to view query ...

Me again. By know you guys probably figured out my strength isn't in hardware <BR><BR>Anyway.....<BR><BR>I came in Monday morning to find that our SQL server running SQL 2000 was hung. I have a ...

This project is a deep dive into SQL, showcasing my ability to craft complex queries to extract and analyze data from large databases. The analysis includes a series of tasks involving product and ...