This post is the first in a series of posts on this topic. The following is a summary of the various parts. Part 1 – Working with Entity Framework v4 and SQL Azure (this post) Part 2 – Next Steps with SQL Azure Part 3 – Putting it all together […]
Programming
322 posts
Happy New Year Everybody! Well, it’s been a surprisingly busy time for me, and this (naturally) translates into great things for you, the reader! You can expect some new entries on Team Foundation Server 2010 (Beta 2) as well as detailed notes on the next revision of the ADO Entity […]
Q: What is SQL Code Camp? A: ““SQL Down Under Code Camp is an annual community-driven event for SQL Server professionals. Each year, well over a hundred DBAs and Developers come together to learn from each other and to network. It is held in October at the Wagga Wagga campus […]
This is a little late – but I feel it is worth going into and you can catch up be reading (or re-reading) Part 1 located here. Just in case you are wondering “what on Earth is he babbling on about?” which is a fair and often under asked question, […]
If you’ve been following the blog for a while now, you’ll know there are two main database schemas I tend to work with for Proof of Concept (PoC) applications, movies and records (vinyl LPs). Last year I was building an Entity Framework based PoC using a schema made up of […]
Hi There! With some excitement brewing, I just got invitation codes to the first public CTP of SQL Azure – the successor to SQL Data Services (SDS) previously documented on this blog. Below is a screenshot of my first SQL Azure Server. As I start to develop with the new […]
“SQL Down Under Code Camp is an annual community-driven event for SQL Server professionals. Each year, well over a hundred DBAs and Developers come together to learn from each other and to network. It is held in October at the Wagga Wagga campus of our friends at Charles Sturt University.” […]
Hi there. I realise that PowerShell is the next logical expansion which combines the utility of batch/command line interfaces with the power of managed code, but here’s a short entry on using loops in traditional batch scripts (just for fun). On a recent project we wanted to execute SQL scripts […]
Hi All, This is just a quick post to advertise some of the high hopes I have for the upcoming Entity Framework v4 which will ship with Visual Studio 2010. The next version is bumped from v2 to v4 (in order to align with the version of the .Net Framework) […]
There is a very good blog entry located here which lists questions every development team and team leads should ask themselves during development cycles. From the article: Whole team What can we automate? where are we "Reinventing the wheel"? what are the tools that slow us down? what tools can […]
Well, this week I was routinely contributing to the massive indentations in my forehead (banging my head against my keyboard) due to an old SQL Server favourite.. “An explicit value for the identity column in table ‘[Table]’ can only be specified when a column list is used and IDENTITY_INSERT is […]
Well I have found the perfect accompaniment for you – Reporting Services Scripter. Key Features: – Quickly and easily extract all RDL from a Report Server – Automatically generates scripts to load reports, data sources, resources, linked reports and folders with all their associated properties […]
Sometimes it’s good to refresh.. I keep forgetting the conditions for using an updatable view in SQL Server so I thought I’d publish this info to my blog for reference purposes. Updatable Views You can modify the data of an underlying base table through a view, as long as the […]
Every now and then this was cropping up as a problem for me, but it was particularly random and I really couldn’t figure out why the “Find in Files” functionality of Visual Studio would just stop working for no apparent reason. Finally, I got fed up with this, after a […]
Visual Studio Tip of the Day “Visual Studio will always try to build everything when you run a single project, even if that project doesn’t depend on everything. This choice can be changed, however. Go to [Tools] –> [Options] –> [Projects and Solutions] –> [Build and Run] and check the […]