Microsoft and JB invites you to a level 400 event.

it is a true SQL Extreme.

it will take place at 4-5 July at Daniel Hotel Herzelia.

I will be a guest speaker at Itays Brown session of Analysis Services.

Full Details can be found here.

If some of you whishes to get a 10% discount, please contact me, I will take care of it.

looking forwards to see you all there!

Ronen

• Read more
• No comments

פורום מעולה לשאלות על התשתית בעברית:

http://social.msdn.microsoft.com/Forums/he-IL/sqlhe/threads

• Read more
• No comments

היי חברים,

ביום שלישי 5.7.2011 אני מתארח באירוע SQL&BI 2011.

אני מתוכנן להציג את הטכנולוגיות החדשות ביותר שנועדו להעשיר את סביבות המשתמשים בפלטפורמת ה -SSAS של מיקרוסופט.

אני מכין לנו DEMO ייחודי שייתן לנו תפיסה רחבה על כיצד אני רואה את הפתרון.

אשמח לראותכם באירוע ולשתף אתכם על כוס קפה ונוף הים, בכיוונים החדשים כפי שאני נחשף אליהם.

נתראה שם, רונן.

• Read more
• No comments

רציתי ליידע אתכם לגבי כנס SQL Explore.

זה הכנס הטוב ביותר בארץ מבחינת עומק התכנים המקצועיים לאנשי בינה עסקית. בכנס יש את המרצים הטובים ביותר חשיפה טכנולוגית לגרסה הבאה של SQL Server..

גם אני אהיה שם ואשמח לפגוש אתכם.

הנה לינק לדף האירוע:  http://www.microsoft.com/israel/sql-explore/

• Read more
• No comments

My friends, soon we all should start to prepare to the “ADFS time”.

ADFS = my company  Microsoft is a partner with Pyramid.  Pyramid employees need access to one of my applications, so we create a federated trust between my application and their user store, so they can log into my application using their internal Active Directory.

So how will it affect us? read the follows:

Understanding what Windows Identity Foundation and ADFS v2 will do is very important. In order to take claims based identity from an idea to a reality means that there are some elements that have to be present. First, the STS must be in place so that tokens can be received. Developers need to have claims aware applications that are able to receive those tokens and use the claims within them. It doesn’t make sense though for all of the developers out there to have to write new code. Instead what will work is a basic and standardized approach to be used for all of them. The difference here though is that the AD FS v2 is in place as an STS. CardSpace is the identity selector. The application itself, SharePoint, is using Windows Identity Foundation. We are going to cover these three types of technology in much more detail later on. Yet it is a good idea to familiarize yourself with them at this point.

AD FS v2 offers support for browsers as well as for clients, encouraging both the WS Federation and the SAML 2.0 protocol. This means it can cover a wide range of different environments and it can be used by just about every identity provider. It won’t matter if it is internal for a business, external on the cloud, or for both of them. It is important to take note that with claims based identity you won’t have to use AD FS v2 as a requirement, it is optional. The STS can come from any vendor including one that you build and operate yourself.

However, the goal of Microsoft is to offer AD FS v2 as a way to get an STS built on AD DS that has all the features you will need.

You may have heard of CardSpace from Microsoft previously, and this is the updated version of it. You will be happy to hear that this particular identity selector is able to be used with a variety of web browsers. It definitely is compliant with the two major ones – Internet Explorer and Firefox. There must be an STS in place for claims based identity to work. However, it can work effectively without any identity selector in place. The problem though is that if you don’t have CardSpace in place or something comparable to it then there is no way for the application to know which identity that you want to use. Based upon that information it just makes good sense that you have an identity selector in place when you are talking about claims based identity. The card will be associated with a given identity as well as a particular provider. When you click on a given card, CardSpace  is going to request a token for it from the provider. This is why a user may be asked for a password or other information that is used to authenticate the request. The software will then take those tokens and exchange them for claims. This is all going on behind the scenes. When you are talking about Windows applications, there is another element of claims-based identity that has to be present. This is the Windows Identity Foundation that I mentioned.

This offers a complete function library including getting a token, verifying who is requesting the token, accessing the claims of a token, and much more. Sometimes a AD FS v2 STS won’t be adequate and the Windows Identity Foundation can be leveraged offering additional support custom creation STS. AD FS v2 is actually built on the Windows Identity Foundation. This realization is important because it means the interactions that occur have to be standard in nature. AD FS v2 doesn’t need CardSpace and vice versa. Both of them can function without the use of the Windows Identity Foundation. This is because when CardSpace is looking at the AD FS v2 it will see an STS requesting tokens through the WS-Trust protocol.

