Monthly Archives: March 2012

The Hidden Cost of Scaling with NoSQL

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 … Continue reading

Posted in SQL Server | Tagged | Comments Off on The Hidden Cost of Scaling with NoSQL

Revenge of the DevOps: Microsoft Targets Next Visual Studio for Admins Too

http://m.readwriteweb.com/hack/2012/03/revenge-of-the-devops-microsof.php

Posted in SQL Server | Tagged | Comments Off on Revenge of the DevOps: Microsoft Targets Next Visual Studio for Admins Too

An Enigma cipher machine in an Excel spreadsheet, made by a non-programmer : programming

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 … Continue reading

Posted in SQL Server, Visual Basic | Tagged | 1 Comment

True Cost of Indexes

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 … Continue reading

Posted in SQL Server | Tagged | Comments Off on True Cost of Indexes

mySql linked server

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 … Continue reading

Posted in SQL Server, Windows | Tagged | Comments Off on mySql linked server

SQL Server 2012 introduces 14 new built-in functions.

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 … Continue reading

Posted in SQL Server | Tagged | Comments Off on SQL Server 2012 introduces 14 new built-in functions.

Windows 8 can become Windows again!

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 … Continue reading

Posted in SQL Server | Tagged | Comments Off on Windows 8 can become Windows again!

Access vs SQL Server – performance

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.. … Continue reading

Posted in SQL Server | Tagged | 1 Comment

Australian philosophers have published an article advocating for the moral right to a post-birth abortion : worldnews

http://www.reddit.com/r/worldnews/comments/qcwv2

Posted in SQL Server | Tagged | Comments Off on Australian philosophers have published an article advocating for the moral right to a post-birth abortion : worldnews

Microsoft Stock Going To $36 With Push From Windows 8 – Forbes

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/

Posted in SQL Server | Tagged | Comments Off on Microsoft Stock Going To $36 With Push From Windows 8 – Forbes