Daily Archives: November 26, 2012

How Application Roles Work in SQL Server

One very interesting security technique available in SQL Server is the application role. It’s an interesting way of applying security to a user, and perhaps a way of preventing users from accessing data with unauthorized applications. An application role is … Continue reading

Posted in Blog | Tagged , | 4 Comments

Review Your Indexing

In the latest versions of SQL Server, there are some amazing new features. Many of them allow us to expand the capabilities of SQL Server, but some are added to allow us to dive more deeply into how the system … Continue reading

Posted in Editorial | Tagged ,