Creating a SSIS Custom Source Component
In this article author Paul Mu shows us how you can create a custom component for the new SQL Server 2005 Integration Services environment.
2007-01-17
17,594 reads
Paul Mu
- Interests: Travelling, Movies and Learning a Foreign Language
Moving Your Database to a New Server
As DBAs we try our best to appropriately size a SQL Servers to match the anticipated load. But things change over time and we may find that some databases are overloading the server. When it's time to move your database to a new home on another server, Paul Mu brings us a technique for doing so.
2006-11-16
15,604 reads
A Guide to Application Memory Tuning
Working with memory in SQL Server and tuning your server for optimum performance gets more complex all the time, especially with the availability of 64-bit platforms. New author Paul Mu brings us a short guide to using the /3GB and PAE switches along with their implications for your server.
2006-10-16
9,029 reads
Blogs
Reverse Engineering a Physical Model Diagram
By Steve Jones
I recently wrote about a logical diagram with Redgate Data Modeler. That was interesting,...
Prepping for Certification, Part 3 of ?
By Brian Kelley
After I have understood the details for a certification test (part 1), including format...
SQL Training Black Friday Deals
By Brian Kelley
If you're looking for particular "Black Friday" deals, here is what I've seen advertised...
Forums
Best analysis approach to reduce data type length in multiple tables
Hello SSC, I hope everyone is having a happy and safe holiday season! I...
Do you separate data/log files and TempDB files on different disks using AWS EC2
Hello, I am receiving multiple direction on deploying SQL Servers in AWS EC2. ...
Service account being in local admin in AWS EC2 environment?
Hello, I am working with a company on their database administration. I am trying...
Question of the Day
A New Operator
In SQL Server 2025, what does this code return?
SELECT '1' || '0'See possible answers