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 opportunity to teach, Grant talks about why statistics are important and we go over some fundamental items you may just want to know about. As always compañeros, have fun on the SQL trail.
Be sure to check out the show notes at http://sqldatapartners.com/2015/09/29/statistics for information we chat about during the program.
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 be a big deal and it is always interesting to get other options on preparation. As data professionals, of course we want a way to be able to advance our careers and a certification can play a role in that, but we might have a bit of anxiety around it. The biggest take away for me from this session was Thomas's tool recommendation and how he was able to start better habits. I took his advice and have seen some results I may share in a latter episode. Have fun on the SQL trail compañeros!
As always, you can check out links for the show on the website http://sqldatapartners.com/2015/09/23/episode-10-test-anxiety-and-test-preparation.
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 support problems. We discuss strategies for starting your automation techniques and he gives a few pie in the sky examples if you are running a large environment. Compañeros, I hope you enjoy the program.
Be sure to check out the show notes at http://sqldatapartners.com/2015/09/17/episode-09-database-automation
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 that, according to Louis, the data type is not the most important component of database design. I hope you enjoy the show.
Be sure to check out http://sqldatapartners.com/2015/09/08/episode-08-database-design/for the show notes.
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 protect your data. Chris also unveils his security analzyer you can use in your environment to see what areas might need to be addressed.
You can check the full show notes at http://sqldatapartners.com/2015/09/01/episode-07-sql-server