New SQLonCall Show Posted!
Check it out – Chris has put together How to hire a DBA as a show! Tips, tricks – and much more. Find out what you need to know from both the hiring and the being-hired end of things. Watch the show here.
> …and, you can catch the most recent SelectViews SQL Server Show here
Featured Article(s)
Troubleshooting SQL Server 2005 Transactional Replication (Part 1)
In this article, Alexander Chigrik explains some problems that you can have when you work with SQL Server 2005 transactional replication. He also tells how you can resolve these problems.
Job Failure Notifications are Nice and All… But…
Have you ever been surprised to find out that jobs are not completing? It’s a pretty typical situation – you think things are fine – then you find out that critical data updates, or data migrations, or some other sort of operation you have scheduled has run. You wonder why you didn’t know – but then you realize that the notification system only tells you on completion if things succeed or fail. Ugh. This is why you need to check out SQL Sentry Event Manager. SQL Sentry Event Manager will monitor your jobs and let you know when something is wrong – running too long (based on real averages, not guessing) and much more. Don’t be surprised again. Get SQL Sentry Event Manager up and running on your system and make sure you know what’s really going on.
Business Intelligence – What’s Your Approach?
I’m curious how you’re building out systems to support your BI work. In our SQL Server challenge on the show, I’ve asked about pulling information from one database to be put into another as an archive, then removing it from the first database… but I’m curious how many people are doing this. My questions, then:
1. Are you archiving information to a secondary server for query/reporting applications?
2. If yes, when you archive, do you REMOVE it from the first database?
3. If yes, what is your retention time-frame? Or does it vary based on the type of information?
4. What have you done on hardware? Did you get a lesser machine for the BI stuff, or was it actually a beefier machine? (technical term: beefier)
Let me know – I’d like to hear what you’re doing and what you’ve had successes with in this area.
Email me here when you get a minute.
Featured White Paper(s)
The High Performance DBA: Optimizing Databases for High Performance
The combination of a cross-platform environment, added database complexity, more data, and less headcount has become a real c… (read more)
Easing the Migration to Microsoft SQL Server 2005
Many companies are eager to take advantage of Microsoft SQL Server 2005 and its notable business and technology benefits such… (read more)
The Shortcut Guide to SQL Server Infrastructure Optimization
In The Shortcut Guide to SQL Server Infrastructure Optimization, the new eBook from Realtime Publishers, leading IT author Do… (read more)
Replication made simple using SQL Data Compare
Replicating SQL Server databases needn’t be a massive headache. This document discusses how to troubleshoot replication probl… (read more)