White Papers

Debugging, though a tough option inside SQL Server, has come a long way with the integration with Visual Studio to make SQL Server Management Studio much more powerful. These additions to SSMS have increased the productivity of Developers and DBA’s alike. This whitepaper introduces you to the debugger techniques introduced with SQL Server 2012.

Whether you are preparing for an interview for a new job or vying for the next level within an organization, sometimes it’s hard to know where or how to get started. This eBook provides career tips that are helpful to database professionals that are looking to move their career to the next level.

DBAs face many challenges working with SQL Server. A lot of time is spent managing and troubleshooting this tool and there is not enough time to appreciate or explore what the tool has to offer. In this whitepaper, Pinal Dave shares some of his tips and techniques that utilize some of the capabilities available with SQL Server Management Studio (SSMS) that can help you enhance your productivity.

Linchpin People makes a business of performing WellDBA™ exams to help clients troubleshoot and optimize their SQL Server environments. This whitepaper summarizes a few of the top mistakes that they find organizations making. In most cases they are really things that DBAs just may not be aware of.

Security is often an afterthought when it comes to working with Software. In this whitepaper, we will take a tour of some of the basic fundamental blocks that define security inside SQL Server — permissions. We will also look at some of the enhancements introduced from a security point of view with SQL Server.

Developers or DBA have an natural inclination to work with SQL Server Management studio day-in day-out. Lesser known to then is the fact, how cool and productive their tool can be. This white paper will show some of the top 12 cool tips for working with a SQL Server management studio that you always wanted to know.

This paper outlines the security features introduced with SQL Server 2014. Have you ever wanted to keep an Administrator locked out? Did you have a scenario where you wanted to give only limited read access to the whole server for people like Auditors? This whitepaper fill focus on these topics extensively.

Locking and blocking are fundamental to any database to maintain consistency. In this paper we will look at the various ways to identify potential problems of locking and blocking, how they are different and what options SQL Server gives to resolve them.

Sybase ASE DBAs have always tackled complex tasks amidst shifting priorities, and pressures only continue to mount. This paper outlines trends impacting Sybase ASE DBAs and teaches techniques critical to streamline and automate database management.

As a DB2 DBA, you are expected to keep key database systems available and optimized for high performance. This paper details techniques to streamline and automate the management of critical areas required for high database performance and availability -- regardless of the database type or version.