WinForms FAQ

0
0
If you have programmed with Windows Forms for long it is most probable that you have come across one or two (or three or four) “quirks” in how WinForms works however a little help is at hand. I found this FAQ the other day which has some useful tips and tricks on how to get some things … Read more

A SQL Limerick

0
1
It wasn’t my idea at all. However someone set me the challenge of writing executable code that rhymed and scanned in the form of a limerick. Obviously, the easy trick is to just to write the limerick, assign it to a string and then do text substitution on that striing to convert it into SQL … Read more

The usability curse

0
0
When I did my degree, nobody told me that my life would forever be cursed. Not once was I taken aside, sat down, and told in clear and simple words that my life would never be the same.  Like hyperactive kittens faced with a vat of warm fishy milk, we lapped up the techniques to … Read more

.NET Oddities #4

0
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

Unreadable code

0
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

A Sql Game

1
5
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

Copying File Security Attributes

0
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

Super size me

0
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

New Check for Updates Client too

0
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

Filtering foibles

0
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

Count down to SQL Backup 4.0 release

0
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

SQL Server Documentation

0
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

Cowboy filenames

0
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

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

0
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

The new SQL Data Compare beta

0
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