This Saturday (May 17th) I’m planning to attend the SQL Learning Day Fire Starter event at the Microsoft Irvine California office. The event aims to bring developers and IT Pros together to share their content.
Here is some info about the presenters I know: James Johnson, President of the Inland Empire .NET User’s Group (IEDOTNETUG), will be presenting “Using ADO.NET Data Services to Connect to SSDS“. I have been to a couple of .NET UG activities since I’m in California and he’s running by far the best UG events. Actually he deals with every aspect of each organization and never lets anybody down. Another presenter will be MSDN Developer Evangelist Lynn Langit, who will present two sessions; respectively “Overview of BI” and “What’s New in SSAS“. Lynn’s presentations are always informative yet fun and they definitely meet the target audience’s expectations. You can find a link to their blogs on the left; if you haven’t already noticed! Matt Penner is also a member of IEDOTNETUG; his presentation sessions are “Beginning SQL Spatial Features” and “Advanced SQL Spatial Features“.
By the way – How did a mainly Java developer end up in Microsoft technology events? That’s a whole different story:) Let’s focus on my interest in SQL Server.
Interestingly I have been working on the database for almost 8 years🙂 I have ben writing SQL queries, working on reports with PL/SQL, generating stored procedures for reusability and sometimes for batch database jobs. There were some nights (oh plus many many weekends!) were I was losing my head over emergency SQL patches. At some times it almost felt as if I would be stuck in my cubicle forever; querying, double-checking, updating, deleting, recovering zillions of records. Why the hassle? Because there’s always a DEADLINE to meet. Even the separate parts of this word sound negative, don’t you think?
Based on our IT strategy, application developers would also work on datamodel design; which meant we had to think of relations, constraints, indexes, triggers etc. Certainly we had the opportunity to recheck the model with DBA’s in case we needed some advice. Still it was more convenient to define specific user privileges, to analyze user sessions, user rights and (please don’t meet again!) database locks, on your own. Last but not least; we sometimes had to deal with Oracle Forms, despite the fact that we were essentially developing web-based applications.
On top of all these bitter-sweet memories, I am definitely fond of Oracle and its database tools. For specific cases you might want to use SQL PLUS (ewwww!), yet for development purposes I would use QUEST SQL Navigator. Some friends are SQL TOAD fans; however I prefer to navigate through my database development expeditions with my friend – SQL Navigator.
Back to SQL-Server. Our latest team project was based on a Business Process Management suite called Ultimus, which leverages Microsoft technologies. That’s when Visual Studio, SQL Server joined me as new tech-friends;) We needed to write Java Web services as integration nodes for the designed workflow project. Furthermore we had to offer data reporting capabilities through Oracle Discoverer to business units. There were several reasons to transfer data back and forth between SQL Server and Oracle databases. Once we struggled for almost one week with Oracle Data Provider for .NET (ODP.NET); just to realize that there were still problems with the Turkish characters. That issue might have been resolved by now?
To cut the long story short: We had to work with both; Oracle + SQL Server.
After this much techie details; my artistic inner voice does have a question … Although the lyrics don’t apply, will we have Prodigy Firestarter at least buzzing in the corridors of the event location? Hey Mr.DJ put that record on! Just to remind you of the song; here’s the scary(!) music video from 1996.
Whaaat? There’s no DJ? At such a funky event? You must be kidding?!? NOOOOOO WAY!
Again this is my inner voice. Now screaming with astonishment;)