Wednesday, January 25, 2012

Brief history of Microsoft SQL Server

Just got curious about the entire history of how SQL server evolved since its birth. Here is a short blog reflecting the research.

For an interesting story on how SQL server evolved, please refer the document History of SQL Server.

A brief history of SQL Server is available in the table below (along with the relevant links to corresponding resources):

Year

SQL Server Version

Code Name

2012

SQL Server 2012

Denali

2010

SQL Server 2008 R2

Kilimanjaro (aka KJ)

2010

SQL Azure

Matrix (aka CloudDB)

2008

SQL Server 2008

Katmai

2005

SQL Server Integration Services (formerly Data Transformation Services)

2005

SQL Server 2005

Yukon

2004

SQL Server 2000 Reporting Service

2003

SQL Server 2000 (64-bit Edition)

Liberty

2000

SQL Server 2000 Analysis Services

Shiloh

2000

SQL Server 2000

1999

SQL Server 7.0 OLAP Services (including Data Transformation Services)

Plato

1998

SQL Server 7.0

Sphinx

1996

SQL Server 6.5

Hydra

1995

SQL Server 6.0

SQL95

1993

SQL Server 4.2 (32 bit Edition)

SQLNT

1991

SQL Server 1.1

1989

SQL Server 1.0 (16bit)

Ashton-Tate/Microsoft SQL Server

Also details of some of the specific release dates and build numbers are available on MSDN link.

Some guidelines on upgrade paths (till SQL Server 2008 R2) are available on MSDN here.

More technical details about each version is available here.

Tuesday, January 3, 2012

How much a private cloud costs?


Microsoft recently showcased the power of its private cloud in a TechEd event in North America, by building one onsite and running Hands on Lab on it. It included hardware mostly from Microsoft’s partner HP, and Microsoft Software stack. The video for the same is available here.
To get a better understanding of this private cloud (in terms of cost), we did a simple cost analysis of hardware infrastructure used for developing such a datacenter. This includes a simple blade system based datacenter, capable of serving around 1500 client systems. The datacenter hosts a huge number of virtual machines (VMs) which are in fact the pre-configured environment for Hands on Lab (HOL) for learning different technologies. These HOLs can be accessed by each of the client systems as and when required. Upon request, a copy of the VM is sent to the client machine, which becomes the personal copy for that client, but still running on the powerful servers of the Datacenter only. No actual processing is done at client's end, except for simple Internet Explorer based application sending and receiving the request to and from the datacenter.
Following are the rough figures explaining the hardware infrastructure along with cost estimate of the private cloud.
Sample Private Cloud Datacenter configuration and cost:
Blade Enclosure Unit
HP BladeSystem c7000 Enclosure with Flex-Fabric
$24,399.00
HP BladeSystemOnboard Administrator
-Enclosure Management
-Flex Fabric Management
-HP Integrated Lights-Out (ILO)
$899.00
Blade Server
HP Proliant BL460c G7 Server Blade (model considered : HP BL460c G7 L5640 1P Svr (603256-B21)
-16 Server blades
-2P * 6 cores
-128 GB RAM
-2*146 GB HDD
-BL460c G7 - 128 GB RAM
$333,180 per blade * 16 = $5,330,880
HP IO Accelerator Card in each Blade (320 GB)
- Solid State Disk PCI Card
- 145,000 IOPS
- Read: 750 MB/s
- Write: 550 MB/s
-Sizes (GB): 640 or 320
$ 9,719 per Blade * 16 =
$155,504
SAN Disks
HP Storageworks 4400 EVA Fibre Channel SAN
- 4/8 Gbps Fibre Channel
-Dual Controllers
-Dual Embedded SAN Switches
$13,839.20 including 8 HDDs
Additional HDD
- 40 * 300 GB 15K RPM Disks
$1,491 * 40
= $59,640
Network
HP FlexFabric Network
- Converged Infrastructure
-Virtual Connect Technology
-4/8 Gbps Fibre Channel
-1/10 Gbps Ethernet
Varies depending on infrastructure location and size
The total Infrastructure cost for this sample Private cloud datacenter turns out to be ~$5,585,161. The cost for software, installation, maintenance and upgrades would be further added to get the complete TCO for a private cloud.
This private cloud provides many benefits like scalability, self service capabilities, high customization, security, and reduced operational costs. So for the enterprises investing billions of dollars for their Infrastructure, this seems to be a reasonable price for all the benefits they gain, but for medium and small industries, this seems to be an investment into the unforeseen future.
(These are just indicative price taken from the mentioned sources. In case of any concerns/discrimination in price or product, or the calculations at any place, we are open for corrections. Do let us know your feedback for the same.)

Friday, December 30, 2011

Top 10 cloud computing providers of 2011

As already expected at the beginning of year 2011, world saw many transitions, transformations, and turnarounds in the cloud technologies from various vendors across the globe. A summarized report of all the predictions made by various analysts is available here.

And the list of most substantial players, as already mentioned in an earlier post, comes out to be as follows:

1) Amazon
For the second year in a row, the king of cloud is still Amazon Web Services. No other company has come close to the cloud-based innovation AWS provides.
Even Eli Lilly taking some of its business elsewhere ended up doing AWS a favor. Since that debacle over SLAs, Amazon has stepped up its support and now offers a premium "white glove" service that routes your call to the nearest engineering specialist.

2) Verizon/Terremark
Charging into the number two position on our list is Verizon. The telco giant had previously built its own cloud; high-quality stuff but with a commensurate price. The Four Seasons of cloud, if you will: snooty service, small menu, long waits for a reservation and eye-watering bill. It was a test run, and apparently Verizon decided it needed some expertise instead of re-inventing the wheel.
Verizon then bought Terremark, much as you or I would buy a coffee and a bagel. Not only is Terremark one of the premier Tier 1 hosters in the world, it's also a cloud supplier to the coveted enterprise market, effectively moving Verizon into the top ranks.
Bigger than almost any competitor and with all the pipe in the world (literally), Verizon could be the King Kong of cloud. We’ll see if they can make it work or if Terremark Cloud is doomed for post-acquisition mishandling.

3) IBM
New to the list is IBM with its Smart Business Test and Development Cloud. While Big Blue might be lugging a hundred years of IT baggage, it has finally launched Infrastructure as a Service, although initially just for test and development purposes.
Despite its convoluted, muddled strategy in the cloud market, the Test and Dev service is winning enterprise business, which after all is IBM’s meat and potatoes. IBM reportedly earned $30 million in cloud revenue last year; few others have the scale of the enterprise user base to ramp up that fast.

4) Salesforce.com
Salesforce.com maintains a spot in the top five, thanks to its acquisition of Heroku. The company singlehandedly forced its way into the Platform as a Service market with this buy, and it will give them legs to hit customers not interested in the patented "Salesforce.com maximum lock-in" feature offered on Force.com and their CRM platform.
The Software as a Service market is rapidly coalescing into a mature, well-defined space; props to Salesforce.com for grabbing on to something that keeps it relevant going forward.

5) CSC
CSC, the IT integrator and service provider has cooked up an interesting private cloud service called BizCloud. The company will wheel VCE -- the giant cloud-in-a-box system from VMware, Cisco and EMC -- into your IT shop. Ten weeks later, it will be integrated into all your messy, legacy IT systems, turning on Infrastructure as a Service. CSC then manages your hardware; for extra capacity, you can hook into a public cloud service, also running on VCE.
CSC points to the trend of enterprises looking for practical ways to use (and get to) cloud computing; the company also performs massive-scale integrations with Google Apps and other Software as a Service players. As a bridge to the cloud for many enterprises, CSC is on the front lines and on our top 10 list.

6) Rackspace
Even though Rackspace fell in the ranks from last year's list, it's still the number two cloud provider after Amazon in terms of revenue. It might even be coming close in terms of its user base, a remarkable feat.
But aside from the feel-good soft launch of OpenStack last year, it's still business as usual. The company hasn't made any major renovations to the service, something that may change as Rackspace absorbs cloud management technology firm Cloudkick.

7) Google
Since our initial list, Google App Engine has won lots of business among Web, gaming and mobile companies, but similarly has yet to make any impact among enterprise developers. We talked to the Google App Engine team recently and they are working on adding features, including an SLA and a hosted SQL service that Google hopes will attract the enterprise developer audience.
The company is also reportedly hiring 6,000 warm bodies in 2011, most likely to supply that crucial enterprise support Google has so notably lacked. Can’t win the cloud with foosball and beanbags, kids; put your big-boy clothes on and get ready for real customers. The race is on with Microsoft!

8) BlueLock
BlueLock is a small-scale provider that's been a key testbed for VMware’s vCloud Express. It even pioneered a tool to help customers get out of their ESX bubbles and mix in vCloud resources, something VMware hadn’t been able to do. BlueLock’s Indiana facilities should soon become a major local employer, as it's now a key VMware/VCE provider and likely to see continued growth.

9) Microsoft
Microsoft is on a bit of a downward spiral. While the software giant has made a song and dance about its Azure cloud service, claiming 31,000 companies are customers, we’ve yet to see any significant traction among enterprise IT developers. Web companies, mobile companies, tech and social networking firms use it, sure, but so far there’s no standout among traditional enterprises.
Meanwhile, Microsoft’s cloud business is in turmoil, as Steve Ballmer has purged many of the company's key leaders. Software architect Ray Ozzie is out. Bob Muglia and Amitabh Srivastava from Server and Tools (and Azure) have left. Dave Thompson (Office Online, Office 365) is gone.
Now at the helm is veteran Satya Nadella, who ran Microsoft’s unremarkable ERP and CRM efforts. These people didn’t fail -- they built everything Microsoft can legitimately call "cloud" -- but they’ve been cut loose before their work had a chance to prove itself.

10) Joyent
We bumped a few other providers off the list due to lack of activity (business as usual doesn’t cut it). Joyent, however, kept a spot in the top 10 by releasing its platform software and forming a partnership with Dell to sell pre-configured cloud infrastructure packages.
It's a nice way to push the model -- use the Joyent service, or build your own if you like the technology but not the public option. This may be the direction the market is headed, as more and more businesses want to adopt cloud computing within their infrastructure.

(Source: http://searchcloudcomputing.techtarget.com/feature/Amazon-2011-top-cloud-computing-provider#slideshow)

Thursday, December 22, 2011

IT Skills vs Real Education

Recently, an article was published on one of the technology portals about the 'Top 11 skills of 2011". On the basis of the results of questionnaires they prepared, and the answers they received, they prepared a list the top skills for 2011. But the results, according to me, were bit misleading.

These are just result of programming contests, mostly attended by college students or employees on bench in IT companies. For them, these are the familer, simplest, and comfortable languages. In practice, different results can be found for hot technologies at different sites like: http://www.sap-img.com/the-top-it-skills-to-have.htm

But in real, the IT skills contains bit different set of names all together. Its much beyon just few programming languages, like Problem-solving, Training skills, Foreign language communication skill, etc, along with domain knowledge like Networking, Security, Telecommunications, Business Intelligence etc. There are few sites where i found mention of such skills that talk about them are people daily, itcareerfinder etc., but there are very few paths or search algorithms that brings these skills higher in the list of Essential IT Skills.

And if you are at much begginer level, you need to get the basic skills like team work, communication and co-operation, i am glad there is a small number of links promoting that too.

If you have these, you can learn any language (C, java etc.) within few weeks.

Again repeating the nice thought for Great Chanakya
"Education is the Best Friend.
An Educated Person is Respected Everywhere.
Education beats the Beauty and the Youth."

But the thing to be noticed here is about the real meaning of education.
Its not just having a Bachelor's or Master's degree. Its something more than that. And that can not be taught in books, but is learned with the real life experiences.

Sunday, November 27, 2011

SQL Server 2008 Learning Framework.

SQL Learning Framework.
I found some good material suitable for all skills and levels. Here are the details:

Level
Source Link
Details
Estimated time
Scope covered
Basic
Learn SQL Server Concepts in very simple steps. This site provides very precise information about SQL Server basics, along with good examples, and also a sample environment for testing the concepts.
64 Lessons
*
10-15 Min per lesson
=
~ 16 hours
Can be referred by the beginners to gain complete understanding about the subject
Intermediate



This 200 page PDF covers good levels of details about various concepts.
10 Chapters
*
6-8 hours per Chapter
=
~80 hours
Can be covered for certification purposes.
Advanced
These tutorials provides a detail drill-down on SQL Server 2008 R2 with relevant examples.
19 tutorials
*
3 days per tutorial
=
~ 57 days
Can be referred while working on real-time projects; or for doing research on a particular topic.





Problems in the cloud

Very recently there have been many incidents with the cloud services, which questions against a promising future of a Cloud-based IT world. Customers of many major cloud vendors have faced outage issues including the following:

1) Amazon: Thursday, 21st April 2011. Outage Duration: approx 11 hours + many services partially down for much longer duration (Computerworld)

2) Google: Wednesday, 11th May 2011. Outage duration : approx 30 hours. (ZDNet)

3) Microsoft: May 10 , May 12 2011. Total Outage Duration 9 hours. (eweek)

4) VMware: 25 and 26th April, 2011. Outage time: Several hours (informationweek)

5) Rackspace: June 29, July 7th and then 3 Nov 2009. Total Outage: Several hours (infoworld)


These incidents are not because of secondary issues like ISP failures or natural disasters.

On these corresponding links, Google, Microsoft, Rackspace, Amazon and VMware confessed themselves, that these issues were due to some technical/manual issues at the ultimate source of origin of these services

And customer's problems may not be limited to the cloud service providers, there can be several other factors, due to which the end-customers may find themselves incapable of using the 'Promised' services. Sony's PlayStation Network Catastrophe, Rdio Service Outage, Netsuite Service Outage and just examples from a long list of failures, hitting back against the effectiveness of the cloud services.
Under these circumstances, customer's trust on this upcoming concept and reliability on cloud are under threat.
The cloud is a relevantly new domain, and will certainly face many hiccups before getting stable. So the general recommendation for the customers will be to stick to a Hybrid Scenario, having a backup of all online services and partial (if not full) support for all services in offline mode.

Top Cloud vendors in 2011

In the beginning of this new decade, there are several technologies in focus by the technocrats around the world. These are assumed to be the game changing technologies, and have a huge potential of making substantial impact on our daily lives. One such technology, cloud computing, has seen several transitions, transformations, and turnarounds via various vendors around the globe.

According to Techtarget (www.techtarget.com), following should be the list of Top Cloud vendors in 2011:
#1: Amazon - So far, no company has come close to the cloud-based innovation AWS provides. Amazon still should remain the king of cloud.

#2: Verizon/Terremark - The telco giant had previously built its own cloud; high-quality stuff but with a commensurate price.

#3: IBM - IBM reportedly earned $30 million in cloud revenue last year; few others have the scale of the enterprise user base to ramp up that fast

#4: Salesforce.com - With acquisition of Heroku, salesforces.com keeps its props of doing some innovation in cloud space.

#5: CSC - With its private cloud 'BizCloud', CSC will wheel VCE - the giant cloud-in-a-box system from VMware, Cisco and EMC - into the corporate space.

#6: Rackspace - Still the number two cloud provider after Amazon in terms of revenue, Rackspace may have something in its pocket this year after the launch of OpenStack last year.

#7: Google - Google App Engine has won lots of business among Web, gaming and mobile companies, and is expected to do even more this year.

Other mentionable names in the list, according to the analysis done be techtarget, were BlueLock, Microsoft, Joyent and NephoScale.

(Article taken and adapted from http://searchcloudcomputing.techtarget.com/feature/NephoScale-2011-top-cloud-computing-provider#slideshow)

Total Pageviews