Category: Queries

• The Hidden SQL Server Gem: UPDATE from SELECT

  

  2015-08-19 - Fundamentals, General, Queries, T-SQL Statements

  Sometimes we need to update data in one table based on the contents of one or more other tables. Discover how the UPDATE from SELECT variation of SQL Server’s UPDATE statement provides an easy way to achieve this.

  [more…]

• Scripting All Logins on a SQL Server Instance

  

  2014-04-14 - General, Queries, Security

  Scripting all logins on a SQL Server instance can be helpful e.g. when setting up a test or development environment. Read on to see an example query for just this purpose.

  [more…]

• How to find all Implied Permissions using sys.fn_builtin_permissions

  

  2014-02-27 - General, Queries, Security

  Are you looking to get the complete list of implied permissions for a given permission? Read on to discover a query returning just that list, based on a recursive CTE against the sys.fn_builtin_permissions catalog function.

  [more…]