The Curious Engineer

All blogs / Databases

Collation, DateTime, SParse Column and XML

learn.microsoft.com/en-us/archive/blogs/qingsongyao

DatabasesTesting / QAEngineering management / careersDistributed systems / cloudMicrosoft blogsMSDN archive

’10’15’20’25
Posts
117 from 31 Jul 2008 to 18 Feb 2015
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/qingsongyao/feed.xml

2015 5

  1. Readings on Service Architect DevOps and Automation
  2. My New presentation on Windows Azure SQL Database Cluster Dashboard project
  3. Reading for mobile development
  4. Reading for BigData and Telemetry
  5. My reading for Engineering System and Continuous Delivery

2014 10

  1. Not a tester any more
  2. Recommend testing article "Leading a Culture of Effective Testing"
  3. Dev management in Douban
  4. Talk by Ken Johnston - Modern testing is becoming EaaSy
  5. Bing team's A/B testing articles
  6. Engineering Principle and Practices from Other Companies
  7. QCON New York 2014 Conference Day 1 Highlight
  8. Day three of Qcon Conference
  9. Take away from running Windows Azure SQL VM (IASS)
  10. How to fix Nokia Lumia 520 frequent shutting down issue

2013 35

  1. A Chinese article "前富士康CEO程天纵：创新来自长尾，创业源于创客！"
  2. Recommend Talk " Resiliency through Failure - Netflix's Approach to Extreme Availability in the Cloud"
  3. Recommend Blog Post "Testers – The Scientists Who Produce Knowledge about the Quality of SUT"
  4. Recommend Slides "Call Of Duty :DevOps"
  5. Recommend J.D. Meier's Blog
  6. Two Hadoop Blogs I plan to read
  7. Learning from doing
  8. No Email after 8PM
  9. My thought on data pipeline
  10. TestOps: it really happen here
  11. My presentation on Windows Azure SQL Database Cluster Dashboard project
  12. Topics on how we testing Windows Azure SQL Database Series
  13. What I did in past months and what i plan to write
  14. Design a good alert system is hard but worth well
  15. My thought on external monitoring
  16. "How Netflix Deploys Code"
  17. Fun with Review
  18. My achievement
  19. How to build and run a service
  20. Take away on Seattle Technique Forum: Case of Big Data
  21. How a Chinese e-commerce company racked up $3 billion in sales in just one day
  22. Curt Monash on "The future of search"
  23. Recommend Book "The Architecture of Open Source Applications"
  24. SQL Server UPPER function on non-english characters
  25. 2013年，移动互联网行业技术趋势前瞻
  26. Prismatic Architecture - Using Machine Learning on Social Networks to Figure Out What You Should Read on the Web
  27. Recommend Paper "​​​The NoSQL movement -How to think about choosing a database."
  28. Testing the Limits With Microsoft’s Seth Eliot
  29. TQA - Quality in the Cloud: The new Role of TestOps
  30. uTest blog: "Advice from 2011′s Testers of the Year"
  31. 2nd Annual QA/Test Job Posting Study from dfrank
  32. Testing the Limits with Gerald Weinberg
  33. Code isn't just for programmers. It's a part of the world we live in.
  34. Notes on the Hadoop and HBase markets
  35. A Tester’s Commitments by James Bach

2012 24

  1. Blogs I usually follows
  2. Common Engineering Principle and Practices
  3. People never learn from others
  4. My past testing experience
  5. My take away on Seattle Technical Forum : Cloud Computing Revealed
  6. A good testing slides
  7. Technology Radar from ThoughtWorks
  8. 享技术，聚朋友。Tcon2012专题 at qa.taobao.com
  9. The journal of becoming senior tester (3) - becoming a professional QA
  10. Software Testing should be challenge, creative and enjoyable
  11. Best practices for building Windows Azure service
  12. Examples of MsTest Extension
  13. From Continuous Integration to Continuous Delivery
  14. How are you testing scenarios?
  15. SASQAG Monthly Meeting "Signals in Testing"/How Google Testing Software
  16. The journal of becoming senior tester (15) - Take time to thinking
  17. The journal of becoming senior tester (14) - Doing things differently
  18. Recommend reading "Testers: Get Out of the Quality Assurance Business"
  19. The journal of becoming senior tester (6) - switch role or stay
  20. ​The journal of becoming senior tester (1) - The four paths of becoming to senior tester
  21. The journal of becoming senior tester (13) - Understand the product
  22. The journal of becoming senior tester (14) - conclusion
  23. The journal of becoming senior tester (12) - Coding, Coding, Coding
  24. How to build a great team

2011 8

  1. The journal of becoming senior tester (8) - suggestions for test manager
  2. The journal of becoming senior tester (11) - making big impact
  3. The journal of becoming senior tester (5) - becoming a domain expert
  4. The journal of becoming senior tester (9) - be passion and be always motivated
  5. The journal of becoming senior tester (10) - be open and be broad
  6. Tester' Career Series
  7. Avoid using varchar or char data type
  8. Do not alter database collation in your server

2009 26

  1. Query on Float DataType may return inconsistent result
  2. Tertiary Collation and the performance impact on order clause
  3. How to make Like Case Sensitive?
  4. Unicode References
  5. Recommended presentation "The future of testing"
  6. Beta version of collation selecting tool availiable
  7. Testing DBMS system: what should be the language?
  8. SQL Server and UTF-8 Encoding (1) -True or False
  9. What I was doing these days?
  10. SQL Server’s Binary Collations
  11. my draft thought
  12. my thought
  13. Be aware of comparing unicode constant with varchar column (updated)
  14. Is Datetime2 compliant with Daylight Savings Time?
  15. Why I write so many collation topics?
  16. Got Collation conflict, How to avoid this?
  17. GB18030 Character Set Support in SQL Server
  18. My recommendation of SQL Server’s Globalization Development
  19. UTF-16 Encoding and SQL Server (4) - String Function Case Study
  20. UTF-16 Encoding and SQL Server (3) - Length Semantic
  21. UTF-16 Encoding and SQL Server (2)
  22. UTF-16 Encoding and SQL Server (1)
  23. Do we need a case insensitive binary collaton?
  24. Changing collation of a column is not so trival
  25. A conversation about how to implement Name/value pairs
  26. My future posting related to semi-structured.

2008 9

  1. Using SQL Server 2008 Semi-Structured features for Performance Tuning and Application Design (1)
  2. Sparse Column Storage
  3. SQL Server 2008 (Katmai)'s new collations
  4. Conversion from string to datetime2, time, date is timezone un-awared
  5. Why should we bother about Surrogate characer?
  6. The resolution of SYSTEMDATE function
  7. Colon(:) and dot (.) in factional second is not the same
  8. Idea about implementing a time internal type in SQL Serve 2008
  9. My first blog