Iterating Through Excel Worksheets with Biml
Wrangling large or complex Excel workbooks in SSIS can be a challenge. From managing data types (more about that in...
2015-03-25 (first published: 2015-03-16)
7,726 reads
Tim Mitchell
On Failure: Getting Up
In my continuing series entitled “On Failure”, I want to talk about skiing.
I’m not a great skier. It would probably...
2015-02-16 (first published: 2015-02-06)
5,945 reads
Advanced SSIS Training in Dallas
I’m very excited to offer a new course entitled “Advanced SSIS” in the Dallas area this spring. My friend and...
2015-01-21
713 reads
On Failure
The first rule of blogging is that you should write about topics you know a lot about. And I know...
2015-01-09
683 reads
Six practical tips for social media success in 2015
Social media is the new résumé. In many ways, it’s even better than a résumé – a person’s social media stream...
2015-01-09 (first published: 2015-01-02)
6,042 reads
[OT] Blog is in maintenance mode
I’m spending part of this holiday break repaying some technical debt on my website. Among other things, I am importing...
2014-12-21
637 reads
On Perspective
Perspective can make or break a career. Maintaining a proper perspective is very often the differentiating factor between a good...
2014-12-10 (first published: 2014-12-03)
5,648 reads
SSIS Parent-Child Architecture in Catalog Deployment Mode
This is the third in a series of posts about SSIS parent-child architecture. You can find the index page here.
In...
2014-12-05 (first published: 2014-12-01)
7,312 reads
How to burn down your house while frying a turkey
It’s an odd query, yes, but in preparation to write this post I actually typed the above phrase into my...
2014-11-26
1,248 reads
Join me in DC for a full day of Biml
I’m excited to announce that my Linchpin People colleague Reeves Smith and I will be delivering a full day Biml...
2014-11-11
606 reads
Blogs
Monday Monitor Tips: CIS Compliant
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Forums
Vendor claims unused table space impacts performance
Hello experts, I got a report from an application owner of degraded performance for...
Automating Export of PowerQuery to SQL Server using DAX Studio...?
I wrote a PowerQuery that parses a table from a PDF, and I want...
Attaching an SQL Server database without Transaction Log Files through SQL Server Management Studio.
Comments posted to this topic are about the item Attaching an SQL Server database...
Question of the Day
Superseded Indexes
Which of these indexes is superseded by another?
See possible answers