Legislative Bills. Legislation begins with the submission of a bill to the legislature for consideration. A bill is a draft, or tentative version, of what might become part of the written law.
SQL Server 2005: using symmetric keys to encrypt data. In SQL Server 2005, the recommended method for encrypting data is to use symmetric keys. A symmetric key can be created using the CREATE SYMMETRIC KEY statement. Information about symmetric keys is stored in the sys.symmetric_keys catalog.
Lock Granularity. 1  SQL Server can lock resources at the table, page, partition or row level. 2  If locks are escalated, SQL Server can also lock a single partition of a table or index. 3  SQL Server can also lock index keys and ranges of index keys if needed. Intent Locks. 2  As the name suggests is a pre-qualifiers to shared/update/exclusive locks. 3  Since SQL Server can acquire locks at different levels, before the process completes or the statements completes SQL Server might want to know if locks are already acquired.