^nix is still easier to manage remotely if you can write the scripts. years ago i had to move some data from a file server and had a unix admin...

virtual shadow copy service has been around since Windows 2003. if an application takes advantage of it then it can create snapshots and copy data outside the normal SQL methods

we...

put me in for the cigars, but i'll pass on the karaoke

not yet

so far the only thing that seems different is that Cognos includes MDS by default where with SQL 2008 R2 you have to buy the expensive version. when i...

sanokistoka (10/22/2009)

---

Have you tried Oracle, which doesn't exhibit, say SELECT/UPDATE deadlocks because of row versioning? Thankfully, there is now row versioning in MSS. The point being is that, yes an...

VinicioAizpurua (6/3/2010)

---

Nice solution regardless the comment why to do it with SQL. It is all depends on you organization and the resources you have in your hands. Sometimes you have...

as a former email admin, why not just let MS Exchange handle the work. create some custom receipients that are hidden from the corporate address book and a few distribution...

i think Microsoft's official support policy is 7 years of regular support and 2 years of extended support which is security updates

sometime last year in one of the linkedin groups i'm there was a huge religious battle between GUID PK supporters and the rest of us. after a while people got...

this is my favorite memory

early 2006 we upgrade to SQL 2005. or early 2007. whenever SP2 came out. we spend a few months testing.

start the upgrade late friday or saturday...

David.Poole (5/26/2010)

---

What am I doing wrong Paul? I don't seem to get any...

David-Leibowitz (2/12/2010)

---

Have you looked at SQLScrubs for SSRS 2008? It provides the ETL, DW and reports to do a lot of this. And it's free on codeplex.

Gets around the 60...

i personally never liked going to a table to look at SP logs for SQL jobs. i like to look at it in sql agent. there was an article here...

Charles Kincaid (5/13/2010)

---

alen teplitsky (5/13/2010)

---

i haven't done the cost analysis, but for a medium to larger environment i think tape and local onsite backups are cheaper. LTO-4 tape is dirt...

i haven't done the cost analysis, but for a medium to larger environment i think tape and local onsite backups are cheaper. LTO-4 tape is dirt cheap and the big...