Pie Charts in Reporting Services
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
Additional Articles
Schemas in ADO.NET 2.0
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
Script to transfer logins to second server
Modification of DR_Script_Logins.sql by Bruce Canady.Puts out a script to add new logins or change the password of existing logins.I insert the output into a table in my production-db. insert database.dbo.login_table exec master.dbo.dr_script_loginsThat way its backed up with the data, and the logins can be restored anywhere by the script i added at the […]
2004-09-03 (first published: 2004-05-26)
2,533 reads
Troubleshooting and Debugging SQL Web Services Configurations
A Q&A look at the new Web Services configurations in SQL Server 2005.
2004-09-02
3,099 reads
The Daily Database Build
From SQLTeam's Bill Granazio, a look at how he ensures his database scripts are always working.
2004-09-01
806 reads
DataSet Server CE: Database Connectivity for Windows Mobile-Based Devi
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
Search for text in procedures and show context
This script will search for text within stored procedures and udf's. As a bonus, it will also diplay a user-configurable number of lines from each stored proc to show the search text "in context" so you can tell if it is something you need to deal with without having to open every proc manually.
2004-08-30 (first published: 2004-05-25)
253 reads
Convert Sql Data to any file format
This sp convert SQL Server data into any file format.eg xsl,txt,doc etc.
2004-08-27 (first published: 2004-05-15)
372 reads
MDX in Analysis Services: Mastering Time: Introduction to Moving Avera
In this article, we will examine "rolling average" aggregations, a common business requirement. "Rolling," or "moving," averages, involve a measure, the average under consideration, that is aggregated over a progressively moving window of time periods.
2004-08-27
1,555 reads
Bulk Insert proc to try out ur optimization skills
This SP can be used for bulk inserting data from an ascii text file onto a table. You have to change the structure, of the temporary table (ITEM_MASTER_TEMP) and the actual table onto which data is inserted, to suit ur needs . I wish you people workout this SP and try to optimize it as […]
2004-08-26 (first published: 2004-05-24)
204 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers