Click here to monitor SSC

David Connell


David Connell

How to add to the list of available SQL Servers

0 comments

Have you ever wanted to add to the list of SQL Servers found in Red Gate’s SQL Compare, SQL Data Compare, SQL Doc or even SQL Data Generator? If so, here goes. All you need to do is add the name of the SQL Server instance to the registry. The application looks for servers named […]

10 March 2008 5:03 am by
David Connell

How to write a Generator for SQL Data Generator 1.0 Beta

0 comments

In this article we will develop our own generator and understand the basic concepts and ideas behind developing generators for SQL Data Generator. Specifically we will write an ISBN number generator for SQL Data Generator 1.0 Beta, that can generate unique ISBN-10 style strings. You will see that writing and developing your own Generators is […]

15 January 2008 5:09 am by
David Connell

SQL Data Generator 1 (Beta) – Adding UK Style Address Generators

1 comment

We are currently running a Beta of SQL Data Generator, and some people have requested UK style data generators. So I have put together a small zip file that generates the following data:- UK Post CodesUK CountiesUK CitiesUK TownsIn order to install this add in, please carry out the following: Stop SQL Data Generator Download […]

10 January 2008 6:42 am by
David Connell

Performance and Multiple Assigment in C#

1 comment

I was recently thinking if I really liked to use the Multiple assignment in ‘C#’ or if it was less readable. In ‘C’ this syntax was popular as it tended to lead to smaller and quicker code.So I wondered in C# if the multiple assigment also lead to quicker code. So I quickly wrote some […]

25 January 2006 5:13 pm by
David Connell

Adding your own .NET exceptions to Visual Studio

0 comments

You can easily add your own exceptions into Visual Studio so that you do not need to add them in each time into your project when debugging your code.I have only checked this against Visual Studio 2003, but it looks like it would works the same in Visual Studio 2000 and Visual Studio 2005. BR>Start […]

9 January 2006 5:01 am by
David Connell

Copying File Security Attributes

0 comments

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 […]

20 December 2005 3:49 am by
David Connell

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

0 comments

.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 […]

30 November 2005 12:43 pm by
David Connell

Visual Studio & Zoomin…..

0 comments

I used to like the old Zoomin utility that came with Visual Studio 6…. Anyway looks like this little applet is no longer shipped in Visual Studio 2003 or Visual Studio 2005. I have recently come across a replacement utility at code project – better zoomin. It does allow you to zoomin a specific part […]

24 November 2005 11:26 am by
David Connell

Wild card registering COM dlls

0 comments

When developing a COM based application sometimes it’s sometimes useful to register all the DLLs/OCX at once.From a command prompt C:develepprojectrelease>for %i in (*.dll,*.ocx) do regsvr32.exe %i /sThis 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 […]

23 November 2005 1:04 pm by
David Connell

Debugging Arbitrary thread stacks in .NET

0 comments

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 […]

23 November 2005 9:21 am by
Older posts