Environment Variables in SSIS Packages and Configuration Tables
Configuration tables are a best practice in just about any SSIS environment. They make it easy to update multiple packages...
2013-08-12
2,150 reads
Blog Posts
Extreme Transaction Processing (XTP, Hekaton) – the solution to everything?
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
My complete last...
2013-08-12
2,179 reads
I Hesitate to Commit
At work my boss this week my boss gave me some quotes about me. We solicit feedback twice a year...
2013-08-12
2,234 reads
SQL – One Query to fetch SQL Jobs Details of All SQL Version – 2000/05/08/R2
Single Query to fetch complete details of sql jobs and you can run it across different version of SQL [2000/2005/2008...
2013-08-12
8,165 reads
SQLSaturday Curacao 2013
Are you looking for some beach time? I know I am. I also know that I will probably get some of that beach time at an upcoming SQL Saturday....
2013-08-12
9 reads
SQLSaturday Curacao 2013
Are you looking for some beach time? I know I am. I also know that I will probably get some...
2013-08-12
664 reads
SSRS – Download all RDL files from Report Server in one go.
Introduction
People working on SSRS are well aware that “Report Manager” does not support downloading all the report files (.rdl files)...
2013-08-12 (first published: 2013-08-07)
13,397 reads
Summer absences, upcoming appearances, and…
It’s summer here in the northern hemisphere, and in Texas we’re getting 100F-plus weather pretty consistently. This brain-frying weather may...
2013-08-12
579 reads
You should NOT attend the PASS Summit
If you asked me, prior to today, if I would type or say those words, I would have laughed right...
2013-08-12
743 reads
SQLSaturday #235 NYC Super Countdown! - Almost Here!
And so, the countdown begins for the super spectacular,
extraordinarily exceptional, amazingly awesome, fabulously fantastic confab
that is known as SQLSaturday
#235 in...
2013-08-11
863 reads
Blogs
Accept the no and move on
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
Don’t Fight with AI
By Steve Jones
I was recently trying to handle a simple task with a few AI tools...
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Forums
Alamat BCA KCU Bumi Serpong Damai Tlp:0817825533
Hub Via Wa:62817825533 Alamat: Wisma BCA BSD City, Kav. CBD, Jl. Pahlawan Seribu Lot...
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers