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,460 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,580 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,004 reads
Blogs
Top 8 Courses to Learn SQL for Data Science in 2024 & Beyond
In the realm of data science, SQL (Structured Query Language) reigns supreme. It's your...
Going to Cloud? Look at the Shared Responsibility Model
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
How Long Will It Take to Learn SQL? The Truth Might Surprise You
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
Forums
Restore dbs
The below code works for backup files only from local drives. When replaced with...
Fine-tune SQL for better performance
I have been asked to fine-tune the following SQL that was written by a...
Row-level security in SQL server
In this scenario, I seek assistance in implementing row-level permissions for a table named...
Question of the Day
Initial Config of tempdb
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers