Understanding Key SQL Server Security Points
I’ll be presenting a webcast this week on SQL Server security. We’ll be looking at the challenges of security, the points to consider, the items you need to consider for your checklist. The webcast is free, and I hope you’ll join me.
Here’s a link to register (it’s free):
https://www.vconferenceonline.com/event/regeventp.aspx?id=1140
One of the things I struggle with is understanding why security is sort of the after-thought in so many installations. It seems like it’s such a critical thing, but when it comes to just flat out including the planning in implementations, too many people just don’t consider it part of the mix. Until, of course, they get into a situation where they have to explain their security, or lack of it.
While there are many different points to security, and many different components to getting things completely locked down (or as much as they reasonably can be), it’s not insurmountable. It’s something that, given just a bit of thinking about it in advance can be done much more easily than after the fact.
From the first keystroke to the destruction of that data in your systems, there are many different phases your information will go through.
– Injection protection
– Access controls
– Firewall controls
– Permissions, login management
– Data at rest, data in motion
– Destruction of information and management of archives
– Data use considerations
These all factor in to protecting your systems. How do you manage your security? How do you manage who can do which things on your systems?