November 30, 2010
This is a live post from the session of Eran Sagi at Tech Ed Israel 2010 .
SSIS 11 CTP1 still runs on Visual Studio 2008
An easy and quick zoom on the flow
Custom toolbox: A special toolbox for SSISGrouping by functionality (like before) and by favorites, commonInformation on each component and a small help icon which will be online and specific for that component with videos and How To for that component.
A new data source (and destination) wizard to assist you in building the data source more easily.
Each task takes its own Meta Data. We're no longer dependant in...
This is a live post from the session of Guy Glantser at Tech Ed Israel 2010 .
Top - Down:
Performance Monitor:%Processor Time% Disk TimePage faults \ secBuffer cache hit ratioFull scans \ secSQL complications \ sec
Resource Governor:Managing SQL server workload and system resource consumptionIn essence, we check how much each query, application etc. require from our different resources. We can check by groups, resources and so on.We can then decide how to limit the use of the resource.
Dynamic Management Objects:Querying DMVs to check query statistics, usage of buffers, partitions, indexes.All the data we get is from the last time we...
November 29, 2010
This is a live post from the session of Henk van der Valk at Tech Ed Israel 2010 .
This session has great tips and tricks for you in SSIS and is in English (just in case you're reading this blog and don't understand Hebrew :))
Checking for problems when test loading data:Select * from sys.dm_os_wait_stats Number 1 wait: pageiolatch_upSolution: add more spindles
So - just add more hardware?Number 2 pagelatch_upSolution: add more database files
Configure 1 to 4 files per filegroup to get 200+ KB writes IOs.
Use Soft Numa - assign a specific port for it
Use money data type instead...
This is a live post from the session of Asaf Bar and Erez Avital at Tech Ed Israel 2010 .
SharePoint 2010 enables us getting a BI solution with a workflow, social computing and an office integrated solution.
Tools for BI in SharePoint 2010:PerformancePoint (is the main tool for BI in SharePoint)Excel ServicesPowerPivotVisio ServicesSQL Reporting Services
We can use Lync to connect to the employees in the workplace directly from the SharePoint Dashboard.
We can add a comment to the values in the scorecard to communicate with each other.
Dashboard Designer in SharePoint 2010 opens as a click once application.
We can create different...
This is a live post from the session of Ronen Chen at Tech Ed Israel 2010 .
New to report builder 3.0 - we can be in local mode or server mode. We can check it in relation to performance on the server and save in directly on the server (rather than on my PC).
Zooming and moving my map is only possible during the design of the report. We cannot zoom in on it after running the report. A zoom in is possible through an action in the report which will create the zoom in a new report.
November 13, 2010
Don't know if you're aware of it, but Microsoft just rocked your world!
I remember interviewing Mr. Ariel Netz, Product Unit Manager for SSRS. I wanted to hear from him what's planned for Report Builder 1.0 as I didn't feel like Report Builder 3.0 covered all the functionality that was in 1.0. I also wondered what sort of answer we will get for ad - hoc reporting against SSAS in SSRS. Mr. Netz said as much as he could I guess, as things were still under NDA. And now the future of Reporting Services is here...
Project Crescent was just presented...
November 11, 2010
Well actually, I'm sure Tech Ed is ready. After all, they've been working on it in Microsoft Israel for so long... :)
I opened my email one day, about a week ago, and looked at a few mails. Going back into the inbox, I saw it. I couldn't help but let out a little yell. "What happened?" my boss turned to me, (I guess it was a little yell, though strong enough to hear). With my hand still over my mouth, all I could do was point at my PC screen. He came over to look at the title of...