by Jeanne Combrinck | Oct 25, 2017 | SQL Girl
Recently been working with getting multiple SQL Instances on one machine to work. When I uninstalled an old one it affected the latest one. Then all of a sudden my ETL jobs failed. It did not make sense at all seeing as I removed a different instance. Got the...
by Jeanne Combrinck | Jul 24, 2017 | SQL Girl
While busy with query performance tuning and trying to see whether the query would run better using a CTE’s (Common Table Expression) or Temp tables and comparing times, I realised I forgot to think about adding indexes on my temp tables which could increase the...
by Jeanne Combrinck | Apr 9, 2017 | SQL Girl
PowerBI has released a fantastic template for Twitter called Campaign/Brand Management for Twitter. After following the “wizard” you will have a complete report filled with sophisticated analytics. In order to set this up, all you need is a twitter account and an...
by Jeanne Combrinck | Feb 20, 2017 | SQL Girl
When trying to install SQL, Windows Update KB2919355 is a prerequisite, and on a new server this is not always installed and the SQL install stops until it is rectified. Occasionally when you try and install the update you get the error KB2919355 is not applicable,...
by Jeanne Combrinck | Feb 2, 2017 | SQL Girl
Before you can deploy a SSIS project you need to set up SSIS in SQL Server Management Studio. When installing SQL you will select to install SSIS, however, it does not setup the SSISSDB or configure any settings for SSIS. Here are the steps for setting up SSIS in SQL...
by Jeanne Combrinck | Jan 4, 2017 | SQL Girl
Have you ever worked with code that is impossible to read and decipher? You could use SQL Prompt which will format the code into a readable format, however what if there is so much going on you are still unable to decipher what is happening? Recently I came across...