Archive for the 'mssql' Category

Available Today: Preview Release of the SQL Server ODBC Driver for Linux – SQL Server Team Blog – Site Home – TechNet Blogs

Thursday, December 8th, 2011

Finally … MS released ODBC driver for linux, it’s a binary, w/out any packging (no RPMs )
Download it here http://www.microsoft.com/download/en/details.aspx?id=28160 , Documents http://msdn.microsoft.com/en-us/library/hh568451%28SQL.110%29.as…

Available Today: Preview Release of the SQL Server ODBC Driver for Linux – SQL Server Team Blog – Site Home – TechNet Blogs

Thursday, December 8th, 2011

Finally … MS released ODBC driver for linux, it’s a binary, w/out any packging (no RPMs )
Download it here http://www.microsoft.com/download/en/details.aspx?id=28160 , Documents http://msdn.microsoft.com/en-us/library/hh568451%28SQL.110%29.as…

Understanding the StackOverflow Database Schema – SQLServerPedia

Tuesday, April 19th, 2011

Notes about schema used by StackOverflow.com and related websites. It is very simple, only several tables used. (most likely because there are performance problems with joins)

www.sdsqlug.org/presentations/May2009/MySpace_DB_Overview.pptx

Thursday, October 15th, 2009

myspace architecture presentation, talks about how to myspace solves its database issues

To BLOB or Not To BLOB: Large Object Storage in a Database or a Filesystem?

Tuesday, August 5th, 2008

a paper from microsoft research comparing perfomance of 2 systems: metadata in db + files in fs vs. meatadata + files as blobs in db. Study uses MSSQL and NTFS. Datasets are in less than 1 GB size.