Ways to get data out of

Microsoft BI is easy to use and is the largest growing BI platform according to Gartner. In order to get data out of Essbase it requires some magic. Below is a list of options to get data out of Essbase into another stack like Microsoft BI.  One other option that I didn’t include […]

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/ NOAA/NCEI […]

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 […]

SQL Backup Types and Backup

There are several types of backups to consider when planning a backup strategy. In this post I am going to talk about different backup types and talk through the strategies. The following list summarizes the database backup types: Full Database Backups – A full database backup backs up the whole database. […]