DB2 A Worthy Competitor?
Recently Steve Jones spent a week working with IBM's DB2 database. Read about his thoughts and impressions of this SQL Server competitor.
2003-06-02
6,204 reads
Articles
Dependency Walker
Dependency Walker has been around for a while as part of Visual Studio. Have you tried it? Got the latest version? Andy does a very quick run through of what the product does, why you might need it, where to get the latest version, and why the new version is better than the old one (isn't it always?).
2003-05-30
7,949 reads
Find out about free Trade Publications
This is a great site that lists all the free trade publications in various industries. You have to meet the criteria of course, but you should definitely check out the offerings.
2003-05-29
1,031 reads
Importing And Analyzing Event Logs
Another new author! Gheorge shares some ideas about importing event logs and using OLAP to analyze the results. Not a bad idea at all. How many of use OLAP as often as we should? Read the article, see if it's something you want to try - and let Gheorge know what you think!
2003-05-28
13,039 reads
Red Gate Web Site Usability Survey
Red Gate asked if we would run a link to a short survey they are working on. Should only take a couple minutes and no personal information is required. They've been an advertiser with us since almost the beginning so we're glad to pass this along to our readers.
2003-05-27
715 reads
Trapping DTS errors with Transact-SQL
Joe has written some articles for us, he also some interesting comment on his site - this article looks at trapping errors such as timeouts or divide by zero.
2003-05-27
2,490 reads
Changing Rogue Database Collations
Collations hard to sort out (I know, bad joke)? Mike did what a good DBA gets paid to do, figure out an easy way to fix something and remove the chance of a user mistake at the same time. Good explanation and a couple scripts show how to handle column level collations.
2003-05-26
12,804 reads
Is Steve Jones Really Steve Jones?
Alien imposter? No, not that complicated. Andy saw an actor on TV that according to some looks JUST like our own Steve Jones. Steve is a good sport about such things and provided several photo's so you could judge for yourself. Of course, there is a little more to the story - read the article to see!
2003-05-26
4,066 reads
Test Your SQL Server Security Skills and Compete with your Friends!
Test to see how much you know about SQL Server security. If you're one of the members to pass the test (72% score or higher), you're entered into a contest to win a copy of AppDetective and one year's worth of support (over $1500 value)! You can only take the test question test once and it is not timed. After the test, you'll be given the answers and why one answer is more correct than another. Questions are randomly chosen from a pool.
2003-05-22
350 reads
COM+, SQL Server, Serializable isolation level and the issues!
This article shows you how to identify SQL Server performance problems and explains how the SERIALIZABLE transaction isolation level effected the performance of an OLTP application.
2003-05-22
1,874 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers