Uncategorized

If You Had a Database Time Machine…

Tomorrow: Kim Tripp and Paul Randal interview from DevConnections.

Featured Article(s)
Oracle 2-Day DBA in x Days Post 1
We just got started. Follow along as we go through Oracles 2-DBA guide. It should be fun.

Cure For The Mysterious SQL Server Slow-Down
As a DBA have you ever received that call from the boss asking why the database is running slow or not responding at all. Panic sets in because you didn’t get any notice of job failure that would be causing an issue. With a lot more research you find a critical job has “hung” and is causing the system slow down. With SQL Sentry Event Manager a DBA can set up a rule across their environment to be notified when a job runs longer than a certain percentage than normal and never fails. This is a great feature for monitoring critical jobs, backup jobs and maintenance plans to make sure they are completing in the assigned time frame required. Get more information here.

Register Now: Troubleshooting and Maintaining SQL Server 2005
Find out about how to dig into your system and pull information you need to know to understand what’s happening. We’ll look into performance monitor counters to keep track of, where logs are that you should be aware of and more. The goal of this session is to have you feeling comfortable with performance profiling and investigation approaches for your system.

> Register Now
> Nov 20 2007 12:00pm Noon Pacific

If You Had a Choice…
What would you pick?

I had a reader write today asking what I would suggest they do in their quest to become a DBA. Should they pick Oracle or SQL Server? They’re well on their way to Oracle DBA-ship and wanted to know if that was a mistake.

Now, all database religion aside, I think it’s a great question. For the record, my response was to pick the one that you’re most comfortable with and are most able to relate to in terms of approach, tools, etc.

But, it certainly gets you thinking. Would you do it differently? Clearly most of the readership on this list is SQL Server, but we have a huge assortment of cross-platform folks too. So – if you could switch horses, or pick horses, what would you choose? I know Oracle tools are getting very well polished, clearly SQL Server has the tools and interfaces well oiled as well. So, if you were going to have to make a selection, which way would you go?

Click one, hit send, I’ll post results next week.

SQL Server Oracle MySQL Something Else (and yes, I realize there are others)

Remember, this is in a perfect world – assume EVERYTHING else (salary, responsibilities, etc.) remains the same – which do you pick?

Featured White Paper(s)
Protecting Transaction Data: What Every IT Pro Should Know
Continuous data protection represents a major improvement over traditional backup, replication, and snapshot systems. This wh… (read more)

Mission Critical Application Protection: Restoring Data Quickly, When And Where You Need It
The need for a reliable backup-and-recovery solution in the enterprise has never been more important, due to many driving for… (read more)

The Failure of Relational Database, The Rise of Object Technology and the Need for the Hybrid Database
Hybrid databases provide the speed and rapid development capabilities of object technology PLUS robust SQL access…. (read more)

ESG Lab Validation Report of the HP PolyServe Database Utility for SQL Server
ESG Lab, the testing facility of industry analyst firm Enterprise Strategy Group, reports its comprehensive testing of HP’s s… (read more)