Recently I was asked about diagnosing deadlocks in SQL Server – I’ve done a lot of work in this area way back in 2008, so I figure it’s time for a refresher. If there’s a lot of interest in exploring SQL Server and deadlocks further, I’m happy to write an […]
SQL Server
9 posts
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 […]
In this session, learn about the DPC (Database Private Cloud) Reference Architecture and how it can be used to consolidate thousands of databases on a single scalable platform. The session will drill into the hardware and software configuration and cover how its wired together. We will cover the use cases, […]
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 […]
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 […]
What is FILESTREAM? Much data is unstructured, such as text documents, images, and videos. This unstructured data is often stored outside the database, separate from its structured data. This separation can cause data management complexities. Or, if the data is associated with structured storage, the file streaming capabilities and performance […]
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 […]
Not too long ago I wrote an article about Team Foundation Server licensing. Now that it is 2011, and after some recent access requests for TFS, I’ve decided it is time for an update. Does TFS cover SQL Server Licensing? One instance of Microsoft SQL Server 2008 Standard Edition or […]
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 […]