Mike Diehl's WebLog

Much aBlog about nothing...

Browse by Tags

All Tags » Database stuff (RSS)
OLAP Cubes
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...

Posted by MikeD | with no comments

SQL Reporting Services - Expression language?
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...

Posted by MikeD | 4 comment(s)

Microsoft Security slide deck
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...

Posted by MikeD | with no comments

Smart Client Offline Application Block
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...

Posted by MikeD | with no comments

OleDbCommandBuilder.DeriveParameters
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.

Posted by MikeD | with no comments

Google Microsoft!
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...

Posted by MikeD | 5 comment(s)

Another webcast with Joel
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...

Posted by MikeD | with no comments

Cursors, BAD! Table Vars, GOOD!
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...

Posted by MikeD | 5 comment(s)

Filed under:

SQL Server Reporting Services - playing with the released bits
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...

Posted by MikeD | 1 comment(s)

SQL Server Reporting Services
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...

Posted by MikeD | 1 comment(s)

More Posts Next page »