|
|
Latest Blog Posts
-
 |
|
480 Views |
SQL Compare 7 was an exciting release for us; not only did we manage to add full support for SQL Server 2008 (before Microsoft released it !) and fix loads of bugs, we managed to find enough time to implement Compare to Backup functionality. Compare is...
|
-
 |
|
1041 Views |
I’ve always been suspicious of denormalizing an OLTP database. Denormalisation is a strange activity that is supposed to take place after a database has been normalized, and is assumed to be necessary in order to reduce the number of joins in queries...
|
-
 |
|
207 Views |
Just a quick .NET puzzle. Does this application ever throw that ApplicationException? If so, why?
using System;using System.Threading;class Program{ static long Num = 0; static void...
|
-
 |
|
476 Views |
The last ANTS Profiler 4 early access build has been released, and now we're on track for a beta on August 4th (yes, I did give out an definite date, don't anybody call an ambulance or anything)....
|
-
 |
|
199 Views |
Andrew Clarke describes how to get Community Server, or any other Blogging platform that only accepts the FONT tag, to accept nicely formatted code from Visual Studio or SSMS. ...
|
-
|
|
804 Views |
A progress update on ANTS Profiler 4, and the soon-to-end early access program....
|
-
|
|
1972 Views |
One of the greatest pleasures of programming in C# is that wonderful, giddy, feeling of superiority one has over VB.NET programmers. In C#, one has a vague awareness that what one is doing has elegance and style. It must be the effect of the curly braces....
|
-
 |
|
2180 Views |
From Waterfall to Scrum
How do you scale your development processes?
Once upon a time Red Gate had a single development team. It was small enough to write software for a new product by doing a few iterations of the more traditional waterfall...
|
-
|
|
1239 Views |
Several parts of SQL Server look as though they were started and then suddenly abandoned. The classic example is the TEXT datatype. Phil Factor has a theory on most things, and in this case it's that the programmer responsible for implementing the TEXT...
|
-
|
|
445 Views |
At Red Gate we have a ‘Memory Wall’ that proudly displays a number of Red Gate’s finest (and not so finest!) moments over the past eight years. We have some super photos of our joint CEO, Neil Davidson, looking like a fresh-faced university graduate,...
|
-
|
|
683 Views |
Red Gate, to the untrained eye, looks a lot like other companies. We are departmentalised, we are spread over multiple offices, and we sometimes don’t know what other areas of the company are up to (note to Sara – when do we find out what “activities”...
|
-
 |
|
4726 Views |
SQL Server 2008 has introduced a few new data types, among others the new date types, like date, time, datatime2 and datetimespan. Because .Net 2 was released before SQL Server 2008 has introduced these data types, there are no classes that map to these...
|
-
 |
|
3581 Views |
Phil has recently been writing a history of computing. He will probably never finish it, since he keeps getting over-excited by the subject and going off at a tangent. Here, he appeals for help with a knotty problem that, if solved, could change our...
|
-
|
|
1049 Views |
Phil muses over the 'Exceptional DBA' awards, and wonders if there really are any 'required skills' that make a DBA exceptional. Maybe it is just down to attitude....
|
-
|
|
2386 Views |
It is strange that two important programming techniques in a SQL Server Database can't be done in TSQL. The first is, of course, being able to read multiple results from a stored procedure. You can do it in ODBC/ADO and so on, but not in TSQL. The other...
|
-
|
|
970 Views |
The ASP.NET support in ANTS Profiler 4, that many of you have been waiting for, is now ready to go....
|
-
|
|
1066 Views |
I sit next to this guy called Stephen Chambers. He is the Usability Engineer working on our next version of our code profiler, ANTS Performance Profiler 4. He is completely revising the UI of ANTS Profiler, and spends most of his time phoning developers...
|
-
|
|
872 Views |
For me, inheritance is often a headache. In particular, in what order is everything initialized? Consider this short C# program. It creates an instance of Dog, which derives from Animal. Both Dog and Animal have an...
|
-
|
|
1787 Views |
Phil Factor confesses to having once suffered from two of the more unfortunate and embarrassing occupational diseases of being a database programmer at once, but somehow the results of his mental aberrations turned to profit....
|
-
|
|
1479 Views |
Server Management Objects (SMO) is a very impressive product. SMO (and its previous incarnation, SQL-DMO) is essentially an object-oriented interface into the management of SQL Server installations and databases. It provides an intuitive way for the VB...
|
-
 |
|
599 Views |
What I learned lately - by Richard Mitchell Aged 32 3/4.1. When you're managing a large project team don't expect to get 4 days coding done a week.2. Designing a UI that people can use is much harder than it seems.3. Hire the right people and they'll...
|
-
 |
|
589 Views |
Hello all,
My first attempt at a blog. Well second actually - I've just created another one for myself at http://nigelrivettblog.blogspot.com/. Anyway I'm trying to concentrate a bit more on contributing to this fine site.
I recently published an article...
|
-
|
|
2453 Views |
The average DBA has to perform many routine checks on his or her servers. There will be daily checks, weekly checks and, probably, monthly checks. A short while ago, we were having quite a debate about what items would be on the DBA Daily checklist. Because...
|
-
|
|
2429 Views |
Find out about the ANTS Performance Profiler 4 early access program, and how you can get your hands on development builds of this new version of Red Gate's award winning profiler....
|
-
 |
|
958 Views |
One of the great features in .NET is its event model. I came from a Java world before I started developing C#, and whilst they achieve the same effect using "listeners", I think C# definitely does it more slickly. That's not to say I wouldn't like to...
|
|
|