Anthony Bloesch's Web Log
A WebLog about SQL Server development.
There is a longstanding issue with Chinese language search in SharePoint where users got strange...
Date: 11/29/2017
I have taken a job as the architect for the new on-premises SharePoint team in Suzhou, China. We are...
Date: 03/13/2015
Introduction Often large amounts of data need to be quickly loaded into a database. A common...
Date: 01/23/2013
Introduction A common cause of mysterious performance issues are traces that have been left running....
Date: 12/14/2012
Introduction I frequently help teams inside and outside of Microsoft investigate SQL Server database...
Date: 12/07/2012
SQL Server uniqueness constraints create an underlying unique index. SQL Server index keys may not...
Date: 11/23/2009
The code name “Oslo” repository now has the official name “SQL Server Modeling Services”. SQL Server...
Date: 11/19/2009
Paging through result sets is an approach for reducing the network and client resources used to...
Date: 11/09/2009
Repositories face issues to do with versioning schema and data as well as integrating with an...
Date: 04/07/2009
Here is a nice article on how to make a copy of the “Oslo” repository so you can later restore it to...
Date: 04/06/2009
One of the duties of working at Microsoft is the day-to-day use of pre-beta and pre-release...
Date: 03/24/2009
Error handling in SQL Server 2008 needs careful implementation. The Microsoft “Oslo”...
Date: 03/10/2009
The SQL standard requires that string comparisons, effectively, pad the shorter string with space...
Date: 02/20/2009
Views are useful for creating a business entity based view data while allowing for an efficient...
Date: 02/16/2009
SQL Server 2008 limits unique constraints to 900 bytes of data per tuple. Here is a technique for...
Date: 02/04/2009
The paper “Top 25 Most Dangerous Programming Errors” (https://cwe.mitre.org/top25) is an interesting...
Date: 01/14/2009
Geoff Snowman had the great suggestion of a blog entry on how developers can give Microsoft feedback...
Date: 01/12/2009
There is a famous book “The Seven Habits of Highly Effective People” by Stephen R. Covey, I have...
Date: 01/07/2009
Recently we started shredding “Oslo” daily builds into the “Oslo” Repository. We did this to help...
Date: 12/18/2008
Now that the codename “Oslo” repository is public I can discuss its architecture and design. When...
Date: 12/17/2008
The central challenge of repository implementations is how to provide support for an extensible list...
Date: 11/05/2007
There is much debate about how to implement hierarchies (trees) relationally in SQL Server. I...
Date: 02/15/2006
Paul Flessner is one of my favorite VPs. Here is a recent high level talk that Paul and others gave...
Date: 10/13/2005
Sqlcmd is the SQL Server 2005 replacement for osql which in turn is being deprecated in SQL Server...
Date: 10/06/2005
One of the features I would like to see in our tools for SQL Server is a T-SQL language service....
Date: 09/26/2005
The conventional way to persist the semantic data in a graphical database design/modeling tool is as...
Date: 09/21/2005
Thanks everyone for the great blog and email comments on how we should deal with T-SQL casing...
Date: 09/20/2005
I have been rethinking using uppercase letters for T-SQL keywords. Readability research shows that...
Date: 09/15/2005
SQL Server 2005’s support for XML has improved substantially. The new internal representation of XML...
Date: 09/14/2005
After you have been building databases for a while, surrogate keys become second nature but many...
Date: 09/09/2005
Boring stuff about me I am a Software Architect in the Visual Studio group. I am interested in...
Date: 09/07/2005