Introduction Last week I gave an internal presentation to my fellow consultants at CGI on the principals of data modelling/data architecture, modelling within Visual Studio 2013 and a history of the (ADO.NET) Entity Framework. I’ve attached the slide deck to this article, and also in my presentations page. Data Modelling […]
Database Magic
49 posts
Introduction This article is part of the ongoing series I’ve been writing recently, but can be read as a standalone article. I’m going to do a better job of integrating the changes documented here into the ongoing solution I’ve been building. However, considering how much time and effort I put […]
Introduction Following on from the previous article, Data Access with the Entity Framework V6 RC1, this time I’m going to go deeper and look at how we manipulate entities through a structured and often times generic approach. We’ll take a particularly close look at an approach to adding, updating and […]
Introduction Following on from the earlier article which established a data schema, the next step is to wrap the database design in an ORM.. for fun. I’m going to take a look at the latest pre-release of the Entity Framework, version 6 (RC1). If you’re interested in the licensing aspects, […]
Introduction Per my introduction article, I’m learning the hard way – with the latest from Microsoft. Yesterday I created a SQL schema from a Twitter archive which was “fun”, but didn’t provide me with a decent enough schema to model a complete end-to-end design for something meaningful. So I’m back […]
This article will look at populating an archive of Twitter data into SQL Server 2014. This process can apply to older versions of SQL Server.
Introduction Recently, I added some articles about installing and configuring some new pre-release software that Microsoft released earlier in the year. [ Visual Studio 2013 | Team Foundation Server 2013 ] Now I’m ready to put it all to the test! I know there’s been a lot of build-up, and […]
This is probably a bit of a late announcement, but Microsoft has elected to make the Entity Framework an Open Source project on CodePlex! The first officially supported packages (from the open source project) are rumoured to be integrated as of Entity Framework v6 (as the Entity Framework team are […]
Hi All. This is a quick post to introduce you to SQL Server Data Tools – support and tools for database developers. Introduction Recently, I started a new solution in Visual Studio 2010. There is a need to build and maintain a database schema (for SQL Server 2008 R2), so […]
Overshadowed, possibly, by the release of the new iPad? Not in the world of databases. Yesterday Microsoft officially released SQL Server 2012 “release to manufacturing” (RTM) which means we’re officially out of pre-release editions! Previously codenamed ‘Denali’, the new version brings to the table some serious changes, some of which […]
Introduction In December 2011, Microsoft released an early Release Candidate (RC) of SQL Server 2012 (formerly known as codename Denali). There are a bunch of new things in SQL Server 2012 – here’s a list of just a few: Master Data Services Reporting Services PowerPivot for SharePoint Data Quality Services […]
There are times when you want to get a little creative about your investigative work when it comes to SQL Server. In this case, this is a very short article highlighting some efficiencies in locating information about specific programmatic resources within a database. If you haven’t used the INFORMATION_SCHEMA views […]
Recently I alluded to writing a series of posts on the Entity Framework Futures, now referred to as the “Microsoft ADO.NET Entity Framework Feature Community Technology Preview 5“ which could really, really use a cool codename. Introduction If you’ve been following along on the Windows Workflow Rules Engine series of […]
A little late, but better late than never – the Entity Framework CTP 5 was released last month before Christmas, and now that I’m back, I’ll be doing a series of posts on Code First and CTP 5. This is mainly to test out the new Object Validation which currently […]
If you are like me, you probably aren’t a huge fan of Kerberos, but it does have some advantages. When using an Active Domain (AD) account as a service account, it is handy to reduce the attack vector by minimising the chosen Domain Account’s permissions and privileges. If you are […]