|
|
-
|
|
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.
Go get'em!
PragmaticWorks Webinars. T...
|
|
-
|
|
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 deplo...
|
|
-
|
|
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...
|
|
-
|
|
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...
|
|
-
|
|
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).
Jen McCown ...
|
|
-
|
|
Following in the foot steps of John Sansom (b|t), I’m going to post a roundup of links from other blogs every Friday. I’ll call this SQL Roundup. John calls his “Something for the Weekend“.
Each Roundup will have no more than 10 lin...
|
|
-
|
|
Problem
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.
Solution
One way to accomplish this is to declare a variable, populate it with the message you wan...
|
|
-
|
|
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...
|
|
-
|
|
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, Umm, i ...
|
|