GilaMonster (5/30/2009)

---

The data pages are backed up as the backup process reads them, so pages early in the file may be as they were at the beginning of the backup,...

marc.schmieder (5/28/2009)

---

Marios,

We tried to run the script form the command line and he get an error. Are we supposed to use the computer name as a parameter on the...

marc.schmieder (5/27/2009)

---

When does data get added to the central DB? We have this setup and we saw data get added once, but it hasn't worked since then. The...

nagendrareddy.kolli (5/24/2009)

---

Hi,

Can some one send me the article which was talking about in the below.

"Found this article useful as a newbie to encryption methods. A dept in our company has...

RBarryYoung (5/22/2009)

---

Marios Philippopoulos (5/20/2009)

---

Hi,

Anyone have CLR code for replacing the functionality offered by the following procedures?

sp_OACreate

sp_OADestroy

sp_OAGetErrorInfo

sp_OAGetProperty

sp_OAMethod

sp_OASetProperty

sp_OAStop

Also, currently on our SQL-2000 instance, these procedures are being used for making web-service calls....

Jonathan Kehayias (5/22/2009)

---

What kind of service are you trying to call? There are generally 2 types, standard .NET webservices that have a ASMX that you can reference as a...

Jonathan Kehayias (5/21/2009)

---

These call into COM which is UNSAFE in SQLCLR. Usually you can get away from COM completely and into a managed provider for what you want to...

EdVassie (5/21/2009)

---

I think in SQL 2005 and above the OA procs can only be accessed by folks with Sysadmin authority. This means that anything monitoring your server has very...

Steve Jones - Editor (5/20/2009)

---

To me the risk is instability in the OLE item, or perhaps a misundertanding of how it can be used by the admin. What if that...

FNS (4/8/2009)

---

There's a push to get some sort of enterprise wide SQL monitoring software running which doesn't touch the "live" servers but runs entirely on it's own server, monitoring from...

Andrew Hatfield (5/17/2009)

---

Virtualisation is a great tool - however you still need to test your particular environment. Also, not all solutions meet the requirements of every problem - eg,...

Here is what caught my attention:

Traditional SQL Server performance monitoring uses the Microsoft Windows performance monitor tool PerfMon to collect statistics. SQL Server integrates with PerfMon to provide familiar counters...

David Benoit (5/14/2009)

---

Interestingly enough, I am working with MS to assess that right now. I have been assured that the DMV's should be accurate in the Virtual environment as they...

Thank you for the useful input.

noeld (5/13/2009)

---

Marios Philippopoulos (5/13/2009)

---

TheSQLGuru (10/24/2008)

---

Can you please tell us which bug it was in CU9 that was causing the problem? I checked and cannot find any FIX from that...