Hierarchies in SQL, Part II, the Sequel
In a followup to his first article on Hierarchies, Gus Gwynn takes a look at the performance of a few different methods of querying a hierarchy. Learn how the HierarchyID stacks up.
2012-08-21
8,015 reads
Articles
How To Support Multiple SQL Server Package Configurations in SSIS
I have several applications that use SSIS packages and I want to be able to store all the configurations together in a single table when I deploy. When a package executes I need a way of specifying the "application" and having SSIS automatically handle the package configuration based on the application.
2012-08-21
2,727 reads
Enforce business rules with indexed views and a two-row table
Here’s a technique that uses a view with a unique index and a dummy table with only two rows to trick SQL Server into enforcing your business rules.
2012-08-20
8,209 reads
The 2012 SQLServerCentral/Exceptional DBA Awards Party at the PASS Summit
The 2012 SQLServerCentral party at the PASS Summit is on and will once again include the awards ceremony for the Exceptional DBA of 2012. Get your tickets now.
2012-08-20 (first published: 2012-08-02)
1,379 reads
SSIS Basics: Introducing Variables
In the third of her SSIS Basics articles, Annette Allen shows you how to use Variables in your SSIS Packages, and explains the functions of the system-defined variables.
2012-08-20
3,122 reads
REPLACE Multiple Spaces with One
Replacing multiple spaces with a single space is an old problem that people use loops, functions, and/or Tally tables for. Here's a set based method from MVP Jeff Moden.
2012-08-17 (first published: 2009-11-16)
65,171 reads
Row Count Plus Transformation
As the name suggests we have taken the current Row Count Transform that is provided by Microsoft in the Integration Services toolbox and we have recreated the functionality and extended upon it. There are two things about the current version that we thought could do with cleaning up Lack of a custom UI You have to type the variable name yourself In the Row Count Plus Transformation we solve these issues for you.
2012-08-17
3,183 reads
Tell Us What You Think
Red Gate needs your help! Fill in our quick survey to help us improve our products – as a thank-you, you'll have the chance to win a Kindle Touch.
2012-08-17 (first published: 2012-08-13)
2,015 reads
2012-08-16
7,029 reads
SQL Server 2012 Integration Services - Using dtexec.exe to Run File System-based Packages
Marcin Policht explores a method of running SSIS packages that relies on the dtexec.exe utility.
2012-08-16
2,694 reads
Blogs
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
PowerShell Strikes Back: Know Your Quotes, Young Padawan
By gbargsley
This is Week 1 of PowerShell Strikes Back – a four-week May series for...
A Redgate Data Modeler Gotcha with Relationships
By Steve Jones
This happened to me recently after being busy with non-data modeling tasks for a...
Forums
BCA KCP Kampung Baru Telpon/wa:0821°8168°291
Kampung Baru Telpon/wa:0821°8168°291.Jl. Brigjend Katamso No.680, Kp. Baru, Kec. Medan Maimun, Kota Medan, Sumatera...
BCA KCP Plaza Medan Fair Telpon/wa:0821°8168°291
BCA KCP Plaza Medan Fair Telpon/wa:0821°8168°291.Gedung Plaza Medan Fair, Jl. Gatot Subroto No.30 GF-1G,...
BCA KCP Katamso Medan Telpon/wa:0821°8168°291
BCA KCP Katamso Medan Telpon/wa:0821°8168°291.Jl. Brigjend Katamso No.56 B-C, A U R, Kec. Medan...
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers