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
It’s time for the MVP Profile of the Week!
You’ve probably seen his work, as he’s been busy producing content for a number of web-sites, such as DatabaseJournal.com, SQL-Server-Performance.com, and of course, our beloved SQLServerCentral.com.
He’s written a lot on identifying the worst performing SQL statements, bringing us… 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
Hi, all! Hope everyone had a great weekend!
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
Always On: SQL Server High Availabilty
Just wanted to tell you all about a fantastic Webinar on SQL Server High Availability, coming your way soon! I have just registered myself.
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
I wanted disseminate some news to our DBA audience regarding the long anticipated release of Microsoft's new operating system, Windows 7, and what SQL Server Users can expect.
The New York Post reports in today's business section on the release of Windows 7, as we all get ready to say…
I was sitting going through some of my materials, scripts, emails and news feeds to find a worthy topic for today's blog, when I looked at the calendar and to my amazement, it is again SEPTEMBER 11.
We all know the worldwide what this date now infamously signifies - a clear… 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
Job Market Update and some Job Search Advice…..
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