How important is database performance tuning? Well, the world essentially runs on data (the business-focused parts of it, anyway). To ensure data is easily and quickly accessible, databases need to be running efficiently and be available at all times…
Data is at the heart of every modern enterprise, so maintaining database performance and ensuring data is quickly and easily accessible for those who rely on it is a key responsibility for database professionals.
With the rapid adoption of cloud database migration, many database professionals have concerns and questions regarding their futures and career prospects in database management. We recently had the opportunity to sit down with two industry veterans– Brent…
If anyone had any doubts that a panel discussion where Brent Ozar and Pinal Dave would be answering attendees’ SQL Server performance questions would be a success, those were quickly dispelled during the blockbuster Ask the Experts session Quest hosted…
Why is SQL performance tuning so important to database management?
Because it can save you money big time. Bear with me and you’ll see how.
Most database professionals spend…
We’re all in the same global boat. In response to COVID-19, and to curtail the spread and keep employees and the general population well, companies worldwide have suddenly sent their employees home to work.
A Picture is worth a thousand words!
Execution plans can help us identify the performance hog sections of SQL code that impact CPU usage and I/O operations. Addressing these bottlenecks can ultimately help us achieve the best execution times. What if…
I’ll admit, the concept of the DBA workaholic used to be an oxymoron. Not too long ago, many of us worked strictly in “Oracle shops” where we had time to indulge our photography hobbies in between tasks. I don’t know about you, but I used to do a fair…
