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,756 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,534 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 HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
Comments posted to this topic are about the item Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers