SQL Data Partners Podcast

Have you attended a SQLSaturday? They are great events and in this episode we chat with a few organizers about what goes into putting on an event and what they think the future of these events looks like. The show notes from today's episode can be found at http://sqldatapartners.com/2018/03/08/episode-126-sqlsaturday-edition. Have fun on the SQL Trail!

8 Maalis 20181h

Have you ever found it difficult to explain how something works to a co-worker?  What about reading documentation?  We have all been there before and in this episode we chat with Ray Kim about his thoughts on how we can be better at communicating technically. What is interesting is the number of tools that are now available to help us with communicating ideas; however, we all still struggle with communication. The show notes from today's episode can be found at http://sqldatapartners.com/2018/02/21/episode-125-you-must-be-an-engineer. Have fun on the SQL Trail!

28 Helmi 201841min

Perhaps you have heard about a runbook--the documented instructions you should follow in the event of a disaster or some situation where an outage occurs.  Instructions are great for IT folks as they give a reference to follow--and they don't freak out even if we might. They don't, however, include instructions for everyone--what about the folks that aren't tapping away on the keyboard?  In this episode, we chat with Greg Moore about his experience in emergency situations outside of IT and how we might apply these principles in our environment. Whether you are directly in the line of fire or support those that do, we think you will find this conversation interesting. The show notes from today's episode can be found at http://sqldatapartners.com/2018/02/13/episode-124-beyond-the-runbook-dr-organization. Have fun on the SQL Trail!

21 Helmi 201842min

Listener Eduardo Cervantes wanted to get our take on what developers should do when they get admin access to a database.  We take on this challenge and I give 5 points you might consider if you are a developer with admin access to the SQL Server.  As Uncle Ben in Spiderman quotes, "With great power comes great responsibility."  We hope you use yours wisely. The show notes from today's episode can be found at http://sqldatapartners.com/2018/02/14/episode-123-top-5-things-to-know-when-getting-admin-access. Have fun on the SQL Trail!

14 Helmi 201820min

Does not play well with others. Is this description appropriate for some of the queries in your database?  In this episode, we explore the role behind isolation levels--why they are important, what they help prevent, and why so many people try to get around the rules they try to enforce. The show notes from today's episode can be found at http://sqldatapartners.com/2017/12/20/episode-122-isolation-levels. Have fun on the SQL Trail!

21 Joulu 201741min

I have heard it said "People don't quit jobs--they quit managers".  At a recent event, I decided to ask people what they thought the qualities of a good manager are.  Perhaps you aren't thinking of getting into management; however, at some point in your career you will have the opportunity to lead.  We share your thoughts and comment on the challenges of having the qualities of a good manager. The show notes from today's episode can be found at http://sqldatapartners.com/2017/12/14/episode-121-what-makes-a-good-manager. Have fun on the SQL Trail!

14 Joulu 201731min

Shouldn't they have fixed that instead of putting out all these new features?  That might be what you are thought when you saw the title for today's episode.  SQL Injection is still a big deal in today's databases and we are pleased to have Bert Wagner on the program to talk with us about how it can affect you and the applications you protect. One of the most difficult aspects to deal with SQL Injection is to decide who is responsible for dealing with it?  Bert does a great job giving us some insights on what he has seen work and we invite you to give us your comments about how you have gone about trying to evade a SQL Injection attack. The show notes from today's episode can be found at http://sqldatapartners.com/2017/12/06/episode-120-sql-injection. Have fun on the SQL trail!

7 Joulu 201753min

At first glance you might think our podcast topic is from way out in left field; however, as you think about it there are a number of reasons we should be talking about GitHub.  Even if you don't need a public source control repository for creating code, GitHub is becoming the preferred place for creators to publish their content and the ability to interact with other is extremely value.  In this episode we give some of our thoughts around getting started with GitHub and how it might differ from some of the other options out there. Don't forget to leave your 'Tips and Tricks' on the podcast page.  If we get enough submissions, we will start that new segment in January. The show notes from today's episode can be found at http://sqldatapartners.com/2017/11/29/episode-119-should-i-get-involved-with-github. Have fun on the SQL Trail!

30 Marras 201739min