Episode 79 SSIS Catalog
Although the SSIS Catalog DB is created with management studio, it does not behave like other databases. Our conversation in this episode revolves around the catalog, SSIS packages, and some of the c...
18 Jan 201749min
Episode 78: Conversion to 2016
As database administrators, we will all upgrade our environments at some point; however, we don't normally have the opportunity to upgrade to the next version of SQL Server before it becomes available...
11 Jan 201736min
Episode 77: New Reporting Options
We invited Paul Turley on the show to chat with us about some of the new features in SQL Server reporting services, but were pleasantly surprised to have the conversation take a different direction. ...
4 Jan 201745min
Episode 76: Availability Group Improvements
Availability groups provide some exciting features in mixing high availability and disaster recovery; however, from a performance consideration, there are a few drawbacks. With the advances in SQL Se...
31 Dec 201652min
Episode 75 Storage Testing
Storage testing and validation is something what we to add under roles and responsibilities as DBAs. Every database we ever manage is going to need one, but how often do we kick the tires? Many times ...
21 Dec 201649min
Episode 74: 2016 Year in Review
As the year 2016 comes to a close, Steve and I share our thoughts on our accomplishments for the year and what lies in store for 2017.
14 Dec 201629min
Episode 73: Performance Tuning
At some point all data administrators will have to tune their environments and there are may ways you might go about that. In this episode, we talk with Pinal Dave about how he does performance tunin...
8 Dec 201647min
Episode 72: Test Automation in BI
In the data space we're hearing a lot about dev ops, continuous integration and the programmers are getting a lot of love there with lots of tools to help them; however, if you're on the data side--no...
30 Nov 201645min
