SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: September 2009

Don't Tick Me Off...CPU Ticks

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

2 comments, 5,356 reads

Posted in Pearl Knows on 28 September 2009

New Tool: SQL Object Level Recovery Native ...by Red Gate

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

0 comments, 911 reads

Posted in Pearl Knows on 24 September 2009

MVP Profile of the Week.....

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

2 comments, 1,395 reads

Posted in Pearl Knows on 23 September 2009

Windows Tip - PAE - did you know that.....

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

1 comments, 881 reads

Posted in Pearl Knows on 21 September 2009

Random Thoughts for Monday..

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

0 comments, 471 reads

Posted in Pearl Knows on 21 September 2009

SQL Server High Availabilty Webinar

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.


The webinar is sponsored by Ntirety, and part of its ‘Always On:’ Ntirety Webinar Series. Ntirety has… Read more

0 comments, 927 reads

Posted in Pearl Knows on 18 September 2009

MVP Profile of the Week.....Jacob Sebastian

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

8 comments, 1,686 reads

Posted in Pearl Knows on 16 September 2009

Windows 7 to be released next month - SQL Server related info...

 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…

Read more

4 comments, 971 reads

Posted in Pearl Knows on 14 September 2009

September 11 - Never Forget - My story of the tragic day..........

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

4 comments, 1,317 reads

Posted in Pearl Knows on 10 September 2009

Labor Day Comes and Goes as Unemployment Grows......

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

0 comments, 841 reads

Posted in Pearl Knows on 8 September 2009

Job Market Update and some Job Search Advice…..

 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

3 comments, 1,401 reads

Posted in Pearl Knows on 4 September 2009