Have you registered for the free PowerPivot and SQL Server Expo?
[Register Here]
Webcast Today: Panic! SQL Disaster Strikes: 5 Best Practices to Recovery
No matter how much we prepare, when disaster strikes we all feel a moment of panic. For some that panic quickly passes as we get down to work to fix the problem. For others the panic continues to grow as we search for a solution. Of course back up is crucial, but in this session Sarah will provide useful real world best practices that will show how to recover from disaster and more importantly how to prepare for the inevitable. Specifically how to recover from common disaster scenarios. For example, what to do when the master database is corrupt, a drive array with half your database files fails, a hardware failure, a SQL injection attacks wipes out whole tables and many more.
Presented by: Sarah Barela
> Register Now
> Today – 1/13/2010 at 12:00 Pacific
So many things going on! (Kinda cool!)
SQL Server and SharePoint – – Maintenance Targets…
I ran across a series of resources on Microsoft.com that talk about maintenance and what a SQL Server administrator can do with and for SharePoint databases. I thought it would be a great set of help and ideas for what people need to be thinking through – great!
I was surprised that most (nearly all, in fact) of the maintenance centered around index fragmentation and tuning. Wow! I thought it would be a series of things that a SQL admin would want to keep track of, not tightly focused suggestions to watch and manage fragmentation. I guess the good news is that you can be focused in your work to manage SharePoint systems. The not-so-good news is that the knobs you can turn may be somewhat limited.
So, as you’ve worked with SharePoint systems, have you found other things that you tweaked and tuned successfully? Drop me a note, let me know… where SHOULD someone be looking on a SharePoint system?
Virtual WorkShop – SQL Server TSQL For The Rest of Us
By popular demand, our next virtual workshop will be all about getting you going with TSQL – from understanding SELECT and UPDATE and DELETE statements to creating databases, creating stored procedures and much more. We’ll be covering it and explaining it and showing it so you can see and experience exactly how everything works. Learn about TSQL for managing your systems and learn what you need to know to get started and up to speed with TSQL. This is a multi-hour workshop and includes sample scripts, slides and I’ll be there to answer questions all along the way.
[Register now] or [Get more information]
Did You Know?
Did you know that you *CAN* debug and test TSQL code in Management Studio? You can! In fact, Bill Ramos has a great series of posts about doing exactly that. Check it out here.
Featured Article(s)
Useful undocumented SQL Server 2008 Database Mail Procedures
In this article, Alexander Chigrik looks at six undocumented SQL Server database mail procedures that shipped with SQL Server 2008.