Contents tagged with Database stuff
-
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.
-
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.
-
Microsoft Security slide deck
From Dana Epp...
-
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.
-
OleDbCommandBuilder.DeriveParameters
If you use a JET data provider, this method throws an exception saying that the underlying provider does not support this method.
-
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.
-
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.
-
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.
-
SQL Server Reporting Services - playing with the released bits
In feedback of my previous blog, Thomas asked:
-
SQL Server Reporting Services
SQL Server Reporting Services has been released, but the download is for a time-bombed 120 evaluation version.