You may have heard of the upcoming SQL Server Modelling suite formerly known as ‘Oslo’. The suite, know known as the SQL Server Modelling CTP, features the ‘m’ modelling language and a graphical workbench known as (or codenamed) ‘Quadrant’. I’ve been meaning to look into codename ‘Oslo’ for a while […]
Database Magic
49 posts
There’s going to be more to this in coming posts, but I thought I’d add all the articles I’ve been reading ahead of schedule. The long and short of the story is this – I’ve managed to implement round trip CRUD operations using POCO (Plain Old CLR Objects) using a […]
Today I learnt an important lesson about moving a PC from one Active Directory domain to another – the process will strip (domain) logins from SQL Server! Yes, I know this is kind of obvious and expected, but also easy to overlook. So our scenario is that we don’t have […]
Today I have been modifying a very repetitious SSIS package which does bulk import of data form a flat file. The Data Import Wizard is a pain when you want to import the same format but from different source files, especially since it is unstable and tends to crash when […]
This is part of a series of entries written about Microsoft’s new SQL Azure database service and the Entity Framework v4. Following on from my previous posts (check them out before continuing) – this article assumes you have followed steps outlined in the previous posts to create various models and […]
Happy Australia Day to you! Following on from my previous posts (check them out before continuing) – this article assumes you have followed steps outlined in the previous posts to create various models and accounts etc. Part 1 – Working with Entity Framework v4 and SQL Azure Part 2 – […]
Following on from my previous posts (check them out before continuing) – this article assumes you have followed steps outlined in the previous posts to create various models and accounts etc. Part 1 – Working with Entity Framework v4 and SQL Azure Part 2 – Next Steps with SQL Azure […]
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 […]
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 […]
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 […]
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 […]
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 […]
Hi Everyone, since I’m off to Sydney from Monday until Wednesday next week (and unlikely to be publishing anything new during that time) here is a bonus post. See you after I return.. /R One of the like-to-haves with SQL Server has been the enforcement of column uniqueness but allowing […]