All Posts by Lori Brown


About the Author

Lori is an avid runner, cross fitter and SQL enthusiast. She has been working for SQLRX for 15 years and has been working with SQL in general for 25 years. Yup...she is an old hand at this stuff.

Jul 09

SQL Server Column Level Encryption and Query Performance

By Lori Brown | Helpful Scripts , SQL Administration , SQL Development , SQL Server

— by Lori Brown  @SQLSupahStah In my last blog post I showed how to implement TDE encryption on a database and the performance impact of doing so. Today’s post will show how to implement encryption at the column level and the performance impact as well as a way to help make queries using encrypted […]

Continue reading
Jun 03

Changes to System Views in SQL 2014

By Lori Brown | Helpful Scripts , Miscellaneous , Performance Tuning , SQL Server , Tip of the Month

There are two new system views and two system views that have new columns added in SQL 2014. Most notable is sys.databases since this is widely used.   sys.xml_indexes – Has 3 new columns: xml_index_type, xml_index_type_description, and path_id. sys.databases – Has 3 new columns: is_auto_create_stats_incremental_on, is_query_store_on, and resource_pool_id. sys.column_store_row_groups – New view.  Provides clustered […]

Continue reading