Katy Park

SQL Server and Oracle DBA for 15 years. Team lead for SQL Server.

Author Archive

Master Data Management

If you’re like me, you’ve been hearing a lot about Master Data Management lately.  Master Data Management is not an entirely new theory; it goes back to the Master File idea from the days of the mainframe.  The basic concept is to have a single ‘correct’ set of data that the entire company will use. [...]

Read the rest of this entry »

Finding Tuning Improvement Opportunities: The Trace or the DMVs?

For any SQL Server DBA who has been in the game longer than the advent of SQL Server 2005, there was one standard place to turn when you wanted to tune your database.  You would turn to the profiler!  If you had some experience with this, and had been burned by getting too small of [...]

Read the rest of this entry »