brandon.lukes (5/23/2012)

---

We do have a process to get disk/mount space via a powershell script. So we have that covered. I was just hoping that there was an easy replacement for...

Very interesting and great idea to assign max memory dynamically! Thanks for sharing.

We currently have a cluster failover alert job runs every 1 minute to check whats the current physical...

Neat but I also use old style CONVERT(). seems simpler and probably more efficient. Just supply the proper [style] code.

/*

http://msdn.microsoft.com/en-us/library/ms187928%28v=sql.105%29.aspx

100mon dd yyyy hh:miAM (or PM)

101mm/dd/yyyy

102yy.mm.dd

103dd/mm/yyyy

104dd.mm.yy

105dd-mm-yy

106dd mon yy

107Mon dd,...

I went on a bit digging and found those books on...

co-ask. The link seems broken as of now. Thanks

m mcdonald (8/11/2011)

---

From the referenced article...

Transparent data encryption (TDE) performs real-time I/O encryption and decryption of the data and log files. The encryption uses a database encryption key (DEK), which...

calvo (7/22/2011)

---

cengland0 (7/22/2011)

---

Hey, wait a second. According to:

http://technet.microsoft.com/en-us/library/bb510667.aspx

Administering Policy-Based Management requires membership in the PolicyAdministratorRole role in the msdb database. This role has complete control of all policies on...