Natural Interaction and Microsoft BI

Today, Microsoft released the official Kinect for Windows SDK. Here is something we have been experimenting with here in the SQL Server BI product group that you might find interesting. A while ago, at SQL PASS Summit 2011 in Seattle, WA, I demoed turning any random surface or wall into a touch screen using a single…


Building a LINQ Provider

Throughout this article, I will build a simple IQueryable provider similar to the LINQ to SQL provider demonstrating what is needed to build a custom provider that is capable of executing LINQ queries and performing create, update and delete operations. Read the rest on MSDN at Pedram  


Store any data in SQL Server 2008 (Katmai)

SQL Server 2008 (aka Katmai) allows seamless transition between relational and nonrelational data, enabling users to access documents as data, encode complex XML hierarchies within XML, and query across relational and text data.  So how is this achieved? There is a new FileStream data type which allows large binary data to be stored in the…


SQL Server 2005 Database Mirroring

Customers often raise the following concerns and questions regarding the Database Mirroring feature of SQL Server 2005. In here, Don Vilen a Program Manager for SQL Server Database Mirroring and I have responded to some of these concerns and questions: 1) performance – synchronous mirroring has well documented performance statistics  for instance index rebuild takes…


SQL Server 2005 Compact Edition is now available

SQL Server 2005 Compact edition runs as an in-process application, with a very small footprint  (less than 2 MB disk footprint) offering you a good subset of the T-SQL features, and replication features of a full blown SQL install. DB Size is capped at 4GB, should you want to be able to deal with that…


SQL Service Broker: The Impatient Way!

For those of you who are interested in creating your first SQL Server 2005 Service Broker conversation but are impatient as I am, just grab the code below and give it a try: — Enable service brokeralter database [YOUR_DB_NAME] set enable_broker — Create a message type. You can also specify —  An XML schema to…