David Connell

David Connell is a Software Developer who led the team that created the SQL Data Generator at Red-Gate. Before then, he led the 'SQL Toolbelt' installer and the SQL Doc team, and before that worked in the SQL Bundle 5.0 team. He was previously a Senior Software engineer at Pi Research. In his spare time David Connell develops other software packages with a Dutch Company, Thermimport Quality Control.

31 March 2008
31 March 2008

Towards a Better Beta

David Connell describes how the team that developed Red-Gate's SQL Data Generator tool came to realise that database developers and DBAs already knew what they wanted for their test data. The team wanted to use the Beta version of the program to get a clear message from them. . And then came the daunting task of working out the best way of incorporating all this wisdom into the final product.… 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
0
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
1
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
1
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
0
23 November 2005
23 November 2005

Explorer and Environment variables

0
You can type environment variables into the the Explorer Address bar and it is expanded into its full path. Typical examples include: Environment Variable  Meaning Example %TEMP% Temp directory C:TEMP %TMP% Temp directory C:TEMP %USERPROFILE% Current Profile C:Documents and SettingsDavid Connell %WINDIR% Windows Directory  C:Windows You may have some company specific enviroment variables, check it out … Read more
0
18 November 2005
18 November 2005

Always set Warnings as Errors

0
How many of us have developed some code only to find the compiler outputs some warnings such as unused parameter, or unreachable code and just thought “yup, I’ll fix it tomorrow”. Unfortunately tomorrow never comes and the warning just get left in. Before you know it when you build a project there are hundreds of … Read more
0
18 November 2005
18 November 2005

Testing for empty String

0
I was speaking with James a few days ago about strings and testing for them being empty, and as usual we had an interesting discussion. At the end of it I thought I better go off and write some test code to find out some real numbers. I investigated three environments. .NET 1.1 .NET 2.0 … Read more
0
09 November 2005
09 November 2005

XP SP1/SP2 system DLL’s

0
Last week I found out that sometimes XP SP1 dlls are labelled as xpsp2. A client had DLLs that were labelled xpsp2 for example comctl32.dll  6.0 (xpsp2.050831-1533) c:windowswinsxsx86_microsoft.windows .common-controls_6595b64144ccf1df_6.0.2600. 1740_x-ww_7cb8ab44comctl32.dll  However just because the DLLs are labelled xpsp2 this does not mean that they are Service Packl 2.Infact they are late XP Service Pack 1 DLLs!… Read more
0
04 November 2005
04 November 2005

Windows Keyboard short cuts

0
Here is a list of some of the windows key board short cuts (thanks to Tilman): Keyboard Meaning Windows key Start menu Windows key + D       Minimize all windows to Desktop Windows key + D Restore minimized windows Windows key + E Windows Explorer Windows key + L Lock Desktop Windows key … Read more
0