Learn about common issues in a data warehouse and the approaches you can use to resolve them.
© Exsilio Solutions 2013
All rights reserved.
What’s on our mind?
Exsilio Solutions is proud to introduce our new blog! Not only is this forum completely integrated with all our social networks, but it is also 100% responsive. Now, you can take Exsilio with you on your phone, tablet, and desktop - redefine what you thought possible!
Understanding Query Execution Plans in SQL Server Management Studio
A baseline on how to start using Execution Plans to improve your query performance.
SQL Server – PIVOT/UNPIVOT Clause
Understanding the benefits of the PIVOT/UNPIVOT Clause in SQL Server.
Producing Recommendations Without Historical Data by Utilizing Fuzzy Search and TF-IDF
How our team created course recommendations without Historical Data by utilizing Fuzzy Search and TF-IDF.
2 Google Analytics Segments to Unlock New Data Insights
2 Google Analytics Segments to you can create to unlock new insights in your data.
What is Business Intelligence?
Understand the core purpose of Business Intelligence and why it is valuable to an organization.
Snowflake vs Star Schema
How to choose between a Star Schema or Snowflake Schema when your building a data warehouse.
Accuracy, Precision, Recall & F1 Score: Interpretation of Performance Measures
How to evaluate the performance of a model in Azure ML and understanding “Confusion Metrics”
SQL SERVER 2016 – ISJSON Function
In my first post, How to load data into SQL Server using JSON functionality, I discussed one of the key functions of SQL Server 2016 JSON support, which is OPENJSON.
Today we will see another built in function of JSON, which is ISJSON.
ISJSON - This function is used to test whether a string contains valid JSON or not. It returns 1 if the string is valid JSON. If not, it returns 0. It returns null if the expression is null. We will check all of these return values.
Maps aren’t just for directions!
There’s a good chance that you looked at a map recently. Maybe it was the GPS in your car or on your phone. Or it may have been on an app to help you find a place to eat or fuel up at a gas station. Every time you use one of these maps you are utilizing a Geographic Information System. Until about 5 years ago, if someone said ‘GIS’ they were probably talking about ESRI’s ArcMap. Today, the term GIS is more ambiguous and can be applied to a lot of different solutions that involve a map. MORE