09 January 2006
09 January 2006

.NET Oddities #4

0
This is sheer genius: System.Math.Sin( double a )System.Math.Cos( double a )…etc all take an angle in radians as their argument. However: System.Drawing.Drawing2D.Matrix.Rotate( float angle )and System.Drawing.Drawing2D.Matrix.Rotate( float angle, MatrixOrder order ) both take the angle in degrees. Who on earth designed this?!?? … Never mind, it’s not that important. I’m just going to take a … Read more
04 January 2006
04 January 2006

Unreadable code

0
Producing unreadable Transact SQL is something of an art form. We all know that the best Transact SQL Style is to make everything elegant and obvious, with explanatory identifiers, liberal comments and deft formatting. It doesn’t always happen, for a number of reasons. One of the more subtle effects of acute caffein poisoning is to … Read more
30 December 2005
30 December 2005

A Sql Game

7
There seems to be computer game written in almost every language out there but I haven’t yet found one written in Transact SQL. I thought that poor old DBAs should have some form of game to play so I have written a little 3D maze game in Transact SQL. Since there is no obvious way … Read more
20 December 2005
20 December 2005

Copying File Security Attributes

0
Last week I was investigating writing out files and what happens if I over-write an existing file. I remembered back from my MFC days that CDocument makes up a little internal C++ class called CMirrorFile. This is a very clever class that when overwriting an existing file, it copies the original file to a temporary … Read more
12 December 2005
12 December 2005

Super size me

0
Having fixed all the outstanding “Oh my [deity/dictator of choice], we have to fix this now or people will be really rather unhappy” issues (as they’re referred to under our bug tracking system. Or is that my imagination? You know, I think it probably is) against DTS Package Compare 2.0, it was time to turn … Read more
09 December 2005
09 December 2005

New Check for Updates Client too

0
Well not only have we got the currently running SQL Data Compare Beta – well SQL Tools beta really but that’s the important bit ;). We have the new DTS Compare Beta, we’re going to be starting work on the next update of our brilliant SQL Log Rescue tool too. Not only all that but … Read more
08 December 2005
08 December 2005

Filtering foibles

0
There are times when you’re striving for a usable design, and no matter what you try, your attempt just fails to cut the mustard.  Everyone has a difference of opinion as to what should be done to fix it and you’re stuck there trying to think of a sensible improvement.  What to do? Time to … Read more
07 December 2005
07 December 2005

Count down to SQL Backup 4.0 release

0
We are now ‘feature complete’ and only have a few weeks until we have code lock off. The beta program has in the region of 75 customers signed up, many of which are actively posting feedback on the private forum. The comments have been encouraging. The beta testers have been carrying out some impressive tests, … Read more
07 December 2005
07 December 2005

SQL Server Documentation

0
Brian Welcker has posted that the December 2005 updates of SQL Server Books online, SQL Server Samples and Sample Databases and the Express Editions documentation and samples are now available to download from the following links: SQL Server 2005 Books Online (December 2005 Update) SQL Server 2005 Samples and Sample Databases (December 2005) SQL Server … Read more
02 December 2005
02 December 2005

Cowboy filenames

0
If you ask me, and I take it as implicit by your visit that you do (sorry about that, but it’s Friday afternoon and I need a weekend), Windows is far too facist about filenames. Most notably in terms of the characters one can put into a filename, and the obstreperous way it will cough … Read more
30 November 2005
30 November 2005

Mapping of .NET Assembly attributes to File Version Information Attributes.

1
.NET automatically generates a FileInformation resource when building the assembly. Here is a mapping of the .NET attribute to the corresponding named element in VersionInformation and the name that Windows Explorer puts on its UI. Assembly Attribute VersionInfo Windows Explore name AssemblyTitle FileDescription Description AssemblyDescription Comments Comments AssemblyConfiguration AssemblyCompany CompanyName Company AssemblyCopyright LegalCopyright Copyright AssemblyTrademark … Read more
29 November 2005
29 November 2005

The new SQL Data Compare beta

0
The new SQL Data Compare beta is about to be released and I hope you all get a chance to have a good look at it and send me your opinions. There are a few features that we are quite proud of mostly of course these are surrounding our new Yukon support, SQL Server 2005 … Read more
25 November 2005
25 November 2005

Cat detective

0
Ahhh… now… er… that shouldn’t happen.  Oooh, yup, that’s not at all clear.  Purrr, Meow, Purrr.  Hmmm… they’re not finding that and why are they trying there?  Reviewing a usability trial recording is akin to playing the role of a detective.  You can’t be one of those detectives who, week after week, fail to solve … Read more
24 November 2005
24 November 2005

.NET Oddities #3

0
OK, so I’ll admit this is a bit cheeky: this entry should almost certainly be .NET Oddities #2a because it’s so closely related to #2, but there. You may have noticed, and in fact I already knew this, that OutOfMemoryException (like StackOverflowException) has a null value for its StackTrace property. Again, this can be a … Read more
23 November 2005
23 November 2005

Wild card registering COM dlls

1
When developing a COM based application sometimes it’s sometimes useful to register all the DLLs/OCX at once.From a command prompt This will try to register all dll’s even if they are not COM dlls. This is fine as the registration will fail silently.You can change the above command to register COM servers eg… Read more
23 November 2005
23 November 2005

Debugging Arbitrary thread stacks in .NET

0
Check out John Robbins November 05 Bugslayer article.. He has ported his excellent SUPERASSRT code from native C++ into C#. Part of his solution uses CDB.(a command line version of WinDBG)I have previously found producing minidump files very useful in tracking down native code problems, so I will be trying out his new C# implementation … Read more