Info

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 sqldatapartners.com/podcast and leave a comment if you have a topic you think we should discuss. We’ll see YOU on the SQL Trail.
RSS Feed Subscribe in Apple Podcasts
2020
September
August
July
June
April
March
February
January


2019
December
November
October
September
July
June
May
April
March
February
January


2018
December
November
October
September
August
July
June
May
April
March
February


2017
December
November
October
September
August
July
June
May
April
March
February
January


2016
December
November
October
September
August
July
June
May
April
March
February
January


2015
December
November
October
September
August


Categories

All Episodes
Archives
Categories
Now displaying: November, 2015

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 sqldatapartners.com/podcast and leave a comment if you have a topic you think we should discuss. We’ll see YOU on the SQL Trail.

Nov 25, 2015

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 performance and there is new technology on the horizon to allow us to access our data even faster.

I talk with Justin Strong and Ananda Sankaran from Micron Technologies about their experiences with SSD and how organizations are using in their environments.  We also chat about some of the new technologies on the horizon for Micron.

Check out the shownotes at http://sqldatapartners.com/2015/11/25/ssd/ for links to topics discussed in today's episode.

Nov 18, 2015

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 up with Bill Fellows and Cathrine Wilhelmsen in Portland and they shared with me some insights on BIML, what they use if for, and some tips on getting started.  If you find your self doing more SSIS packages and haven't yet tackled BIML, this episode is for you!

Check out the shownotes at http://sqldatapartners.com/2015/11/17/biml/

Nov 11, 2015

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/

Nov 4, 2015

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

1