Archives: September 2009

OK, there was something that Microsoft did to tick me off.SQL Server 2005 introduced us to so many exciting and useful DMVs, such as sys.dm_os_sys_info.This DMV, which would give us a set of useful information about the computer, and about the resources available to and…Read more

As an official ‘Friend of Red Gate’ , I occassionally get direct updates and announcements from the company. They have an excellent suite of tools, which I have used and recommended at various client sites of mine.

Although I'm not promoting specifically any one product (with the exception of my own tools…Read more

Everyone remembers that in 32-bit windows architecture, in order for SQL Server (2005) to address more than 4GB of memory, one must enable the /PAE switch in the boot.ini, as a prerequisite to enabling AWE.

This short blog is not meant to rehash the memory architecture of Windows and SQL, nor… Read more

I was preparing my Blog for today on a subject I believe that would be useful to all DBAs having issues with scheduling an SSIS package under the SQL Job Agent. It's not as straightforward as you'd think, without understanding the security… Read more

It’s been a busy month of September, and I’ve been getting feedback from the busy world of SQL Server MVP’s and professionals all over the world.These days with social networking, email and the Internet, we’re all one big happy virtual community, and that goes double for us SQL…Read more

Labor Day, which marks the unoffical end of Summer in the U.S., is particularly poignant in light of the news of economy. While I'm not in the business of giving advice, I wanted to share my thoughts and some experiences in searching for a job or a contract position, as I commented in my… Read more

Not too long ago, I posted a blog on the possible thawing of the economy and job freezes, with good news for IT professionals. That according to data published by the Department of Labor, suggesting that there has been a "startling increase…Read more