The expansion of data sets and increased expectations of businesses for analysis and modeling of data has led developers to create a number of database products to meet those needs. As data professionals, it is incumbent upon us to understand how these tools work and put them to their best use--before somebody else puts them to sub-optimal use.  I am joined by Kevin Feasel who walks us through some of the technologies available and sorts out under what circumstances we want to consider using each one.

Have you ever looked at some tsql code and thought--How does even run? I know I have and it can be daunting to take a piece of code and review it for performance or to make a change to it. I enlist the help of Jen McCown from the MidnightDBA team to discuss approaches to unraveling code. We tackle the issues of nested views, documentation, formatting, Hungarian Notation, and visualizing how all the code pieces fit together.

At the end of the day, we just want our code to be understandable and usable for the next person who has to review it, because that next person just might be you. :)

Get the show notes for today's episode at http://sqldatapartners.com/2016/05/31/unraveling-code/ and I'll see you on the SQL trail!

Have you ever looked at some tsql code and thought--How does even run? I know I have and it can be daunting to take a piece of code and review it for performance or to make a change to it.  I enlist the help of Jen McCown from the MidnightDBA team to discuss approaches to unraveling code.  We tackle the issues of nested views, documentation, formatting, Hungarian Notation, and visualizing how all the code pieces fit together.

At the end of the day, we just want our code to be understandable and usable for the next person who has to review it, because that next person just might be you.  :)

Get the show notes for today's episode at  http://sqldatapartners.com/2016/05/31/unraveling-code/ and I'll see you on the SQL trail!

Episode 44 takes us into a new service in the Microsoft cloud--Azure SQL Data Warehouse. While still in preview, the Azure SQL Data Warehouse looks to help level the playing field for organizations that want to analyze their data without the expense of creating a data warehouse. Sound a bit counter intuitive? Check out this episode to find what the service is all about and what the future of data processing might look like.

Show notes for today's episode are at http://sqldatapartners.com/2016/05/17/azuresqldatawarehouse/. Have fun on the SQL trail, compañeros!

Episode 44 takes us into a new service in the Microsoft cloud--Azure SQL Data Warehouse.  While still in preview, the Azure SQL Data Warehouse looks to help level the playing field for organizations that want to analyze their data without the expense of creating a data warehouse.  Sound a bit counter intuitive?  Check out this episode to find what the service is all about and what the future of data processing might look like.

Show notes for today's episode are at http://sqldatapartners.com/2016/05/17/azuresqldatawarehouse/.  Have fun on the SQL trail, compañeros!

Why is ETL so hard? All we want to do is move data from system A to system B. Perhaps that is the problem, says my guest Rafael Salas, and more time should be given to thinking about the architecture of the system. With our thoughts turned to SSIS, we discuss this idea in today's episode.

The show notes for today's episode can be found at http://sqldatapartners.com/2016/05/10/etl/ and I'll see you on the SQL trail!

Why is ETL so hard?  All we want to do is move data from system A to system B.  Perhaps that is the problem, says my guest Rafael Salas, and more time should be given to thinking about the architecture of the system.  With our thoughts turned to SSIS, we discuss this idea in today's episode. 

The show notes for today's episode can be found at http://sqldatapartners.com/2016/05/10/etl/ and I'll see you on the SQL trail!

How did that get changed--do you ever get that question? In this episode I talk with Brad McKuhen about how you would answer that and how you might need more than just enabling the auditing feature in SQL Server. If you are willing to be a bit proactive and do some testing, you might be able to give an answer to that question instead of the same old shoulder shrug.

Check out the shownotes for today's episode at http://sqldatapartners.com/2016/05/03/auditing/. See you on the SQL trail!