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