Webcast Tomorrow:
Avoiding a SharePoint Disaster
Whether you’ve already implemented SharePoint, or are only preparing to, backup and recovery should be a priority. Discover how to use SharePoint’s out of the box backup and restore capabilities to protect your data in case of calamity. This session will take a quick trip through the built in backup options available with SharePoint; suggest some tips, tricks, and best practices; and focus on some techniques concerning how to restore that data before disaster strikes. Presented by: CA Callahan
> Register Now
> Live date: 2/3/2010 at 12:00 Pacific
Troubleshooting BI Is Challenging!
BI puts all sorts of new types of loading on your SQL Server. It can touch on so many different aspects of your server and require all new sorts of insights when you’re troubleshooting issues that come up. Think about it – SSAS, SSIS, SSRS and much more – all come into play. SQL Sentry BI Suite will help you dig into your systems and see where issues are, see where you need to look to tune your systems and troubleshoot performance and other issues. Check out all of the details and get your trial download – you’ll quickly be seeing excellent information on your systems. Get it here.
Where is the Line Between Snooping and Enhancing Data Use?
I read this great post from Curt Monash about "Data-based snooping" — and have to admit both the title and the content had me sitting back saying "hmmmm…." and thinking through exactly what we all do and what we expect to get out of it. Specifically, Web 3.0 or 4.0 or whatever we’re calling it now is all about customization, using data bits to provide more meaningful experiences on the ‘net and so-on.
Where is the line?
We expect more and more from our Business Intelligence systems and more and more from our work to customize online and application experiences. We expect systems to get smarter, to begin to recognize trends without our help and to use information to generate more information that’s beneficial. I’m a strong believer in the idea that our systems can indeed be so much better at using the information they contain and provide more solid decision support. I’m not talking about "Terminator" type systems that are running our lives, but rather about systems that can provide us with the information to make better choices and help people faster.
I can’t tell though where the line is between too much access to data vs. too many walls up needlessly protecting it.
Where do YOU draw the line? Do you agree with the article?
I don’t know that legal means have the ability to really control or channel this. If you’re looking through information on your databases, trying to find trends or other information, I’m not thinking that the legal ramifications of your honorable work are going to be foremost in your mind.
Drop me a note – what do you think is the trend? The answer? The problem?
Time is running out to register
SQL Server Indexing – KEY Information
Update: Kalen will be giving away a copy of her book to one lucky attendee! The drawing will be held from those answering the session survey!
Kalen Delaney will be presenting our next virtual workshop, all about SQL Server Indexes. You’ll learn about key design considerations as you determine where, and what types of indexes will best support your queries. You’ll also learn the value of unique indexes and included columns. You’ll find out about composite indexes, and how to determine the best indexes for your queries involving ANDs, ORs and JOINs. Last but not least, we’ll discuss best practices that you can put to use immediately as you review and update your designs to support the queries on your system.
Indexes can be the key to performance on your system. Kalen is one of the foremost authorities on SQL Server internals – and an expert on how indexes work and are applied. You won’t want to miss this incredible workshop opportunity! You can even get a certificate after completing the workshop and passing the quiz! Kalen will be available during the workshop to answer questions live in the chat room and make sure you get all you can from the workshop. It’s an incredible opportunity and we hope to see you there!
When: Feb 12, 2010 at 9:00a Pacific
[Get More Information] or [Register Now]
Webcast Next Week:
Optimizing Backup and Restore Performance
As databases continue to grow in size, the time it takes for backup and recovery grows in length of time. Attend this session and learn methods to minimize the time it takes for your backups to complete, as well as how to minimize the amount of time it takes to recover. Presented by: Thomas LaRock
> Register Now
> Live date: 2/10/2010 at 12:00 Pacific
Featured Script
admin db – sp_monitor history and historical performance report
Save regular samples from sp_monitor to help you know when it’s time to beef up the hardware on your server…. (read more)