If you have ever been responsible for a replication environment, you know what a pain that can be. Many of the guests of the show will point out their frustration with replication and many are loathe to use it--myself included; however, there are a few brave souls out in the world who do use replication regularly--and even use it well. Chuck Lathrope is our guest today and he talks us through some of the components of replication and why we might not need to be so skittish about this long time feature.
We cover all the basics including an overview of Transactional Replication, Merge Replication, Peer-to-Peer replication and Snapshot Replication, the concept of publisher, distributor and subscriber in relation to replication. The most important piece is Chuck gives us some good business cases for why we might use replication and I think you will find the discussion interesting. Thanks for joining us on the SQL trail!
The shownotes for today’s episode is found at http://sqldatapartners.com/2017/05/24/episode-97-sql-server-replication/ and have fun on the SQL trail.
Have you ever created something and wanted to share it with others with the hope they will contribute and make it better? Sites like the new defunct codeplex and GitHub are full of functionality people want to share and work with others on; however, many projects remain dormant. What are the characteristics that create an environment where people want to contribute to your project? Steve and I discuss a few ideas and we interview two very successful community project leaders in Brent Ozar and Chrissy LeMarie about how they got started and what it takes to put together a good community project.
The shownotes for today’s episode is found at http://sqldatapartners.com/2017/05/10/community-tools/ and have fun on the SQL trail.
Big data is term we have been hearing frequently as of late and this might cause some concern for us in the SQL Server space. Micrsoft has introduced some new functionality to help connect different data stores with PolyBase. We are happy to have Kevin Feasel from ChannelAdvisor back with us and Kevin will discuss some of the basics around what PolyBase does. We’ll be discussing a lot about integrations using PolyBase specifically on Hadoop and Azure SQL Blob Storage. We also touch on some of the technologies that will be supported in the future.
For those looking at implementing both structured and unstructured data stores, PolyBase will be a way to help bring these environments together. Kevin gives us a great overview and we think you will enjoy this episode.
The shownotes for today’s episode is found at http://sqldatapartners.com/2017/05/03/episode-95-polybase/ and have fun on the SQL trail.
There are lots of reporting options and I watch SQL Server move up the Gartner magic quantrant, I saw another reporting tool moving up as well--Qlik. In this episode we will start by sharing information about Qlik, what it is and some background in the event it gets adopted at your company. Today we are delighted to have Michael Armentrout as our guest. Michael is a Microsoft SQL Server DBA as well as the developer of QlikView and we discuss the fundamentals of QlikView such as the associative model, in-memory, compression and sharing among others. Also we will hear from Michael the difference between QlikView and QlikSense, and some of the “competitors”.
Michael share some of his thoughts on using the technology and how it is different from the traditional Microsoft stack. We think you will find it interesting.
The shownotes for today’s episode is found at http://sqldatapartners.com/2017/04/27/qlik/ and have fun on the SQL trail.
We all make them and sometimes it can be painful. Making and sharing mistakes is one of the most powerful tools for learning; However, most of us do all they can to avoid and hide those mistakes. In this episode, Steve and I talk about making mistakes and share some thoughts around how we might improve how to respond when we don't do something quite right.
The shownotes for today’s episode is found at http://sqldatapartners.com/2017/04/25/episode-93-making-mistakes/ and have fun on the SQL trail.
At one time there were two different products named SSDT and that was confusing for lots of folks. and we’re pleased to have Kevin Cunnane, the program manager for SSDT, as our guest. We wanted to ask him about some of the new database features in Visual Studio and what kind of problems they are looking to solve.
We think it is awesome the Microsoft folks will take some time our there their schedules to talk with us and we think you will this episode an interesting discussion on the future of database tooling.
The shownotes for today’s episode is found at http://sqldatapartners.com/2017/04/18/episode-92-ssdt/ and have fun on the SQL trail.
We all want an easy button. It is human nature. We heard quite a bit about how easy PowerShell will make everything, but for those of us who aren't programmers, it can be a bit intimidating to get started. Luckily for us, we have what is shaping up to be the closest thing to an easy button for DBAs I have found for PowerShell tools from the folks at dbatools.io. We invite some of the team to chat with us about their tool, how they got started and the types of problems they are looking to solve.
In this episode, Chrissy will be talking about how DBA Tools started from just being a simple migration tool until it became a useful tool solving various SQL related issues. The team will discuss the other various situations where DBA Tools can really be helpful and how they manage contributions from over 30 people which leads us to talk about GitHub, the open source community, and their experiences in updating versions of DBA Tools and how they encourage contributors in the project.
Chrissy, Rob, Constantine, and Aaron were super excited to talk with us and we loved their energy and think you will enjoy this episode.
The shownotes for today’s episode is found at http://sqldatapartners.com/2017/04/12/episode-91-dba-tools/ and have fun on the SQL trail.
DBCC CheckDB. It is a simple command, but one that can cause database contention, dba stress, confusing results, dba elation, and everything in between. At one time we will all have to face the results of having a corruption issue and we’re delighted to have Sean McCown with us again to discuss the ins and outs of the issues of this command. If you can remember, Sean was our guest in Episode 41. He is an SQL Server MVP with more than 15 years experience.
We talk with Sean about how frequent issues we have with maintenance like we often we should run CheckDB on our databases or what happens when I can only check one database during my window. While we don't end up discussing the command as much, we definitely review all aspects of making sure it can run in ALL environments.
The shownotes for today’s episode is found at http://sqldatapartners.com/2017/04/05/dbcc-checkdb/ and have fun on the SQL trail.
One of the neat benefits of putting the podcast together is talking to a wide spectrum of folks with varied backgrounds. As we get more feedback from listeners, the idea of the Lone DBA emerged. The Lone DBA is someone who is the only person responsible for database administration at their company. These tasks may have been assigned or they may have simply been required to help support an application. Steve and I thought we should explore this a bit and to help give us some context, we invited Monica Rathbun to chat with us about some of the challenges she’s faced.
Besides the challenges, Monica shares tactics and techniques to juggle many tasks while being a lone DBA. This includes using social media as a way of building connections with different experts, getting the right tools for the organization’s needs and making your boss your supporter. Have your own perspective on this? Let us know in the show notes for the episode.
The shownotes for today’s episode is found at http://sqldatapartners.com/2017/03/28/episode-89-lone-dba/ and have fun on the SQL trail.
Why can't we just get along? There can be a real love/hate relationship between those of us with data responsibilities and those who are responsible for SharePoint environments. We want to provide good service to those environments, but there are SO MANY things we can't do on a SharePoint database. To see how the other half lives, we invited Todd Klindt onto the program to give us his thoughts on how we can all get along a bit better.
Because Todd suggests the “SQL and SharePoint communities should understand each other a little better”, we will try to tackle some of the obstacles the teams face so you can be better armed to support your SharePoint team.
The shownotes for today’s episode is found at http://sqldatapartners.com/2017/02/08/episode-88-sharepoint/ and have fun on the SQL trail.
Why do some features get all the fun? I would like to be a fly on the wall at some of the Microsoft feature development meetings. There are many very cool features that didn't get quite enough love to get the adoption they deserve. In this episode we are talking about Resource Governor and before you roll your eyes, you may be interested to know some of the side benefits of using the feature. We are joined by Mark Wilkinson from channeladvisor to give us an overview of the feature and how they use it to manage SQL resources and workloads.
One interesting story is how their team won the query challenge last PASS summit using Resource Governor so it is pretty powerful. Mark will also share his experiences using Resource Governor in different working environments. He will also be discussing the basics and tips about building the classifier function of Resource Governor. Furthermore, we will go through setting up I/O caps, resource pools and workloads, and the NUMA node affinity.
The shownotes for today’s episode is found at http://sqldatapartners.com/2017/02/08/episode-87-resource-governor/ and have fun on the SQL trail.
Based on listener feedback we got from episode 72, a request was made to have a conversation about testing frameworks and in this episode we are going to focus on tSQLt. We are pleased to have Sebastian Meine, the creator of the tSQLt unit testing framework, on the podcast with us. We talk about the basic principles of tSQLt Framework when it comes to unit testing. Sebastian will also be discussing about the do’s and don’ts as well as the different aspects to be considered when using the framework. Sebastian makes the case for why you should take the time to create unit tests and we discuss the challenges culture might play into the use of the framework.
The shownotes for today’s episode is found at http://sqldatapartners.com/2017/03/03/episode-86-tsqlt/ and have fun on the SQL trail.
Have you done your migration to SQL Server 2016 yet? Don’t worry—you aren’t alone. With all the glory of new features and improved performance, not all upgrades are equal. In this episode we talk with Javier Villegas who returns from episode 2 to talk about some of the issues he ran into on the upgrade to 2016. He stumbled on a process that normally runs for 7 minutes prior to the upgrade and then 26 hours after the upgrade. While it all worked out, he shares the issues he had and gives us a reminder that testing has not been deprecated.
The shownotes for today’s episode is found at http://sqldatapartners.com/2017/01/25/speedbumps/ and have fun on the SQL trail.
The Microsoft Most Valued Professional or MVP award--while it’s hard work and dedication to be called an MVP, what are the benefits? Well, Kathi Kellenberger is a great member of the SQL community, traveling to many SQL Saturdays, speaking at conferences about SQL server, and this time she is here with us to tell us what it really means to be an MVP and the great journey it has been to becoming one.
Do you actually know the percentage between men and women MVPs in the world and US? How many posts do MVPs have on forums, helping others? How do they keep track of all the SQL Saturdays, User Groups, conferences they have been to? Kathi will be sharing her story, the process that she went through until she became an MVP, how you get nominated, and how to get renewed!
The shownotes for today’s episode is found at http://sqldatapartners.com/2017/02/22/episode-84-mvp/ and have fun on the SQL trail.
We’ve all been there – you have some data and you need to make it pretty for the report. With the all the new reporting options you have probably been tempted to find a new way to visually present information. In this episode of the podcast, we are talking about data visualizations and our guest, Jonathan Stewart, has some issues with the way we currently go about it. Jonathan has been on the show as a panelist and I have really enjoyed his perspective on things so we invited him on the program to discuss some ways you can go about improving the data visualization of your reports, without adding additional burden on process.
Psychology plays a big role in data visualization. To make a good report, before even starting your tool, you should be able to summarize what the report presents. One of the major aspects of psychology is color and how we perceive it. Jonathan explains how we can use this while visualizing data. We discuss color blindness and I haven't heard this discussed too much elsewhere and I was curious to know how we can solve this problem with an easy button.
The shownotes for today’s episode is found at http://sqldatapartners.com/2017/02/15/episode-83-data-visualizations/ and have fun on the SQL trail.
In the previous episode we discussed the basics of using indexes, what they are, how to use them, along with some common problems and solutions. One of the problems you will certainly face as time passes is index fragmentation. While indexes will certainly help your database perform well, they do require care and feeding--meaning there is some administrative overhead.
In this episode, we continue our conversation with Randolph West and discuss what we can do to take care of indexes and keep them well maintained over time. There is an option to use default maintenance plans and to do fragmentation and updating statistics, but should you use them? What are the alternatives? We didn’t forget to consider strategies for deciding which indexes to keep and which can be dropped.
The shownotes for today’s episode is found at http://sqldatapartners.com/2017/02/08/episode-82-indexes-part-2/ and have fun on the SQL trail.
Part of what we like to do on podcast is to present topics and discuss different ways you might use features. In this episode, we go back to basics and discuss indexes. Like most topics, we made sure to explain all the important aspects. Because this is a such broad topic, we decided to carry this over into our next episode as well. Using the phone book as an example, we chat with our guest Randolph West and explain heaps, non-clustered indexes, and clustered indexes. We also explain best practices to use them when creating new tables.
We didn’t forget to cover the problems you might run into. For example, you might not think about indexes until your data grows very large. Sure, you can attempt to resolve the problem by moving to SSD’s and increasing memory, but this will push the issue further in the future. In this episode, we will discuss considerations for indexes and why database architecture is so important.
We would like to hear your opinions. What are your strategies when using indexes? Use the hashtag #sqlpodcast and let us know!
The shownotes for today’s episode is found at http://sqldatapartners.com/2017/02/01/episode-81/ and have fun on the SQL trail.
When was the last time you deployed code and then found an issue with the version of a stored procedure, a setting, or even a service pack? While we data folk don't generally have as much trouble with environment issues are our developer counterparts, it can still be a big deal. Spinning up a VM may not be such a big deal anymore; however, most of us still have to request one and wait. What if you could take care of the OS and the SQL Server and not worry about setting up another development environment? Our guest today is Andrew Pruski and he talks to us about how he is using containers to support his environments and the flexibility it provides to his and his co-workers.
While the Linux containers seem to get lots of love, one unique thing about Andrew's setup is he is running Windows containers with older versions of SQL Server. What is cool to me is there are tools out there that can help us folks running windows get up and running without having to wait on our infrastructure to upgrade to Windows server 2016. If you are using containers, I would love to hear about it. Use the hastag #sqlpodcast and let us know!
The shownotes for today’s episode is found at http://sqldatapartners.com/2017/01/24/sql-server-containers/ and have fun on the SQL trail.
Although the SSIS Catalog DB is created with management studio, it does not behave like other databases. Our conversation in this episode revolves around the catalog, SSIS packages, and some of the complexities of migrating packages. Steve and I are excited to chat with our guest Andy Leonard about his thoughts on the catalog and how this feature provides some really interesting benefits for ETL architecture.
The shownotes for today’s episode is found at http://sqldatapartners.com/2017/01/17/episode-79-ssis-catalog/ and have fun on the SQL trail.
As database administrators, we will all upgrade our environments at some point; however, we don't normally have the opportunity to upgrade to the next version of SQL Server before it becomes available to everyone else. In this weeks episode of the podcast, Steve and I chat with Brian Carrig about the journey channeladvisor took to implement SQL Server 2016 in their environment, that it was like working with the SQLCAT team, and how they go about making use of some of the new features. Brian shares with us some of the struggles they were having along with how the 2016 version helped address these issues.
Brian invites everyone to upvote his connect item which you can find on the shownotes
The show notes are available at http://sqldatapartners.com/2017/01/11/conversionto2016/ and have fun on the SQL trail!
We invited Paul Turley on the show to chat with us about some of the new features in SQL Server reporting services, but were pleasantly surprised to have the conversation take a different direction. Paul talks about some of the new training available for those interested in visualizations and why this community can be hard to define--and connect with. There are so many visualization options and even within Microsoft we have many products that overlap in functionality. In addition to talking about the pick list items of new features, Paul gives some guidance and why you should choose certain products and what makes good use case scenarios for some of the new features.
With the new analytics features now available in SQL Server 2016 via SP1, I think there is going to be additional requirements for data professionals to provide better analytics features and this episode is a good starter for how to frame those conversations.
Show notes for today's episode can be found at http://sqldatapartners.com/2017/01/03/reporting-improvements/ and have fun on the SQL trail!