SQL Data Partners Podcast

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 answered yes to any of these questions, partitioning may be for you!

Partitioning allows us to break a table or index down into smaller more manageable chunks.  Partitioning can enable us to perform maintenance on just part of a table or index. We can even move data in and out of tables with quick and easy metadata only operations.

In this episode, we’ll go over basic partitioning concepts such as horizontal vs. vertical partitioning, how to identify if a table is ready for partitioning, and what you need to know about your applications before you implement partitioning.

Check out the show notes at http://sqldatapartners.com/2015/11/10/partitioning/

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 Wilkinson about the SQL Server Agent--some best practices and MSX--a feature I have not used in the past.

If you are interested in expanding your SQL Server agent horizon, this episode is for you. Check out the show notes for today's information at http://sqldatapartners.com/2015/11/03/sql-server-agent

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 Wilkinson about the SQL Server Agent--some best practices and MSX--a feature I have not used in the past. 

If you are interested in expanding your SQL Server agent horizon, this episode is for you.  Check out the show notes for today's information at http://sqldatapartners.com/2015/11/03/sql-server-agent

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 Carolina and Jamie Wick, DBA at William and Mary in Virginia about their experiences working in the university system.

Check it out compañeros, and have fun on the SQL trail. As always, the shownotes are available at http://sqldatapartners.com/2015/10/28/working-at-a-university/.

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 Carolina and Jamie Wick, DBA at William and Mary in Virginia about their experiences working in the university system.

Check it out compañeros, and have fun on the SQL trail.  As always, the shownotes are available at http://sqldatapartners.com/2015/10/28/working-at-a-university/.

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 approach has changed as the technology has evolved. If you are looking for a good introduction to some concepts of clustering, this episode is for you! It should be noted this episode does not include the new feature of Availability Groups.

You can view the show notes for this episode at http://sqldatapartners.com/2015/10/03/clustering/

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 approach has changed as the technology has evolved.  If you are looking for a good introduction to some concepts of clustering, this episode is for you!  It should be noted this episode does not include the new feature of Availability Groups.

You can view the show notes for this episode at http://sqldatapartners.com/2015/10/03/clustering/

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.

He there shared this quote in his session. "If you don't understand the APPLY operator, your skills are somewhere around the 50th percentile at best." -- Adam Machanic.

I knew immediately I wanted to have him on the show.

This episode will introduce some concepts, but you will have to do a bit a leg work if you want to start 'Applying' this into your code--I'm sorry, I couldn't resist.

As always, you can check out http://sqldatapartners.com/2015/10/13/the-apply-operator/ for the show notes. Have fun on the SQL trail!

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. 

He there shared this quote in his session.  “If you don't understand the APPLY operator, your skills are somewhere around the 50th percentile at best.” -- Adam Machanic. 

I knew immediately I wanted to have him on the show.

This episode will introduce some concepts, but you will have to do a bit a leg work if you want to start 'Applying' this into your code--I'm sorry, I couldn't resist.

As always, you can check out http://sqldatapartners.com/2015/10/13/the-apply-operator/ for the show notes.  Have fun on the SQL trail!

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 back the corrupted data and get everyone back on track.

In May of 2015, Steve Stedman set the data community ablaze with his database corruption challenge. Some of the biggest names in the community jumped in with solutions to his challenge and I knew I wanted to have Steve on the show.

If you are interested in hearing more about his experience and his suggestions for dealing with database corruption, this episode is for you!