Why should I care about this episode? I know many of you are going to ask that question. Artificial Intelligence is getting lots of buzz and in this episode we invite Hope Foley from Microsoft to discuss why and how AI is relevant to those in the data platform community. We get a little help from Kevin Feasel as we try to connect the dots between all the hype and how this can and will affect you in the future. Did we do a good job? Let us know and contribute to the conversation.
The show notes for today's episode can be found at http://sqldatapartners.com/2019/03/27/episode-165-artificial-intelligence. Have fun on the SQL Trail!
DAX is the acronym for Data Analysis Expressions, and it is the formula language used throughout Power BI. In this episode we talk about DAX concepts and how they are simple and straightforward, but can be confusing for those coming from a relational database background. DAX uses some unique programming concepts and patterns which can make it difficult to fully use and understand. We talk about some experiences getting started with this language and ideas on how you can get started.
The show notes for today's episode can be found at http://sqldatapartners.com/2019/03/20/episode-164-the-dax-episode. Have fun on the SQL Trail!
Are you experiencing challenges managing Very Large Databases (VLDBs), or anticipate challenges with future growth? In this episode, we are joined by Aaron Hayes to discuss the practical advice on managing very large databases in SQL Server, focusing on common problem areas we have found, along with our own experiences. Topics include storage layout decisions, unique tuning challenges, HA/DR implications, and database restores, along with the challenges of getting backups, re-indexing and DBCC checks into your maintenance windows. No comparisons here -- we are sure you will enjoy the discussion regardless of your database size.
The show notes for today's episode can be found at http://sqldatapartners.com/2019/03/12/episode-163-very-large-databases. Have fun on the SQL Trail!