What's New in SQL Server Integration Services 11 CTP1

יום שלישי, נובמבר 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...
3 comments

Troubleshooting with the Microsoft 2008 R2 Tools

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...

Loading 1TB in 10 Minutes in SSIS – SQL Server Scalability on high end hardware

יום שני, נובמבר 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...
2 comments

Advanced Dashboard Creation with SharePoint 2010

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...
no comments

Building Effective data visualizations in Reporting Services 2008 R2

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. Avoid...

Tech – Ed 2010 in Eilat, are you ready?

יום חמישי, נובמבר 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...
2 comments