Podcasts by SQL Data Partners Podcast
Hosted by Carlos L Chacon, the SQL Data Partners Podcast focuses on Microsoft data platform related topics mixed with a sprinkling of professional development. Carlos and guests discuss new and familiar features and ideas and how you might apply them in your environments. Visit our website for episode show notes at marathonus.com/podcast and leave a comment if you have a topic you think we should discuss. We’ll see YOU on the SQL Trail.
Further podcasts by Carlos L Chacon
Podcast on the topic Technologie
All episodes
Episode 270: Medallion Architecture from 2023-11-21T18:30
Moving up the ranks in the holy technology wars is the medallion architecture, and boy are we interested in getting your thoughts. Not since the 2008 Olympics and Michael Phelps' tenth of a seco...
Listen
Episode 269: Why Do I Need a Managed Service Provider? from 2023-10-19T15:49
In this Episode, Carlos talks about managed services and shares some of the benefits of working with an MSP, as well as potential cons.
The term manage services refers to the practice of...
Listen
Episode 268: AI and the Future of the Database from 2023-09-28T00:08
We love hearing from our listeners!!! In this episode, a long-time listener asked about the future of AI in the data platform space. We thought this was a very interesting topic as Microsoft has...
Listen
Episode 267: Microsoft Fabric from 2023-09-12T16:54
All your data, all your teams—in one place. What am I? If you said Microsoft Fabric, you win! When I interned with Cisco Systems in 2000, I supported a platform called Unified Messaging. At that...
Listen
Episode 266: Working with Containers from 2023-08-29T17:00
We're kicking off Season 7 with containers!
Spinning up a VM may not be such a big deal anymore; however, most of us still have to request from another group one and wait. Even waiting on...
Listen
Episode 265: WHY and What's Next from 2023-06-28T15:03:40
Listen
Episode 264: Verified Backups from 2023-04-12T23:15:13
Listen
Episode 263: SQL Server This ‘n That from 2023-03-29T23:00
Listen
Episode 262: Learning Azure Synapse Pt 1 from 2023-03-15T22:00
Learning new technology can be difficult—especially when it’s a technology in an area you are not familiar with. In this episode, Eugene walks us throug...
Listen
Episode 261: The Data Lakehouse from 2023-03-01T13:30
It would appear Microsoft has run out of words to use for new features/products, so they are just going...
Listen
Episode 260: Contained Availability Groups from 2023-02-15T15:00
We’re back with another SQL Server 2022 feature—Contained Availability Groups. Have you ever failed over to a secondary node and then found a job or login missing? This new Enterprise-only fea...
Listen
Episode 259: T-SQL Snapshot Backups from 2023-01-17T22:41:48
We kick off the new year discussing a new feature in SQL Server 2022 called Transact-SQL snapshot backups. Good luck with the Google search on this feature--we know we had fun. 😊 These are not ...
Listen
Episode 258: Leave 2022 Enter 2023 from 2022-12-27T19:08:55
As we close out the year, we take a look back and think about all those SQL Server 2022 episodes we didn’t record this year—and then make the goal to increase this count in the new year. 😊 We d...
Listen
Episode 257: The Business of Working for Yourself from 2022-11-30T21:12:52
Have you ever thought about working for yourself? It can be very enticing for some, and in this episode, we talk with John Sterrett about the pros and cons of running your own organization. We t...
Listen
Episode 256: The Community Episode from 2022-11-03T19:04:27
Seven years ago, I started the SQL Data Partners Podcast. We have now arrived at Episode 256, and we dedicate this episode to you, the community. Thanks to everyone who has joined us along the w...
Listen
Episode 255: Automate Complex CRUD with sp_CRUDGen from 2022-10-05T13:30
One of the biggest challenges with developers using object-relational mapping (ORM) tools is the bad queries or procedures they create. Sure, most tools can create CRUD (Create, Read, Update, De...
Listen
Episode 254: Code Smell Checks with sp_Develop from 2022-09-21T20:54:24
Would you be interested in a tool to help you do code review checks and provide developers guidance on best practices? In this episode of the SQL Data Partners Podcast, we talk with Kevin Martin...
Listen
Episode 253: Go Mobile with Power Apps from 2022-09-07T19:49:30
In this episode, we dive into the Power Apps offering and discuss the pros and cons of using this latest Microsoft offering. Some definitions are given and hopefully this episode can orient folk...
Listen
Episode 252: The Cumulative Update Dilemma from 2022-08-24T20:00
Knowing your SQL Server is patched when an issue occurs is worth the effort of keeping it patched. While I don’t suggest a zero-day install for most folks, setting up a regular cadence to check ...
Listen
Episode 251: Azure Cognitive Services from 2022-08-10T16:30
How can you begin to integrate AI models into your environment without spending months building everything out? As we continue our march to Episode 256, we bring back our friend Sam Nasr to talk...
Listen
Episode 250: What happens before... “COMPANEROS!” from 2022-07-27T20:45:40
This episode we are doing a bit of a look back and are going to air some previously buried content. Some of the bloopers are pre-video and some of them have some physical comedy, which you’ll h...
Listen
Episode 249: Data Marts in Power BI from 2022-07-13T12:30
Data marts in Power BI have arrived and the words “data mart” mean something to data professionals. In this episode of the SQL Data Partners Podcast, we introduce the latest offering in Power B...
Listen
Episode 248: Inventory Documentation from 2022-06-29T12:30
How do you keep records of your SQL Server environments? Patching levels, security accounts, configuration options, maintenance jobs and the like are some of the pieces we have to keep organize...
Listen
Episode 247: Pushing the Boundaries or Pushing Your Luck from 2022-06-15T12:30
IT workers will generally claim they like learning new technology—it is almost a required attribute. Why then is bringing in new technology so hard? In this episode, we explore how new technol...
Listen
Episode 246: Microsoft Build 2022 Announcements from 2022-06-08T12:30
While we continue to review the new features of the CTP preview of SQL Server 2022, we turn our attention to the recent Microsoft Build conference and talk about some of the announcements made. ...
Listen
Episode 245: Tooling Updates from 2022-04-20T12:00
SQL Server Management Studio (SSMS) version 18 was introduced to support SQL Server 2019 and in this episode of the podcast, we discuss some of the new updates available in SSMS and Azure Data S...
Listen
Episode 244: Extended Events vs SQL Server Audit from 2022-03-30T12:00
Who made that change? It is one of those questions that can send chills down the spine of those responsible for databases. In this episode, Josephine Bush talks with us about how we can use a ...
Listen
Episode 243: Choosing What Content To Focus On from 2022-03-16T12:00
Conferences are on the uptick as COVID restrictions lift and we are excited for the upcoming year. After Eugene's return from SQLBits my thoughts revolved around what I wanted to learn this year...
Listen
Episode 242: Upgrading Your SQL Server from 2022-02-02T19:08:37
SQL Server 2012 is end of life later this year. I feel too young for this to be happening—it seems like only last year SQL Server 2005 came out. In this episode of the podcast, we talk about u...
Listen
Episode 241: Replicating Data with Azure SQL Data Sync from 2022-01-20T19:17:05
Do you find you need to keep SQL Server tables in sync across multiple systems? After several projects involving syncing data, we return to the topic of Azure SQL Data Sync with some real world...
Listen
Episode 240: Azure Synapse Link from 2022-01-05T18:43:13
Azure Synapse Link is a feature coming to SQL Server in the next release. While there are few details on what the new feature will look like, we discuss how this same service is implemented in o...
Listen
Episode 239: Bi-directional HA/DR to Azure SQL from 2021-12-15T21:23:29
SQL Server 2022 has been announced and we are excited to start unpacking the new features. For this episode, we start with a very interesting feature--Bi-directional HA/DR to Azure SQL. We have ...
Listen
Episode 238: Getting Started with Power BI - Part 2 from 2021-12-08T14:30
Part 2
Power BI has been described as a “self-service” BI platform. While that may bring to mind an image of easy-peasy, plug-and-play, th...
Listen
Episode 237: Getting Started with Power BI - Part 1 from 2021-12-01T22:47:36
Part 1
Power BI has been described as a “self-service” BI platform. While that may bring to mind an image of easy-peasy, plug-and-play, th...
Listen
Episode 236: Database Monitoring with SQL Sentry from 2021-11-17T22:00
Building your own scripts to monitor SQL Server seems like a very reasonable thing to do. We’re smart folks and SQL Server is what we do for a living—we should be able to figure this out. Upon f...
Listen
Episode 235: SQL Trail 2021 In-person Q&A from 2021-11-03T21:00
Live Podcast! We decided it was time to try and get together in person and reconnect. As we did, we pulled out the microphone and started recording. As a result, we break the single topic mode t...
Listen
Episode 234: Communication Tips for the IT Pro from 2021-10-07T01:15:30
As a data pro, you are negotiating and problem-solving all the time, often without knowing it. Your success as a professional as your company evolves its Data Platform depends on how well you ca...
Listen
Episode 233: ScriptDOM from 2021-09-15T21:30
Episode 232: Giving Technical Presentations from 2021-09-01T21:30
Public speaking is not fun for most; however, it can be very rewarding. Chris Seferlis chats with us about a few tips he has on being a speaker. Most of the tactical advice we defer to a toastma...
Listen
Episode 231: Mental Health and Wellness in IT from 2021-08-11T21:00
Everyone has bad days; however, how those bad days develop are unique to each of us. In a special episode, we chat with Tracy Boggiano about her experiences with Mental Health, how she has dealt...
Listen
Episode 230: RTO&RPO from 2021-08-04T21:00
No one wants to lose data when disaster strikes; however, we need to plan for some data loss and putting all the pieces in place can be tricky. There are two metrics commonly used to measure dat...
Listen
Episode 229: Data Migration Assistant from 2021-07-21T21:00
The scary part of upgrading SQL Server is finding out you have a problem AFTER the fact. In this episode, Mariano Kovo joins us to discuss the Data Migration Assistant tool from Microsoft. While...
Listen
Episode 228: Predicting Application Problems with Database Metrics from 2021-07-14T21:30
As data practitioners, we want to get ahead of any problems that might come up and share those insights with others on our team. In this episode, Edward Pollack gives us a few scenarios we might...
Listen
Episode 227: SSDT Methodologies for DB DevOps from 2021-06-23T21:10:58
Organizations look to constantly improve and offer better services and the application tooling has been built to accommodate the process. Database tooling has been a bit slower to develop; howev...
Listen
Episode 226: SQL Server IaaS Agent Extension from 2021-06-09T21:00
Let’s say you have completed a lift and shift VM hosting to the cloud. Great—you now use Iaas services. While you don’t have to worry about the hardware, managing the software can be problemat...
Listen
Episode 225: Dashboard Design Principles from 2021-05-26T21:00
Have you ever created a report in a visualization tool, spent all this time and energy creating something that looked really cool, went through more edits than you could remember only to deliver...
Listen
Episode 224: The Standup Meeting from 2021-04-28T20:00
Carlos, Kevin, and Eugene reconnect after some time away with a new streaming time. Long form conversation on a single topic is also the place we want to get back to in our podcast.
The...
Listen
Episode 223: Podcast Update from 2021-04-14T20:22:07
With both Kevin and Eugene busy this week, Carlos went solo to share a few changes to the podcast, including the Twitch livestream moving to Tuesday, how you can support the podcast, and podcast...
Listen
Episode 222: Azure Arc-enabled Data Services from 2021-03-24T22:31:04
Azure Arc-enabled data services provide powerful capabilities to deploy and manage local, on-premises, and hybrid cloud data resources using the same centralized management and tooling you get f...
Listen
Episode 221: SQL Trail March 2021 Retrospective from 2021-03-22T23:05:17
Virtual conferences are just not the same as the conferences we are used to, but we’re still determined to provide a good learning and networking environment for our friends. We very much miss ...
Listen
Episode 220: Microsoft Ignite Recap from 2021-03-10T22:11:52
As we prepare for SQL Trail on March 18th, we peek back at Microsoft Ignite and review the announcements made there—filtering out the pieces our compañeros will enjoy hearing about. Did we miss ...
Listen
Episode 219: SQL Server Inventory from 2021-02-24T23:27:42
How do you document your SQL Server environments? I can remember walking through Brent Ozar’s takeover script back in the day and how cumbersome it was to put all that information together. We h...
Listen
Episode 218: File Growths from 2021-02-17T18:09:24
In this episode of the SQL Data Partners Podcast, Eugene and I go back to our DBA beginnings and talk about database file growth, how to manage files and how to tell when a file has grown.
<... Listen
Episode 217: A Little Something About A Few Things from 2021-02-10T21:00:57
The story begins with a process that has been running forever and suddenly decides to cause grief by filling up tempdb. We talk about patching, and we talk about mental health. We talk a little ...
Listen
Episode 216: EDI vs ETL from 2021-02-03T19:56:17
When working on a customer on an import process, she made the comment—if we were doing true EDI, we’d [Do X]. The comment got me thinking—Aren’t we working on an EDI process? As someone who fre...
Listen
Episode 215: Azure Data Factory from 2021-01-27T23:05:26
We have been moving data for years with technologies like DTS and SSIS; however, these were very much designed for on-premises moves in mind. As more cloud services were being offered Microsoft ...
Listen
Episode 213: New Goals for 2021 from 2021-01-13T22:43:45
We open this year with a few updates on the podcast, a change to SQL Trail, and we invite you to give us some feedback on writing a book for 2021.
The show notes for today's episode can b...
Listen
Episode 212: 10 Things You Need to Know About Data Security from 2020-12-31T22:35:36
20 years ago, the objection to implementing security on the basis of performance had validity—especially for smaller organizations. Security was a pain in the neck; however, how many of us are s...
Listen
Episode 211: Solorigate from 2020-12-23T04:35:31
Microsoft released a lengthy white paper on the SolarWinds hack affecting thousands of computers. This is scary stuff, and the details continue to come out slowly and you wonder how it all will ...
Listen
Episode 210: The Elephant in the Room from 2020-12-18T23:32:18
It was sad news to hear PASS plans to dissolve in January of 2021. So much good has come of the community and it is sad to see it go. In this episode, we explore the why behind the collapse and ...
Listen
Episode 209: Career Ready: Advice to New Graduates from 2020-12-14T17:04:45
Finding your first full time job is incredibly difficult—and that was before we were in a worldwide pandemic. In this episode, we discuss some strategies and share some experiences about how we ...
Listen
Episode 208: SQL Server and Graph Data from 2020-10-28T19:40:26
There is a growing list of formats to store data and Graph is one of the newer trends. It is becoming so popular SQL Server has created ways to implement graph structures. Mala Mahadevan joins u...
Listen
Episode 207: SQL Trail 2020 Retrospective from 2020-10-15T16:00
SQL Trail 2020 was a success! There was a time I was unconvinced this would be the case. This is not to say we didn't have issues; however, talking with others helped us avoid some common pitfal...
Listen
Episode 206: .NET Core Interactions with SQL Server from 2020-09-17T00:00
There are many programming languages available to the modern developer and there are even more options for connecting to the database. In this episode, we talk with Taurius Litvinavicius about h...
Listen
Episode 205: Data Modeling for Power BI from 2020-09-03T16:00
Power BI is founded on the idea of self-service BI and Excel is the most common data source in the world. While Power BI can import that information with ease, the data may not be in the best fo...
Listen
Episode 204: IoT in Azure from 2020-08-19T21:00
A variety of devices now have the ability to report metrics about status, performance, or other sensor information. Collecting this information and making it useful in business operations can be...
Listen
Episode 203: Spark in Action from 2020-08-07T02:31:51
As we stretch the technology stack in this episode, I rely on my trusty co-hosts to get us through. Kevin and Jean-Georges Perrin do a great job giving us their thoughts on Spark. I hope you wil...
Listen
Episode 202: Virtual Conferences from 2020-07-23T03:30
As COVID-19 prevents us from gathering in the same place, how do organizers continue to put on compelling events? This strikes home as SQL Data Partners consider whether to have our SQL Trail ev...
Listen
Episode 201: Common Data Model from 2020-07-09T03:30
After we recorded Episode 189, we knew we lacked some of the business reasons behind the Common Data Model. Luckily, we reached out Tricia Wilcox-Almas and she has helped us fill in some of the ...
Listen
Episode 200: Anything but the Cowboys . . . from 2020-06-25T03:30
To celebrate our 200th episode, we reached out to Bob Ward to come and celebrate this milestone with us. I have to plead the 5th on why it took us 200 episodes to finally invite him; however, we...
Listen
Episode 199: Technical Debt from 2020-04-30T19:30:39
We can incur technical debt in several ways—aging technology, choosing delivery speed over scale architecture, or implementing new technology the entire team cannot yet support. I don’t know tha...
Listen
Episode 198: Cloud Infrastructure from 2020-04-23T03:30
Episode 197: Power Query in Power BI from 2020-04-15T17:13:26
In 1990, the group Snap! release a song called "The Power". It would take Microsoft more than 20 years, but they eventually came up with a series of 'power' tools they built into Excel. Those to...
Listen
Episode 196: Teleworking from 2020-04-02T00:15:51
This is a topic I have been interested in covering for some time and as our world faces a crisis dictating that we stay home, it seems like a good time to talk about teleworking. Everyone will h...
Listen
Episode 195: Understanding DAX from 2020-03-26T23:10:17
The number of new programming languages never ceases to amaze me. Technology advances continue to require new ways of allowing users to customize the way they use tools and Power BI is no differ...
Listen
Episode 194: PolyBase Use Cases from 2020-03-19T02:24:34
After Listen
Episode 193: Power BI Premium from 2020-03-12T01:17:58
Our regular host is down for the count with the flu; however, the podcast must go on! In this episode, we answer a listener-submitted question about Power BI Premium. Kevin and Eugene take us th...
Listen
Episode 192: The DBA is Dead! Long Live the DBA! from 2020-03-04T20:00
What is the future of the DBA and what technologies should I be focused on? In this episode, we attempt to look into the crystal ball and give our take on the future of work for the data platfor...
Listen
Episode 191: Power BI Row-Level Security from 2020-02-12T08:00
Wouldn’t it be nice if you could filter the rows a user sees in Power BI? What’s that? You’ve already implemented Row-Level Security at the database level? Well, t...
Listen
Episode 190: SQL Server 2019 from 2020-02-05T23:21:37
Episode 189: Power BI Common Data Model from 2020-01-23T01:08:48
Moving data is fairly straightforward; however, mapping data from one source to another can be extremely challenging. In an attempt to hel...
Listen
Episode 188: Databricks from 2020-01-16T03:34:18
A couple of years ago, Netflix offered a reward for anyone who could improve the algorithm for choosing a movie....
Listen
Episode 187: Power BI Performance Tuning from 2020-01-08T20:48:41
Make it go faster! Visualizations are great, but when users start complaining about the load times on reports, it can be a tough exercise to figure out the issues....
Listen
Episode 186: Analytics&Security: Find Pain Points, Make a Plan from 2019-12-27T16:37:29
Episode 185: DBATools in a Month of Lunches from 2019-12-19T10:36:04
Listen
Episode 184: Where do people get stuck with Power BI? from 2019-12-12T03:35:45
You've seen the visualizations and want to dive in--perhaps you were assigned the task. However you started with Power BI, chances are you might get stuck at some point. In this episode, we cha...
Listen
Episode 183: SQL Server Big Data Clusters from 2019-12-04T22:34:50
SQL Server 2019 is out and one of the most interesting additions is SQL Server 2019 Big Data Clusters. In this episode, Kevin Feasel covers the marriage of SQL Server and Apache Spark. We discus...
Listen
Episode 182: XEvents from 2019-11-21T02:41:25
Episode 181: Paginated Reports in Power BI from 2019-11-13T19:51:40
Episode 180: PolyBase in SQL Server 2019 from 2019-11-06T23:20:28
Episode 179: SQL Trail Recap&Buying Power BI from 2019-10-24T02:09:06
Episode 178: Database Design from 2019-10-17T02:22:41
After 170 episodes, we bring back Louis Davidson to talk about database design and get his thoughts on how we can get better at planning for our data.
The show notes for today's episode c...
Listen
Episode 177: Lock Pages in Memory from 2019-10-09T23:48:14
Episode 176: Power BI Storage Options from 2019-09-25T20:09:24
Episode 175: Migrating to the Cloud from 2019-09-18T23:18:58
Episode NULL: Summer Break from 2019-07-24T22:11
Listen
Episode 174: Power BI Report Server from 2019-06-27T02:13:23
Episode 173: New Data Certifications from 2019-06-12T19:04:55
As the data platform continues to evolve, so do certifications. In this episode we chat with Rick Heiges about the new role-based certifications and how they fit i...
Listen
Episode 172: Power BI Monitoring from 2019-06-05T07:00
From a SQL Server perspective we have many ways to identify problem areas. In this episode, we discuss ways to diagnose performance issues in Power BI. They are ce...
Listen
Episode 171: SQL Server Encryption from 2019-05-22T00:33:47
You’ve got first name, last name, full name, birth date, address, email, phone, tax ID or Social Security Number, driver’s license number, medical evaluation notes...
Listen
Episode 170: Devops with Power BI from 2019-05-15T20:12:54
Two years ago blogger Jay Killeen observed, "And with modern languages and modern applications such as PowerBI and Power Query you should be safe to assume there w...
Listen
Episode 169: Should you learn to code? from 2019-05-08T21:23:35
Episode 168: Data Privacy Settings from 2019-05-01T00:12:53
One of the great abilities we have with Power BI is connecting to multiple data sources. Authors can actually publish data sources for others to use in their repor...
Listen
Episode 167: Azure SQL Data Sync from 2019-04-25T01:12:04
Azure SQL Data Sync has been generally available for almost a year now. Have you heard of it? Are you using it? Microsoft's page tell us that "Data Sync is useful ...
Listen
Episode 166: Custom Visuals from 2019-04-17T07:00
The number one reason organizations choose Power BI is the ability to visualize data; however, even with all the immediate choices, many report developers desire t...
Listen
Episode 165: Artificial Intelligence from 2019-03-28T00:38:52
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 inv...
Listen
Episode 164: The DAX Episode from 2019-03-21T01:54:25
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 ...
Listen
Episode 163: Very Large Databases from 2019-03-13T01:46:31
Are you experiencing challenges managing Very Large Databases (VLDBs), or anticipate challenges with future growth? In this episode, we are joined by Aaron Hayes t...
Listen
Episode 162: Power Query vs DAX from 2019-02-28T01:03:25
In this corner, coming in with all its Excel glory we have Power Query! And in this corner we have a new programming language, DAX! Have you ever felt like there i...
Listen
Episode 161: Migrating/Upgrading 8000 databases from 2019-02-21T02:55:56
How do you migrate 8,000 databases on a single instance in an environment that doesn't tolerate downtime? Today's episode focuses on migration strategy and how our...
Listen
Episode 160: Power BI Embedded from 2019-02-13T08:00
The traditional model for Power BI is to pay per user, but what if you want to use the reports in your web app and don't know who all the users would be? In this e...
Listen
Episode 159: Power BI Dataflows from 2019-02-06T08:00
So what happens when you want to use data from two different sources, manipulate it (transform it) and then present the data in Power BI -- and you don't know how ...
Listen
Episode 158: Gateways from 2019-01-24T03:11:46
For only 10 bucks a month you can start visualizing your data and finally get the dashboard your executives have been waiting for!! What's that? You need to refres...
Listen
Episode 157: Windows Server Core from 2019-01-10T03:22:53
I can still remember working in high school when you had to 'dial in' to the internet and Microsoft bought the rights to the Rolling Stones song 'Start Me Up' for ...
Listen
Episode 156: Social Intelligence from 2019-01-02T08:00
How well do you connect with others? We generally think pretty good of ourselves and at first glance you may give yourself a pretty high score. While there is no ...
Listen
Episode 155: Data Science from 2018-12-13T04:41:31
Do you want to be a data scientist? Do you even know what data science is? In this episode, we tackle the idea of being a data scientist and discuss the criteria a...
Listen
Episode 154: Test Driven Development from 2018-11-21T20:15:30
Who hasn't had a deployment go a bit sideways? For all the talk of DevOps these days, the ability to push out code can still be challenging. When I heard David M...
Listen
Episode 153: SQL Trail 2018 Retrospective from 2018-11-07T21:57:39
Year Two of our beautiful idea--gather together with a group of podcast listeners in a conference type format and find ways for us to connect and help each other g...
Listen
Episode 152: Do you use Analysis Services? from 2018-11-01T07:34:04
Those trained in SSAS may cringe a bit, but a curious thought entered my mind. Many organizations start using data warehouse structure with fact and dimension tab...
Listen
Episode 151: Azure SQL Database Managed Instance from 2018-10-24T16:30:58
Platform as a service has finally arrived to Microsoft's Azure offering. With the release of Azure SQL Database Managed Instances--quite the mouthful--there is no...
Listen
Episode 150: The SQL Data Partners Team from 2018-10-19T03:00:09
Today we, the SQL Data Partners team, celebrate our 150th podcast episode! We introduce ourselves, talk about what we're doing, our goals for the coming year and answer the SQL Family questions....
Listen
Episode 149: Managing lots of databases from 2018-10-11T14:19:03
Do you ever feel like you have too many databases to manage? Managing lot of databases can get tricky and in this episode we explore some of the techniques you ca...
Listen
Episode 148: High Performance SSRS from 2018-10-03T07:00
SSRS is great -- it comes with SQL Server, provides quite a bit of functionality, but sometimes doesn't always perform well. In this episode we welcome back Bert W...
Listen
Episode 147: Always Encrypted from 2018-09-19T07:00
Security is always important to data folks and when a new feature like Always Encrypted comes along, it gets your attention. In this episode, we discuss this featu...
Listen
Episode 146: SQL Trail Speakers from 2018-09-12T16:26:01
So what is SQL Trail all about? In this episode we invite our MVPs to discuss some of the topics they are ready to share on SQL Trail. We know there are lots of ...
Listen
Episode 145: Is SSIS still relevant? Part 2 from 2018-09-05T07:00
In this episode we finish up our conversation with Jason and Cathrine and talk about how they keep up with all the changes in data conversions. The advent of Azur...
Listen
Episode 144: Is SSIS still relevant? Part 1 from 2018-08-29T07:00
Moving data with SSIS is a forgone conclusion for most of us -- it is part of SQL Server, it has a interface we are somewhat familiar with, and connects to lots of...
Listen
Episode 143: Transitioning from DBA to Data Warehouse Architect from 2018-08-09T03:40:13
We frequently talk about how many DBAs are concerned our job may be phased out in the future. This episode discusses one common career path in going from DBA to Da...
Listen
Episode 142: Do You Have a HEAP of Hurting? from 2018-07-26T01:54:48
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 sort...
Listen
Episode 141: Wait, Wait, What? from 2018-07-04T22:01:15
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...
Listen
Episode 140: Why data types matter from 2018-06-20T19:13:11
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...
Listen
Episode 139: Getting Started with SQL Server in Azure from 2018-06-13T22:36:28
"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 ...
Listen
Episode 138: Meeting of the Minds from 2018-06-06T07:00
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 episo...
Listen
Episode 137: You want to work with Analytics? from 2018-05-31T01:42:52
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...
Listen
Episode 136: Devops with Visual Studio from 2018-05-23T15:47:19
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 epis...
Listen
Episode 135: Seinfeld Episode from 2018-05-16T18:15:59
Normally we have one specific topic we focus on each episode. This episode is a little different.
The show notes for ...
Listen
Episode 134: CosmosDB from 2018-05-09T16:08:55
It is not very often the internal codename is used when a product is launched; however, when you think about a database designed with global distribution in mind, ...
Listen
Episode 133: Shrinking Files from 2018-05-03T15:28:55
While the ability to shrink data files is available in SSMS, the conventional wisdom is don't do it. I was extremely curious when I read an email from our guest s...
Listen
Episode 132: What technologists can learn from superheroes from 2018-04-19T00:03:42
Bang! Pow! Crash! Besides just awesome fighting techniques, are there things we can learn from superheroes? My guest, Will Fehringer, gave that very question som...
Listen
Episode 131: Big Data Solutions in the Cloud from 2018-04-11T19:22:43
Big Data. Do you have big data? What does that even mean? In this episode I explore some of the concepts of how organizations can manage their data and what que...
Listen
Episode 130: Use Case for PowerShell from 2018-04-04T15:09:11
Heroes in a half shell, PowerShell! Well, maybe that wasn't the original line, but you know from this program and other places on the internet, PowerShell is all ...
Listen
Episode 129: Graph Databases from 2018-03-28T02:59:02
Books online state: “There is nothing a graph database can achi...
Listen
Episode 128: Database Doing DevOps from 2018-03-21T17:16:22
To Devops or not to Devops, that is the question. We've talked before about how the developers have all the cool new tools, but this is slowly changing. For thos...
Listen
Episode 127: Developing in the database from 2018-03-15T00:01:05
There has been a remarkable shift introduced in the new features of SQL Server--programming languages have been embedded into the database. This has led to a few ...
Listen
Episode 126: SQLSaturday Edition from 2018-03-08T05:13:42
Have you attended a SQLSaturday? They are great events and in this episode we chat with a few organizers about what goes into putting on an event and what they thi...
Listen
Episode 125: You must be an engineer from 2018-02-28T08:00
Have you ever found it difficult to explain how something works to a co-worker? What about reading documentation? We have all been there before and in this episo...
Listen
Episode 124: Beyond the runbook; DR Organization from 2018-02-21T08:00
Perhaps you have heard about a runbook--the documented instructions you should follow in the event of a disaster or some situation where an outage occurs. Instruc...
Listen
Episode 123: Top 5 things to know when getting admin access from 2018-02-14T08:00
Listener Eduardo Cervantes wanted to get our take on what developers should do when they get admin access to a database. We take on this challenge and I give 5 po...
Listen
Episode 122: Isolation Levels from 2017-12-21T16:57:53
Does not play well with others. Is this description appropriate for some of the queries in your database? In this episode, we explore the role behind isolation le...
Listen
Episode 121: What makes a good manager? from 2017-12-14T18:37:28
I have heard it said "People don't quit jobs--they quit managers". At a recent event, I decided to ask people what they thought the qualities of a good manager ar...
Listen
Episode 120: SQL Injection from 2017-12-07T03:42:29
Shouldn't they have fixed that instead of putting out all these new features? That might be what you are thought when you saw the title for today's episode. SQL ...
Listen
Episode 119: Getting started with GitHub from 2017-11-30T03:09:12
At first glance you might think our podcast topic is from way out in left field; however, as you think about it there are a number of reasons we should be talking ...
Listen
Episode 118: How has index maintenance changed? from 2017-11-24T18:54:29
After having attended PASS Summit and seeing all the new features coming it out, it can be very easy to overlook the basics--they are boring. These features have been around forever. This may ...
Listen
Episode 117: PASS Summit Retrospective from 2017-11-15T23:17:29
Have you ever had a week without a Wednesday? Me neither, so for this episode, we recap our experience at PASS Summit and talk about all the amazing compañeros we...
Listen
Episode 116: Are people still using PSSDiag? from 2017-11-08T18:20:23
If you have ever worked with Microsoft support, you probably came across the PssDiag tool they use to collect information about your environment. My experience wi...
Listen
Episode 115: The Companero Conference Retrospective from 2017-11-01T07:00
It was a beautiful idea. Gather together with a group of our podcast listeners in a conference type format and find ways for us to connect and help each grow. I ...
Listen
Episode 114: How do you start consulting? from 2017-10-25T20:26:36
One of the advantages to a small conference is the ability to take attendee feedback and put it in place during the conference. We actually made time for the atte...
Listen
Episode 113: Standing on the shoulders of giants from 2017-10-11T14:14:50
"If I have seen further, it is by standing on the shoulders of giants." Those words are attributed to Issac Newton and they are fitting for the way I was feeling ...
Listen
Episode 112: Keeping up with patching from 2017-10-04T15:16:42
When listener Mel Vargas first suggested the topic of patching, I was not sure this would work as a topic; however, the Equifax story had just developed and there are many other security related...
Listen
Episode 111: How do you prepare for conferences? from 2017-09-27T20:57:31
Sometimes just getting approval to attend a conference is a challenge, but getting the green light isn't the only thing you should plan for. Sure, you want to lea...
Listen
Episode 110 How do I build trust with my team from 2017-09-20T11:26:25
As you work with other people, you will experience resistance when you suggest changes and want to implement something new. Why is this?
One podcast listener shared an experience where a...
Listen
Episode 109: To certify or not to certify? from 2017-09-13T20:32:41
In episode 64 we interviewed Patrick Thomas, the program manager for the MCP program which includes certifications. There con...
Listen
Episode 108: The Future of the Relational Database from 2017-09-06T17:48:42
After a brief hiatus, we are back on the air to continue the conversation and let me tell you--we have a great conversation lined up for this episode. The discussion around what will hap...
Episode 107 BI for the Little Guy from 2017-08-03T04:56:03
Data analytics is all anyone seems to talk about anymore. We've even caught the bug at SQL Data Partners and have started working with data platform MVP César Oviedo from Costa Rica. César has...
Listen
Episode 106 Temporal Tables from 2017-07-26T07:00
User: What was that record before it was updated?
Me: I don't know. Maybe I could restore a backup?
User: Really? You have to do all that? It is just one record.
Me: (under my...
Episode 105 When is enough, enough? from 2017-07-19T07:00
How can you tell when a change is enough of a change? How do you know you didn’t make too big of a change? Steve and I discuss some thoughts around what you might look for when you make certai...
Listen
Episode 104: Keeping up with technology from 2017-07-13T01:52:08
Do you have any experience with [Insert random technology]? Your heart starts to race and your palms get a little sweaty. You don’t want to say no–we’re tech folks–we know stuff, but there are...
Listen
Episode 103 Plan Reuse from 2017-07-05T13:38:29
When we write our queries to the database, SQL Server has to go and figure out the best way to go and bring back the data you asked for. A query plan is created to help SQL Server remember how t...
Listen
Episode 102 Monitoring Availability Groups from 2017-06-29T09:27:50
One of the newer features in SQL Server is availability groups, which can help solve a number of business problems. As administrators, availability groups introduce some complexity as we are ta...
Listen
Episode 101 Inspecting a new Database from 2017-06-21T08:39:01
Listener Cody Ford wrote in and asked if we could share some thoughts on getting familiar with an unfamiliar database. While we have done episodes in the past on best practices, this episode ta...
Listen
Episode 100 Role Reversal from 2017-06-14T07:00
Something a bit strange happened in episode 100--almost like something out of the twilight zone, but don't take our word for it. Check out our latest episode as tell some of the stories that le...
Listen
Episode 99 Imposter Syndrome from 2017-06-07T15:41:19
Impostor syndrome (also known as impostor phenomenon or fraud syndrome) is a term coined in 1978 by clinical psychologists Dr. Pauline R. Clance and Suzanne...
Listen
Episode 98: The first change you make from 2017-06-01T13:37:31
In a recent SQLSaturday conference, I walked into the speakers room and asked the question--What is the first thing you change after you install SQL Server? It was interesting to get their take...
Listen
Episode 97 Transactional Replication from 2017-05-24T15:34:58
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 ...
Listen
Epsiode 96 Building Community Tools from 2017-05-17T11:38:37
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...
Listen
Episode 95 Polybase from 2017-05-10T13:58:29
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 diff...
Listen
Episode 94 Qlik Technologies from 2017-05-03T09:54:32
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 in...
Listen
Episode 93 Making Mistakes from 2017-04-26T09:16:36
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 mistake...
Listen
Episode 92 SSDT from 2017-04-19T07:00
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...
Listen
Episode 91 DBA Tools from 2017-04-12T07:00
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...
Listen
Episode 90 Check DBCC from 2017-04-05T09:29:01
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 th...
Listen
Episode 89 Lone DBA from 2017-03-30T08:58:33
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...
Listen
Episode 88 SharePoint from 2017-03-22T07:00
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...
Listen
Episode 87 Resource Governor from 2017-03-15T07:00
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 ...
Listen
Episode 86 TsqlT from 2017-03-08T14:50:26
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 ...
Listen
Episode 85 2016 Speedbumps from 2017-03-01T09:26:03
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 tal...
Listen
Episode 84 MVP from 2017-02-22T16:22:47
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 co...
Listen
Podcast 83 Data Visualizations from 2017-02-15T08:00
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 prese...
Listen
Episode 82 Indexes Part 2 from 2017-02-08T11:34:26
In the previous episode we discussed the basics of using indexes, what they are, how to use them, along with some common problems...
Listen
Episode 81 Indexes Part 1 from 2017-02-01T08:00
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...
Listen
Episode 80 Containers from 2017-01-25T08:00
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 troub...
Listen
Episode 79 SSIS Catalog from 2017-01-18T08:00
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,&n...
Listen
Episode 78: Conversion to 2016 from 2017-01-11T20:15:02
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 ava...
Listen
Episode 77: New Reporting Options from 2017-01-04T20:10:21
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 direct...
Listen
Episode 76: Availability Group Improvements from 2016-12-31T22:08:11
Availability groups provide some exciting features in mixing high availability and disaster recovery; however, from a performance consideration, there are a few drawbacks. With the advances in ...
Listen
Episode 75 Storage Testing from 2016-12-21T21:01:33
Storage testing and validation is something what we to add under roles and responsibilities as DBAs. Every database we ever manage is going to need one, but how often do we kick the tires? Many ...
Listen
Episode 74: 2016 Year in Review from 2016-12-14T08:00
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.
Listen
Episode 73: Performance Tuning from 2016-12-08T02:59:35
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 talk with Pinal Dave about how he does performance...
Listen
Episode 72: Test Automation in BI from 2016-11-30T21:37:10
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 help them; however, if you're on the data si...
Listen
Episode 71: BI Tools of the Trade from 2016-11-23T17:12:27
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 our companies may not always have the same e...
Listen
Episode 70 SQL Server on Linux from 2016-11-16T14:51:34
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 installed on Linux. What makes this all even mor...
Listen
Episode 69: Our SQL Server Setup Checklist from 2016-11-09T16:31:51
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 real impact is in the way we administer the data...
Listen
Episode 68: SSIS Administration from 2016-11-02T07:00
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, we share some thoughts around SSIS administra...
Listen
Episode 67 Dear Developer from 2016-10-27T01:34:51
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 session and I was super happy with the results. We...
Listen
Episode 66: Microsoft's Professional Program from 2016-10-19T13:04:51
After talking with Patrick Thomas in episode 64, I was introduced to Microsoft's newest learning curriculum, the Microsoft aca...
Listen
Episode 65: Do you have good data architecture? from 2016-10-12T07:00
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 architecture, or even just a data architecture, people...
Listen
Episode 64: Certifications and Career Development from 2016-10-05T07:00
Have you ever thought that Microsoft certifications were a waste of time? Depending on where you are on the experience scale, certifications still play a large role in hiring and career developm...
Listen
Episode 63: New Data AvailabilityFeatures in SQL Server 2016 from 2016-09-28T07:00
Availability groups provide both high availability features and disaster recovery options, but they also have several areas you must be aware so you don't introduce more risk into your environme...
Listen
Episode 62: Ask Me Anything--Cortana Intelligence Suite from 2016-09-21T07:00
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 new features in this space. In Episode 62, Ste...
Listen
Episode 61: The Debrief from 2016-09-14T07:00
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? This week we chat with Russ Thomas and get his...
Listen
Episode 60: What is U-SQL? from 2016-09-07T07:00
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. U-SQL plays a role in the streaming analyt...
Listen
Episode 59: Mirroring, Availability Groups, Replication, and Log shipping from 2016-08-31T12:27:55
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 differences between Availability groups, mirroring...
Listen
Episode 58: 4 ways to stay sharp with technical learning from 2016-08-24T07:00
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 last several episodes and in this episode we, ...
Listen
Episode 57: What SQL Server feature would you change? from 2016-08-17T11:47:41
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 w...
Listen
Episode 56: What is your favorite SQL Server 2016 Feature? from 2016-08-10T07:00
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--what we are most excited about. We also discuss...
Listen
Episode 55: The new and improved SQL Server Reporting Services from 2016-08-03T07:00
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 changes and it seems like we could use a few upda...
Listen
Episode 54: An Executive Panel Interview from 2016-07-27T07:00
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 have and executive pane on episode 54. Andr...
Listen
Episode 53: THE Argenis Fernandez interview on storage from 2016-07-20T07:00
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 learn something new from Argenis every time we t...
Listen
Episode 52: Statistics are coming to the DB R you ready? from 2016-07-13T07:00
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 for R and I know I have had people approach ...
Listen
Episode 51: A PowerShell Story from 2016-07-06T07:00
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 solved with PowerShell. The setup of this is d...
Listen
Episode 50: SQL Server Settings from 2016-06-29T07:00
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 in the Operating System, the local security p...
Listen
Epsidode 49: Temp Tables VS Table Variables from 2016-06-22T07:00
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 wisdom out there and my guest Wayne Sheffiel...
Listen
Episode 48: Is the Data Warehouse Dead? from 2016-06-15T07:00
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 Warehouse dead? I chat with MVP Tim Mitchell about...
Listen
Episode 47: Helping Your Data Find A Home from 2016-06-08T07:00
The expansion of data sets and increased expectations of businesses for analysis and modeling of data has led developers to create a number of database products to meet those needs. As data prof...
Listen
Episode 46: Unraveling Code from 2016-06-01T07:00
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 performance or to make a change to it. I en...
Listen
Episode 45 Service Broker from 2016-05-25T07:00
Episode 44: Azure SQL Data Warehouse from 2016-05-18T07:00
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 organizat...
Listen
Episode 43: Why is ETL so hard? from 2016-05-11T07:00
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 archi...
Listen
Episode 42: Who made that change? Find out with Auditing from 2016-05-04T07:00
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 fea...
Listen
Episode 41: Index Maintenance from 2016-04-27T07:00
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 to Sean McCown about the best practices for i...
Listen
Episode 40: SQL Server Compression from 2016-04-20T07:00
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 your compression questions: Why is it a bad ...
Listen
Episode 39: Set statistics and StatisticsParser.com from 2016-04-13T07:00
Today on the SQL Trail I talk with Richie Rump, the podcaster, bloggerListen
Episode 38: SQL Server 2016 Feature Review from 2016-04-06T07:00
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 SQL Server 2016, including how one client's m...
Listen
Episode 37: PowerBI and the DBA from 2016-03-30T07:00
In this episode of the SQL Data Partners podcast I sit with Patrick LeBlanc during SQL Saturday RVA. We chat about Microsoft PowerBI. ...
Listen
Episode 36: SQL Server Virtual Machines in Azure from 2016-03-23T07:00
You can host SQL Server on Azure Virtual Machines in a variety of configurations, ranging from a single d...
Listen
Episode 35: Position Yourself to Better Opportunities from 2016-03-16T07:00
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 influenced my work at SQL Data Partners, so I wanted to...
Listen
Episode 34: In-Memory Tables from 2016-03-09T08:00
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 questions like I did, like how does in me...
Listen
Episode 33: From Developer To DBA from 2016-03-02T08:00
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 C#/.NET developer and moved into the database w...
Listen
Episode 32: Up Your Game With PowerShell! from 2016-02-24T08:00
PowerShell, isn't that a Windows Administration tool? This is certainly how it is positioned by Microsoft, but why should the DBA community give it more than a passing glance? My gues...
Listen
Episode 31: What Has Virtualization Done To My Database? from 2016-02-17T08:00
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't have some of the SQL Servers virtuali...
Listen
Episode 30: The Best Investment You Can Make from 2016-02-10T08:00
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 Azure on the books this year. Maybe you have been...
Listen
Episode 29: You Thinking What I Am Thinking? from 2016-02-03T08:00
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 think that SQL Server would go about getting data...
Listen
Episode 28: How Do You Know There Is A Problem? Baselines! from 2016-01-27T08:00
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 we know there's a problem? Baselines can hel...
Listen
Episode 27: Testing Changes Before You Break Production from 2016-01-20T08:30
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 for SQL Server tuning? Well that tool has be...
Listen
Episode 26: DevOps for the Database--Everyone is Doing it, Right? from 2016-01-13T08:00
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 have this down to a science, and now it is the...
Listen
Episode 25: Stretch Database from 2016-01-06T08:00
SQL Server 2016 has several new features and this episode explores the stretch database feature. One of the unique attributes of this feature is that it uses both the on premise instance and th...
Listen
Episode 24 Query Store from 2015-12-30T08:00
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 databases. This is going to be extremely helpful...
Listen
Episode 23: IO, IO, It’s Off to Tune We Go from 2015-12-23T08:00
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 moving pieces, but if you can tame the IO sit...
Listen
Episode 22: Eight Years of sp_whoisactive from 2015-12-16T08:00
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 session information to data professionals for e...
Listen
Episode 21: Azure Data Factory from 2015-12-09T08:00
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 comparisons; however, I talk with MVP Reza Rad a...
Listen
Episode 20: the Role of Mentors from 2015-12-02T08:00
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 lucky person indeed. This episode I chat some ...
Listen
Episode 19: How Solid State Disks Can Help SQL Server from 2015-11-25T08:00
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 (ssd) have changed the rules in terms of perfo...
Listen
Episode 18: BIML from 2015-11-18T08:00
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 use to build your SSIS packages.
I met ...
Listen
Episode 17: Partitioning from 2015-11-11T08:00
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 jobs and maintenance getting tighter? If you an...
Listen
Episode 16 SQL Server Agent from 2015-11-04T08:00
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 is an example of this. I chat with Mark Wil...
Listen
Episode 15 Working at a University from 2015-10-28T07:00
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 Doug Purnell, DBA at Elon College in North Carol...
Listen
Episode 14: SQL Server Clustering from 2015-10-21T07:00
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 experiences with clustering and how his appro...
Listen
Episode 13 Apply Yourself from 2015-10-14T07:00
I attended Kevin Feasel's SQLSaturday session entitled Apply Yourself and thought it was pretty funny. While not close friends, I have know Kevin for a while and knew he had good stuff.
Episode 12: Database Corruption from 2015-10-07T07:00
Database corruption is something that will eventually come to all data professionals. While I have been fortunate to only come across is a handful of times, I was glad that I was able to get ba...
Listen
Episode 11: SQL Server Statistics from 2015-09-30T07:00
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 about SQL Server Statistics. Always taking an ...
Listen
Episode 10: Test Anxiety and Test Preparation from 2015-09-23T07:00
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...
Listen
Episode 09: Database Automation from 2015-09-16T07:30
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 helped him be more efficient and have fewer s...
Listen
Episode 08: Database Design from 2015-09-09T07:00
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 available to help you. It may surprise you t...
Listen
Episode 07: SQL Server Security from 2015-09-02T07:00
I chat with Microsoft MVP Chris Bell about database security and some seemingly cavelier attitudes some organziations have about keeping data safe. We hit some of the methods SQL Server has to ...
Listen
SQL Data Partners Podcast: Episode 06 Build Your Personal Brand from 2015-08-26T06:00
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 talk about Steve's brand and how he built that o...
Listen
SQL Data Partners Episode 05: Principal of Least Privilege from 2015-08-19T06:00
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, other groups and Robert's home grown group t...
Listen
SQL Data Partners Podcast Episode 04: Advanced Backup Options from 2015-08-12T05:00
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 his super hero power of choice.
Erik ...
Listen
SQL Data Partners Podcast Episode 03: Backup and Recovery from 2015-08-05T05:04
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 our conversation. This episode focuses on why ...
Listen
SQL Data Partners Podcast Episode 00: Who I Am and What the Podcast is About from 2015-08-05T05:00
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 becoming a data professional and how I think...
Listen
SQL Data Partners Podcast Episode 02: Extended Events from 2015-08-05T05:00
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 extended events have been around for some time, many...
Listen