https://pinboard.in/u:sunpig/public/ recent bookmarks from sunpig 2015-03-16T07:57:30+00:00 https://www.simple-talk.com/sql/t-sql-programming/contiguous-time-periods/ sunpig tsql sql time period temporal table db database https://pinboard.in/ https://pinboard.in/u:sunpig/b:e758b1cc5308/ 2015-03-16T07:56:14+00:00 https://www.simple-talk.com/sql/database-administration/how-to-get-database-design-horribly-wrong/ sunpig db design database failure patterns https://pinboard.in/ https://pinboard.in/u:sunpig/b:5cd9fa8c26ad/ 2014-09-25T05:50:08+00:00 http://www.garysieling.com/blog/auditing-data-changes-postgres sunpig postgresql security audit trail table db database pg pgsql sql trigger hstore https://pinboard.in/ https://pinboard.in/u:sunpig/b:1f67c152bf60/ 2014-03-20T08:27:20+00:00 http://blog.lostpropertyhq.com/postgres-full-text-search-is-good-enough/ sunpig postgres postgresql sql full text search index db database performance https://pinboard.in/ https://pinboard.in/u:sunpig/b:2415b0ad870d/ 2013-06-06T11:00:16+00:00 http://www.salsify.com/blog/easy-eager-loading-with-database-views/1252 sunpig database rails views materialized db postgres postgresql eager load performance sql https://pinboard.in/ https://pinboard.in/u:sunpig/b:eea639dabc22/ 2013-05-20T14:16:42+00:00 http://aphyr.com/tags/jepsen sunpigcap database db partition network distributed architecture aphyr jepsen carly rae call me maybe https://pinboard.in/ https://pinboard.in/u:sunpig/b:bea3cfc11f0d/ 2013-05-10T09:35:14+00:00 http://adamsanderson.github.io/railsconf_2013/ sunpigconference postgres postgresql rails activerecord hstore array type data database db https://pinboard.in/ https://pinboard.in/u:sunpig/b:036ff5b2e81a/ 2012-10-04T17:14:41+00:00 http://www.rollcallapp.com/blog/2011/10/03/adding-multi-tenancy-to-your-rails-app-acts-as-tenant sunpig multitenant db database rails tenancy user postgres pg pgsql schema multiple ruby library select activerecord strategy https://pinboard.in/ https://pinboard.in/u:sunpig/b:79e50b2f5c20/ 2012-10-04T17:13:43+00:00 http://blog.jerodsanto.net/2011/07/building-multi-tenant-rails-apps-with-postgresql-schemas/ sunpig multitenant db database rails tenancy user postgres pg pgsql schema multiple ruby library select activerecord strategy https://pinboard.in/ https://pinboard.in/u:sunpig/b:44dac5dec0a8/ 2012-09-25T10:26:10+00:00 http://highscalability.com/blog/2012/9/24/google-spanners-most-surprising-revelation-nosql-is-out-and.html sunpig database db google spanner nosql sql bigtable megastore data transaction row lock performance bottleneck https://pinboard.in/ https://pinboard.in/u:sunpig/b:6499af0ebce2/ 2012-02-29T16:17:26+00:00 http://blog.mozilla.com/tglek/2012/02/22/psa-dom-local-storage-considered-harmful/ sunpightml localstorage db local cache api synchronour io https://pinboard.in/ https://pinboard.in/u:sunpig/b:412cc6758d4d/ 2012-02-01T18:11:03+00:00 http://www.allthingsdistributed.com/2012/01/amazon-dynamodb.html sunpigamazon dynamo dynamodb db database nosql scale aws service https://pinboard.in/ https://pinboard.in/u:sunpig/b:5bf75818b4bd/ 2011-10-31T09:11:51+00:00 http://www.sqlmag.com/article/sql-server/inline-scalar-functions sunpigsql server udf function inline table return performance optimization db microsoft https://pinboard.in/ https://pinboard.in/u:sunpig/b:aaf6d9faee9d/ 2011-04-04T07:51:55+00:00 http://www.simple-talk.com/sql/sql-tools/the-unnecessary-evil-of-the-shared-development-database/?utm_source=simpletalk&utm_medium=email-main&utm_content=SharedDevTroy-20110404&utm_campaign=SQL sunpigsimpletalk sql mssql development practice dev code software programming database db vcs dvcs version control developer productivity local shared https://pinboard.in/ https://pinboard.in/u:sunpig/b:08b457417f05/ 2011-02-21T13:43:50+00:00 http://www.simple-talk.com/sql/t-sql-programming/look-up-tables-in-sql-/?utm_source=simpletalk&utm_medium=email-main&utm_content=LookUp-20110221&utm_campaign=SQL sunpigjoecelko lookup table sql database db design attribute property name https://pinboard.in/ https://pinboard.in/u:sunpig/b:aac799206014/ 2011-02-02T16:16:19+00:00 http://www.kitebird.com/articles/ruby-dbi.html sunpigdatabase programming ruby tutorial dbi dbd access open close connect select db sql https://pinboard.in/ https://pinboard.in/u:sunpig/b:56b212bae013/ 2010-06-17T21:37:02+00:00 http://www.vineetgupta.com/2010/01/nosql-databases-part-1-landscape.html sunpigvineetgupta nosql voldemort redis cassandra sql scalability database datastore survey overview summary comparison db data https://pinboard.in/ https://pinboard.in/u:sunpig/b:f0e327bf56dc/ 2010-02-09T20:08:03+00:00 http://ai.mee.nu/seeking_a_database_that_doesnt_suck sunpigdatabase db storage data sql nosql mysql postgres redis voldemort couchdb https://pinboard.in/ https://pinboard.in/u:sunpig/b:89a93a6ed357/ 2009-03-08T21:09:13+00:00 http://www.jurriaanpersyn.com/archives/2009/02/12/database-sharding-at-netlog-with-mysql-and-php/ sunpigperformance data php mysql scale database db availability scaling sharding shard jurriaanpersyn netlog partition https://pinboard.in/u:sunpig/b:37fafcc5e607/ 2009-01-07T16:50:35+00:00 http://www.37signals.com/svn/posts/1509-mr-moore-gets-to-punt-on-sharding sunpigperformance optimization web space mysql scale database 37signals db memory scaling sharding shard migration geeknotes https://pinboard.in/u:sunpig/b:6831a7cf1832/ 2007-01-11T12:15:40+00:00 http://www.techinterviews.com/?p=161 sunpigsqlserver database db dba interview questions sql work tech job https://pinboard.in/u:sunpig/b:99245c0162f8/ 2006-12-09T21:28:06+00:00 http://scottonwriting.net/sowblog/posts/10592.aspx sunpigscottmitchell sql sqlserver datetime month db database https://pinboard.in/u:sunpig/b:a27a2fc7c111/