Episode 162: Power Query vs DAX

It is easy to feel like the odd man (or gal) out in the SQL Community.  We are constantly hearing about new features, products, and architectures and our companies may not always have the same enthusi...

23 Nov 201638min

In the keynote of PASS summit 2016 Rohan Kumar, the program manager for SQL Server proudly displayed a database restore to a SQL Server instance installed on Linux. What makes this all even more inte...

16 Nov 201645min

We have all been there–next, next, next–let's just get this install done. While there are many ways to get SQL Server installed on a server, the real impact is in the way we administer the database a...

9 Nov 201638min

For all of us working with data, we know that we work no only with SQL Server but the suite of tools around the SQL Server engine.  In this episode, we share some thoughts around SSIS administration, ...

2 Nov 201652min

Compañeros! The good organizers SQLSaturday in Pittsburgh allowed me to take a slot on the schedule and opened up the podcast for a little Q&A session and I was super happy with the results. We had s...

27 Okt 201646min

After talking with Patrick Thomas in episode 64, I was introduced to Microsoft's newest learning curriculum, the Microsoft academy, and their first offering in data science.  In this episode, I talk w...

19 Okt 201631min

This week on the SQL Trail, Steve and I chat with Jason Horner about building a good data architecture. When talking about a data warehouse architecture, or even just a data architecture, people often...

12 Okt 201637min

Have you ever thought that Microsoft certifications were a waste of time? Depending on where you are on the experience scale, certifications still play a large role in hiring and career development. ...

5 Okt 201634min