I am driving thru America’s Renaissance City, Providence Rhode Island, to present to the RI SQL Server User Group on June 7, 2017. Check out the meetup for more details.
I always love the home team advantage by knowing the audience very well. It makes for a relaxing environment to teach and attendees to learn.
Here is the gritty details of the 30 minute presentation that I will be covering that night.
Topic:
Efficient File Management For Performance
Abstract:
Many accidental database administrators do not know that optimizing file performance leads to a faster database. Tonight’s talk goes over four common techniques that should be applied to every database server.
Coverage:
1 – Optimizing the temporary database.
2 – Fast file initialization.
3 – Virtual log file fragmentation.
4 – Using multiple data files for speed.