Top 10 SQL Server Integration Services and DTS tips
Top SQL Server Integration Services (SSIS) tips from migrating and running DTS packages, to SSIS debugging, maintenance and programming in SQL Server 2005.
2008-01-02
5,713 reads
Articles
Finding Primes
While it's not likely that many of you need to find prime numbers using T-SQL, it is an interesting programming exercise. SQL Server guru Kathi Kellenburger brings us one solution after taking a break over the holidays and reading some popular fiction.
2008-01-01 (first published: 2007-01-29)
7,387 reads
Performance Tuning: Concatenation Functions and Some Tuning Myths
Rumor has it that Concatenation functions have gotten the nasty reputation of being "performance hogs". Here's why that's not true.
2008-01-01
22,422 reads
SQL Server Security Model
Greg Larsen discusses the different options available within SQL Server 2005 for managing security.
2008-01-01
2,853 reads
Becoming A DBA, Part 2
Buck Woody discusses the hard-earned knowledge and experience that you'll need to gain in order to stand out as a and professional and exceptional DBA.
2007-12-31
8,083 reads
The Dynamic Process of Loading Data
When loading a data warehouse, handling the ETL process of working with files can be problematic. Longtime DBA Janet Wong brings us an interesting solution that is flexible and efficient for quickly loading a number of files into a warehouse using DTS.
2007-12-31 (first published: 2007-01-23)
9,956 reads
The Weekly Update for Dec 31, 2007
Interviewing, Google as a monopoly, Cumulative Update 5 and more.
2007-12-31
119 reads
Add Custom Data Mining Algorithms to SQL Server 2005
Get a high-level overview of the benefits of the extensibility framework in SQL Server 2005 Analysis Services that allows independent software developers to easily integrate new data mining algorithms into the product.
2007-12-31
1,647 reads
A Christmas Time Saving Contest for DBAs
We've got a new contest running for the next week just for your production DBAs. Win a prize just for telling us a story.
2007-12-28
2,640 reads
Row-By-Row Processing Without Cursor
If you are a SQL Server DBA, you realize that the performance of cursors is not great and they should be avoided where possible. One place it is difficult to avoid cursors is individual row processing within a trigger. Amin Sobati brings us a new article that shows just how you can avoid this.
2007-12-28 (first published: 2006-12-07)
47,979 reads
Blogs
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
Forums
BCA KCP KHM Mansyur II TLP/WA 08218573837
By Quay thu XSMN hôm nay - quay thu MN - KETQUA.TV
Jl. KHM. Mansyur No.69, Krendang, Kec. Tambora, Kota Jakarta Barat, Daerah Khusus Ibukota Jakarta...
BCA Finance WTC Mangga Dua Telp/WA.0853°5504°2311
BCA Finance WTC Mangga Dua Telp/WA.0853°5504°2311 Gedung WTC Jl. Mangga Dua Raya. 8 Lantai...
BCA KCP Teluk Naga TLP/WA 08216977749
Jl. Raya Kampung Melayu No.1-2, RT.003/RW.04, Teluknaga, Kec. Teluknaga, Kabupaten Tangerang, Banten 15510
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers