Tim Ford(WWW, Twitter) tagged me. This meme is all about what you would do if you were trapped on a deserted island with nothing but a laptop and aircard. Here is an excerpt:
So You’re On A Deserted Island With WiFi and you’re still on the clock at work. Okay, so not a very good situational exercise here, but let’s roll with it; we’ll call it a virtual deserted island. Perhaps what I should simply ask is if you had a month without any walk-up work, no projects due, no performance issues that require you to devote time from anything other than a wishlist of items you’ve been wanting to get accomplished at work but keep getting pulled away from I ask this question: what would be the top items that would get your attention?
Well, first I would have to set camp, kill The Others, and salvage the wreckage of Oceanic Flight 815. But after I would ferment coconut juice so I could have drinks on the beach. Priorities, right?
So after a couple of months of drinking, surfing(waves and pr0n), fishing, and basically being an all around beachbum I would do this:
Study up for the Oracle Certified Professional exams.
I should be doing this now but I have trouble finding time and motivation. I have the books, study material, and an Oracle lab environment in the cloud. I have been pondering why I find it easier to put my head down and learn the new versions of SQL Server but procrastinate on Oracle. I have come to the conclusion that it is the fact that I do not use books with SQL Server. I usually learn all of the new engine feature before any books are written. I guess I just need to get more hands on with Oracle.
Design a set of default policies for new SQL Server 2008 installations.
In SQL Server 2008, we have policy based management. I want a set of default policies that guide people into best practices. For example, preventing a new database from being created with 1MB autogrow. The policies should mostly cover server and database settings. Schema oriented policies could vary between dev teams and should be handled by them.
Powershell as my default administration method.
I got into a powershell kick for a while but I lost interest. I need to give up the whatever GUI and do all administration through powershell. That is how I learned TSQL. Today, I use the GUI when it is a couple of clicks versus lines of TSQL but I could do it if I needed to. If I give up all MMC snapins and other GUI’s, I might spend a little extra time with powershell at first but it should pay big dividends in the long run.
The Others:
Brent Ozar(Twitter)
Grant Fritchey(Twitter)
Thomas LaRock(Twitter)
I am tagging the following:
SQLChicken
SQLFool
Jeremiah Peschka
SDS news has been flying all around the intertubes. I am going to try to summarize the links in this post. There is official “[This document supports a preliminary release of a software product that may be changed substantially prior to final commercial release. This document is provided for informational purposes only.]” on MSDN here.
Simon Sabin talks about it here.
The SDS team posts Q and A.
Oh nevermind, just go here. Mike Amundsen has links to everything SDS in his feed.
SQL Data Services will be a relational database that has most of the features of SQL Server.
To quote David Campbell:
Tables?...CheckStored Procedures?...CheckTriggers?...CheckViews?...CheckIndexes?...CheckVisual Studio Compatibility?...CheckADO.Net Compatibility?...CheckODBC Compatibility?...Check
Tables?...Check
Stored Procedures?...Check
Triggers?...Check
Views?...Check
Indexes?...Check
Visual Studio Compatibility?...Check
ADO.Net Compatibility?...Check
ODBC Compatibility?...Check
Read about it here.
Up late making some changes on a large SQL 2000 publication and hoping like hell that I do not have to push the full snapshot.
Anyway, just a link post but Dave Robinson dropped a real teaser on the forthcoming “rewrite” of SDS here. As always, Mary Jo Foley has the rumors. Pay attention to Mix which is #mix09 on twitter.
Tony Bain(RSS, Twitter) has written a very nice article comparing relational databases to “cloud” databases. Not only is it well written, it has a HUGE audience at ReadWriteWeb. Props Tony. Suggested reading for Database Professionals.
The full article can be found here. Here is one thing you should see this even if you do not follow the link.
The core of a relational database is normalization. The reduction of data duplication is what it is all about. Less data means less IO. SDS removes database design from the equation. This is why sparse columns and filtered indexes where implemented in SQL Server 2008. Here are a few posts on how this is handled in SDS.
The End of of JOINs?
The End of JOINs Part 2?
Yah yah, it doesn’t apply to your job, business, sector. Adam may call me out on FUD again. I hope it is true since this is hopeware so far.
However, I want to point out one company who have found a cloud non-relational database to meet their business requirements. They state their limitations and it makes sense as to why they took this route. If you are not up to speed, Simpledb is Amazon’s cloud db. Big table is Google’s cloud db. You are here because you already know about MSFT.
Glue chooses SimpleDB.
This is what we need to keep an eye on.
I got a nice little surprise in my inbox today: The first reader submitted Captain Varchar comic from Rod Colledge of SQLCrunch.
I have written about this twice. I pushed it here and I toned it down after the facts came in from PDC. TJay Belt also had some commentary on it here today.
The comic does raise another off topic but interesting point. Apple’s desktop market share has been gaining ground. What happens when SaaS makes the browser the OS? Yes, another stretch but that is where some “experts” think we are heading.
Awhile back I wrote about the Death of the DBA. After digesting, the Windows Azure PDC announcements it clear that the only thing SQL about SQL data services is the backend managed by Microsoft. In all reality, it is simply an ORM for the cloud(ORM WIKI). Call a spade a spade. A lot of us have had to support databases for ORM based applications. Most of us didn’t like it but at least we had a database to manage. Our cries for real SQL development fell mostly when deaf ears when managers could forgo a SQL developer head count while shipping faster and app devs could stay in the object realm.
From the manager’s perspective
Assuming that Microsoft delivers a high quality, full featured product with the Azure platform, there are a lot of compelling reasons for an IT decision maker to use this platform. No CapEX. No sysadmins. No SQL Dev’s\DBA’s. No patch or backup management. On demand scaling. The early adopters will be startups that where the CEO is also the developer but as some of the companies succeed more established companies will follow.
The false downsides
Security is the big one. This will be solved. In the 90’s, everybody had a server closet or data center. IT folks didn’t want to give it up due to physical security. Today, colo and hosting has become the norm except for the largest environments. It is because a colo\data center companies\hosting providers can provide higher uptime, faster connectivity, greater redundancy for a much lower cost. Nowadays, some companies outsource everything IT from help desk to Exchange admin to the CTO. A good chunk of HP’s growth this quarter was from the division that was previously EDS. The cloud just takes it a step further.
Functionality is coming. This first release might be “SQL 6.5” like but you can bet that MSFT will listen and respond to customer needs. They have gotten much more agile at this. They are throwing a lot of resources at the cloud to make this happen.
3rd party ISV’s will respond. You may manage a SQL system that powers SAP, Siebel, Peoplesoft etc. These company will have to respond to the market. They will release azure versions or their own web based hosted solution. If they don’t, they may get left behind by competitors. Look at how well SalesForce.com is doing.
The real downsides
You have to rewrite your app. I am not a .Net developer so I am not sure how big of deal it would be to port an existing app. I am not sure if many do as new as this stuff is but there will be at least some work effort. If I had to guess, it is considerable.
The biggest downside is the fact that this will be the only game in town for your app once it is written. If you are not happy with the service or prices are raised, you are stuck. How many of you have been unhappy with your web host and moved your web site? *Raises hand* You can’t do that once you are on Azure without a rewrite.
So what does this mean?
I really do not see a career path for a DBA or even a SQL developer to evolve into a role in an Azure based environment unless you want to become a .Net developer. It is pretty cut and dry as far as I see it. However, I do not think that Azure is going to take over the world and be the end of shipping SQL Server on a DVD. There will be SQL 2000 boxes out there 10 years from now because they work and there is no business need to upgrade. Features will exist in on premise SQL Server installations that just can’t happen in the cloud. Big news at PDC was blob support for in SDS. Hello and welcome to Access 97.
There will be hybrid solutions where part of the app is in the cloud while the VLDB is on premise. For example, the product catalog, TodaysOrders and CustomerLogin entities are in the cloud while the Orders, OrdersHistory and Customer databases are local.
Here is Microsoft’s vision:
SQL jobs
If everything works out for Microsoft, there will be less SQL and sysadmin jobs. The question is when and how many? I suspect Azure will RTM with Visual Studio 2010. That should be in about 2011 ;) How quickly are enterprises going to jump on that? The first apps to go will be the ones where the developer\sysadmin is also "the DBA". That won’t effect us and I would venture to guess that would be the typical azure installation for a few years. Providing Azure is a solid platform and given the development cycle, the enterprise may begin to move around 2015. I would say we are good until 2025 just with “legacy SQL” in the worst case scenario. If there are 25% less DBA jobs by 2020, how bad is that going to hurt? I don’t know about you. Hiring and keeping a top notch SR. SQL person is really tough in my part of the country.
The crystal ball
Keep in mind that this is an editorial with a sprinkling of known facts and lots of forward looking guesses. I think SQL Server professional career path is safe for at least the next 10 years. If it is not, the writing will be on the wall in bold ms sans serif with plenty of time to evolve.