May 6, 2011 at 12:19 am
Comments posted to this topic are about the item An Impressive SQL Server
May 6, 2011 at 12:22 am
Here in India, we have a saying that if a restauranter does not eat in his/her own restaurant or if a building contractor does not live in buildings they built, then they are no good.
Similarly, I have always believed that if a company does not use it's own products, it's not a good product.
For me, there is no doubt about SQL Server scalability and I know Microsoft uses SQL Server to power it's back offices. Therefore, I believe that for most people, if Microsoft uses SQL Server for it's services and websites, it should good enough proof that SQL Server is scalable.
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins
May 6, 2011 at 12:55 am
I would love it if IBM used SQL Server as the database for Tivoli Netcool for storing all the monitoring data and the topology database.
I have experienced it using DB2 and MySQL (the former runs particularly badly) and reckon it would handle the load really well (if properly maintained by someone who knows what performance tuning is).
I think it would also help fight the stigma that Microsoft has in the RDMS arena 🙂
May 6, 2011 at 1:03 am
Nakul: I like the Microsoft example very much 🙂
Impressive for me would be if the CIA or NSA are using SQL Server to store their intelligence data.
Have a nice day!
May 6, 2011 at 1:59 am
In regard to scalability it is of no consequence but as for the 'image' of SQL server: well, since 2010 SQL server is hosting and cohordinating the television personnell data for the 'A series' Italian football championship and for next season it will manage the same data also for the 'B series'.
The funny thing is: guess what system was used untill 2010 to manage that data?
Excel and e-mail!
When I found out last year I couldn' t believe it 😀
May 6, 2011 at 2:32 am
SQL Server is already used by F1 teams (McLaren mainly but now all it seems) for live data recording and processing on the fly. Sure I saw an article or advert trying to hide as one regarding the use of it already - a quick web search finds that Microsoft has this as one of their case studies... maybe I'm one of the last to just read up on this properly!
http://www.microsoft.com/casestudies/Case_Study_Detail.aspx?CaseStudyID=4000001476
Wish I was the DBA that needed to be track side....
May 6, 2011 at 2:35 am
Amazon, definitely.
The BBC's web site perhaps. Although, depending on how the site was developed it may not actually use the database that heavily. Still, it'd be kinda cool.
May 6, 2011 at 2:39 am
Amazon, Google, Apple, eBay, Bing (?)
May 6, 2011 at 3:20 am
That Oracle might use SQL Server as a back end for any of their serious systems is, I'm sure, highly unlikely. However, I'd love to see how much they use SQL Server for smaller applications. No doubt they do their damnedest to avoid using it, but I'd still bet something in Oracle'd break if SQL Server suddenly ceased to exist.
Semper in excretia, suus solum profundum variat
May 6, 2011 at 3:22 am
I'd love to see how the TFL and Oyster network for London Underground is architected.
They have approximately 3 million journeys a day taking place, using RFID cards to gain entry in and out of the system. These cards are paid for either by monthly billing or as a cash top up from thousands of machines located in local shops and stations which can be used instantly. There is also an integrated website where you can pay for your travel pass, before swiping your card at the nominated station to 'collect' it. As well as that there is the route planning and real-time service information being delivered to the thousands of mobile internet users checking the best way home on their smartphone apps.
I don't know how they do it, but if SQL Server handled any part of all these real-time transactions and subsequent analysis this it would be impressive.
Kindest Regards,
Frank Bazan
May 6, 2011 at 3:24 am
Telefónica (major telecommunications company in Spain).
Actually, we used SQL Server for the Customer Relationships Center in an application for Telefónica Móviles (the mobile filial of Telefónica): the database stored data from all the customers' calls to the Contact Center, including the mobile cell used, transfers of the call across different systems (both automated and human-attended), tracking of the options typed on the phone keyboard during the call, et cetera.
It was only for the calls directed to the Contact Center and usually stored about 5,5 millions rows a day in the main tables. Can you imagine the system that actually stores the same data for all the calls from any subscriber to any other subscriber across the country?
May 6, 2011 at 3:24 am
Hotmail, MSN and Windows Live.
May 6, 2011 at 3:28 am
Actually, I've just thought about it a bit more, and what would really impress me would be if Microsoft would finally allow at least the choice of using SQL Server as the back end for Exchange.
Semper in excretia, suus solum profundum variat
May 6, 2011 at 4:00 am
World of Warcraft? 🙂
May 6, 2011 at 4:06 am
I agree, if homeland security used MS SQL server I would be impressed. No so much for the volume of data but the fact they believe the security of data is the best. In my honest opinion, the security of data is what will make the difference.
Viewing 15 posts - 1 through 15 (of 66 total)
You must be logged in to reply to this topic. Login to reply