I’m fortunate to be able to work with some rather large SQL Server instances on a daily basis, including databases over 25TB in size. Due to their bulk, “VLDBs” (Very Large Databases) present some challenges for DBAs: following best practices for small transactional systems might not be feasible on a VLDB. Regular maintenance processes such [...]

At work, a key function of my team is importing new systems into our data warehouse, most of which come from vendors. To do this we utilize many different methods depending on the capabilities of the source system and desired timeliness of the data. ETL through SSIS, snapshot replication, and transactional replication are among the [...]

Back at the first Chicago Free-Con event in 2011, Brent Ozar was talking about how wonderful the SQL Saturday movement is and prophesized that in the near future we’ll be seeing similar free training events put on by individual vendors instead of community volunteers. Eighteen months later I found myself at Red Gate’s SQL in [...]