SQL Server

images_thumb.jpg 1
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 […]

Data Modelling and the Entity Framework

image_thumb.png 1
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 […]

SQL Server 2012 Release Candidate 0

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 […]