Deploying Reports
Longtime SQL Server expert Raj Vasant takes a look at various ways in which you can deploy reports for Reporting Services 2005.
2008-04-16 (first published: 2007-06-05)
21,430 reads
Vasant Raj
- Interests: Learning new things, Playing Table Tennis and watching English Premier League...
Custom Report Item - Part I
This article will give a basic introduction of Custom Report Item in SQL Server 2005 Reporting Services.
2008-03-11
7,429 reads
Adding Custom Code To Reporting Services
Reporting Services has been greatly enhanced in SQL Server 2005 and become an integral tool in many SQL Server installations. Longtime autor Raj Vasant brings us an example of how you can enhance your reports with custom coded DLLs called from within the reporting engine.
2008-01-15 (first published: 2007-03-15)
21,723 reads
Navigation Options in Reports
You can build some very complex reports in Reporting Services and longtime author Raj Vasant brings us a short tutorial on how you can implement internal navigation structures in your reports.
2008-01-10
5,259 reads
Document Your Database
Computer professionals are constantly complaining about the documentation for the software they use. And are notorious for not documenting their own code very well. Longtime author Raj Vasant brings us a short article with some suggestions on how to go about documenting your databases.
2008-01-02 (first published: 2007-01-11)
13,830 reads
Source Control in SQL Server
One of the most requested features from SQL Server developers is the integration of source control with T-SQL code. SQL Server Management Studio brings some integration with Visual Source Safe and longtime SQL Server author Raj Vasant explains it to us.
2007-11-30 (first published: 2006-12-04)
14,226 reads
Working With SqlParameter in .NET
Interacting with SQL Server from .NET is a radical change from the old OLEDB/ODBC method. Raj Vasant brings us some easy ways to work with parameters passed in with the ADO SQLCommand.
2007-11-09 (first published: 2006-03-22)
24,531 reads
Distributing SQL Server Databases
Longtime SQL Server author Raj Vasant brings us a technique for delivering databases along with an application. As more and more systems take advantage of SQL Server or Express, this is a technique that can come in very handy.
2007-10-22
5,615 reads
Querying System Tables
It is not recommended, but there is quite a bit of valuable information stored in the SQL Server 2000 system tables. Raj Vasant brings us a look at some of the information that you can get by directly querying the system tables and explains what is stored in a number of them, including gathering information about computed columns.
2007-10-02 (first published: 2005-06-13)
39,751 reads
Using OpenXML
SQL Server 2000 added XML support awhile back, though it was limited in what is offered and can be a little confusing. SQL Server 2005 will add many more features and functions, but in the meantime, if you are looking to add some XML support to your 2000 server, new author Raj Vasant brings us some basics on using OpenXML.
2007-10-02 (first published: 2005-05-12)
42,903 reads
Blogs
Another Change
By Steve Jones
Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity...
Using Prompt AI to Help Setup Data Analysis
By Steve Jones
I used Claude to build an application that loaded data for me. However, there...
NVMe vs PVSCSI: Real-World Performance Testing for SQL Server Workloads on VMware
End-to-end NVMe vs PVSCSI testing over NVMe/TCP to a Pure Storage FlashArray: TPC-C and...
Forums
Simplifying WHERE Condition with LIKE test on multiple columns
Good Evening, Is there a simpler way to rearrange the following WHERE condition: [Column_1]...
Which Table I
Comments posted to this topic are about the item Which Table I
Using Python notebooks to save money in Fabric: The Fabric Modern Data Platform
Comments posted to this topic are about the item Using Python notebooks to save...
Question of the Day
Which Table I
I have this code in SQL Server 2022:
CREATE SCHEMA etl;
GO
CREATE TABLE etl.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT etl.product
VALUES
(2, 'Bee AI Wearable');
GO
CREATE TABLE dbo.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT dbo.product
VALUES
(1, 'Spiral College-ruled Notebook');
GO
CREATE OR ALTER PROCEDURE etl.GettheProduct
AS
BEGIN
SELECT ProductName
FROM product;
END;
GO
When I execute this code as a user whose default schema is dbo and has rights to the tables and proc, what is returned? See possible answers