May 2010 Entries

First Shard for SQL Azure and SQL Server

That's it!!!!! It's ready to go and be tested, abused and improved! It requires .NET 4.0 and uses some cool technologies, like caching (the new System.Runtime.Caching) and the Task Parallel Library (System.Threading.Tasks). With this library you can: Define a shard of 1, 2 or 100 SQL databases (a mix of SQL Server and SQL Azure) Read from the shard in parallel or sequentially, and cache resultsets Update, Delete a record from the shard Insert records quickly in the shard with a round-robin load Reset ......

SQL Azure: Notes on Building a Shard Technology

In Chapter 10 of the book on SQL Azure (http://www.apress.com/book... I am co-authoring, I am digging deeper in what it takes to write a Shard. It's actually a pretty cool exercise, and I wanted to share some thoughts on how I am designing the technology. A Shard is a technology that spreads the load of database requests over multiple databases, as transparently as possible. The type of shard I am building is called a Vertical Partition Shard (VPS). A VPS is a mechanism by which ......

SQL Saturday 40 - South Florida - July 31st 2010

Hi everyone - if you live in Florida, or if you will be in the area on July 31st come and see us! If would like to speak or attend, visit http://www.sqlsaturday.com/... The event will be in Miramar, Florida - no too far from Fort Lauderdale. We had over 350 people show up last year and we will do better this year! We are also welcoming sponsors for this event. Thank you for spreading the word ......

Twitter