Whitepaper : SQL Server in Simple Words

The world is full of interesting challenges and we are constantly running every single day chasing our dreams. Especially in the software ecosystem, it is not about literally our dreams but about the release scheduled in the next couple of months. We are on a constant run every single day and we stop appreciating the journey we are taking. As a developer or database administrator, we have our share of time working with SQL Server. In this process of working with SQL Server, the default tool of our choice is always SQL Server Management Studio (SSMS). Similar to the incident shared before, we spend so much time on this fun tool that we hardly appreciate or explore what the tool has to offer.

Security is a core area and non-negotiable when it comes to mission critical applications. We know how companies have lost business and lost respect in the press because of lack of security measures. With every release of SQL Server, there are tons of additions that get added as part of the platform. It is important to start using them in our application deployment design so that these loopholes can be avoided.

In this whitepaper, we will look at some of the capabilities available with SSMS that will make each one of us more productive. Read this whitepaper to learn tips and techniques for using SSMS. This whitepaper discusses some of the general best practices as they evolved with SQL Server versions and we took a note of specific SYSADMIN privileges and how we can secure our server using permissions. The eBook describes jumpstarting the use of SSMS, blocking and locking troubleshooting, demystifying debugging techniques with SQL Server, nuts and bolts of permissions and security, and SQL Server security practices.

Author: Pinal Dave

Pinal Dave is a Developer Evangelist. He has authored 11 SQL Server database books, 14 Pluralsight courses and over 2900 articles on the database technology on his blog at http://blog.sqlauthority.com. Along with 10+ years of hands-on experience, he holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET). His past work experiences include Technology Evangelist at Microsoft and Sr. Consultant at SolidQ.

Register to read the full whitepaper.

Topics : Database Administration,

Products : SQL Doctor,

Register for Free Whitepaper

Note: By filling and submitting this form you understand and agree that the use of IDERA’s website is subject to the General Website Terms of Use. Additional details regarding IDERA’s collection and use of your personal information, including information about access, retention, rectification, deletion, security, cross-border transfers and other topics, is available in the Privacy Policy.