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!
Benefits of a Cloud-Based Enterprise Data Warehouse
Here's why you should make the move to a Cloud-Based EDW.
How to use Change Data Capture
Here's a step-by-step tutorial on using the Change Data Capture function.
SSIS Safari Adventure: How to Hack an XPath through the Occasional ETL Jungle
Our guide on how to hack an XPath through the ETL jungle in SSIS.
Loading Data from Azure Data Lake Store to Azure SQL Server via SSIS
How to Load Data from Azure Data Lake Store to Azure SQL Server via SSIS
Creating Restful Web Services with Web Tokens and Azure Active Directory
How to add Restful web services using Web API 2.0 in MS Visual Studio, protect our APIs with Azure Active Directory using OAuth 2.0, OIDC, and JSON web tokens
SQL Server – PIVOT/UNPIVOT Clause
Understanding the benefits of the PIVOT/UNPIVOT Clause in SQL Server.
SSAS Dimensions and Cube Basics
Explaining SSAS Dimensions and Cube Basics.
Pros and Cons of Dynamic SQL
The pros and cons of Dynamic SQL and how to use it.
Setup and Usage of R in SQL Server 2016
How to setup and use R in SQL Server 2016 using the SQL server R Service.
Flowchart: How does an Enterprise Data Warehouse Work?
A flowchart to better understand the function of an enterprise data warehouse.
Implementing an Enterprise Data Warehouse and Determining its Business Value
Understand the 3 main strategies used when implementing a enterprise data warehouse.
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.
The Comprehensive Video Walk-Thru of the Azure ML Toolkit
The comprehensive set of video walk-thru tutorials for the Azure ML Toolbox.
How to Use Powershell or SSIS to Download a Sharepoint File
Here's how to download and access a Sharepoint file via Powershell or SSIS.
Snowflake vs Star Schema
How to choose between a Star Schema or Snowflake Schema when your building a data warehouse.
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.
SQL Azure Job Agent Using Azure Automation
How to use Azure Automation to schedule executions of stored procedures on your SQL Azure database.
SQL Server 2016 – How to load data into SQL Server using JSON Functionality
SQL 2016 brings in many new features such as Data Masking, Always Encrypted, multiple TempDB database files, Query Store, JSON support, Row Level Security, R, and Stretch Database etc. Today we are going to focus on one of my favorite which is JSON support.
Switching Tables in a SQL Server Database to a New Filegroup
Sometimes you may find your SQL Server database is performing at suboptimal levels. After a lot of use, especially in a production environment, your database will have endured a high number of transactions, object creation and drops, and these can lead to fragmentation of the data at the disk level. You may also find that your database is quite large, but it has some empty space. However, when you attempt to shrink the database, you cannot do it. In this case, a common culprit is fragmentation.
Setting Up Schema, Roles, and Database Permission for Users
This procedure code should help you out with setting up an environment for your users and save yourself the extra steps of manually creating group, schema, and granting permission.
Configuring Environment Variables for an SSIS Package
For all the devs out there - how do you configure the environment variables for an SSIS Package? Our preference is to create package and using parameters and variables to create two separate environments of the same package. In this post, we'll show you how.
Analyzing Source-Target Mappings for SQL Stored Procedures
If you want to analyze or create a particular job, Integration Services (SSIS) package, or other form of ETL in Microsoft SQL Server, one of the first things you may want to do is take a look at all the stored procedures you are running and determine which ones need to run before others.
Big Data & Marketing
As a business intelligence professional, I am always keeping an eye on developing trends in the industry and recently I came across an article on the "Top 8 Big Data Trends That Marketers Should Care About." Being a part of the Redmond office, I have the opportunity to see our marketing team in action and appreciate the work that they do. This article naturally piqued my interest as I see the team work diligently to help clients develop sound marketing strategies to grow their businesses and streamline their day-to-day business operations. MORE
Using Metadata to Simplify Database Administration
When creating a database and an ETL process to either load or extract from it, you can help yourself quite a bit by creating a metadata repository. The benefit of this metadata is that you can use it to create data-driven ETL and other processes: instead of creating numerous lines of code for each particular object, you can create a dynamic process which uses metadata to perform the appropriate ETL for all your objects.
Parallel Optimization in SSIS 2012
Being able to run multiple stored procedures in parallel can provide a major performance boost when loading a data warehouse. In this post, I’ll describe a process which will take full advantage of server resources by running multiple procedures in parallel.
SQL Server Integration Services Fast Load – So Fast and So Clean
The difference between running an SQL Server Integration Services Fast Load and a Stored Procedure.