Jason McKittrick's Blog

Tag Archive for SQL Server

Understanding Fragmentation and its effects on SQL

Understanding Fragmentation and how it affects the performance of your database is critical.  Performing regular maintenance tasks that defragment and compact clustered and non-clustered indexes on tables and views. This will improve index-scanning performance. This should be run on weekly or fortnightly basis. Fragmentation can happen at several levels and if fragmentation is allowed to occur, overall…

SQL Server Recovery Models

There are several means by which SQL Server databases can be recovered. The recovery model set for the individual database determines the types of recoveries that can be performed and the amount of work and space required to protect the data. To understand how database backup works, there must first be an understanding of the…

SQL Server Row and Cell Level Security

With current regulations such as SOX, HIPAA, etc., protecting sensitive data is a must in the enterprise.  There is a published toolkit to implement Row Level Security (RLS) and Cell Level Security (CLS) using SQL Server Label Security Toolkit which is a free download from CodePlex http://sqlserverlst.codeplex.com/.  It makes use of a Security label in SQL…