|
|
-
|
|
This is by far the simplest and silliest post ever, but i just figured how to create vertical tabs in management studio. When I learn something, you have to read it. I apologize, but you have to read it. As Ellen DeGeneres says, “if I see something… you...
|
|
-
|
|
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 is Table...
|
|
-
|
|
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 resul...
|
|
-
|
|
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...
|
|
-
|
|
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...
|
|
-
|
|
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 Dat...
|
|
-
|
|
Given a customer table:
CREATE TABLE Customers
(CustId INT, OrderDate DATE, OrderAmount MONEY) ;
INSERT Customers VALUES
(1, ’2011-12-03′, 12500)
, (1, ’2011-10-07′, 15000)
, (1, ’2011-09-12′, 16000)
, (2, ’2011...
|
|
-
|
|
Charts present summary data in a visually appealing format. Following is a chart for sales over month:
Before
I frequently use a few options along with charts to get most out of them.
Show data labels:
It’ll be easier for the users to quickly read, if the...
|
|
-
|
|
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 ...
|
|
-
|
|
Apparently, SQL Saturday isn’t popular in the west. See for yourself. I wanted to see what cities frequently host SQL Saturday and ended up creating this dashboard. There are some interesting findings. Look at how the events are primarily confined to only ...
|
|