Updating to SP2 CU 5 next weekend.

Clarification: the current system has been C# .NET ORM for years -- so it was changes to code, not a move to ORM. I suspect development and management...

Thanks for the feedback. Changes to the ORM-generated sql would no doubt make big difference, as would creating a data warehouse so "report-type" queries aren't run against the OLTP...

What I do know is that our current web application is going to have to survive another few years while it's replacement is written. This will include adding new...

Any experience with either approach, good or bad? If so, which products? My CIO tells me the world of SSDs has changed since I last reviewed it...

Thanks for the article. I do try to avoid cursors and while loops. In fact, our development team just wrote some stored procedures to improve upon a data extract...

If you can add groups or members to groups ( or your systems people do it quickly when asked and always communicate when changes are made ),

then AD only sounds...

How is SA ( with good password properly managed and not used by applications ) any worse than your own "admin" sysadmin login?

Worth mentioning again that many of us can't create windows groups, or manage their contents, or make sure they work across domains.

I think somebody said "disable SA" earlier in this thread. But best practice is ( was? ) to assign job ownership to SA. Another recent article here on...

duplicate post, no way to delete apparently.

In my experience, moving people in and out of AD groups is often done without DBA knowledge. It isn't difficult for the DBA to see who is in a...

Thanks for the reply.

Keys/certificates etc were created and backed up,. Encryption is proceeding -- 6% in 30 minutes so far. Inserts, updates, deletes and selects were...

Opened a case with Microsoft Premier Support

Sure, I know it works in most situations. I just prefer not to run it on my work laptop, connecting to servers over VPN, so I remote to the...