Are you an Accidental DBA?
If so, we have an excellent workshop for you THIS WEDNESDAY! Don’t miss it – Stephen Wynkoop will be teaching this virtual workshop – it’s 4 hours of learning about things you want to know in working with SQL server. You can take a look at the outline of the workshop, and even check out the different segments presented, all here.
But get registered – it’s only a day or so away!
[Get more information, or register, here]
Webcast: SQL Server and SharePoint Data Integration
SharePoint’s Data View web part can do much more than just view data. It can serve as a complete front-end to your SQL Server (and other data store) information allowing you to create robust applications without writing code. In this session, you will see just how to create such an application including conditional graphics. You’ll even learn how to pass data from SQL Server into a SharePoint Designer workflow for business process automation.
Presented by: Ricky Spears
> Register Now
> Live date: 10/6/2010 at 12:00 Pacific
Featured Article(s)
Give everyone DBO…
If allow users, or applications to have DBO access you may want to take a look at this.
Featured White Paper(s)
VIDEO WHITEPAPER – How to Avoid Downtime – VIDEO WHITEPAPER
In this Experts & Insights video, we take a close-up look at the data protection challenges and solutions surrounding downtim… (read more)
Is SSD a Viable Solution for Your Slow Database Today?
Is Solid State Disk (SSD) a future technology, or a solution for your current database performance? I have been following up on this technology since discussing it last month.
For those of you who missed those blurbs, the benefit of SSD is that it is REALLY FAST. Compared to any hard disk technology, SSD runs much quicker. Quicker than SAN technology.
SSD consists of specialized controllers that use the similar technology as hard disk controller combined with the storage technology similar to that used in digital cameras and cell phones; a small card that does not require electricity to maintain the contents. We use thumb sticks today which have the same underlying storage mechanism.
The difference is that SSD degrades faster than hard disk technology when data is modified. Reads also have some impact, but not to the same degree.
We had members who having used SSD had issues with the drives failing. One member with a frequently updated database had the SSD fail within three months. Others with slower changing data had failure nine to twelve months. For the cost of SSD at the time, it didn’t really pay off.
Recently I found a posting on Linked In from an SSD vendor endorsing the technology as more advanced. The evangelist is a highly valued SQL Server professional. I posted the experience our users shared and asked him to provide a more current perspective on the technology. That discussion can be found on this LinkedIn Discussion Thread on SSD. LinkedIn requires a user account in order to access the discussion. I believe it is free. If you do join, feel free to join my network on LinkedIn.
I don’t know if SSD is the solution for the general masses yet. But, if I had to predict the future, this is definitely a technology I would bet on.
As always, send your thoughts or comments to ben@sswug.org.
Cheers,
Ben