August 2009 - Posts

• Simplified Virtual PC Creation with Differencing Disks

  If you regularly test software, or do development, then you probably use Virtual PC or one of the other virtualization technologies out there.  I like Virtual PC because it is free, easy to use, and gets the job done.  I used it for testing Read More... Posted Monday, August 31, 2009 6:07 AM by Jonathan Kehayias | 3 Comments Filed under: Presentations, Virtualization

• Ola Hallengren Releases New Version of Backup, Integrity Check and Index Optimization Scripts

  Ola Hallengren’s Backup, Integrity Check and Index Optimization scripts are pretty famous.  They have been covered by SQL Server Magazine and they have been reviewed on the following blogs: Aaron Bertrand's Blog Chad Boyd's Blog Greg Low's Blog Kevin Read More... Posted Wednesday, August 26, 2009 6:25 AM by Jonathan Kehayias | 0 Comments Filed under: Database Administration, SQL Server 2008

• Troubleshooting the SQL Server Memory Leak (or Understanding SQL Server Memory Usage)

  Learn how SQL Server allocates and uses the physical memory available on a server, as well as why SQL Server doesn't release memory like most other applications. Read More... Posted Monday, August 24, 2009 10:32 PM by Jonathan Kehayias | 10 Comments Filed under: Database Administration, Memory Allocation, Internals

• SQL 2008 R2 Breaks SSMS Addins

  If you are trying out SQL Server 2008 R2 CTP2 and you are a frequent user of Addin’s for SSMS like the SSMS Tool Pack or the SQL Server 2008 Extended Events Addin that I wrote, you will notice almost immediately that the Addin’s will not work and raise Read More... Posted Saturday, August 22, 2009 12:41 AM by Jonathan Kehayias | 17 Comments Filed under: SQL Server 2008, SSMS Addin

• Book Review: SQL in a Nutshell

  This week I came home from work to find a unexpected package waiting for me.  When I opened it, I found a copy of Kevin Kline’s ( blog / twitter / website ) latest edition of SQL in a Nutshell .  I forget now exactly how the topic came up, but Read More... Posted Monday, August 10, 2009 10:45 AM by Jonathan Kehayias | 0 Comments Filed under: Book Review

• Another Case of Online Plagiarism

  I don't know what the deal is lately online, but it sure seems like a lot of people are doing what they want to call reposting information, but in my mind I don't care how you sugar coat it, they are essentially plagiarizing information that was written Read More... Posted Friday, August 07, 2009 1:22 PM by Jonathan Kehayias | 4 Comments Filed under: Rants and Ramblings

• Scripting Database Attach for SAN based LUN migration

  Recently I have been involved in some cross server database migrations to balance load in my environment, and as apart of this, I have needed to provide some automation scripting.  To help minimize overall downtime the use of multiple SAN LUNs was Read More... Posted Wednesday, August 05, 2009 2:45 AM by Jonathan Kehayias | 1 Comments Filed under: Database Administration, Upgrades

• RANT: Got Performance Problems? Buy bigger hardware!

  Ok, so the title of this thread is very tongue in cheek, or in layman's terms a bunch of crap.  However, it is the most common answer I seem to get from application vendors these days when dealing with performance issues, despite the fact that I Read More... Posted Tuesday, August 04, 2009 3:32 AM by Jonathan Kehayias | 22 Comments Filed under: Rants and Ramblings