Happy Halloween, and have fun at the PASS Summit (wish I could be there, just didn't work out financially this year)!

I've seen one good implementation of Sharepoint, which ignored the workflow aspects entirely but made it very easy to keep project data in one place and share it effectively. ...

jjarupan (10/27/2009)

---

Backup, Update stats,DBCC, shrink the file, restart service etc, all done by jobs by the server itself or from monitoring server.

All can be done by set one computer...

skelly-806234 (10/27/2009)

---

There's no way you can come up with even a ballpark number of DBA's per server. With the right tools, a well set up infrastructure, reliable networks and well...

Roy Ernest (10/28/2009)

---

I got into an accident yesterday. A four car pile up. Thankfully no one got hurt bad. My whole body is sore. Hit my chest badly on the...

One thing you could do in that case would be to do a version of log shipping. Do an hourly backup, full or diff or log (mainly this would...

1. I generally prefer to let the presentation layer do the presentation. That means set the web page or application to display money, and it'll do so. ...

Do the two people doing those queries need up-to-the-second data for what they're doing? Would hour-old data or last night's data work for their needs?

Alternately, have you checked to...

I don't see DBA and BI as exclusive. I know less about BI than I do about other aspects of SQL, but that's merely due to what's been needed...

I generally use performance monitor and traces for that kind of thing. Haven't bothered with a commercial tool.

Check these:

http://www.sqlservercentral.com/articles/Auditing/63247/

http://www.sqlservercentral.com/articles/Auditing/63248/

There are a lot of factors that go into that kind of decision.

If the datacenter server is designed for any sort of load at all, two people running a few...

Use row_number().

;with TopDates as

(select row_number() over (order by DateColumn desc) as Row, *

from dbo.MyTable)

select *

from TopDates

where Row<=2;

Or use Top (2).

select top 2...

I could be mistaken, but so far as I know, the whole idea of using something other than the default port number is to make it so you have to...

Is the pc on a domain? If so, you can control the security quite easily.