Browse by Tags

OLAP Cubes
29 September 04 03:36 PM | MikeD | with no comments

Whenever my boss can use a pivot table in Excel, he does a little happy dance. Well, sometimes its more like watching a horny chihuahua, but I won't go any further - you probably have an indelible picture in your mind already. Recently, I've been putting...

Filed under: .NET Development, Database stuff

SQL Reporting Services - Expression language?
15 March 04 12:06 PM | MikeD | 4 comment(s)

I'm starting to use SQL Reporting Services. I've got some textboxes that I want to format nicely for an address, for example. Unit Street City Region PostalCode Country All this needs to be in one textbox. If Unit or Street is null, then there should...

Filed under: .NET Development, Database stuff

Microsoft Security slide deck
11 March 04 08:53 AM | MikeD | with no comments

From Dana Epp... Microsoft has released a slide deck and white paper on their Application Security Assurance Program. Microsoft founded the Application Security Assurance Program (ASAP) to inventory, assess, and-when necessary-ensure resolution of security...

Filed under: .NET Development, Database stuff

Smart Client Offline Application Block
03 March 04 06:01 PM | MikeD | with no comments

It appears that Microsoft has published the Smart Client Offline Application Block , even though the Patterns and Practices Group says it is “Coming Soon“ . The block itself is available for download here . This page provides an overview of...

Filed under: .NET Development, Database stuff

OleDbCommandBuilder.DeriveParameters
27 February 04 03:54 PM | MikeD | with no comments

If you use a JET data provider, this method throws an exception saying that the underlying provider does not support this method. Anyone got any ideas for a workaround? I suppose I could use good ol' DAO through Interop.

Filed under: .NET Development, Database stuff

Google Microsoft!
25 February 04 02:48 PM | MikeD | 5 comment(s)

Ever try searching support.microsoft.com or msdn.microsoft.com for something and not get what you want? I've usually ended up using Google to find kb articles or whatever, then getting a ton of non-MS related hits in the results. Here is something I happened...

Filed under: .NET Development, Database stuff

Another webcast with Joel
20 February 04 08:03 PM | MikeD | with no comments

I was Joel's 'question monkey' today on his second webcast this week. We had some fun today, there were far less questions than Wednesday's presentation. We covered buffer overruns, integer overflows, cross-site scripting, SQL injection attacks, and some...

Filed under: .NET Development, Database stuff

Cursors, BAD! Table Vars, GOOD!
07 February 04 07:48 PM | MikeD | 5 comment(s)

As of SQL Server 2000, we have had the table variable to use in T-SQL for temporary tables or user defined functions. I like to use table variables wherever I can because I have observed performance problems with CURSORS and #TEMPTable objects. Stephen...

Filed under: Database stuff

SQL Server Reporting Services - playing with the released bits
28 January 04 09:51 PM | MikeD | 1 comment(s)

In feedback of my previous blog, Thomas asked: Mike - I remember some review of this thing talking about it not being programmable with C# or VB.NET. Did you see anything in regards to that? Yes and no... You work with report definitions in VS.NET - there...

Filed under: .NET Development, Database stuff

SQL Server Reporting Services
27 January 04 03:34 PM | MikeD | 1 comment(s)

SQL Server Reporting Services has been released, but the download is for a time-bombed 120 evaluation version. Cool things: importing Access reports. scheduled execution of reports subscriptions to reports various output types: html, xml, pdf, text, rtf...

Filed under: .NET Development, Database stuff