Being in the computer industry is one of the most challenging things anyone can get into. When upgrading one’s knowledge to keep the data secure, there are a number of hurdles to cross. In this industry where we look for quick, fast responses from development to deployment to sales, everyone is expected to deliver without compromising any of the business parameters.
As we chase around the tough deadlines for delivery, the team tries to take shortcuts. This, for most cases, involves cutting corners and compromising on designing for secure systems. This is a concern for a number of organizations. DBAs love to build a secure system to deploy applications delivered from the Application team. Having said that, in this whitepaper I would like to get back to the basics of security. We want to cover some of the fundamental building blocks that were added with SQL Server since the 2005 version that are worth noting.