Episode 142: Do You Have a HEAP of Hurting?
Are you giving yourself a HEAP of trouble by using tables with no clustered indexes? But it is faster you say . . . because you don't have to worry about the sorting when inserting. Our guest Rick Lowe suggests everything is fast until you decide to SELECT, UPDATE, or DELETE. We talk about why you may or may not want to use HEAP tables. I know I was surprised to get his take on the use of HEAP tables and I think you will be, too. Do you agree with our assessment? Let us know in the comments on the show notes page. The show notes for today's episode can be found at http://sqldatapartners.com/2018/07/25/episode-142-do-you-have-a-heap-of-hurting. Have fun on the SQL Trail!
26 Jul 201832min
Episode 141: Wait, Wait, What?
In this episode, we chat with David Maxwell about wait stats, what they are and why we should care about them. There are so many different directions we can go and if you have a specific use case you’d like us to consider, let us know and we can include it in a future episode. The show notes for today's episode can be found at http://sqldatapartners.com/2018/07/04/episode-141-wait-wait-what. Have fun on the SQL Trail!
4 Jul 201841min
Episode 140: Why data types matter
They're just numbers, right? A date's a date. It's just string data, who cares? I admit I have posed those questions before and only much later did I understand how complicated it can get. Angela Henry, our guest for today, has heard these same phrases many times before and she chats with us to enlighten us on the issue and ways we can get around it. Perhaps you have heard about terms like SARGable and implicit conversions. This episode seeks to tie these terms to one of the very first decisions you have to make about your data -- the data types. The show notes for today's episode can be found at http://sqldatapartners.com/2018/06/20/episode-140-why-data-types-matter. Have fun on the SQL Trail!
20 Jun 201850min
Episode 139: Getting Started with SQL Server in Azure
"The move to the cloud is inevitable." Listening to Microsoft marketing and all the MVPs out there, it can certainly seem like we are getting further and further behind each day we aren't use cloud services. Sure, lift and shift of VM resources are straightforward at this point and they are happening with more frequency; however, this doesn't mean everyone is leveraging cloud services. How do you go about trying to prepare for the future when the company you work for isn't quite ready to make the leap? In this episode, we talk with Jim Donahoe about making the transition from our traditional SQL Server environments to using Azure SQL Database. We discuss some of the basics and some of the challenges you will face as you make the migration. It can be a bit overwhelming to think about all the other services available in Azure. Lift and shift gets us to the 'cloud', but if we want to start doing the cool stuff, we will have to make our data available to start interfacing with these services. We know that cloud providers are pushing more hybrid models as not every system is ready for the cloud. New development initiatives make better candidates for the cloud services and this episode covers the first steps to help you on path to cloud services. The show notes for today's episode can be found at http://sqldatapartners.com/2018/06/13/episode-139-getting-started-with-sql-server-in-azure. Have fun on the SQL Trail!
13 Jun 201848min
Episode 138: Meeting of the Minds
I invited our fearless panelists Kevin Feasel and Eugene Meidinger to join me for a podcast discussion. We couldn't agree on a topic so we'll just call this episode Meeting of the Minds. You're welcome. The show notes for today's episode can be found at http://sqldatapartners.com/2018/06/06/episode-138-meeting-of-the-minds. Have fun on the SQL Trail!
6 Jun 201838min
Episode 137: You want to work with Analytics?
What’s in a name? That which we call a rose, by Any Other Name would smell as sweet. We could say the same for analytics -- there are plenty of similar or related words we use to describe the role or process of working with data. In this episode, we talk with Nicki Tinson about her journey into analytics, how others, like you, might break into the fields, and what has remained the same even when the names change. I am joined by Kevin Feasel and Eugene Meidinger, so you know we keep the conversation lively. Be sure to check out Nicki's Facebook page if you are interested in making the transition into analytics. Tell her Carlos sent you. The show notes for today's episode can be found at http://sqldatapartners.com/2018/05/30/episode-137-you-want-to-work-with-analytics. Have fun on the SQL Trail!
31 Mai 201858min
Episode 136: Devops with Visual Studio
Everybody does things a little differently and this is one of the things I LOVE about the podcast--chatting with others about how they get work done. In this episode I chat with Tom Norman about how he uses Visual Studio for source control, deployments, and keeping his sanity. We explore the setup process and how we have a reverse 80/20 rule when it comes to importing databases with Visual Studio. The show notes for today's episode can be found at http://sqldatapartners.com/2018/05/23/episode-136-devops-with-visual-studio. Have fun on the SQL Trail!
23 Mai 201848min
Episode 135: Seinfeld Episode
Normally we have one specific topic we focus on each episode. This episode is a little different. The show notes for today's episode can be found at http://sqldatapartners.com/2018/05/16/episode-135-seinfeld-episode/. Have fun on the SQL Trail!
16 Mai 201819min
