New Video: SelectViews Weekly Show
On today’s show, we’ll be going into more tips for Accidental DBAs. This series is meant to help people that are only really working with databases part time and just need a few tips and ideas about how to do a little bit at a time. Also, the 60-second SQL Server tip of the day, noise and news in the industry, events, the newsletter and discussion list watches and a lot more.
> Watch the show here
> Register for the list servers (email discussions) here
Other Video Programs/Shows available:
[Watch] SelectViews – Special – SQL Server 2005 Jobs – How-To, When, Where, Why – Demos
[Watch] SQLonCall – Creating Standards for Your SQL Server
Featured Article(s)
Oracle 2-Day DBA in x Days Post 5; Starting to use Enterprise Manager (dbconsole)
James Koopmann, in this 5 post on Oracle’s 2-day DBA documentation talks about starting to use Enterprise Manager. Some things to look out for and some things to expand you knowledge.
About That Matrix…
Yesterday I wrote (and it’s on today’s show) about the idea of the matrix’d database. The rumors, the products, etc.
A good number of people wrote asking about how this is any different from data warehousing – what’s the difference – you’re just putting all the data in a large storage location and accessing it from there for archive/reporting/whatever purposes, yes?
Yes. And no. Yes because you’re moving data, but no because it’s not necessarily ALL of your data. It’s possible to see a single table split across these two destinations. Information that’s deemed "older" could be in the cloud, newer information could be more local for performance reasons. But even that’s not the entire point of this. If you’ll pardon the stretch, it sort of speaks to Bill Gates’ original ideas concerning information at your fingertips. This concept of "stuff" living in the cloud – or, really, just things living where they’re best suited to live, then having access to them where you need to have access to them… That’s really what this boils down to.
I’ve seen some industry bloggers and writers too talking about the idea that really, this is where things must go. Access to your information from wherever you need it facilitated by these storage systems that can be smart about getting data to you.
Then of course several other people wrote about access speeds and bandwidth. We’re already seeing doomsday predictions of running out of bandwidth on the ‘net over time and if we add to that significant data access, we’d possibly hasten that. Barring that outright failure issue, the problem of bandwidth to the office needing the information comes into play where it’s much less of an issue if the data is stored locally.
So, yes, there are certainly issues to work out – and I’m sure we’ll continue to see this evolve in many areas, but it is certainly something on the nearer, rather than farther, horizon I think.
Featured White Paper(s)
The Payment Card Industry Compliance – Securing both Merchant and Customer data
This white paper introduces the Payment Card Industry Compliance standard, and the security threats which brought about the n… (read more)
Protecting SQL Server Applications and Data Against Common SQL Failures
Microsoft SQL Server has emerged as the database of choice for mission critical applications for small and mid-sized companie… (read more)