Category: SQL
-
Four tools to help you become a better data analyst
Four Tools to Help you Become a Data Analyst Gathering and analysing data has changed how business decisions are made and how resources are allocated. Through a better use and understanding of data, business managers can plan and enable better strategies with increased confidence. When understood, the companies data can increase administrative efficiency and add…
-
When testing ETL tools here are 5 things to bear in mind
As it is officially braai (barbeque, BBQ) season in South Africa, I decided to compare the elements involved in testing ETL tools with that of a braai. After all, you would not simply light a fire and throw your carefully selected steak onto the flames. There are several steps you take in the process to…
-
Quick Windows Server 2008 R2 – SQL Server Firewall setup
Setting up SQL Server 2012 I received the same warning I have always received when setting up a SQL instance on a new Windows server: So I executed my handy Windows Server Firewall batch file for SQL to set up the default ports on the Firewall, which executed successfully, but I noticed the following warning…