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
915 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,125 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
629 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
289 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
620 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
780 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,555 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,913 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
324 reads
Blogs
Monday Monitor Tips: Intelligent Alert Thresholds
By Steve Jones
At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert...
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
Forums
String_agg not working as needed
I'm trying to get this string_agg to put all the 'comments' into one result...
Vectors in SQL Server 2025
Comments posted to this topic are about the item Vectors in SQL Server 2025
Odd Sequences
Comments posted to this topic are about the item Odd Sequences
Question of the Day
Odd Sequences
What values are returned from this code?
CREATE SEQUENCE NumericSequence
AS NUMERIC(5,1)
START WITH 1.0
INCREMENT BY 0.1;
GO
SELECT NEXT VALUE FOR NumericSequence
GO
SELECT NEXT VALUE FOR NumericSequence
GO See possible answers