How To: Use the Same Data Flow Column Twice As a Parameter in SSIS
Every once in a while, you'll have a slightly more complex UPDATE statement in an OLE DB Command or Destination. ...
2011-05-18
1,378 reads
Where to put the logic? SQL? Code?
A discussion of where logic should go and why SQL might be the best place.
SQL is a powerful language and...
2011-05-18
844 reads
Not. Quite. There. This Time I Failed the Lab
Since I’ve been blogging about my progress through the SQL Server MCM certification, it makes sense to follow-up with my...
2011-05-17
680 reads
SQL Server 2008 SP1 CU14 and SQL Server 2008 SP2 CU4 Released
Microsoft has released two new Cumulative Updates for SQL Server 2008 SP1 and SQL Server 2008 SP2. The first one...
2011-05-17
1,528 reads
Presenting at Denver SQL Server User’s Group on May 19
I will be giving the main presentation at this month’s meeting of the Denver SQL Server User’s Group on May...
2011-05-17
600 reads
On Transactions, errors and rollbacks
Do errors encountered within a transaction result in a rollback?
It seems, at first, to be a simple question with an...
2011-05-17
13,279 reads
Updated SQLSaturday Advisory Council
About a year and a half ago we put together the first advisory council consisting of Andy Leonard, Kevin Kline,...
2011-05-17
701 reads
SQLRally Nordic
With all the talk about SQLRally Orlando you may have missed that we’ve got another SQLRally event in the pipeline...
2011-05-17
686 reads
DBA Brush-Up
I have a session I like to give called “Forgotton T-SQL”, or sometimes “T-SQL Brush-Up”. The idea is that there’s...
2011-05-17
794 reads
PASS SQLRally Orlando–We took the Checkered Flag
We did it! SQLRally happened and, from everything I heard, it was a success! That’s not to say that there weren’t some glitches and lessons learned, but we accomplished...
2011-05-17
5 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Alamat Kantor BCA KCU Cianjur Telp:08218154374
Hub Via Wa:628218154374 Alamat Jl. HOS Cokro Aminoto No.56-58, Muka, Kec. Cianjur, Kabupaten Cianjur,...
Alamat Kantor BCA KCU Depok Telp:08218154374
Hub Via Wa:628218154374 Alamat Jl. Margonda Raya No.182, Kemiri Muka, Kecamatan Beji, Kota Depok,...
Alamat Kantor BCA KCU Cibubur Telp:08218154374
Hub Via Wa:628218154374 Alamat Jl. Alternatif Cibubur RT.005/09. Kel. Harjamukti, Cibubur, Kec. Cimanggis, Kota...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers