Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

Monday, November 23, 2009 10:01 AM

Implementing uniqueness constraints on large columns

SQL Server uniqueness constraints may not be aver columns larger than 900 bytes. Here is how to implement uniqueness constraints over larger columns with hash indexes.
Posted by AnthonyBloesch | 0 Comments
Attachment(s): Large uniqueness constraints.docx
Thursday, November 19, 2009 9:28 AM

SQL Server Modeling Services announcement

The code name “Oslo” repository now has the official name “SQL Server Modeling Services”. SQL Server Modeling Services will be a SQL Server workload like SQL Server Reporting Services.
Posted by AnthonyBloesch | 0 Comments
Monday, November 09, 2009 12:21 PM

Paging SQL Server result sets

Paging through SQL Server result sets is an approach for reducing the network and client resources used to display large result sets. Here is a discussion of the merits of three approaches including their relative performance.
Posted by AnthonyBloesch | 0 Comments
Tuesday, April 07, 2009 9:44 AM

"Oslo" repository lifecycle/versioning whitepaper

Repositories face issues to do with versioning schema and data as well as integrating with an organizations lifecycle processes. Here is a whitepaper I wrote on how the "Oslo" team thinks about handling various lifecycle/versioning issues.
Posted by AnthonyBloesch | 1 Comments
Monday, April 06, 2009 4:22 PM

How to make a copy of the repository

Here is how to make a copy of the “Oslo” repository so you can later restore it to its previous state.
Posted by AnthonyBloesch | 1 Comments
Filed under: ,
Tuesday, March 24, 2009 8:36 AM

Favorite keyboard shortcuts

Here are a list of my favorite shortcuts in US Letter docx, A4 docx, US Letter XPS and A4 XPS formats. I have included Windows 7, Internet Explorer 8 and SQL Server Management Studio 2008 shortcuts.
Posted by AnthonyBloesch | 1 Comments
Attachment(s): Shortcuts.zip
Tuesday, March 10, 2009 12:45 PM

SQL Server 2008 error handling best practice

Error handling in SQL Server 2008 needs careful implementation. Here is the pattern the Microsoft "Oslo" Repository uses. It is based on experimentation and best practice guidance from the SQL Server team and other SQL Server experts.
Posted by AnthonyBloesch | 4 Comments
Attachment(s): Error Handling.sql
Friday, February 20, 2009 1:13 PM

Testing strings for equality counting trailing spaces

The SQL standard requires that string comparisons, effectively, pad the shorter string with space characters. This leads to the surprising result that N'' ≠ N' ' (the empty string equals a string of one or more space characters) and more generally any string equals another string if they differ only by trailing spaces. Here is a discussion of various work arounds.
Posted by AnthonyBloesch | 1 Comments
Monday, February 16, 2009 3:58 PM

Instead of triggers over views (part 1)

Views are useful for creating a business entity based view data while allowing for an efficient logical schema. SQL Server’s instead of triggers allow many of these views to be updatable. Here are some experiments that show how to write them and some of their properties.
Posted by AnthonyBloesch | 1 Comments
Attachment(s): Instead of trigger demo code.sql
Wednesday, February 04, 2009 9:13 AM

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 enforcing uniqueness over larger tuple sizes.
Posted by AnthonyBloesch | 1 Comments
Attachment(s): BigUniqueConstraint.sql
Wednesday, January 14, 2009 1:25 PM

Top 25 most dangerous programming errors

The paper “Top 25 Most Dangerous Programming Errors”is an interesting study of the families of programming errors that lead to security issues. From a T-SQL perspective, however, the paper seems off mark so here is a list of Common SQL specific errors I was able to extract from their database.
Posted by AnthonyBloesch | 1 Comments
Filed under: , , ,
Monday, January 12, 2009 1:05 PM

An insiders guide to giving feedback to Microsoft

I have worked on both sides—giving feedback to Microsoft and receiving it from customers. Here are the best ways I know of to have your voice heard.
Posted by AnthonyBloesch | 1 Comments
Wednesday, January 07, 2009 8:40 AM

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 been thinking about what are the n habits of a great developer. Here is my list.
Posted by AnthonyBloesch | 1 Comments
Filed under:
Thursday, December 18, 2008 12:42 PM

SQL Server fragmentation

We have recently been looking at database fragmentation for real usage of the "Oslo" repository. However, since database fragmentation is a major cause of poor performance I thought a discussion of how to minimize and deal with database fragmentation in SQL Server might be generally useful.
Posted by AnthonyBloesch | 4 Comments
Wednesday, December 17, 2008 9:50 AM

Architectural design tenets and corollaries

Now that the codename "Oslo" repository is public I can discuss its architecture and design. In this post, I discuss how I like to start the design process for a new product and the design tenets for the "Oslo" Repository.
Posted by AnthonyBloesch | 1 Comments
More Posts Next page »
 
Page view tracker