This is not part of the ongoing series of articles on SQL Data Services, but rather a call out to a Microsoft White Paper which has been published (a) here – SQL Server White Paper Template. I’d recommend, if you are interested in SQL Data Services, that you take a […]
Programming
322 posts
Here’s some helpful information for those of you out there who are trying to make the call between using SQL Server Compact Edition or SQL Server Express Edition. Compare SQL Server 3.5 Compact and SQL Server Express Edition Features [http://download.microsoft.com/download/A/4/7/A47B7B0E-976D-4F49-B15D-F02ADE638EBE/Compact_Express_Comparison.doc] My short summary asks you to determine if any of these […]
Hi, so this is the next logical sequence in my series on the ADO Entity Framework. If you read the previous article/entry you would be familiar with the replacement of ugly foreign key data with nice friendly text (or whatever). This time, we’re going to look at how you can […]
Here are some lessons learned from using the Entity Framework and the EntityDataSource provider in ASP.net development. Edit: Hi Everyone, I’ve been getting some traffic on this topic and I realise I’ve only written half the details (there is more to come). Please bare with me and I’ll aim to […]
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 […]
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 […]
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 […]
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 […]
This just in from our ‘friends’ at Slashdot – a critical Microsoft patch for all “modern” Windows systems. There’s a bulletin notice located here which is pretty alarming, from the bulletin: “This security update resolves a privately reported vulnerability in the Server service. The vulnerability could allow remote code execution […]