Simple Series : SSIS Conditional Split
Conditional Split is a very powerful component, enabling you to send records in different directions or exclude them from the downstream...
2010-03-26
909 reads
Josef Richberg
Simple Series : SSIS Conditional Split
Conditional Split is a very powerful component, enabling you to send records in different directions or exclude them from the downstream...
2010-03-25
1,121 reads
Virtual Presentation : Index Statistics
I just gave a virtual presentation, courtesy of Pass and the appdev group. The recorded presentation is available here:
Recorded Presentation
A...
2010-03-23
626 reads
Business needs vs dirty reads
I have worked in many industries, but most of my time has been in the publishing industry. For those not...
2010-03-12
288 reads
Managing user data and response through 'drop boxes'
There are a few ways to get data from a client to your system; FTP or email. Internally we tend...
2010-02-24
617 reads
SSIS 2008 Script Component variable gotcha..
In a previous post I showed you how to access variables from within an SSIS script component. More specifically I...
2010-02-22
3,693 reads
SSIS 2008 Script Component variable gotcha..
In a previous post I showed you how to access variables from within an SSIS script component. More specifically I...
2010-02-17
775 reads
SSIS 2008 Script Component variable gotcha..
In a previous post I showed you how to access variables from within an SSIS script component. More specifically I...
2010-02-16
4,552 reads
Covering Index using Included Columns
This article from Josef Richberg details the benefits of included columns for use in creating a covering index to improve performance.
2010-02-11
12,899 reads
I've been published on Simple-Talk.
I am excited to say I have been published on Simple-Talk. This was my first foray into being professionally edited. I...
2010-02-09
323 reads
Blogs
Reverse Engineering a Physical Model Diagram
By Steve Jones
I recently wrote about a logical diagram with Redgate Data Modeler. That was interesting,...
Prepping for Certification, Part 3 of ?
By Brian Kelley
After I have understood the details for a certification test (part 1), including format...
SQL Training Black Friday Deals
By Brian Kelley
If you're looking for particular "Black Friday" deals, here is what I've seen advertised...
Forums
Best analysis approach to reduce data type length in multiple tables
Hello SSC, I hope everyone is having a happy and safe holiday season! I...
Do you separate data/log files and TempDB files on different disks using AWS EC2
Hello, I am receiving multiple direction on deploying SQL Servers in AWS EC2. ...
Service account being in local admin in AWS EC2 environment?
Hello, I am working with a company on their database administration. I am trying...
Question of the Day
A New Operator
In SQL Server 2025, what does this code return?
SELECT '1' || '0'See possible answers