Just Posted: SelectViews 86
This show is an interview with Kim Tripp and Paul Randal. We got together at DevConnections in Las Vegas and talked about everything from the famous board game to SQL Server 2008.
Converting Mainframe Data to SQL Server?
Do you need expert conversion of complex EBCDIC (mainframe) data into ready-to-import ASCII files? Greenview’s conversion tools and turn-key services convert nearly any EBCDIC file and absolutely any COBOL-based mainframe database into ASCII tables. 10 years experience with over 1000 different files – FDR, credit card processing, Defense Logistics Agency (DLA), Texas Gas/Oil, telephone, IRS, banking, healthcare, real estate, etc. The included VEDIT editor quickly edits and sorts Gigabyte-sized files. Get more information here.
Webcast TOMORROW – 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
Holiday Schedule
Just a quick heads-up – there won’t be a newsletter on Thursday (US Thanksgiving Holiday) or Friday. We’ll avoid over-stuffing your email inbox. Happy holidays! (We’ll still have new resources posting to the site though…)
Database Platform Choices
Well, our mini-poll is complete. Thanks for all of the responses!! It was interesting to see the numbers change later in the week. I mentioned Friday that these were the percentages:
MySQL – 6%
Oracle – 18%
SQL Server – 70%
Other – 7%
…and here’s where they ended up:
MySQL – 7%
Oracle – 18%
SQL Server – 67%
Other – 7%
Some comments:
Choosing Oracle, Jeremy: "Funny that I choose this based upon the amount of conversions that I’ve implemented from Oracle to SQL Server over the years.
I choose this because in the Oracle world the roles are much more specific and unique than they are in the SQL Server world. With 2005 / 2008 becoming so BI intensive (from a marketing / perception perspective) its largely increased the amount of technology that I have to be the expert in.
I’d also like to mention that the path to different titles / responsibilities is cleaner and more understood from an Oracle perspective than it is from the SQL Server perspective. (i.e. an awesome Oracle dba becoming a performance tuning guru or an excellent Oracle dba with soft / business skills becoming a data architect).
In my experiences I’ve seen that the SQL Server resources have a harder time making this kind of career transition.
With all of that said, I have made the transition from SQL Server DBA >> SQL Server Consultant >> Data Architect. It was long process (years) but I feel like I’ve finally arrived and I’m doing what I love."
Choosing SQL Server, Luke said: "I’m currently taking some Oracle classes and all things being equal SQL server just seems to take a lot less futzing around with to get it to stable, reliable platform with which to work. Granted I’ve not seen any of the 11g tools, but as far as native tools go, MS seriously has the advantage over Oracle 9I and 10G R2 tools. And don’t even get me started on the oh so vague error messages that Oracle tends to give. I recall recently having to stare at my code for 10 minutes before I found a comma was missing. Oracle kept telling me it was a case of a missing Closing parenthesis. SQL server might not tell you exactly where the error is all of the time, but at least it typically won’t mistake an improperly placed comma for a missing right paren."
Featured White Paper(s)
10 Easy Steps to Convert, Migrate and Upsize Microsoft Access to SQL Server
Getting to SQL Server from Microsoft Access is typically a very tedious and labor intensive process. It requires skill, exper… (read more)
The Forrester Wave™: Enterprise Service Bus, Q2 2006
Cape Clear retains its leading position in Forrester’s latest review of the standalone ESB market. The vendor is one of the p… (read more)
Architecting the Infrastructure for SOA and XML
As application systems are developed using SOA principals and implemented using XML and Web Services, the increasing sophisti… (read more)
Improving SQL Server Performance through Better Application Monitoring
Learn how to provide higher performance and availability for your SQL Server by knowing the key drivers behind SQL Server per… (read more)