Perry Whittle (11/1/2010)

Use the Windows 2008 R2 OS for your host machine,...

Is there anyway we could try clustering on a windows 7 machine just for learning purpose.

Please advise.

On Windows 7 home, I am unable to see the local user management option from console. I get this error message.

"This computer is running windows 7 home premium. This snapin...

Perry,

I was referring your PDF for 2008 and in page 6 related to VMWare “Manage Virtual Networks” option, I am unable to click on 'OK' button after performing the actions...

You are absolutely right. I tried this from another client and I was able to view the job properties etc.

My question is, on a client machine how do I check...

Perry,

Thanks for your inputs. Could you please post the full link, there is nothing coming up when I click the hyperlink.

Also, as I don't have the Windows server 2008 or earlier version software, I am trying to download the

evaluation edition from Microsoft website

It is horizontal partitioning. But from select statement, how do we know?

Thanks Steve, it is my mistake.

I went to the right folder and now I installed 2 more named instances.

Yes, I have administrator access.

I was able to install the default SQL Server instance.

While I try to install another named instance, it is throwing this error.

Thank you all for your inputs. As per application team, parallelism on Informatica code level is not yet introduced in the ETL load job. This query belongs to an ETL...

By any chance, is there a policy template for detecting disabled jobs in a server.

If so, please share with me.

I found answer for the second part of question (regarding event class when a job is disabled).

These are below.

SQL:BatchStarting

EXEC msdb.dbo.sp_update_job @job_id=N'XXXXXXXXXXX',@enabled=0

SQL:BatchCompleted

EXEC msdb.dbo.sp_update_job @job_id=N'XXXXXXXXXXX', @enabled=0

Thansk NJ.

On some servers which I support, there are several cases where we need to do RCA (root cause analysis) when there is performance issue like slowness etc.

Usually during...

Today, I got to know of the black box trace too which can be configured in SQL Server. Infact, it is a feature that is available in SQL Server 2000...