ikriv

I have just received an e-mail in my work inbox titled “calling all women of SharePoint”, that started with the words “Working in the male-dominated IT industry isn’t easy”. It […]

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 […]

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 […]

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 […]

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 […]

I needed to create a script of medium complexity that goes along these lines: 1. Take a list of databases. 2. Each database has an SVN folder, list of files […]