Views are handy constructs for abstracting security and simplfying queries, but they can have unexpected results sometimes. Longtime DBA Peter He takes a look at subquery issues in views.  Read more...

Views are one of the more basic constructs in SQL Server, but often it seems that developers are not sure when to use them. SQL Server expert DBA and trainer Andy Warren brings us a look at views as an abstraction layer in your database.  Read more...