Jason McKittrick's Blog

Monthly Archives: April 2015

Data Links

Over the years I have collected free Data Source links and assembled my favorites.  I have collected these from stumbling on them and some from colleagues. Enjoy! Updated 02/25/2017. Data Collectors National Weather Service Data Collector  https://github.com/thesqlgeek/WeatherData World The World Bank http://www.worldbank.org/ Gapminder http://www.gapminder.org/data/ United Nations Datasets http://data.un.org/ International Monetary Fund http://www.imf.org/external/data.htm Open Spending https://openspending.org/ CIA World Factbook https://www.cia.gov/library/publications/the-world-factbook/…

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…