Click here to monitor SSC

2011 March


Tony Davis

An Agile House of Straw

15 comments

The ideal Agile application developer welcomes changing requirements, even late in development. The DBA or Database Developer doesn’t. Why is that? You can’t create complex databases in the Agile way, by breaking tasks into small increments, with minimal planning. Building a database that will perform quickly, reliably and securely over time, as it grows, is […]

31 March 2011 3:39 pm by
Fatherjack

Comments – What’s that?!!

0 comments

LiveJournal Tags: tsql,comments,tips and tricks,how to This blog entry is not one of mine. I have the pleasure of sitting back and letting someone else do the work! Ladies and gentlemen, this blog is written by ….. my wife! I have recently changed job, in my previous job our Senior DBA, also my husband, and […]

31 March 2011 2:00 pm by
Simon Cooper

Anatomy of a .NET Assembly – The CLR Loader stub

0 comments

In Windows XP and above, the OS loader knows natively what to do with .NET executable assemblies, and fires up an instance of the CLR. However, .NET also runs on Windows 98, ME, NT 4.0, and 2000. When you run a .NET assembly on the older operating systems, the CLR has to be loaded somehow. […]

28 March 2011 4:47 pm by
Simon Cooper

Anatomy of a .NET Assembly – The DOS stub

0 comments

The DOS stub at the top of the file is the first thing you notice when you open a .NET assembly in a hex editor. But what do those bytes mean, and what do they do? As I discussed in a previous post, the first 64 bytes are the DOS header, and the next 64 […]

28 March 2011 10:11 am by
Grant Fritchey

SQL Saturday 67

2 comments

Red Gate sent me out to SQL Saturday 67 where I was able to present a session (more on that here) and promote Red Gate. The picture to the right here was taken when I drew the prizes at the end of the day. One of the biggest things about a SQL Saturday event are […]

28 March 2011 8:15 am by
Fatherjack

I’m at SQL in the City

1 comment

Yesterday RedGate announced the SQL in the City events to be held in London (15th July) and Los Angeles (28th Oct), all the details are here http://sqlinthecity.red-gate.com. It promises to be an awesome event where you can come and see how RedGate tools are put into use in various circumstances, talk to users and developers […]

28 March 2011 3:00 am by
Alex Davies

Exploring Windows Azure – is it more than just hosting?

0 comments

Recently, I’ve been working on a side project in my spare time. It’s a little facebook app to help you remember how much money you owe your friends: Visit my app: ToTuP Since the cloud seems so fashionable at the moment I thought I’d give Microsoft’s Azure infrastructure a bit of a test, by running […]

27 March 2011 3:52 pm by
Fatherjack

It’s worth finding me for a chat at SQLBits8

0 comments

LiveJournal Tags: RedGate Tools,Reflector,.Net,License Give AwayA while ago RedGate grabbed a whole lot of attention by changing the licensing model for their .Net Reflector product. The whys and wherefores of their decision have been discussed with great passion all over the developer community and I wont be entering into that particular arena here. This post […]

25 March 2011 3:00 am by
Simon Cooper

Anatomy of a .NET Assembly – Methods

0 comments

Any close look at the method definitions in a .NET assembly has to start off with the method’s information in the metadata tables – the MethodDef. So lets do that. MethodDef The MethodDef entry for the entrypoint method in my TinyAssembly example used in previous posts has the following bytes: D0 20 00 00 00 […]

24 March 2011 11:00 am by
Damon Armstrong

SQL – Joining to a Single Row

0 comments

If you have a one-to-many relationship, and you are performing a join on the tables but you only want one record from the “many” portion of the relationship, then this is a very helpful link: http://stackoverflow.com/questions/2281551/tsql-left-join-and-only-last-row-from-right The outer apply appears to be very useful for joining a single row in one table to a very […]

23 March 2011 9:05 pm by
Older posts