Finding SQL Server views with (or without) a certain property

In this tip Aaron Bertrand uses SQL Server metadata queries to discover SQL Server views that have certain properties or use certain syntax.

Using Views to Expose Encrypted Data in SQL Server

I'm using SQL Server's built-in encryption to hide data in one of my SQL Server databases, but this is a reporting system and my end users need to be able to query the data without having to remember the specialized decryption functions. Is there a way to do this? Yes, there is, via the use of views.

SQL views

Divide by zero

VIEW - 9

View - 8

What a View

I need to create views? How many? Today? This article talks about a few issues with using views too extensively in your design.

Views and Dependencies

Be sure to understand the consequences of modifying underlying tables and the affects they can have on Views

SQL View: Beyond the Basics

Joe Celko delves into the main uses of views, explains how the WITH CHECK OPTION works, and demonstrates how the INSTEAD OF trigger can be used in those cases where views cannot be updatable.

SQL VIEW Basics

SQL Views are essential for the database developer. However, it is common to see them misued, or neglected. Joe Celko tackles an introduction to the subject, but there is something about the topic that makes it likely that even the experienced developer will find out something new from reading it.