2013.02.13 (2)

   

  SQL

• How to allow Ad hoc updates in SQL Server system catalogs

  http://www.mssqltips.com/sqlservertip/2875/how-to-allow-ad-hoc-updates-in-sql-server-system-catalogs/

   

• SQL Agent Alert System Error: [264] An attempt was made to send an email when no email session has been established

  http://basitaalishan.com/2013/02/11/sql-agent-alert-system-error-264-an-attempt-was-made-to-send-an-email-when-no-email-session-has-been-established/

     

• Exploring earnings data for the UK [Open Data]

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/02/11/exploring-earnings-data-for-the-uk-open-data.aspx

   

• Difference between UNIQUE CONSTRAINT versus UNIQUE INDEX

  http://www.sqlserver-dba.com/2013/02/difference-between-unique-constraint-versus-unique-index.html

     

• #0239 - SQL Server 2012 - Msg 402 - The data types datetime and time are incompatible in the add/subtract operator

  http://beyondrelational.com/modules/2/blogs/77/Posts/18855/0239-sql-server-2012-msg-402-the-data-types-datetime-and-time-are-incompatible-in-the-addsubtract-op.aspx

     

• Moving Database Files in SQL Server

  http://www.sqlservercentral.com/articles/Files+and+Filegroups/96031/

     

• Move all SQL Server indexed views to a new filegroup

  http://www.mssqltips.com/sqlservertip/2882/move-all-sql-server-indexed-views-to-a-new-filegroup/

     

• SQL SERVER – What is Semantics Model – A Simple Explanation

  http://blog.sqlauthority.com/2013/02/11/sql-server-what-is-semantics-models-a-simple-explanation/

     

• Day 26 of 31 Days of Disaster Recovery: The Mysterious Case of the Long Backup

  http://www.sqlsoldier.com/wp/sqlserver/day26of31daysofdisasterrecoverythemysteriouscaseofthelongbackup

     

ETC

   

• fatcache is memcache on SSD. Think of fatcache as a cache for your big data.

  http://data.story.lu/2013/02/11/twitters-fatcache-available-on-github

     

• Testing the StreamInsight Service for Windows Azure

  http://www.simple-talk.com/cloud/platform-as-a-service/testing-the-streaminsight-service-for-windows-azure/

     

• Google on Datastore Query, Index, and Transactions

  http://architects.dzone.com/articles/google-datastore-query-index