Skip to main content

SQL Server vs. Ford Focus RS: it is a gain!

The installation of SQL Server is very simple. After a few simple questions where you want to put what the installation is a fact and you can use SQL Server. Most users follow the Next - Next - Next - Finish rule and in that case SQL Server is installed with all options chosen installed on the system disk. Nothing wrong with that of cause if you have only one disk because then there is not much to chose, is it.

However, if you are the lucky one having multiple disks in your laptop (I managed to have up to 3 disks) then the installation becomes more tricky. Of cause this is much more difficult when we talk about a Fast Track server with a dedicated SAN behind it and an array of disks that makes an ordinary user dasle. Because you can choose everything becomes more difficult.

It is like ordering an hamburger at MacDo or a VW Golf at your dealer. You have to think whether you like electric windows in the back or tinted glass and at what level. Everything becomes much more easy when you have an example. That's why you see in MacDo this big window above the counter to make you choose faster. The same with VW. Their publicity guides you into prefab models like the Golf 'Rolling Stones' or 'Swing' etc. They try to limited your choice to 5 or 6. Ford did that with the Ford Focus RS. No compromise and really, really incredibly fast! And factory warranty up to 350 horsepower!

The installation of SQL Server does the same thing. It guides you through a process that normally is complex making it simple and give you the feeling that you are in control. But do you really know what you are doing? Looking at all the clients I worked, I can say the majority is not. Especially the customers in France and India. The guys installing SQL Server are just too young, thinking too much on the girl they kissed yesterday while doing the installation or just returned from a late night party doing the installation on automatic mode. They give the impression that they know what they are doing but in fact they don't. And you will find that out after 3 months running. Then things come together and your SQL Server just seem to lose performance.

I knew some IT managers telling me that my loading job should not take more then 1/2 hour because their daily schedule is full. And they have only to load their Data Warehouse. When I looked into it, their DWH turned out to be full of errors like using all the substitute keys and all user keys together in one table. And they stored their user keys of 255 characters long in their fact tables with 800M rows. Great work guys! You knew what you had to do to screw it up! And this guy was telling me that he was in control and he knew what he was doing. LOL.

Last time I got involved me and a colleague of mine tuned down a job that lasted more than 3 hours down to 2 minutes. Oh and I did some tests and their shared SAN had a performance of 0.06 Mb/second at some point in a working day. No wonder that SQL Server did not perform.

This was the bad side of the story which I had to tell to make you understand the good side. Microsoft actually realized that in order to make the choice much more easy for this IT manager they had to provide a pre-configured out of the box solution with a blazing performance. So they designed the Fast Track for Data Warehousing. Bull worked together with Microsoft to deliver a range of products that scale linear in performance and size. From 3 Gb/second up to 14 Gb/second and from 4 Tb to 125 Tb of storage.

The performance is really, really fast! Like the Ford Focus RS the Fast Track program is for Data Warehousing and Data Marts with no compromise. Bull Fast Track does the same for your Data Warehouse as Ford does for their Ford Focus RS: warranty for the performance but Bull gives it for the lifetime of the configuration. So 3 Gb/second stays 3 Gb/second for the whole lifetime of your Data Warehouse. This should make you go to sleep much relaxed and is worth the investment.

You know what? If you get your people on a line we deliver it in 6 weeks completely installed and ready to use. How about it? Is it a deal?

Comments

Popular posts from this blog

Privacy and the liberty to express yourself on LinkedIn

Unaware that LinkedIn has such a strong filtering policy that it does not allow me posting a completely innocent post on a Chinese extreme photography website I tried to post the following: "As an Mpx lover I was suprised to find out that the M from Million is now replaced by the B from Billion. This picture is 24 Bpx! Yes you read this well, 24 billion pixels.  Searching on the picture I stumbled on a fellow Nikon lover. If you want to search for him yourself you can find him here: http://www.bigpixel.cn/t/5834170785f26b37002af46a " In my eyes nothing is wrong with this post, but LinkedIn considers it as offending. I changed the lover words, but I could not post it.  Even taking a picture and post it will not let this pass:  Or my critical post on LinkedIn crazy posting policy: it will not pass and I cannot post it.  The technology LinkedIn shows here is an example what to expect in the near future.  Newspapers will have a unified reporting using

Windows Server 2016 with ... XBox extensions !!!

Microsoft must have been thinking that the live of a Windows administrator gets so boring that they need a distraction and they have integrated the XBox Live extensions standard in Windows Server 2016.  No kidding: take a look. I did not select it as a feature and it is there. As you can see the XBox Live service is started automatically even in mode manual (see error log).  To my opinion these 3 XBox Live services should never be available on a server. Unless the server is part of the XBox Live platform of cause but honestly I don't think that Microsoft will allow that.  Every IT manager with a serious Windows production environment would fire any administrator playing XBox Live on the production servers. So though it might be tempting don't do it Windows administrator. It is a trap! :-)

How to run SQL Server 2016 with In-Databasse R on Windows 2016 CTP5

For those who like me tried to run SQL Server 2016 with In-Database R might have run into the same problem as me: In-Database R or the LaunchPad service gives a timeout and won't start. I did several clean installations with different configuration options - for instance I like to put my data on another disk than the system disk - but in the end I tried to do the next, next, next, finish install to see if it something in the setup options is hard coded in there (yes, it happens developers!). For some reason this problem is related to Windows 2016 and not on Windows 2012R2 and I hope the SQL Server team will soon resolve these issues because they are in one word a bit sloppy.  There are 2 issues (maybe even 3 so I give this one also):  The R setup does not create the ExtensibilityLog directory in the "C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Log" directory The R setup sets the number of users in the SQL Server Launchpad service to 0 it is pos