SQL Server has a nice alert system, but SQLMail leaves something to be desired. New author Desiree Harris, from hosting provider Orcsweb, looks at an alternative method for sending alerts using an SMTP server and without requiring Outlook to be installed.
2004-09-09
14,040 reads
This step-by-step article describes the steps you must use to change domains for an existing SQL Server 2000 Failover Cluster.
2004-09-09
698 reads
All the submissions for the Nightmare Contest are in, now take a moment and vote for your favorite.
2004-09-08
3,708 reads
User defined functions were added in SQL Server 7 and enhanced in SQL Server 2000, but they are still a relatively little used feature. Here's a look at a unique way that Leo Peysakhovich solved a problem using a UDF.
2004-09-07
11,093 reads
Reporting Services is one of the hottest new tools that adds on to SQL Server. William Pearson continues his series on this new product with a look at how to add pie charts to your report.
2004-09-07
2,338 reads
How solid is your SQL Server database design? Will it perform well in practice? SSW has a product, SQL Auditor, that compares your design against a number of well known design rules and gives you reports based on how well your design does. Read Mike Pearson's review of this product.
2004-09-06
5,792 reads
When you decide on a connection string and add a Data Connection, each Data Connection also displays a tree of information about the database objects (like tables, views, and stored procedures) visible directly through the connection. But where does this information come from? Read this article from MSDN on the new features of ADO.NET.
2004-09-06
853 reads
Win XP Pro limits users to one web site, but developers often need to be able to switch between sites when coding locally. This free tool let's you easily do just that. Why an article on an IIS tool on a SQL site? We think it might be useful to you or someone on your team, and lots of SQL developers use IIS as well.
2004-09-03
5,746 reads
In 2004 is the IT industry expanding or contracting? Is your job secure? Steve Jones recently completed a survey and just got the results. Read this short summary of the results.
2004-09-03
5,139 reads
A Q&A look at the new Web Services configurations in SQL Server 2005.
2004-09-02
3,099 reads
Full documentation on the Undercover Catalogue can be found HERE It’s been a while...
By DataOnWheels
It was awesome to see the Kentucky data community come out for the first...
All, I'm trying to find a way to let some of our users see...
Hello, I have a script that was running really long, and I have found...
I am building a report to show customer journeys and their arrears levels. I...
Can I create In-Memory OLTP tables in SQL Server Express?
See possible answers