|
|
Latest Blog Posts
-
 |
|
149 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...
|
-
 |
|
137 Views |
With gas prices here in the panhandle of Florida where I comfortably reside soaring to over $3.60 per gallon, I knew I would spend at least $110 toting myself and my beautiful fiancee from Pensacola to Jacksonville, host city of the most recent SQL Saturday...
|
-
 |
|
1097 Views |
The Daily WTF recently reported that the Sexual and Violent Offender Registry of Oklahoma had to shut down its website for 'routine maintenance'. It turns out that this routine maintenance was necessary because 10,597 social security numbers from sex...
|
-
 |
|
821 Views |
Not drugs. I mean the C# (and VB) keyword....
|
-
|
|
1064 Views |
So each week, I am required to turn in a weekly status report that demonstrates in summary fashion what I have accomplished the previous week. In a smoothly running SQL infrastructure of even 90+ servers, DBA managers may find themselves in a repetitive...
|
-
 |
|
931 Views |
SQL Server 2008 introduces a few new languages like Welsh, Tibetan
and Norwegian. While these new languages map to the codepages in Windows Server
2008, in earlier operating systems (like XP) this is not so, and simple queries
like “select * from...
|
-
 |
|
533 Views |
I was developing against a web site project -- you know the ones in Visual Studio 2005/2008 where you can just point to a directory and do your thing (as compared to a web application project with an actual project file) -- and I noticed something a bit...
|
-
 |
|
201 Views |
There a number of RSS feeds on the Simple-Talk site. For historical reasons, these feeds are tucked away in a number of different places on the site. Just for convenience, I'm putting them here.
Main Site Feed ...
|
-
|
|
1632 Views |
I was chatting to Phil Factor the other day about the slow start-up of some CLR applications. He started telling me, with apparent irrelevance, how he once, a long time ago, developed a database system in Z80 assembler code and a large eight-inch floppy...
|
-
 |
|
3567 Views |
...In which Phil writes a SQL-based spam detector. ...
|
-
|
|
1082 Views |
In which Phil discovers Tony Davis's shoebox, and makes an exciting discovery....
|
-
|
|
353 Views |
Andrew is waylaid whilst innocently pondering the significance of autumn leaves in the Red-Gate foyer, and discovers the joys of SQL Prompt 3.8. SQL Code Formatting and layout, even for Query Analyser and Visual Studio....
|
-
|
|
1602 Views |
"That ain't a database, it's a spreadsheet!"
From the Sayings of Phil Factor
There is a world of difference between an enterprise-level relational database and a 'repository of persistent data'. Until you've had the experience of dealing with...
|
-
|
|
1287 Views |
I want to restore only a single table from my database
backup. We have been hearing this request from many of our SQL Backup
customers. The problem is simple: Given a large database backup and a live
database that has a partial “corruption”, e.g....
|
-
 |
|
679 Views |
If you had come of age before Component Object Model as I have, the concept of COM registration seemed rather odd at first glance. Why is your system limited to exactly one application extension which is forced to be backwards-compatible, when, for years,...
|
-
|
|
358 Views |
Ever since the dark ages of programming, certain tricks have been implemented in code compilers to eke out the maximum performance from the compiled code, the most important of which is inlining. Put simply, inlining is the process by which a child method...
|
-
|
|
701 Views |
Many years ago, when switching from programming in plain old C to the managed environment of .NET Framework, I had discovered exceptions. The idea was not completely new to me because I'd already seen try/catch blocks in JavaScript and I liked that...
|
-
 |
|
1198 Views |
I'm finding I really like C#'s anonymous delegates. I've used them several times now in various ways. Normal delegates are already a Good Thing, however basically they are C(++) function pointers with a much nicer syntax. Anonymous delegates do clever...
|
-
 |
|
546 Views |
As a small addendum to my previous blog on the subject of authenticating users, and checking for administrator privileges, under Windows 2000, XP and Vista, I should add this little note. It turns out, thanks to the sort of heavily industrious testing...
|
-
|
|
970 Views |
Some activities on any operating system fall into that category of "should be extraordinarily
simple, and yet is full of the sort of pitfalls that cause headaches, confusion
and (at least in my case) bouts of cursing and ranting". ...
|
-
|
|
1104 Views |
Many orthodoxies, or 'truisms', exist in IT; rules of programming that emerge in the light of shared experience and are then passed on from programmer to programmer and instilled as "the right way" to tackle a certain problem. The difficulty is that many...
|
-
 |
|
176 Views |
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...
|
-
|
|
1486 Views |
SQL Server 2008 CTP6 does not work on February 29th.
Period.
On one hand, it is really nice that Microsoft is releasing
Community Technology Previews for its latest SQL Server. It helps developers
and DBAs to test their solutions and get familiar...
|
-
|
|
2132 Views |
Among the large number of new features in SQL Server 2008
there are two, almost insignificant features, that I use almost constantly.
These are variable initialization and the values clause of insert statements that
now accept multiple...
|
-
|
|
3394 Views |
It is strange to see the heat generated over arguments about how code should be formatted. With Visual Studio, of course, it isn't much of an issue, as it is done for you, but the closer you get to the 'live free and die' communities of the LAMP platforms,...
|
|
|