Machine learning is an analysis of data to use it to drive answers. Data is derived by detecting statistical patterns and trends.

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!
Machine learning is an analysis of data to use it to drive answers. Data is derived by detecting statistical patterns and trends.
Process of automating business operations with the help of bots without human intervention is called Robotic Process Automation (RPA).
Power bi data gateway is used as a bridge between on premise database and cloud services to have up to date data.
Learn about common issues in a data warehouse and the approaches you can use to resolve them.
Here's why you should make the move to a Cloud-Based EDW.
Here's a step-by-step tutorial on using the Change Data Capture function.
Our guide on how to hack an XPath through the ETL jungle in SSIS.
How to Load Data from Azure Data Lake Store to Azure SQL Server via SSIS
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
Understanding the benefits of the PIVOT/UNPIVOT Clause in SQL Server.
Explaining SSAS Dimensions and Cube Basics.
The pros and cons of Dynamic SQL and how to use it.
How to setup and use R in SQL Server 2016 using the SQL server R Service.
A flowchart to better understand the function of an enterprise data warehouse.
Understand the 3 main strategies used when implementing a enterprise data warehouse.
How our team created course recommendations without Historical Data by utilizing Fuzzy Search and TF-IDF.
The comprehensive set of video walk-thru tutorials for the Azure ML Toolbox.
Here's how to download and access a Sharepoint file via Powershell or SSIS.
How to choose between a Star Schema or Snowflake Schema when your building a data warehouse.
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.
How to use Azure Automation to schedule executions of stored procedures on your SQL Azure database.
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.
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.
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.
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.
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.
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
The difference between running an SQL Server Integration Services Fast Load and a Stored Procedure.