The Hidden Cost of Scaling with NoSQL Today’s applications are big. With hundreds of thousands of users, many of whom are uploading content regularly, the size of the data store can grow massive in short order. Not surprisingly, for data architects, scale is a real concern. At companies with global internet reach, such as Google […]
I just love Visual Basic, and the Excel / Access paradigm. I just wish that Excel had basic RDBMS support. This is interesting to me.. but it seems REALLY REALLY sad that this actually takes -any- time at all to execute.. I mean, how complex can the algorithm really be? Maybe I’ll re-create this in […]
March Madness – SQL Azure – sys.dm_db_partition_stats – Index Cost Yesterday we looked at how you could determine the cost of a single row stored in SQL Azure. Part of my focus for doing so was to help you understand that a bad database design can lead to higher costs. Creating unnecessarily wide tables will result in […]
I think that Microsoft SQL Server is the best database in the world. Sometimes, it is necessary to work with inferior 3rd party products. Here is a walkthrough on setting up a Linked Server on mySQL. In other words- you can use this data as if it were located in God’s database- SQL Server. In […]
14 New Functions and 1 Changed Function SQL Server 2012 introduces 14 new built-in functions. These functions ease the path of migration for information workers by emulating functionality that is found in the expression languages of many desktop applications. However these functions will also be useful to experienced users of SQL Server. The new functions […]
http://betanews.com/2012/03/08/windows-8-can-become-windows-again/ Wow this person has tb audacity to claim that Vb is what made Windows successful.. I entirely agree. It is too bad that (unproductive ) c++/c/c# people look down upon Vb. The death of Vb is why Windows is irrelevent.
I just was looking at this 14m row table.. I had a copy sitting in Jet and a copy in SQL Server. I just couldn’t get over how slow jet queries are. The SAME QUERY in Jet takes 140 seconds.. In SQL Server? 2 seconds!
Microsoft kicks ass.. ridiculous that Apple is overvalued by so much with a tiny market share!!!! 6 percent!!! http://www.forbes.com/sites/greatspeculations/2012/03/01/microsoft-stock-going-to-36-with-push-from-windows-8/