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...
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...
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...
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....
Date: 12/14/2012
SQL Server performance investigation
Introduction I frequently help teams inside and outside of Microsoft investigate SQL Server database...
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...
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...
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...
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...
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...
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...
Date: 03/24/2009
SQL Server 2008 error handling best practice
Error handling in SQL Server 2008 needs careful implementation. The Microsoft “Oslo”...
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...
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...
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...
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...
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...
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...
Date: 01/07/2009
SQL Server fragmentation
Recently we started shredding “Oslo” daily builds into the “Oslo” Repository. We did this to help...
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...
Date: 12/17/2008
Oslo repository
The central challenge of repository implementations is how to provide support for an extensible list...
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...
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...
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...
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....
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...
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...
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...
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...
Date: 09/14/2005
Surrogate keys
After you have been building databases for a while, surrogate keys become second nature but many...
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...
Date: 09/07/2005