• Read more
• No comments

מפגש קהילת ה- BI בנושא: 

CacheWarming הפתרון לשיפור ביצועים בקוביות .

למידע נוסף: http://blogs.microsoft.co.il/blogs/bilive/

נשמח לראותכם,

איתי בראון ורונן חן

סדר יום:

18:00 - 17:30  התכנסות וכיבוד קל

19:00 - 18:00  

CacheWarming הפתרון לשיפור ביצועים בקוביות .

אם תרצו אין זו אגדה הקוביות יכולות לטוס .

יש סיכוי שיקראו לכם קוסמים אחרי שתיישמו את הרעיון של חימום הקובייה . 

על הפרק:

• מה זהCacheWarming
• איך לעבוד עם Profiler על גבי הקוביות
• נלמד ונבחן את ביצועי הקובייה מתי הנתונים נקראים מ Cache , Partitions , Aggregations
• Demo להצגת פתרון ייחודי.

19:15 - 19:00  הפסקה וכיבוד קל 

20:15 - 19:15  המשך.

20:45 - 20:15   Q&A and Job Reference

על המרצה:

עופר אוחנה בעל 10 שנות ניסיון בתחום SQL Server

משמש כיום כמומחה BI וארכיטקט SQL Server בחברת MyThings 

מירב נסיונו רכש בחברת ICQ  שם הקים את אחד הפרויקטים הגדולים בארץ בתחום ה BI.

הסדרי חנייה:

למשתתפים רשומים:
החניה חינם, בחניון האורחים שמחוץ לבניין

למשתתפים לא רשומים:
בסמוך למשרדים, נמצא חניון כורכר בתשלום (בכיכר יש להמשיך ישר והחניון נמצא מימין).
עלות חנייה לשעה או חלק ממנה: 6 ש"ח. 
עלות חנייה ליום שלם: 15 ש"ח.

למגיעים בתחבורה ציבורית קווי אוטובוס: 

• מתל אביב (תחנה מרכזית) לצומת רעננה: קווים 501, 502, 567.
• מהרצליה (תחנה מרכזית) לצומת רעננה: קווים 501, 502.
• מירושלים (תחנה מרכזית) לצומת רעננה: קו 947.
• מפתח תקווה (תחנה מרכזית) לצומת רעננה: קווים 561, 921, 641, 551.
• מהוד השרון אל צומת רעננה: קווים 921, 551, 561, 641, 564.

• מנתניה (תחנה מרכזית) אל צומת רעננה: 947, 641.

• Read more
• No comments

Support for interactive report features varies by browser type. The following support matrix shows which browser types are supported on which platforms, subject to constraints noted in the Notes column.

1In standards mode, Internet Explorer 7.0 and 8.0 do not display slanted lines in reports. If you use slanted lines in your reports, set your ASP.NET page to run in quirks

• Read more
• 1 comment(s)

Reporting Services provides several Web Parts that work with specific versions of a report server and in particular deployment modes. If you want to access report server content on a SharePoint site from a native mode report server, use the SharePoint 2.0 Web Parts that are included with Reporting Services. Instructions for installing and using the 2.0 Web Parts are provided in this link:

The Report Viewer Web Part has the same name as a newer Report Viewer Web Part that is part of the Reporting Services Add-in, a SharePoint integration feature for Reporting Services report servers. Although it has the same name, it is a different Web Part that has a different schema and implementation. The Report Viewer Web Parts are not interchangeable despite having the same name. Visually, you can distinguish the two Web Parts through the following characteristic: the Report Viewer 3.0 Web Part that is installed through the add-in has an Actions menu on the toolbar

• Read more
• No comments

Today , I have encountered the following scenario:

• You have two computers that are running Windows Server 2008 or Windows Vista. One computer sends a Kerberos authentication message to the other computer.
• The Kerberos authentication uses the Advanced Encryption Standard (AES) algorithm to encrypt and decrypt the authentication data.

The patch can be found here : http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=969083&kbln=en-us

For more details, please follow http://support.microsoft.com/kb/969083

• Read more
• 1 comment(s)

To verify that the report server is installed and running

• Run the Reporting Services Configuration tool and connect to the report server instance you just installed. The Web Service URL page includes a link to the Report Server Web service. Click the link to verify you can access the server. If the report server database is not configured, do that first before clicking the link.

