Nowadays, customer behavior becomes more complex and market trends continue to shift rapidly. Thus, businesses need specialized technological systems to make sense of the mountains of data they generate.
We’ve all seen devices that can connect over a shared network, algorithms that can predict future consumer behavior, and devices that can talk to you. Have you wondered how the data behind all these technologies are generated?
This article is the second part of the material dedicated to SSIS Multicast Transformation used to send the report data to multiple destinations.
In the previous section, we set up the environment for doing that task – refer to it to refresh your knowledge and recall the examples. In this section, we are going to use that data to design the Multicast Transformation solution and test-run it.
So, get back to the previously created project. We are starting the next stage of our work.
Have you ever been asked about creating arrays in SQL Server? Processing an array of values inside a procedure/ function in SQL is a common requirement. The question arises quite often, especially if you deal with Oracle specialists because Oracle has arrays. But the thing is, SQL Server does not have this.
Still, what if we need this functionality in the SQL Server environment? Fortunately, there are ways to resolve the issue. In this article, I am going to explain the most efficient alternatives to array in SQL Server.
The first time Karl heard of SQL Server CTE was when he was looking for something to make his SQL code easier for the eye. It’s kind of a headache when you look at it. Anton, his concerned colleague, asked him about CTE. Karl thought Anton was referring to his headache. Maybe he heard it all wrong, so he answered, “Of course not.” The funny thing is, he was referring to Chronic Traumatic Encephalopathy, also a CTE – a neurodegenerative disease caused by repeated head injuries. But based on Karl’s response, Anton knew for sure that his colleague was clueless about what he was saying.
What a crazy way to introduce CTEs! So, before you get into the same boat, let’s clarify, what is SQL CTE or Common Table Expressions in the SQL world?
You can read the basics here. Meanwhile, we’ll learn a bit more about what happened in this unusual story.
Read MoreA table is a two-dimensional logical structure and the fundamental means of storing data in relational database management systems. Its ‘row and column’ format is very much like the organization of the spreadsheet.
Each new record introduced to a table is a row (also called a record or tuple), while rows are grouped into a finite set of columns (also called fields or attributes). Each column has a name and data type, and it serves as a reference for displaying result sets when querying data from relational database systems.
In this article, we explore the current options letting us add new columns to an existing table in SQL Server database. The use case may arise on many occasions. Particularly, it happens when there are updates for an application, and they demand adding new columns.
Read MoreThis article aims to help beginners understand the basics of the T-SQL COALESCE function and its application for handling NULL values. Additionally, the readers will get hands-on experience by implementing some simple examples of this function.
We’ll also highlight the importance of T-SQL functions in resolving database analytical problems.
Read MoreCASE Expressions in SQL Server are used for the column values substitution to present the result sets in a particular fashion or simple queries. Use cases for such commands are various.
For instance, there is a column containing the department code, but you wish to display the department’s name rather than the code. You could achieve it by doing a JOIN with another table containing the department details. However, let’s assume you want to keep the query relatively simple. Another use case would be returning specific values for the computed values set. Computed columns would not fit if the sets of conditions to specify are not the same.
Read MoreWhen you develop large chunks of T-SQL code with the help of the SQL Server Management Studio tool, it is essential to test the “Live” behavior of your code by making sure that each small piece of code works fine and being able to allocate any error message that may cause a failure within that code.
Read MoreThe final article will take us through Power BI Visualizations and how to create them using the data sets created previously in these series. The walkthrough will cover 3 basic Visualizations: Table, Pie Chart, and Line Chart. These will then combine to create a basic report/dashboard within Power BI.
Read MoreThis article will cover off importing data, manipulating data, and finally managing relationships within Power BI. Again, like the previous article, this one will focus on the basic principles of using Power BI, as opposed to an in-depth walkthrough.
Read More