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 1/20/2016. 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/ NOAA/NCEI weather and climate data http://www.ncdc.noaa.gov/ Government Data.gov…

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…