Anthony Bloesch's Web Log

A WebLog about SQL Server development.

Improvements to Chinese language search in SharePoint

There is a longstanding issue with Chinese language search in SharePoint where users got strange...

Author: Anthony Bloesch Date: 11/29/2017

On-Premises SharePoint careers

I have taken a job as the architect for the new on-premises SharePoint team in Suzhou, China. We are...

Author: Anthony Bloesch Date: 03/13/2015

Bulk loading data with IDataReader and SqlBulkCopy

Introduction Often large amounts of data need to be quickly loaded into a database. A common...

Author: Anthony Bloesch Date: 01/23/2013

Finding and stopping rogue SQL traces

Introduction A common cause of mysterious performance issues are traces that have been left running....

Author: Anthony Bloesch Date: 12/14/2012

SQL Server performance investigation

Introduction I frequently help teams inside and outside of Microsoft investigate SQL Server database...

Author: Anthony Bloesch Date: 12/07/2012

Implementing uniqueness constraints on large columns

SQL Server uniqueness constraints create an underlying unique index. SQL Server index keys may not...

Author: Anthony Bloesch Date: 11/23/2009

SQL Server Modeling Services announcement

The code name “Oslo” repository now has the official name “SQL Server Modeling Services”. SQL Server...

Author: Anthony Bloesch Date: 11/19/2009

Paging SQL Server result sets

Paging through result sets is an approach for reducing the network and client resources used to...

Author: Anthony Bloesch Date: 11/09/2009

"Oslo" repository lifecycle/versioning whitepaper

Repositories face issues to do with versioning schema and data as well as integrating with an...

Author: Anthony Bloesch Date: 04/07/2009

How to make a copy of the repository

Here is a nice article on how to make a copy of the “Oslo” repository so you can later restore it to...

Author: Anthony Bloesch Date: 04/06/2009

Favorite keyboard shortcuts

One of the duties of working at Microsoft is the day-to-day use of pre-beta and pre-release...

Author: Anthony Bloesch Date: 03/24/2009

SQL Server 2008 error handling best practice

Error handling in SQL Server 2008 needs careful implementation. The Microsoft “Oslo”...

Author: Anthony Bloesch Date: 03/10/2009

Testing strings for equality counting trailing spaces

The SQL standard requires that string comparisons, effectively, pad the shorter string with space...

Author: Anthony Bloesch Date: 02/20/2009

Instead of triggers over views (part 1)

Views are useful for creating a business entity based view data while allowing for an efficient...

Author: Anthony Bloesch Date: 02/16/2009

Large tuple uniqueness constraints in SQL Server

SQL Server 2008 limits unique constraints to 900 bytes of data per tuple. Here is a technique for...

Author: Anthony Bloesch Date: 02/04/2009

Top 25 most dangerous programming errors

The paper “Top 25 Most Dangerous Programming Errors” (https://cwe.mitre.org/top25) is an interesting...

Author: Anthony Bloesch Date: 01/14/2009

An insiders guide to giving feedback to Microsoft

Geoff Snowman had the great suggestion of a blog entry on how developers can give Microsoft feedback...

Author: Anthony Bloesch Date: 01/12/2009

The n habits of highly effective developers

There is a famous book “The Seven Habits of Highly Effective People” by Stephen R. Covey, I have...

Author: Anthony Bloesch Date: 01/07/2009

SQL Server fragmentation

Recently we started shredding “Oslo” daily builds into the “Oslo” Repository. We did this to help...

Author: Anthony Bloesch Date: 12/18/2008

Architectural design tenets and corollaries

Now that the codename “Oslo” repository is public I can discuss its architecture and design. When...

Author: Anthony Bloesch Date: 12/17/2008

Oslo repository

The central challenge of repository implementations is how to provide support for an extensible list...

Author: Anthony Bloesch Date: 11/05/2007

Hierarchies (trees) in SQL Server 2005

There is much debate about how to implement hierarchies (trees) relationally in SQL Server. I...

Author: Anthony Bloesch Date: 02/15/2006

Paul Flessner talk

Paul Flessner is one of my favorite VPs. Here is a recent high level talk that Paul and others gave...

Author: Anthony Bloesch Date: 10/13/2005

Sqlcmd's cool new facilities

Sqlcmd is the SQL Server 2005 replacement for osql which in turn is being deprecated in SQL Server...

Author: Anthony Bloesch Date: 10/06/2005

Adding intellisense and refactoring to the T-SQL editor

One of the features I would like to see in our tools for SQL Server is a T-SQL language service....

Author: Anthony Bloesch Date: 09/26/2005

How should database models be persisted?

The conventional way to persist the semantic data in a graphical database design/modeling tool is as...

Author: Anthony Bloesch Date: 09/21/2005

T-SQL casing conventions feedback

Thanks everyone for the great blog and email comments on how we should deal with T-SQL casing...

Author: Anthony Bloesch Date: 09/20/2005

Uppercase or lowercase T-SQL keywords

I have been rethinking using uppercase letters for T-SQL keywords. Readability research shows that...

Author: Anthony Bloesch Date: 09/15/2005

When to use SQL Server 2005's XML data columns

SQL Server 2005’s support for XML has improved substantially. The new internal representation of XML...

Author: Anthony Bloesch Date: 09/14/2005

Surrogate keys

After you have been building databases for a while, surrogate keys become second nature but many...

Author: Anthony Bloesch Date: 09/09/2005

Database design made easier

Boring stuff about me I am a Software Architect in the Visual Studio group. I am interested in...

Author: Anthony Bloesch Date: 09/07/2005