|
|
-
|
|
My blog has many practical tips and best pratices for SQL/BI developers,but I haven’t focused on interview questions for SQL/BI developers so far. This might change in the future. It’s been a challenge for many people to break into or stay competitive in the SQL/BI profession.
I am very......
|
|
-
|
|
I hope so far you are convinced that you need to learn at least one ETL tool in
order to stay competitive in the SQL/BI profession. I also hope that Microsoft SSIS
is your choice.
I’ve worked with two types of people with very different views on ETL tools.
One is ......
|
|
-
|
|
I am back from vacation, and have spent a couple of weeks catching up my workload. Now I am ready to finish the SQL Server BI Quiz “Mass Mailing Your Report”.
Here is my original blog, SSRS #55 – SQL Server BI Quiz “Mass Mailing Your Report”. Thanks to the following re......
|
|
-
|
|
In one of my many SSIS blog posts, I said that if you are using SSIS, sooner or later, you are going to create variables.
In this blog, I’ll say that, if you are using SSIS, sooner or later, you are going to be frustrated by the crazy syntax in Expressions.
If you are like me, who has been i......
|
|
-
|
|
For the purpose of this blog, my answer is 4. I’ve always wanted to do a benchmark comparison so I can proudly say that my “normal” way is the best in terms of run time. STAGE-TSQL: Use the data flow to bring the raw data into staging, and us...
|
|
-
|
|
I have several posts on how to pass parameters to
1) an OLE DB source in a data flow and
2) to an Execute SQL Task with OLE DB connection.
For case 2), the key is to use the correct mark for the passed in parameter. Different connection types demand different ways to mark the parameters.
For cas......
|
|
-
|
|
In a previous blog, SSRS & SSAS #61 – SSRS and SSAS Integration: how bad it is and
our hope with two types of data providers, I complained about how bad the integration
between Reporting Services and Analysis Services is.
Complain itself will not solve any issue. But......
|
|
-
|
|
What does Merge Join in SSIS do?
Merge Join task in SSIS is actually a very straightforward task to use, if you know this:
The Merge Join Transformation joins two data sets on a common key (or keys).
It is the same as performing an SQL Join – the options you have are Inner Join, Full Oute......
|
|
-
|
|
Some times, we need to “Pivot” our data to show data as a pivot table, instead of in tabular format. Here is an example. It runs total across and also vertically (at two different levels or groups). It also has ability to hide the details unless users click on the plus sign on the summar......
|
|