SSIS How-To: Reuse Existing Connection Manager to Execute SQL in Script Task
There’s a myriad of examples out there on how to execute a sql task via OLEDB connections and C# in a...
2012-04-09
3,275 reads
Blog Posts
Thoughts on Twitter
We hear a lot about social media these days: Facebook, LinkedIn, Google+, Twitter, etc. More and more, we’re expected to...
2012-04-09
964 reads
Calling Function / UDF using linked server
If one needs to call a UDF or System function ( ex: Serverproperty, Getdate(), etc ) on a remote server, then one...
2012-04-08
2,992 reads
The Kimball Approach
The Kimball Approach
There are a lot of misconceptions about dimensional modeling and the Kimball approach to building a DW/BI system....
2012-04-08
58,346 reads
Why shrink sql server data file failed?
Today I need to shrink a big data file, I know shrink file is not a best practise, and it...
2012-04-07
2,390 reads
24HOP Spring 2012 recordings
Many of the folks who are the PASS members, can have the possibility to watch 24 Hrs of PASS Spring...
2012-04-06 (first published: 2012-04-04)
1,954 reads
April 2012 Speaking Events
This month I’ll be out and about quite a bit with speaking events. Thought I’d detail them quickly in case...
2012-04-06
960 reads
Certification Exams: From the Other Side
Today I took the 70-464 beta exam today "Developing Microsoft SQL Server 2012 Databases" and after spending the last few...
2012-04-06
769 reads
Clean SQL Server Cache
I lives alone, usually, I clean my small apartment at every weekend, wipe the table/firniture with cloth, clean the capet...
2012-04-06
26,603 reads
Designing Database Solutions for Microsoft SQL Server 2012 Beta exam (70-465 / 71-465) – My Thoughts
After sitting the Administering Microsoft SQL Server 2012 Databases Beta exam (71-462) on Monday, I was still a little disappointed...
2012-04-06
1,369 reads
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
Bank BCA TLP/WA 08216977701
Jl. Daan Mogot No.48C 6, RT.6/RW.3, Jelambar, Kec. Grogol petamburan, Kota Jakarta Barat, Daerah...
BCA KCU CIKARANG CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Madison Square, Business Park Lippo Cikarang, Jl. MH. Thamrin No.163, Cibatu,...
BCA KCP Tmn. Harapan Indah TLP/WA 08216977701
Komp. Taman Harapan Indah Blok EE No.1, Jelambar Baru, Daerah Khusus Ibukota Jakarta 11460
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers