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
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
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,776 reads
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
3,802 reads
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
341 reads
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
Do you know what the schema is? In Relational databases, there is the concept of a database and a table, but the schema sits between them. In SQL Server, this is known as the owner. But do we really need this additional layer? Has it ever caused you problems? Has it outlived its usefulness?
2003-05-21
5,220 reads
SQL Stripes is an application that helps you - the SQL Server DBA, to have complete control over your servers. From the high-level of monitoring essential components to the low-level of analyzing your various databases. SQL Stripes is an intuitive and easy to use application and is intended for SQL Server DBA who want to have an easier life. SQL Stripes is completely free! (Announcement, not reviewed)
2003-05-20
461 reads
New Web interface generator for multi-user SQL Server databases. Makes either complete DB interfaces with a single click, or web form fragments through model-based developer API. Sources available. Online showroom allows use and development; trial version available for download. (Announcement, not reviewed)
2003-05-20
1,154 reads
Dinesh does a good write up on research he did investigating the BI market and doing a feature comparison between Oracle 9i and SQL 2000. Simple bullet point format, worth a look.
2003-05-19
19,288 reads
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Comments posted to this topic are about the item No Defaults Passwords Ever
Hi, We have low latency high volume system. I have a table having 3...
Comments posted to this topic are about the item The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?