TSQL Tuesday #63 – How do you manage security?


February 3, 2015 by Kenneth Fisher

Come on down! You’re the next contestant on T-SQL Tuesday! I’m your host Kenneth Fisher and this month I’d thought we might talk about security. Security is one of those subjects that most DBAs have to deal with regardless of specialty. So as something we all have to work with at some point or another what are some tips you’d like to share? What’s the best security design? You’ve picked up a legacy system and the security is awful, how do you fix it? Any great tools out there you’d like to share? Hate it or love it I’m betting we all have something to say.

What is T-SQL Tuesday

T-SQL Tuesday is a blog party started by Adam Machanic (b/t) just over five years ago. The first Tuesday of each month a blogger hosts the party and suggests a topic. Then anyone who is interested blogs on that topic. It can be a lot of fun and quite a challenge to blog on a topic you didn’t pick. Not to mention the time limit. I didn’t mention the time limit? Oh, well, you have one week to write your blog and then it has to be posted on the second Tuesday of the month. If you want to host just contact Adam and ask for a spot. I believe there is a requirement that you have to have participated at least a few times, but hey that’s only reasonable right?

How to join the party
  • Your post must be published between 00:00 GMT Tuesday February 10, 2015 and 00:00 GMT Tuesday February 10, 2015. Don’t be late!
  • Your post must contain the T-SQL Tuesday logo at the top (see above) and the image must link back to this blog post. Otherwise how will we know it’s a T-SQL Tuesday post?
  • Trackbacks should work, but if not please put a link to your post in the comments section so everyone can see your contribution!

26 thoughts on “TSQL Tuesday #63 – How do you manage security?

  1. […] and as this month’s T-SQL Tuesday (hosted by Kenneth Fisher – @sqlstudent144) is on the topic of security, that’s what this post […]

  2. Warwick Rudd says:

    Thanks Kenneth for hosting this month’s T-SQL Tuesday blog party. Here is my contribution to the party – http://www.sqlmastersconsulting.com.au/SQL-Server-Blog/t-sql-tuesday-63-how-do-you-manage-security

  3. dotdottelot says:

    Here is my contribution to this month’s TSQL2SDAY : http://t-sql.dk/?p=1104
    Thanks for hosting it Kenneth

  4. […] TSQL Tuesday!  Edition 63 is being hosted by Kenneth Fisher (@sqlstudent144).  The topic this month is security, and what a globally relevant topic it […]

  5. […] we look at security. Kenneth Fisher has chosen this as his topic for February and you can read his invite here. There are lots of choices on what you write about, and I’m looking forward to reading what […]

  6. Sir, thanks for hosting this month’s T-SQL Tuesday. Here’s my take on it http://www.edwinmsarmiento.com/tsql-tuesday-63-how-do-you-manage-security/

  7. sqlsanctum says:

    My first time contributing to TSQL Tuesday after just starting blogging this month. Thanks for hosting. https://sqlsanctum.wordpress.com/2015/02/10/t-sql-tuesday-63-how-do-you-manage-security/

  8. andreaallred says:

    Thank you Kenneth! Here is mine. http://royalsql.com/2015/02/10/ima-make-a-deal-with-the-sa-so-the-sa-dont-bite-no-more/ Extra points to anyone who can guess the song before I add it to my site playlist. 🙂

  9. […] This month’s T-SQL Tuesday (hosted by Kenneth Fisher – @sqlstudent144) is about security This hasn’t been my area of expertise for a long time, although I did write a long TechNet Magazine article about common security issues and solutions back in 2009. […]

  10. […] the invitation is for us to share our stories on how we like to manage security.  Or at least that is the request […]

  11. […] month’s T-SQL Tuesday is about how we manage database security, hosted by the ever effervescent Kenneth […]

  12. Somehow my own post didn’t ping back! So thanks me for hosting and here’s mine. https://sqlstudies.com/2015/02/10/dba-myths-you-cant-deny-something-to-a-member-of-db_owner-database-role/ (Yes I know I’m late but yesterday was a busy day. I posted on time I promise.)

  13. […] months T-SQL Tuesday is hosted by none other than Kenneth Fisher (B|T). His topic for this month revolves around security and how you manage security. There probably […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,755 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
%d bloggers like this: