|
|
Latest Blog Posts
-
 |
|
101 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...
|
-
 |
|
268 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....
|
-
 |
|
276 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...
|
-
 |
|
164 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...
|
-
|
|
1200 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...
|
-
|
|
884 Views |
Not drugs. I mean the C# (and VB) keyword....
|
-
|
|
1105 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...
|
-
 |
|
962 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...
|
-
 |
|
551 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...
|
-
 |
|
211 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 ...
|
-
|
|
1659 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...
|
-
 |
|
3629 Views |
...In which Phil writes a SQL-based spam detector. ...
|
-
|
|
1098 Views |
In which Phil discovers Tony Davis's shoebox, and makes an exciting discovery....
|
-
|
|
366 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....
|
-
|
|
1618 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...
|
-
|
|
1315 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....
|
-
 |
|
688 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,...
|
-
|
|
362 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...
|
-
|
|
707 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...
|
-
 |
|
1206 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...
|
-
 |
|
550 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...
|
-
|
|
990 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". ...
|
-
|
|
1118 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...
|
-
 |
|
180 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...
|
-
|
|
1510 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...
|
|
|