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.
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.
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.
The Influence of the Cloud
This Friday Steve Jones is talking clouds. In the next year, will the cloud influence your job or will it be a fad for you?
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.
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.
Marketing Data is Exploding
The explosion of social media data has resulted in a lot more marketing data for companies. Some are using it well and some aren't, but in both cases, Steve Jones notes there are more opportunities for data professionals.
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.
Learning C
As we use computers more and more, and more people must develop algorithms or simple programs, Steve Jones says everyone should learn C. Perhaps they should learn SQL as well.
Blogs
Creating a Pulsing Conducting Baton - Part 1
By Bert Wagner
Train Wreck The last time I watched a high school band nearly fall apart mid-performance...
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Forums
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Distance Metric Algorithms
Comments posted to this topic are about the item Distance Metric Algorithms
What Can AI Really Do?
Comments posted to this topic are about the item What Can AI Really Do?
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers