Since I’m rather unlikely to reach for the book on Windows for Workgroups or Red Hat 6.1 they went off to be recycled. My general rule of thumb is that if it’s >10 years old, I probably don’t need it anymore. One exception to the rule (for example) is a […]
Monthly Archives: November 2008
21 posts
Sometimes you have to wonder how people miss things.. Something simple like: string movieTitle = "Ghostbusters";var movies = from mov in mdb.Movie where mov.Title.Contains(movieTitle) select mov; Fails with a nasty error: "The ntext and image data types cannot be used in WHERE, HAVING, GROUP BY, ON, or IN clauses, except […]
Don’t you just hate it when your heart sinks and you read something like this: SQL Server Express and Hosting “Several questions have come up lately regarding whether SQL Server Express is an appropriate product to be used in a hosting environment. Here are the answers: User Instances (also known […]
Hi Everyone, The VSTS Database Edition GDR (which introduced support for SQL Server 2008) has just been released (RTM). Worthy of note: (from the release notes): Projects Partial projects Allowing code sharing between projects by including files from a different project, where the code is included as-is from the originating […]
In the last entry, we looked at basic querying with a web browser and viewing service metrics. This entry will examine administrative commands and bulk uploading options using the SDS administration utility (st.exe) which is part of the SDS SDK. Migrating Data To SQL Data Services There’s really no fun […]
On the weekend we were at the mercy of some really terrible rugby as Australia played France to decide who could play the worst. Stay tuned for a complete review of a game which was only slightly better than South Africa vs Australia, 2006…
Yesterday was suddenly (without warning) my last day working for Readify Pty Ltd. I’ve worn the Readify badge of honour with pride for over two and a half years spread over two stints (from February this year until end of November) and just under two years, 2005-2007. To those whom […]
In the previous entry we reviewed how to create entities, but what do we do now? Before I go into detail on how to interact with SDS directly, let’s take some time to go over the fundamentals of querying with SDS. This entry will focus on some of the techniques […]
Hi Everyone, This is a small break in our scheduled programming (the SQL Server Data Services series) to point to a new blog post by the ADO Entity Framework team announcing some of their thoughts for the next edition. As you might be aware, the ADO Entity Framework shipped v1.0 […]
In the last entry, we established a way of programmatically creating an SDS Authority and Containers. In this entry we will focus on creating data Entities using the SOAP interface. Review In Part 1, we saw how the relationship is defined between objects in the SQL Data Services world. An […]
In Part 1, we were introduced to the concept of SQL Data Services (SDS) and the fundamental design. In Part 2, we looked at the options for authentication, data access and the SDS SDK (helpful tools). In this entry we will look at using the SOAP interface to create an […]
Yesterday, Part 1 in this series introduced you to the basic fundamentals behind SQL Data Services (SDS). The official definition of SQL Data Services is below. “Microsoft SQL Data Services (SDS) offers highly scalable and Internet-facing distributed database services in the cloud for storing and processing relational queries. SDS can […]
Recently, SQL Data Services (SDS) were published as a Community Technical Preview (CTP). Registering via Microsoft Connect, I’ve been able to start building a sample application which is designed to make use of SDS for online real-time queries. This blog entry forms part of the [MiniProject] documentation – the Mini […]
Match Notes: Australia vs England, Twickenham (UK) 16-11-2008 (AEST) 15-11-2008 (local) Halftime Report We’re at the halftime portion of the England v Australia rugby test match live from Twickenham, in the UK. Besides being a closely contested match, and the referee not handing out a yellow […]
No, I haven’t forgotten! I’ve been working extensively on the Mini Project and I think you’re going to like what the outcome looks like. Since SQL Code Camp (where Matt Lynch and I demonstrated advanced Entity Framework concepts in concert with SQL Server Compact Edition) I’ve been reworking the Mini […]