Sunday, October 30, 2005

Toronto CodeCamp > Home ( DNN 3.1.1 )

Toronto CodeCamp > Home ( DNN 3.1.1 )

Monday, October 17, 2005

Microsoft SQL Server 2005 Data Lifecycle-Partitioning

Partitioning data with Project Real

Friday, October 14, 2005

Jamie Thomson - Life, the universe and SSIS!

Jamie Thomson - Life, the universe and SSIS! or How to Pass DTS Datetimevalues into a stored proc.

Mark Hill Rambling About ... Analysis Services

Mark Hill Rambling About ... Analysis Services Good article on aggregations in 2005

More head-hurting articles...

Detecting Duplicate Indexes in Microsoft SQL Server 2005 databases using PIVOT

Nick Grattan - My Blog - Using the OUTPUT Clause with INSERT, UPDATE and DELETE in SQL Server 2005

No more @@IDENTITY or @@SCOPE_IDENTITY? My head hurts...

Jamie Thomson - Life, the universe and SSIS! : SSIS: The mind-shift from DTS

Jamie Thomson - Life, the universe and SSIS! : SSIS: The mind-shift from DTS

Jamie Thomson - Life, the universe and SSIS! : SSIS Nugget: Get error descriptions

Jamie Thomson - Life, the universe and SSIS! : SSIS Nugget: Get error descriptions

x5 � ISNULL in c# (2.0 only stuff)

x5 � ISNULL in c#

Separating Data Layer from Reporting Layer in RS

How to preview a report without direct access to its data source in SQL Server Reporting Services 2000
You may have noticed that starting with SSRS SP1, when you preview a report which contains data in the designer, a ReportName.RDL.Data file appears on your file system. We store the data that was just displayed by your preview action in this file so we don't have to round-trip to the server over and over again each time you preview the report (assuming you don't change any parameter values, etc.)
If you want, you can use this data file to make your report more "portable" -- Basically taking the report.rdl and report.rdl.data files to another machine that doesn't have access to the "real" data store. You can also use this method to send the report/data to a buddy if you need some help troubleshooting the report. Cool hack!
Close Visual Studio and add the following lines to Program Files\Microsoft Visual Studio .NET 2003\Common7\IDE\devenv.exe.config file:

What this entry does is force the preview pane to bypass checking that the cache (data file) is up-to-date and that any report parameter values selected in the report match those used to generate the cached data in the local file.
Next, Create a new VS Report Project and add the existing (rdl) report to it. Drop your rdl.data file in the same folder.
(This is the strange part) Add a new shared datasource to the project, giving it the SAME name as the old datasource your report used in the other project it lived in previously. You don't need even need to specify connection string in his data source -- it'll be using the cached data in your rdl.data file.
Finally (if necessary), modify the report so that any parameters in it don't use queried values (which you no longer have data for) , and that all parameters have valid default values. You also need to remove any other datasets that use data not coming from your .rdl.data file.
Preview!

Russell Christopher's Semi-Useful BI Musings

Russell Christopher's Semi-Useful BI Musings

Very useful musings...

Russell Christopher's Semi-Useful BI Musings

Russell Christopher's Semi-Useful BI Musings

Very useful musings...

Thursday, October 13, 2005

Read from a text file into SQL table without BCP

One of my co-workers asked how to read a text file into a table.

Without using BCP, here is one way of doing it... (must have xp_cmdshell enabled.)

-- This procedure reads the ALL text file which contains the currently
-- running date and displays the results

DECLARE @FileCommand as varchar(255)
SET @FileCommand = 'type c:\all.txt'
-- =============================================
-- Create table basic template
-- =============================================
IF EXISTS(SELECT name
FROM sysobjects
WHERE name = 'TempDateCheck'
AND type = 'U')
DROP TABLE TempDateCheck

CREATE TABLE TempDateCheck (
Contents varchar(100) NULL)

INSERT INTO TempDateCheck
EXEC xp_cmdshell @FileCommand

SELECT Contents
FROM TempDateCheck