Webcast: Understanding the new culture of SharePoint
You have a sponsor for SharePoint development, you have a budget, now where are all the users? Online Collaboration powered by SharePoint is not only a new technology, but a new culture of doing work. In this session we’ll explore change management (the fluffy kind) strategies that can be tailored to your user base. Attract users, and keep your budget!
Presented by: Adam Levithan
> Register Now
> Live date: 7/28/2010 at 12:00 Pacific
FREE SSWUG Expo – Maximizing SQL Server Uptime – Friday 9am Pacific
SQL Server uptime is a key component of managing your SQL Server(s). Knowing what’s important, what options you have for building out solutions to help when things go wrong, is at the core of the responsibilities for those working with databases. This expo will feature information moving to SQL Server 2008 to get you started. You’ll learn about new features and important things that you’ll want to know about as you work with SQL Server 2008. We’ll also have segments on Transactional Replication for High Availability, Database Mirroring and even log shipping basics. Join us to learn about the key elements to making sure your systems are able to provide excellent uptime options for your business, clients and end-users. Sign up today. <- click to register…
SSD – Reloaded
Before you get completely bored with SSD I received a couple responses I thought you may want to take into consideration.
Brice reminds us that like any hardware device you need to be sure to have a backup and restore strategy. He writes, "I was burned by a ### 128GB (SSD), because I didn’t backup my pst’s. Lesson learned. It lasted < 3 months! (of pretty heavy use)."
I appreciate the email heading from Brice, "Burned by SSD (My Own Fault)." We all know that any hardware can fail and eventually will. We have to prepare for that eventuality. SSD is a lot newer technology and is not as heavily vetted as the traditional disk drive. So, be sure to have a failover plan.
If you want to review some of your database failover options, SSWUG is hosting a FREE Expo on July 30th titled Maximizing SQL Server Uptime. This will be a great opportunity if you find yourself responsible for your database servers and don’t yet have a strategy for system failures.
Ron is doing something different than most database applications. He is using SSD to help optimize his embedded applications for real time testing. He has found that the additional performance of SSD allows his testing tools to be much more robust and extensible.
These responses got me wondering. Could I get an inexpensive SSD for highly utilized database objects and increase my overall server performance? What if I could put something together with a raid controller using 2.5" SATA II SSDs. You can get 160G for $400 or less. Wouldn’t that scream on a raid 10? You hardware gurus probably know…I wouldn’t guess the SATA controllers are fast enough to compete with SAN speeds. But there are SCSI controllers out there that can work with SATA drives.
I could see putting TempDB or even SWAP files onto this kind of drive. TempDB is a great candidate. If the drive fails move it to another drive and you’re back in business.
Drop me a note with your comments, experience or concerns at btaylor@sswug.org.
Cheers,
Ben
Featured Article(s)
DBA Learning Strategies (Part 3 of 4)
Next we need to document what you need to know… We found out what we know, we have our reds and greens. Now we need to figure out, which of these reds do I care about?