This blog post will explore three underused features that can significantly enhance your SQL Server experience. Let us discuss 3 Underutilized Features.
How to Enable Files & Folders Level Auditing in SQL Server? – Interview Question of the Week #176
Files kept vanishing from a client’s SQL Server Binn folder. SQL Server cannot track that, so here is how to enable Files and Folders Level Auditing in Windows.
SQL SERVER – Finding What Policies Are Enabled on Our Databases
A reader asked how to know which policy is enabled on a server. I explain how the policy engine uses target sets, then query what policies are enabled.
SQL SERVER – Introduction to Policy Management
Policy Management, added in SQL Server 2008, is an underappreciated feature. Here is an introduction to its building blocks and how the pieces fit.
SQL SERVER – Identifying Guest User using Policy Based Management
Can a policy catch a guest user left enabled in user databases? Here is a quick tutorial on identifying guest user access with Policy Based Management.
Policy Based Management Quiz: Which Mode Can Stop a Change?
This Policy Based Management Quiz asks which evaluation mode can stop a bad change before it is saved. The answer is On change: prevent. A tested T-SQL script blocks a badly named table and shows how few facets support that mode.
SQL SERVER – Policy Based Management – Create, Evaluate and Fix Policies
A full walk through Policy Based Management in SQL Server 2008: the policy framework, facets and conditions, then creating, evaluating and fixing policies.