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,125 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,808 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,755 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,149 reads
A Q&A look at the new Web Services configurations in SQL Server 2005.
2004-09-02
3,099 reads
From SQLTeam's Bill Granazio, a look at how he ensures his database scripts are always working.
2004-09-01
806 reads
Continuing with Dinesh Asanka's series on SQL Server and Infopath 2003, he shows us this time how to build a report that joins two tables and includes some conditional formatting. Infopath 2003 is part of Office 2003 and is a great quick and dirty tool for getting to your SQL Server data.
2004-08-31
7,532 reads
A short tutorial on building database back-ended applications with SQL Server and CE. If you're looking to build mobile apps, this is a good place to start.
2004-08-31
541 reads
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Comments posted to this topic are about the item Optimism Without Illusion or Why...
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Hi So the case statement is slowing this down - but for the life...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers