SQL Data Partners Podcast
Episodes
Episode 87 Resource Governor
15 Mar 2017
Contributed by Lukas
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 ver...
Episode 86 TsqlT
08 Mar 2017
Contributed by Lukas
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...
Episode 85 2016 Speedbumps
01 Mar 2017
Contributed by Lukas
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 ...
Episode 84 MVP
22 Feb 2017
Contributed by Lukas
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 ...
Podcast 83 Data Visualizations
15 Feb 2017
Contributed by Lukas
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 be...
Episode 82 Indexes Part 2
08 Feb 2017
Contributed by Lukas
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 o...
Episode 81 Indexes Part 1
01 Feb 2017
Contributed by Lukas
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 an...
Episode 80 Containers
25 Jan 2017
Contributed by Lukas
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...
Episode 79 SSIS Catalog
18 Jan 2017
Contributed by Lukas
Although the SSIS Catalog DB is created with management studio, it does not behave like other databases. Our conversation in this episode r...
Episode 78: Conversion to 2016
11 Jan 2017
Contributed by Lukas
As database administrators, we will all upgrade our environments at some point; however, we don't normally have the opportunity to upgrade to the nex...
Episode 77: New Reporting Options
04 Jan 2017
Contributed by Lukas
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 h...
Episode 76: Availability Group Improvements
31 Dec 2016
Contributed by Lukas
Availability groups provide some exciting features in mixing high availability and disaster recovery; however, from a performance consideration, there...
Episode 75 Storage Testing
21 Dec 2016
Contributed by Lukas
Storage testing and validation is something what we to add under roles and responsibilities as DBAs. Every database we ever manage is going to ne...
Episode 74: 2016 Year in Review
14 Dec 2016
Contributed by Lukas
As the year 2016 comes to a close, Steve and I share our thoughts on our accomplishments for the year and what lies in store for 2017.
Episode 73: Performance Tuning
08 Dec 2016
Contributed by Lukas
At some point all data administrators will have to tune their environments and there are may ways you might go about that. In this episode, we tal...
Episode 72: Test Automation in BI
30 Nov 2016
Contributed by Lukas
In the data space we're hearing a lot about dev ops, continuous integration and the programmers are getting a lot of love there with lots of tools to ...
Episode 71: BI Tools of the Trade
23 Nov 2016
Contributed by Lukas
It is easy to feel like the odd man (or gal) out in the SQL Community. We are constantly hearing about new features, products, and architectures and...
Episode 70 SQL Server on Linux
16 Nov 2016
Contributed by Lukas
In the keynote of PASS summit 2016 Rohan Kumar, the program manager for SQL Server proudly displayed a database restore to a SQL Server instance insta...
Episode 69: Our SQL Server Setup Checklist
09 Nov 2016
Contributed by Lukas
We have all been there–next, next, next–let's just get this install done. While there are many ways to get SQL Server installed on a server, the...
Episode 68: SSIS Administration
02 Nov 2016
Contributed by Lukas
For all of us working with data, we know that we work no only with SQL Server but the suite of tools around the SQL Server engine. In this episode, ...
Episode 67 Dear Developer
27 Oct 2016
Contributed by Lukas
Compañeros! The good organizers SQLSaturday in Pittsburgh allowed me to take a slot on the schedule and opened up the podcast for a little Q&A sessi...
Episode 66: Microsoft's Professional Program
19 Oct 2016
Contributed by Lukas
After talking with Patrick Thomas in episode 64, I was introduced to Microsoft's newest learning curriculum, the Microsoft academy, and their first of...
Episode 65: Do you have good data architecture?
12 Oct 2016
Contributed by Lukas
This week on the SQL Trail, Steve and I chat with Jason Horner about building a good data architecture. When talking about a data warehouse architectu...
Episode 64: Certifications and Career Development
05 Oct 2016
Contributed by Lukas
Have you ever thought that Microsoft certifications were a waste of time? Depending on where you are on the experience scale, certifications still ...
Episode 63: New Data AvailabilityFeatures in SQL Server 2016
28 Sep 2016
Contributed by Lukas
Availability groups provide both high availability features and disaster recovery options, but they also have several areas you must be aware so you d...
Episode 62: Ask Me Anything--Cortana Intelligence Suite
21 Sep 2016
Contributed by Lukas
Have you heard the buzz around the Cortana Intelligence Suite? It seems like it is all the rage these days and Microsoft is coming out with lots of ne...
Episode 61: The Debrief
14 Sep 2016
Contributed by Lukas
Do you dread the idea of going to the project post-mortem? Is it because you have to spend tons of time prepping your defenses for the onslaught? ...
Episode 60: What is U-SQL?
07 Sep 2016
Contributed by Lukas
When Microsoft introduced the Azure Data Lake, they included a new language, U-SQL, for Big Data processing as part of the Cortana Intelligence Suite....
Episode 59: Mirroring, Availability Groups, Replication, and Log shipping
31 Aug 2016
Contributed by Lukas
Have you ever wondered what the best option is for making your data available in your environment? Listener Chris Hendon asked us to talk about dif...
Episode 58: 4 ways to stay sharp with technical learning
24 Aug 2016
Contributed by Lukas
With all the changes in technology, how do you stay up to date with your technical learning? This is a question we have been asking our guests the...
Episode 57: What SQL Server feature would you change?
17 Aug 2016
Contributed by Lukas
Compañeros, in Episode 57 of the SQL Data Partners Podcast we take a page from the SQL Server Radio podcast where they list the 50 worst feature an...
Episode 56: What is your favorite SQL Server 2016 Feature?
10 Aug 2016
Contributed by Lukas
I found myself in Columbus Ohio at the SQLSaturday event and thought I'd do a live panel discussion about our Favorite SQL Server 2016 Features--wha...
Episode 55: The new and improved SQL Server Reporting Services
03 Aug 2016
Contributed by Lukas
SQL Server reporting services hasn't changed in what seems like 10 years. The rest of the reporting environment at Microsoft has seen some MEGA chan...
Episode 54: An Executive Panel Interview
27 Jul 2016
Contributed by Lukas
What is the leadership of your company thinking about the future of data and the role you will play? To help give some insight into that question we...
Episode 53: THE Argenis Fernandez interview on storage
20 Jul 2016
Contributed by Lukas
In Episode 53 Steve Stedman and I chat with THE Argenis Fernandez, storage guru and PASS Director-at-Large about what else? Storage. Steve and I l...
Episode 52: Statistics are coming to the DB R you ready?
13 Jul 2016
Contributed by Lukas
Since Microsoft purchases the R language they have been baking it into their products and SQL Server is on the list. SQL Server 2016 now has support...
Episode 51: A PowerShell Story
06 Jul 2016
Contributed by Lukas
I am always amazed at how people can use technology to solve different problems and in today's episode, my friend Jana shares with us a problem he sol...
Episode 50: SQL Server Settings
29 Jun 2016
Contributed by Lukas
As database administrators, we want to get as much performance as we can out of our SQL Servers. Microsoft has provided a few knobs for us to tweak ...
Epsidode 49: Temp Tables VS Table Variables
22 Jun 2016
Contributed by Lukas
When you code and you need to use a temporary object what do you use in SQL Server--temp tables or a table variable? There is plenty of conventional...
Episode 48: Is the Data Warehouse Dead?
15 Jun 2016
Contributed by Lukas
Over the last few years we have seen an explosion of new technologies and processes to manage data. Episode 48 asks the question--Is the Data Wareho...
Episode 47: Helping Your Data Find A Home
08 Jun 2016
Contributed by Lukas
The expansion of data sets and increased expectations of businesses for analysis and modeling of data has led developers to create a number of databas...
Episode 46: Unraveling Code
01 Jun 2016
Contributed by Lukas
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 ...
Episode 45 Service Broker
25 May 2016
Contributed by Lukas
Compañeros, we are going to get back into the engine this episode and go back to a feature that has been available since 2005--Service Broker. I ch...
Episode 44: Azure SQL Data Warehouse
18 May 2016
Contributed by Lukas
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 ...
Episode 43: Why is ETL so hard?
11 May 2016
Contributed by Lukas
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 ti...
Episode 42: Who made that change? Find out with Auditing
04 May 2016
Contributed by Lukas
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 ...
Episode 41: Index Maintenance
27 Apr 2016
Contributed by Lukas
Compañeros, you know good care and feeding of your indexes is VITAL to a healthy database. In this episode of the SQL Data Partners Podcast, I talk...
Episode 40: SQL Server Compression
20 Apr 2016
Contributed by Lukas
In this episode of the SQL Data Partners Podcast I chat with Jason Brimhall, about SQL Server compression and his experience with it. He also answers ...
Episode 39: Set statistics and StatisticsParser.com
13 Apr 2016
Contributed by Lukas
Today on the SQL Trail I talk with Richie Rump, the podcaster, blogger, and now new hire at Brent Ozar. He and I discuss measuring query performan...
Episode 38: SQL Server 2016 Feature Review
06 Apr 2016
Contributed by Lukas
Compañeros! You heard rumblings about how awesome SQL Server 2016 is, right? I talk with Rick Heiges about the wins he's seen for his clients using...
Episode 37: PowerBI and the DBA
30 Mar 2016
Contributed by Lukas
In this episode of the SQL Data Partners podcast I sit with Patrick LeBlanc during SQL Saturday RVA. We chat about Microsoft PowerBI. PowerBI is a bus...
Episode 36: SQL Server Virtual Machines in Azure
23 Mar 2016
Contributed by Lukas
You can host SQL Server on Azure Virtual Machines in a variety of configurations, ranging from a single database server to a multi-machine configurati...
Episode 35: Position Yourself to Better Opportunities
16 Mar 2016
Contributed by Lukas
On Episode 35 of The SQL Data Partners Podcast, I talk with Philip Morgan of The Positioning Manual for Technical Firms. Philip’s book has influence...
Episode 34: In-Memory Tables
09 Mar 2016
Contributed by Lukas
Hello, compañeros! You’ve heard of Hekaton and in-memory tables before, but what does in memory really mean for your database? Perhaps you have qu...
Episode 33: From Developer To DBA
02 Mar 2016
Contributed by Lukas
Many developers will make the transition to the DBA role and in this episode I chat with Amy Herold about making that very move. Amy started as a...
Episode 32: Up Your Game With PowerShell!
24 Feb 2016
Contributed by Lukas
PowerShell, isn't that a Windows Administration tool? This is certainly how it is positioned by Microsoft, but why should the DBA community give...
Episode 31: What Has Virtualization Done To My Database?
17 Feb 2016
Contributed by Lukas
As database administrators, we have to live with virtualization. As a consultant, I can't think of a single environment I have been in that didn...
Episode 30: The Best Investment You Can Make
10 Feb 2016
Contributed by Lukas
Think of one big investment that will be made this year. How will it affect you? Perhaps there is a large server migration project or move to Az...
Episode 29: You Thinking What I Am Thinking?
03 Feb 2016
Contributed by Lukas
We each have our way of going about things–this is what makes us unique. When it comes to getting data out of the database, many times we might t...
Episode 28: How Do You Know There Is A Problem? Baselines!
27 Jan 2016
Contributed by Lukas
Have you ever had a situation where performance got worse and you were sure why? Do you keep records of when changes happen to your system? How do...
Episode 27: Testing Changes Before You Break Production
20 Jan 2016
Contributed by Lukas
Have you ever wanted a feature to help you assess the impact of future SQL Server upgrades, the impact of hardware or operating system upgrades, and f...
Episode 26: DevOps for the Database--Everyone is Doing it, Right?
13 Jan 2016
Contributed by Lukas
DevOps for the database--you have probably heard the term if you work in an organization that is deploying code on a regular basis. The developers h...
Episode 25: Stretch Database
06 Jan 2016
Contributed by Lukas
SQL Server 2016 has several new features and this episode explores the stretch database feature. One of the unique attributes of this feature is tha...
Episode 24 Query Store
30 Dec 2015
Contributed by Lukas
One of the new features being added to SQL Server 2016 is the Query Store which will allow for greater access to the performance history of your datab...
Episode 23: IO, IO, It's Off to Tune We Go
23 Dec 2015
Contributed by Lukas
If I were a betting man, I would wager your disk IO system is probably the biggest bottleneck in your SQL Server right now. Sure, there are lots of ...
Episode 22: Eight Years of sp_whoisactive
16 Dec 2015
Contributed by Lukas
In what has to be one of the most downloaded SQL Server scripts on the planet with over 73,000 downloads, sp_whoisactive has been providing active ses...
Episode 21: Azure Data Factory
09 Dec 2015
Contributed by Lukas
As one of the newest Azure offerings, Azure Data Factory can at first thought be compared to SSIS. I don't think we are quite there yet with the co...
Episode 20: the Role of Mentors
02 Dec 2015
Contributed by Lukas
We all start somewhere and if you can find a mentor who will help you on your way by pointing you in a direction you had not considered, you are a luc...
Episode 19: How Solid State Disks Can Help SQL Server
25 Nov 2015
Contributed by Lukas
A hard drive is a hard drive, right? Storage has come a long way, but is probably still the biggest bottleneck in your system. Solid State Drives ...
Episode 18: BIML
18 Nov 2015
Contributed by Lukas
I learn stuff every day. In this episode I tackle a new subject for me and one I am hearing a lot about--BIML. BIML is a markup language you can u...
Episode 17: Partitioning
11 Nov 2015
Contributed by Lukas
Do you find you have tables and indexes that have grown really large? Are you moving around a lot more data than you used to? Are your windows for job...
Episode 16 SQL Server Agent
04 Nov 2015
Contributed by Lukas
I learn things every day. One of the great things about the SQL community is the willingness to share their learning experiences and today's episode...
Episode 15 Working at a University
28 Oct 2015
Contributed by Lukas
Corporate culture is a BIG deal when it comes to job satisfaction, and it is interesting to see how different sectors can be. Today we talk with Dou...
Episode 14: SQL Server Clustering
21 Oct 2015
Contributed by Lukas
Clustering is a now tried and true technology to help increase the availability of your SQL Server environment. I talk with Paul Popovich about his ...
Episode 13 Apply Yourself
14 Oct 2015
Contributed by Lukas
I attended Kevin Feasel's SQLSaturday session entitled Apply Yourself and thought it was pretty funny. While not close friends, I have know Kevin fo...
Episode 12: Database Corruption
07 Oct 2015
Contributed by Lukas
Database corruption is something that will eventually come to all data professionals. While I have been fortunate to only come across is a handful o...
Episode 11: SQL Server Statistics
30 Sep 2015
Contributed by Lukas
So it turns out an old dog can learn new tricks--or at least that is what happened to me when I chatted with Grant Fritchey from Red Gate software abo...
Episode 10: Test Anxiety and Test Preparation
23 Sep 2015
Contributed by Lukas
We mix things up a bit as I chat with Thomas Frank from collegeinfogeek.com about test anxiety and test preparation. Taking a test can be a big deal...
Episode 09: Database Automation
16 Sep 2015
Contributed by Lukas
Joey D'Antoni has been doing quite a bit with database automation and I caught with him to discuss his experiences about how database automation has ...
Episode 08: Database Design
09 Sep 2015
Contributed by Lukas
I chat will Louis Davidson about database design and get his thoughts on some strategies about how to go about making your design and what tools are a...
Episode 07: SQL Server Security
02 Sep 2015
Contributed by Lukas
I chat with Microsoft MVP Chris Bell about database security and some seemingly cavelier attitudes some organziations have about keeping data safe. ...
SQL Data Partners Podcast: Episode 06 Build Your Personal Brand
26 Aug 2015
Contributed by Lukas
Steve Jones, the editor from SQL Server central and I talk about the need to build your own brand and we share a few ideas on how to do that. We ta...
SQL Data Partners Episode 05: Principal of Least Privilege
19 Aug 2015
Contributed by Lukas
Robert Verell and I chat about good security practices and the principle of least privilege. We discuss Robert's rule to never give anyone db_owner,...
SQL Data Partners Podcast Episode 04: Advanced Backup Options
12 Aug 2015
Contributed by Lukas
We finish up our conversation with MVP Tim Radney on backup options with discussions on encryption and Azure. Tim also shares his favorite tools and...
SQL Data Partners Podcast Episode 03: Backup and Recovery
05 Aug 2015
Contributed by Lukas
I chat with MVP Tim Radney about Backup and Recovery options in SQL Server. We chatted for quite awhile and I ended up making two episodes out of ou...
SQL Data Partners Podcast Episode 00: Who I Am and What the Podcast is About
05 Aug 2015
Contributed by Lukas
Today I am super happy to announce the launch of my podcast and I start with episode 00. In this episode I take some time to go through my journey in ...
SQL Data Partners Podcast Episode 02: Extended Events
05 Aug 2015
Contributed by Lukas
I was in Argentina for the SQLSaturday event in May of 2015 and made friends with Javier Villegas, a 20 year veteran in the DBA world. While ext...