![[MiniProject] Part 2: The Refactor](https://sanderstechnology.net/wp-content/themes/customizr/assets/front/img/thumb-standard-empty.png)
As with all good data schemas, there’s usually some refactoring as time goes by. This project isn’t immune to the shifting sands of time or perfection, and so today’s second instalment features a schema change. Below is a representation of the schema shift. To summarise, separate Actor/Director tables have been […]
Programming
322 posts
Today, as promised, Visual Studio 2008 Service Pack 1 was released. You can download the ~800 MB Service Pack from the following location. Read about what Service Pack brings to the table here. My experience with (SP 1 Beta) has revolved around the ADO Entity Framework, but I understand that […]
Let’s kick off the Mini Project by examining the database schema. The project involves storing and manipulating data related to movies (in my case, DVDs I own). For this project I am going to concentrate on three key relationships: 1. Movies have at least one director2. Movies have one or […]
Yesterday SQL Server 2008 was released but had a rather unbalanced dependency: SQL won’t install next to a copy of Visual Studio 2008 unless said Visual Studio has been applied with Service Pack 1. Problem: Service Pack 1 for Visual Studio isn’t released until August 11th. How do […]
Well, I’ve been waiting for this release since the February CTP drop was "feature complete". SQL Server 2008 went RTM today and is available to subscription owners on MSDN. This is the latest release in the SQL Server family and encompasses a number of different flavours, from the traditional Developer/Standard/Enterprise […]
Hi Everyone, Quick note: if you found this information helped you, please leave a comment – thanks! Well, chances are that if you’re using Hypervisor (Hyper-V) as I am, you might also be using a Wireless Network Interface Card (NIC) to connect to the Internet and/or other sources. Personally, I […]
If you know anything about storing meaningful data for compact (mobile) applications, you’ve probably looked at SQL Server Compact Edition or SQL Server Mobile Edition (2005) in the past. You also probably disregarded previous versions due to their inherent restrictions or lack of support for very mainstream SQL concepts and […]
We all by now have probably heard about the increase in SQL injection attacks to popular (and unpopular) web sites. A SQL Injection attack is where an external party passes potentially harmful or exploitive data in the form of raw, formatted or encoded T-SQL in a way in which it […]
Recently covered by Slashdot, Microsoft has re-released (ok, apparently the April releases were actually ‘preliminary versions‘…) the binary file format details for legacy (pre-Office 2007) Microsoft Office formats (direct link [64 MB file]) (licensing terms for using the information). Notably absent: Microsoft Access.. the hardest file format to reverse engineer. In 2001-02 when […]
Finally, sick of running low end machines incapable of handling the latest and greatest, on the weekend I bought and built a new machine; a workstation. It’s been some time since I last built a machine by hand (aside from years of reworking old Dell parts into working laptops), so […]
Mitch Denny presents: codename ‘Rosario’ a.k.a Team Foundation Server 3.0. Edit: Rosario is the code name for the next edition of Team Foundation Server. The next release of Visual Studio Team Suite and various other denominations of Visual Studio will contain large feature improvements for Developers, Software Testers, Build Managers, […]
Here’s an interesting article. Apparently in the .Net 3.5 Service Pack 1 world, strong name verification for .Net assemblies will be bypassed by the Common Language Runtime if the following criteria is met: Fully signed (delay signed assemblies still require a skip verification entry) Fully trusted (without considering its strong […]
In the spirit of doing a few things at the same time, Microsoft’s Parallel Computing Platform (PCP) team has unveiled ‘Microsoft Parallel Extensions’ for the .Net Framework 3.5. Here’s a link to the official Parallel Computing Team site. You may download a Community Technology Preview of the latest Parallel Extensions […]
Preface: A few weeks ago I ripped down and rebuilt my Lego Mindstorms NXT model and replaced it with a by-the-numbers build of the "famous" Alpha Rex humanoid version designed by Lego. Photo: active-robots.com The design (Alpha Rex) looks nice, but the model unfortunately doesn’t walk very well. In fact, […]
So recently I studied for the first in a series of SQL Server focused Microsoft exams (M70-431 A: SQL Server 2005 – Implementation and Maintenance). To assist me (and, in particular, to determine the scope of knowledge I needed to acquire) I used an exam prep kit from uCertify. I’m […]