Featured Article(s)
SQL Server 2008 – All Smiles for A Data Base Administrator.
The Title of this article tells it all! Learn why are DBA’s jumping all over their cubicle … It could also be titled : DBA’s Life Optimization … 😉
Are You an Application DBA?
I’ve been seeing a trend in blog postings, posts to the list servers, discussion boards and other areas.
It’s the concept of addressing application-specific DBA functions. I’ve heard the term batted around a few times of being an application DBA. Basically, it’s providing the traditional DBA function but focused on doing so for applications. You get to know the applications from the inside-out and you also apply the DBA functions (performance troubleshooting, administrative functions, recovery, etc.) to the applications in use at your business or your client’s business.
While it may seem like a "no duh!" statement, the thing that I’ve seen more and more is that some DBAs are becoming experts in working with specific applications or environments. SAP, CRM-based systems and others are examples where people have made an art of supporting those environments specifically and by bringing that leverage, adding real value to the DBA position.
It’s worth a thought – figuring out as much as you can about the applications running and what types of procedures, systems and approaches you can build to provide support for those applications. What can you do specific to the applications in a proactive way? How can you keep those applications from ever red-lining in any way? It’s an excellent way to extend your expertise and still give yourself some structure to work within.
Do you have application-specific procedures? Do you have application-aware recovery and planning models? Send me a quick email, let me know if you’re approaching things this way as well.
Protect & Defend Your Data
With most SharePoint implementations storing critical business data, it is crucial that this data be protected and quickly restorable in the event of a disaster. Learn how utilizing Data Protection Manager 2007 as your backup/restore/disaster recovery solution provides a full-fidelity solution with granular control. We will walk you through the initial configuration of DPM as well as setting up a recovery farm. Presented by: Christopher Regan
> Register & Watch Now
7 SQL Server development practices more evil than cursors
Cursors do indeed cause performance issues, but cursors are easy to correct. This session addresses the problem of cursors and then uncovers 7 common practices that are more costly than cursors Based on several years of consulting specializing in optimizing third-party ISV databases, the list of worst practices range from critical database design blunders to indexing errors to T -SQL mistake. Avoiding the blunders on this list will be the difference between a successful database project and a failure. Not to leave you in the dark, this session will contrast every evil practice with a best practice to solve the problem. Presented by: Paul Nielsen
> Register & Watch Now
Featured White Paper(s)
Empowered SQL Server Development with Toad for SQL Server
Database developers face a variety of challenges every day, from creating and maintaining tables and stored procedures to opt… (read more)