Great suggestion. I'm working this weekend to make the FAQ area look identical to the scripts area, including the rating system. It should hopefully be up with any...

The reason I covered Active/Active was because it was the harder of the two configurations. If you don't install the second instance, then you have Active/Passive. Good luck!

Brian...

Finally wrapped up our initial deployment. Everything looks good so far.

Brian Knight

bknight@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bknight

Excellent idea. Thanks for sharing that.

Brian Knight

bknight@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bknight

I have to agree more with lua point of view and with Steve. In our market (Jax), potential employees aren't even being considered for Sr. potitions unless they have...

These would be great topics. I've sent a message to the PASS board members.

Brian Knight

bknight@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bknight

quote:

---

Perhaps PASS can help to create, define and advocate some standard roles for SQL Server

---

I...

Good question. The more involved you are in the forum, the software will automatically bump your status up for each post. I think the first threshold is 25...

You may want to run a SP_RESETSTATUS to change it to a fine status, then DROP DATABASE. You can also place it in "emergency mode" if that fails.

Brian Knight

bknight@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bknight

I've implemented this myself based on a Technet article. As long as the files are placed on separate drive letters, added parallel IO is created for SQL Server. It...

quote:

---

Does anyone bother to schedule database shrinks? Can it have a performance benefit?

---

You probably won't...

Look under the connection tab in the SQL Server Agent properties. Verify that that the acccount that is selected is a valid SQL Server login. If you ever...

He recently installed a Hitachi SAN and experienced the same problem. It wound up being the SAN's fault but it took a number of weeks to prove it. ...

I thought the data warehouse test was one of hardest tests I've ever taken. It had questions that were 2 pages long with each answer being a page long....

I'll ditto Wes. One thing that will remain a DBAs role for a while is performance tuning and scalability. Has anyone tried to implement a distributed partitioned view...