2014.02.05

   

   

SQL

   

• Top SQL Server Forums of 2014

  http://www.johnsansom.com/top-sql-server-forums-2014/

   

• 5 MORE QUESTIONS FOR INTERVIEWING A DATABASE ADMINISTRATOR

  http://thomaslarock.com/2014/02/5-more-questions-for-interviewing-a-database-administrator        

     

• SQL Server versions ? Should you upgrade to the next release?

  http://www.pythian.com/blog/sql-server-versions-should-you-upgrade-to-the-next-release/

     

• AlwaysOn Availability Groups, Listener, Named Instances, Port Numbers, etc.

  http://blogs.msdn.com/b/sqlcat/archive/2014/02/03/alwayson-availability-groups-listener-named-instances-port-numbers-etc.aspx

     

• Generating a trusted TDE Certificate in the proper format from a Certificate Authority

  http://blogs.msdn.com/b/sql_pfe_blog/archive/2014/02/04/generating-a-trusted-tde-certificate-in-the-proper-format-from-a-certificate-authority.aspx

     

• Merge Replication Identity Range Management ? An Identity Disorder? Part 2

  http://www.pythian.com/blog/merge-replication-identity-range-management-an-identity-disorder-part-2/

     

• Using sys.objects When Scripting Permissions? You're Missing Something!

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/04/using-sys-objects-when-scripting-permissions-you-39-re-missing-something.aspx

     

• Error Authenticating Proxy | SQL and UPNs

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/04/error-authenticating-proxy-sql-and-upns.aspx

     

• 3 Tips for Getting Gold Medal Performance out of Your SQL Server Installation

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/04/3-tips-for-getting-gold-medal-performance-out-of-your-sql-server-installation.aspx

     

• SQL SERVER ? Multiple ways to convert Datetime to Varchar

  http://raresql.com/2014/02/04/sql-server-multiple-ways-to-convert-datetime-to-varchar/

     

• Conditional Aggregates

  http://mattsql.wordpress.com/2014/02/04/conditional-aggregates/

     

• PowerShell Script for SQL Server 2012/2008 Cluster/StandAlone unattended Install and uninstall

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/04/powershell-script-for-sql-server-2012-2008-cluster-standalone-unattended-install-and-uninstall.aspx

     

• Loading Power Query M Code From Text Files

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/04/loading-power-query-m-code-from-text-files.aspx

     

• SSAS: Synchronize

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/04/ssas-synchronize.aspx

     

• PowerShell ? SQL Inventory ? Automatic ? Excel File ? EMAIL

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/04/powershell-sql-inventory-automatic-excel-file-email.aspx

     

LINKS

   

• LAST WEEKS TOP "READING" LINKS #69

  http://www.jasonstrate.com/2014/02/last-weeks-top-reading-links-69/

     

Other

   

• Which is the best MongoDB GUI?

  http://blog.mongodirector.com/which-is-the-best-mongodb-gui/

     

• Iaas, Paas, SaaS 개념

  http://sqlmvp.kr/140206089976

     

• [Redis] Scan/SScan/ZScan/HScan 이야기…

  http://charsyam.wordpress.com/2014/02/04/redis-scansscanzscanhscan-%EC%9D%B4%EC%95%BC%EA%B8%B0/

     

• NoSQL trends: MongoDB, Cassandra, Couch & Riak

  http://java.dzone.com/articles/nosql-trends-mongodb-cassandra

     

• [번역] 좋은 엔지니어와 나쁜 엔지니어의 리더십

  http://www.mimul.com/pebble/default/2014/02/04/1391490935022.html