English Blog Posts
Viewing how much memory is used by not reused query plan
Friday, July 23, 2010
One interesting observation that may help developers get convinced that they should parametrize query and that they must check that the ORM they use does it correctly is show how much memory can be wasted by plans that cannot be effectively reused. The following query can help on this: with cte as ( select reused = case when usecounts > 1 then 'reused_plan_mb' else 'not_reused_plan_mb' end, &#...
PASS Summit 2010 – BI Workshop
Wednesday, June 30, 2010
PASS Summit 2010 Pre & Post conference are out! This year I’ll deliver the “Creating BI Solution from A to Z” seminar in which, as the title implies, attendees will see how to create a BI solution starting from scratch. Going through the dimensional modeling and the creation of the Datawarehouse, the implementation of the ETL process with SSIS, the creation of cube with Analysis Services and reports with Reporting Services with, if time permits, also a glance at PowerPivot, attendees will...
Installing SQL Server 2008 R2 Best Practices Analyzer on a Stand-Alone machine
Monday, June 21, 2010
As soon as the shiny new SQL Server 2008 R2 BPA has been released, I’ve downloaded it and tried to install it immediatly on my Virtual Machine, which is not joined to any domain. Unfortunately I had a bad surprise, since the installation failed with a very anonymous error. Some more detailed error appears in a pop-up console, but it closes just too fast to be read. Armed with patience and Camtasia, I recorded the installation and found the error: I’ve tried to run the command manually (u...
SSIS Expression Tester Tool
Sunday, June 13, 2010
Thanks to my friend's Doug blog I’ve found a very nice tool made by fellow MVP Darren Green which really helps to make SSIS develoepers life easier: http://expressioneditor.codeplex.com/Wikipage?ProjectName=expressioneditor In brief the tool allow the testing of SSIS Expression so that one can evaluate and test them before using in SSIS packages. Cool and useful! Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!
DTLoggedExec 1.0.0.2 Released
Sunday, June 13, 2010
These last days have been full of work and the next days, up until the end of july, will follow the same ultra-busy scheme. This makes the improvement of DTLoggedExec a little bit slower than what I desire, but nonetheless Friday I’ve been able to relase an updated version of the tool that fixes a bug and add a very convenient option to make even more straightforward the creationg of execution logs: [bugfix] Fixed a bug that prevented loading packages from SSIS Package Store [new] Add...
