A surrogate key is an auto generated value, usually integer, in the dimension table. It is made the primary key of the table and is used to join a dimension to a fact table. Among other benefits, surrogate keys allow you to maintain history in a dimension table. Despite of… Read more
I occasionally review the search terms people use to get to this blog and secretly celebrate knowing my post helped them. If i know it didn’t, i add it to the list of items i should write about. This post is a result of one such thing.
Note: If you… Read more
Topic for this month’s T-SQL Tuesday, hosted by Aaron Nelson (@SQLVariant) is Logging.
I like to think of logging as a Flight Data Recorder (FDR) to an aircraft. FDR records data about functioning of an aircraft. No one cares what is in there as long as the aircraft… Read more
As I learnt a few things about blogging, I made a list of tips to get better at blogging. Thought I would share.
- Pour your heart out to answer a question. When someone asks a question, it means they followed your post hoping they would find an answer to…
You might constantly see a warning message that appears like the one below when creating Analysis Services Tabular projects. It basically says, workspace database server ‘ServerName’ was not found.
You’ll have to change this setting from the model properties. The server should be an Analysis Services Server running in Tabular… Read more
I hear you. You’ll use the Execute Package Task. This mechanism of executing one package from another is popularly knows as Parent Child paradigm. Let me tell you, this isn’t new in 2012. There are, however, a few changes to the Execute Package Task. Let’s take a look.
In DTS, changing package properties was close to impossible (the less we talk about DTS, the better). Package configurations introduced in 2005 solved most of the problems. In 2012, SQL Server Integration Services introduces parameters to make this process even easier. Parameters allow you to change package properties without the… Read more
I frequently attend a few online training events that greatly help me learn new things. Thought I would share, if may be you are interested too. These are all cool people sharing information for free to the community.
- PragmaticWorks Webinars. Training events on the T’s – Tuesday’s…
Andy Leonard blogged about a gotcha when creating SSIS projects using SSDT yesterday. He showed that you can use any component in SSDT whether or not your SQL Server supports that component. For example, you can create a package with Fuzzy Lookup and deploy to a server running Business Intelligence… Read more
I spotted a new task in
SSIS 2012 – Execute T-SQL Statement Task. It executes T-SQL statements, only Transact-SQL statements against SQL Server databases. Cool, but don’t get too excited. Why? Because you can neither parameterize the SQL nor save the results to a variable.
The task editor looks… Read more
There are a few design choices that can make your SSIS packages run super fast when loading data from table A to table B.
SQL Command at Source
OLE DB source editor allows you to choose either a table or a view from a drop down if data access mode… Read more
Howdy! I was flying last week, and for the first time i sat facing a flight attendant. You don’t actually sit face to face with anybody in a flight, because, you know all the seat rows are facing in only one direction. But attendants sit in the opposite direction. That… Read more
Business users are often interested in finding distinct counts in addition to other aggregations. They may want to know the number of distinct customers calling customer support, the number of distinct employees selling business, or the number of distinct products that are being sold. Note the difference between distinct count… Read more
Welcome to another week of SQL Roundup. Just in case you missed, SQL Server 2012 was released this week and you can download the evaluation edition here.
Clever and great improvisation. Create tag cloud style reports using SSRS. (Jason Thomas).
In this short post, I’ll discuss NoRowsMessage property. When there is no data for a data region, the message you specify for the NoRowsMessage property will displayed to the user instead of a blank report.
I created a report with a tablix and configured the NOROWS property from the tablix… Read more
Each Roundup will have no more than 10 links.… Read more
I’ve a SSIS package. When it fails execution, I want to write a custom message including the package name and error description to a text file.
One way to accomplish this is to declare a variable, populate it with the message you want, and write it’s value to… Read more
No matter how simple it is, new things come with some confusion; at least until you get used to it. Analysis Services 2012 Tabular is no different. This post will look at steps to create your first Tabular project.
Let’s start with firing up SQL Server Data Tools located under… Read more
I recently had a scary conversation with a user, which can be broken down to:
User: Why would the data have customers with a birth date of MM/DD/2020?
Me: What are you talking about? Lemme take a look.
Me again, this time with a changed voice: Umm,… Read more
Earlier, i discussed FIRST_VALUE() function. FIRST_VALUE() returns the first value from an ordered set of records. Similarly LAST_VALUE() returns the last value for an ordered result set, but you are in for a bit of a surprise if you aren’t familiar with the enhancements to the SQL windows functions. Read more