Episode 186: Analytics & Security: Find Pain Points, Make a Plan

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 situation, you are putting yourself in the drivers seat. So how do you go about putting together the pieces you need identify your IO constraints? I chat with Theresa Iserman, a premier support engineer at Microsoft about some of her thoughts and why IO in general is an issue. She gives us some guidelines and even some metrics to check out. Join us in the conversation, and I'll see you on the SQL trail . . . As always you can check out the show notes at http://sqldatapartners.com/2015/12/22/iotuning/

23 Joulu 201528min

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 eight years.  I catch up with Adam Machanic to talk a bit about how the procedure came to be, how he uses it and what is in store down the road. If you are using SQL Server and haven’t used sp_whoisactive before, I invite you go and download it right now, then come back and listen to the program.  We will wait for you.  Ready?  Let's do this. Have fun on the SQL trail compañeros. You can see the show notes for today's episode at http://sqldatapartners.com/2015/12/15/sp_whoisactive/

16 Joulu 201530min

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 and discuss some of the similarities and differences between the two. A consultant now living in New Zealand, Reza has lots of experience with the data management and gives us the scoop on the initial offering of this new Azure tool.  I hope you enjoy the episode.  If you have some feedback or comments, feel free to reach out on Twitter--I am @CarlosLChacon   You can see the show notes at http://sqldatapartners.com/2015/12/08/azure-data-factory/

9 Joulu 201531min

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 fellow podcasters about their experience with mentors and the characteristics we think good mentors have. Experience is simply the name we give our mistakes. -Oscar Wilde Be brave. Take risks. Nothing can substitute experience.  -Paulo Coelho Experience is what you got by not having it when you need it. -Author Unknown [A mentor and mentee] is the third most powerful relationship for influencing human behavior (after the family and couple relationships ) if it is working. -Richard E. Caruso, PhD  Part of the reason I have the podcast is to help bring to light some thoughts and ideas you may not have considered.  I hope this continues with today's episode.  I hope you check it out. You can see the links to the other podcasts at http://sqldatapartners.com/2015/12/01/role-of-mentors/

2 Joulu 201534min

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.

25 Marras 201534min

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/

18 Marras 201526min

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/

11 Marras 201525min

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

4 Marras 201529min