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,767 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,788 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
336 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,213 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,280 reads
As AI continues to evolve, many of us are looking for ways to leverage...
By Steve Jones
I was chatting with a customer recently and they wanted to know which host...
Yeah, yeah, second AI post in a row. I promise not to make a...
Hi everyone My SSIS package will not log to sysssislog. I am not sure...
Dear All, In one of the server its repeatedly restarting sqlserver services and not...
Comments posted to this topic are about the item Understanding CROSS APPLY and OUTER...
I want to store database files on a file share for a SQL Server 2017 instance. Can I use \\fileserver\D$ as a location?
See possible answers