I received a question this morning about whether there are any ways to estimate the memory requirements of executing SSIS packages?  In the case of the question, the emailer wanted to know how to do things like find out the data size at the source and at the destination of a data transformation, or how to reckon the memory consumption of ...

Have you ever looked at the Windows Task Manager for a quick read on SQL Server 2005 memory consumption?   You can get good information from the Windows Task Manager about SQL Server memory, but you have to know what to look for. When running with AWE memory enabled on a 32-bit system, you may see an unusually low amount of ...

For some reason, the title of this blog post makes me grin because it evokes a mental image of one guy trying to comically strangle another guy.  But I digress…   Speaking at a user group meeting recently, an attendee asked whether the mirroring process had any capability to speed up or slow down its workload according to the amount of ...

As I've been traveling around speaking at various SQL Server user groups, I get requests for my slide decks.  Of course, I'm happy to share those, but I've got one better for you.  As it turns out, you can find five of my most recent webcasts here.  These are recorded webcasts that you can listen to any time.  I believe that ...

SQL Server MVP Kent Tegels recently raise an interesting question. SQL Server publishes a number of performance counters. In the code he's written that publishes performance counter data, he's had to explictly code the counter updates within his code regardless of knowing if any processes were consuming those ...