April 2008 - Posts

• PowerShell Learning Resources Online

  PowerShell is all the rage! It is deeply integrated in SQL Server 2008, where you can start a PowerShell session from Management Studio, and create job steps which execute PowerShell scripts. SQL Server 2008 will also introduce some great new cmdlets. Read More... Posted Tuesday, April 22, 2008 10:10 AM by Lara Rubbelke | 2 Comments Filed under: SQL Server 2008, PowerShell

• Great Post on SSIS Destinations + More Information

  Another recycled post from days gone by... One of my favorite blogs on SQL Server Integration Services (SSIS) is by Jamie Thompson. He does a tremendous job sharing tips, tricks, and lessons learned from working with SSIS. Recently he posted a blog on Read More... Posted Friday, April 18, 2008 10:00 AM by Lara Rubbelke | 0 Comments Filed under: SQL Server 2005

• Memory Pressure on 64 Bit SQL Server 2005

  I have just learned that my old blog will be disabled, so I will be recycling some of the more meaningful blogs to SQLBlog. This was written last year during an engagement where I was troubleshooting an issue with procedure cache growth. The good news Read More... Posted Friday, April 18, 2008 8:00 AM by Lara Rubbelke | 3 Comments Filed under: SQL Server 2005, Maintenance

• What's in a name?

  A good friend recently asked me to explain the difference between Performance Data Collector, Performance Studio, and Performance Datawarehouse. Well, this is an interesting question, and I am certain many people have been trying to figure out how all Read More... Posted Thursday, April 17, 2008 2:43 PM by Lara Rubbelke | 1 Comments Filed under: SQL Server 2008