MySQL: you get what you're paying for
Long, long time ago in the galaxy not so far away I installed mySql 5.05 on my server. After some time I decided to upgrade to the current version, MySql […]
Databases
Why I would not recommend SSRS
I’ve been putting this off for a while, and it’s been a couple of months since I had actively worked with SSRS reports on a daily basis. Here are my […]
All your database are belong to us
Just tried to import some data from Excel into SQL Server. Got the following error message: You have selected to skip 4 potential lost column conversion(s). You are only allowed […]
How to Send More than 4000 Characters from CLR Stored Proc
I was sending some debug output from my CLR stored procedure via SqlPipe.Send() method, and suddenly I received this exception: System.ArgumentException: Message length 4474 exceeds maximum length supported of 4000. […]
Random Notes on MDX Filtering
1. Filter() and IIF work funny in the columns hierarchy. Consider this: SELECT FILTER([MarketValue], [MarketValue] >1000) ON COLUMNS, [Region].[Region].[Region] ON ROWS FROM [MyCube] In this case the MarketValue in red […]
SSRS Production Deployment, Part 3
Deploying Reports Download code. In Part 2 we talked about deploying SSRS data sources. Now we are ready reports. Reports are deployed using rs.CreateReport() method. It accepts array of bytes […]
SSRS Production Deployment, Part 2
In Part 1 we discussed that in development environemnt we deploy reports by simply clicking “Deploy” in BIDS, but this won’t work in production. To deploy reports in production we […]
SSRS Production Deployment, Part 1
So, you built your shiny and flashy SSRS report, and you hit “Deploy” in BIDS, or “SQL Server Data Tools” in newer versions. Your UAT is a breeze, and everything […]
BI Studio: cannot customize auto generated MDX query
Long story short: if you are building an SSRS report in Microsoft BI studio, and if that report has parameters, you cannot customize the automatically generated MDX query. If you […]
ADO.NET: what did you just say?
I need to do some processing when rows are deleted from my DataTable. One would think it should be easy: after all, you have RowDeleting and RowDeleted events, that should […]