Info

SQL Data Partners Podcast

In this podcast, I discuss a variety of SQL Server related topics mixed with a sprinkling of professional development and I talk with some of the biggest names in the industry. I want to introduce new and familiar topics and talk about them in a way you may have not considered. We are all on different stages as data professionals. I hope you will join me and Steve on the SQL trail compañeros--you won't regret it.
RSS Feed Subscribe in iTunes
SQL Data Partners Podcast
2017
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: June, 2016

Companeros, welcome to the SQL Data Partners Podcast, a podcast dedicated to SQL Server related topics which is designed to help you become familiar with what’s out there, how you might use features or ideas and how you might apply them in your environments.

Jun 29, 2016

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 policy, and in the engine itself and in episode 50 of the SQL Data Partners Podcast, we review some of these SQL Server settings and how you might take advantage of some and avoid others. Join me as I chat with Justin Randall about some of these settings and get introduced to my new co-host Steve Stedman!

Show notes for today are available at http://sqldatapartners.com/justin

Jun 22, 2016

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 Sheffield and I talk about the differences between these two objects.  Whether it around performance or coding standards, it seems everyone has an opinion about these objects. 

Check out the show notes for today's episode at http://sqldatapartners.com/2016/06/21/sql-server-temp-tables/ and I will see you on the SQL Trail compañeros!

Jun 15, 2016

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 the subject and how things are changing . . . and how they are staying the same. 

Jun 8, 2016

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 professionals, it is incumbent upon us to understand how these tools work and put them to their best use--before somebody else puts them to sub-optimal use.  I am joined by Kevin Feasel who walks us through some of the technologies available and sorts out under what circumstances we want to consider using each one.

Jun 1, 2016

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 enlist the help of Jen McCown from the MidnightDBA team to discuss approaches to unraveling code.  We tackle the issues of nested views, documentation, formatting, Hungarian Notation, and visualizing how all the code pieces fit together.

At the end of the day, we just want our code to be understandable and usable for the next person who has to review it, because that next person just might be you.  :)

Get the show notes for today's episode at  http://sqldatapartners.com/2016/05/31/unraveling-code/ and I'll see you on the SQL trail!

1