• Open the Services console applications and verify that the Report Server service is running. To view the status of the Report Server service, click Start, point to Control Panel, double-click Administrative Tools, and then double-click Services. When the list of services appears, scroll to Report Server (MSSQLSERVER). The status should be Started.

• Open a browser and type the report server URL in the address bar. The address consists of the server name and the virtual directory name that you specified for the report server during setup. By default, the report server virtual directory is named ReportServer. You can use the following URL to verify report server installation: http://<computer name>/ReportServer<_instance name>. The URL will be different if you installed the report server as a named instance. For more information about the URL format, see Configuring Report Server URLs. If you are a local administrator on Windows Vista or Windows Server 2008, see How to: Configure a Report Server for Local Administration on Windows Vista and Windows Server 2008 (UAC).

• Run reports to test report server operations. For this step, you can install and publish the sample reports if you do not have any reports available. For instructions on how to install sample databases, applications, and data files that are used in Reporting Services tutorials, see Initial Installation (Reporting Services) in SQL Server Books Online.

To verify that Report Manager is installed and running

• Open a browser and type the Report Manager URL in the address bar. The address consists of the server name and the virtual directory name that you specified for the Report Manager during setup or in the Report Manager URL page in the Reporting Services Configuration tool. By default, the Report Manager virtual directory is Reports. You can use the following URL to verify Report Manager installation: http://<computer name>/Reports<_instance name>.

• Use Report Manager to create a new folder or upload a file to test whether definitions are passed back to the report server database. If these operations are successful, the connection is functional.

To verify that Report Designer is installed and running

• Open Business Intelligence Development Studio, and create a new project based on a Report Server project type. For more information on using the Report Server Project Wizard, see How to: Add a New or Existing Report to a Report Project (SSRS) in SQL Server Books Online.

• If you installed report samples, open the sample report project files and publish the reports to a report server. For more information, see Publishing Models in SQL Server Books Online.

• Read more
• No comments

Data consumers, such as Visual Studio and SQL Server, use the Data Links dialog to configure connections to IBM DB2 database servers. Data Links can save a data source definition as an OLE DB universal data link (UDL) file, which allows the user to share configurations between applications, users, and computers.

You can create a data link by clicking the Data Access Tool shortcut in the Microsoft Host Integration Server 2010 program folder. You can then modify the UDL using the Data Links tool by opening the file from Windows Explorer, which loads the standard OLE DB Data Links user interface.

To start the Data Access tool, click the Data Access Tool shortcut in the Microsoft Host Integration Server 2010 program folder or click Start, Programs, Microsoft OLE DB Provider for DB2 and then Data Access Tool

Use the Connection tab to configure the basic properties required to connect to a data source. This section describes the properties that are specific to Microsoft OLE DB Provider for DB2 connections.

Data Source

Specify a string to describe the data source. When you create a data link file by using the Data Source Wizard, the Data Source property names the Universal Data Link (UDL) file or connection string file.

Network

The Data Provider supports TCP/IP and SNA (Systems Network Architecture) over LU6.2 APPC (Advanced Program to Program Communications) network connections to remote IBM DB2 database servers that are running on IBM mainframe and midrange host computers. The Data Provider supports TCP/IP network connections to remote IBM DB2 database servers that are running Linux, UNIX, or Windows operating systems.

You can select either APPC Connection or TCP/IP Connection from the drop-down list, when you connect to DB2 databases that are running on host mainframe DB2/MVS and host midrange DB2/400 computers.

You must select TCP/IP Connection from the drop-down list, when connecting to DB2 databases that are running Linux, UNIX, or Windows operating systems.

APPC Connection

If you select APPC Connection, click the ellipses (…) to open the dialog box for configuring APPC Network Settings.

You must select or enter the name of the APPC local LU alias, APPC remote LU alias, and APPC mode name configured in Host Integration Server. A common value for DB2/MVS is IBMRDB and DB2/400 is QPCSUPP. Optionally you can specify the APPC conversation security to identify the Data Provider user to the DB2 database server.

please find more details.

http://msdn.microsoft.com/en-us/library/gg164980%28BTS.70%29.aspx

• Read more
• No comments

---News alert--- Today 2/6/2011 the Analysis Services Operations Guide was published!

In this guide you will find information on how to test and run Microsoft SQL Server Analysis Services in SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2 in a production environment. The focus of this guide is how you can test, monitor, diagnose, and remove production issues on even the largest scaled cubes. This paper also provides guidance on how to configure the server for best possible performance.

link to download: http://msdn.microsoft.com/en-us/library/hh226085.aspx

• Read more
• 2 comment(s)