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!
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!