להרשמה לאירוע ולהבטחת מקום החנייה, אנא הרשמו באתר הרשמי:

https://msevents.microsoft.com/cui/EventDetail.aspx?EventID=1032487626&culture=he-IL

• Read more
• No comments

Microsoft Windows Server 2003 -> 2008 R2 offer the capability of tracing detailed Kerberos events through the event log mechanism. You can use this information when you troubleshoot Kerberos. This article describes how to enable Kerberos event logging.
before doing anything, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:

322756 (http://support.microsoft.com/kb/322756/ ) How to back up and restore the registry in Windows

Enabling Kerberos Event Logging on a Specific Computer

1. Start Registry Editor.
2. Add the following registry value:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\Kerberos\Parameters

Registry Value: LogLevel
Value Type: REG_DWORD
Value Data: 0x1
If the Parameters subkey does not exist, create it.
Remove this registry value when it is no longer needed so that performance is not degraded on the computer. Also, you can remove this registry value to disable Kerberos event logging on a specific computer.

1. Quit Registry Editor. The setting will become effective immediately on Windows Server 2008, on Windows Vista, on Windows Server 2003, and on Windows XP. For Windows 2000, you must restart the computer.

You can find any Kerberos-related events in the system log.

המידע שקיבלת במסגרת פוסט זה הינו מידע כללי בלבד ואין לראות ו\או להסתמך על מידע כאמור כייעוץ ו\או תחליף לייעוץ מכל סוג שהוא ו\או להסתמך עליו לעניין כלשהוא.

• Read more
• No comments

ישר מטקאד צפון אמריקה שמתקיים באטלנטה השבוע ממש:

צוות הפיתוח מפרסם פרטים ראשונים על דנאלי:

קראו כאן:

• Read more
• No comments

 

 

אני שמח להזמינכם למפגש ה -22 של קהילת ה - BI ,

המפגש יתקיים בתאריך ה - 25/05/2011 בשעה 17:30.

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

בתוכנית הפעם -> SQL BI High availability

17:30 - 18:00 התכנסות

18:00 - 19:00 רפליקציות BI  למסדי נתונים  (Part 1)

• 1. הסבר על משמעות Down-Time.
• 2. הסבר על מוצר Double-Take Availability עם מנגנון הגנה לשרתי SQL.
• 3. אינטגרציה ל Hyper-v.
• 4. אינטגרציה ל Cluster SQL.

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

19:15 - 20:15 רפליקציות BI  למסדי נתונים  (Part 2)

• 5. הסבר על Double-Take Share כמנגנון רפליקציה דו כיוונית בין מסדי נתונים מפלטפורמות שונות.
• 6. יתרונות Double-Take Share כמנגנון Active Active ל SQL.
• 7. שיטות מיגרציה ב Real Time מכול מערכת ל SQL עם Double-Take Share.
• 8. הסבר על B.I. Centralized reporting from multiple DB to SQL

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

בנוסף רצינו לעדכנכם שתוכלו להתעדכן גם ב-FACEBOOK בכל הקשור לפעילות הקבוצה, הרצאות מתוכננות, תמונות ומצגות מאירועים קודמים ועוד ועוד.

חפשו אותנו בFACEBOOK Israel BI UserGroup

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

 

• Read more
• No comments

If you looked into BIDS elper documentation, you can see the new features. One of them I chose to write today is the Biml file.

The Biml Package Generator provides the ability to create packages from Business Intelligence Markup Language (Biml). Biml is an XML-based language that allows you to describe your BI solution in a declarative fashion, similarly to using HTML to describe how a web page should appear. In addition, you can embed BimlScript (C# or VB.NET code) into Biml, in the same way that ASP.NET works with HTML. This allows for large numbers of packages to be created with a minimal amount of code.

To add a Biml file to the project, right-click on the project, or on the Data Sources, Data Source Views, or SSIS Packages folders. The context menu will have an Add New Biml File menu opton. This will add a Biml file to the Miscellaneous folder in the project.


Opening the Biml file will launch Visual Studio's XML editor, with Intellisense for the Biml language. If Intellisense is not working, see Manually Configuring Biml Package Generator. To learn more about the Biml language, right-click on the .biml file and choose Learn More About Biml from the context menu.


Here's a simple example of Biml code to create a package that contains a data flow:

<Biml xmlns="http://schemas.varigence.com/biml.xsd">
    <Packages>
        <Package Name="MyTestPackage" ConstraintMode="Linear" AutoCreateConfigurationsType="None">
            <Tasks>
                <ETL Name="My Data Flow">
                </ETL>
            </Tasks>
        </Package>
    </Packages>
</Biml>

After adding Biml code to a file, it can be checked for errors by choosing the Check Biml for Errors option from the context menu.


A Biml file can be expanded into one or more SSIS packages by choosing Expand Biml File from the menu. Expanding a file will automatically run an error check.


If the Biml file was expanded successfully, it will be added to the SSIS Packages folder in the project.


The Biml Package Generator is a plugin that leverages the Biml compiler from Varigence. This version of the Biml compiler has been provided free of charge for BIDS Helper users

Enjoy it!

Ronen

• Read more
• No comments

The CTP (aka beta) of SQL Server 2008 R2 Service Pack 1 is out & available. Go here for details and to download. Microsoft’s community techology preview program is our way of releasing betas to the community for you to test out, try out and provide feedback as part of the release process. This is not a production-ready release and so do not use this yet on any production SQL Server 2008 R2 databases yet. But please do download it and give us your feedback on your development and test boxes.

The SP1 for 2008 R2 is essentially CU 1 – 6, so this is good news for those who have waited for an SP instead of actively loading each cumulative update. You will also get a few new features which are listed for you in the product page blog link I listed above. Some of the things that I noticed are new in-place upgrade methods for Data-Tier Application packs and the ability to control Disk Cache for PowerPivot.

Have Fun!

Ronen

• Read more
• No comments

Please see below information that may help you to get started. It is part of the SQL 2008 R2 feature pack

Microsoft® Connector 1.1 for SAP BW for SQL Server® 2008 R2

The Microsoft Connector for SAP BW is a set of managed components for transferring data to or from an SAP NetWeaver BW version 7.0 system. The component is designed to be used with the Enterprise and Developer editions of SQL Server 2008 R2 Integration Services. To install the component, run the platform-specific installer for x86, x64, or Itanium computers respectively. For more information see the Readme and the installation topic in the Help file.

Audience(s): Partner, Developer

X86 Package(SapBI.msi)
X64 Package (SAPBI.msi)
IA64 Package(SAPBI.msi)

 

 

• Read more
• No comments

Pyramid Analytics presents “bioXL for PowerPivot” which allows users to benefit from the flexibility and speed of PowerPivot without the deployment headaches posed above when the solution is shared across the workgroup.

As of version 3.0, bioXL for PowerPivot provides:

• Easy, web-based connections to the SharePoint hosted PowerPivot cubes without requiring the cube and associated data to be downloaded to the desktop
• Web based, reporting content written around the PowerPivot cubes that can be easily shared across the enterprise.
• All of the ad-hoc analytics power of bioXL against the PowerPivot cubes from the convenience of a web-deployed client
• Microsoft SharePoint integration

The resulting BI solution offers an ideal toolset to scale the power of “instant analytics” to the needs of an enterprise

• Read more
• No comments

http://www.pyramidanalytics.com/

Pyramid sees strategic relationship with Microsoft key to successfully reaching its target market: enterprise customers requiring enhanced analytic functionality from their Microsoft SQL Server-based BI systems.

Tel Aviv, Israel, May 3, 2011: Pyramid Analytics today announced that it has been selected to join the Microsoft BizSpark One program. Pyramid Analytics provides a web-based Online Analytics Processing (OLAP) viewer that allows business users to fully exploit the rich functionality of Microsoft SQL Server Analysis Server. Operating either as a standalone analytic toolset, or integrated into Microsoft SharePoint 2010, Pyramid provides a complete ad-hoc analytics interface that is both intuitive and powerful, and delivers query performance comparable to best of breed desktop software.

“Given our interoperability with the Microsoft BI tools, we are truly excited to have been invited to join the very dynamic Microsoft BizSpark One program” said Omri Kohl, CEO of Pyramid Analytics. “We strongly believe that Microsoft’s mentorship will further accelerate our sales of Pyramid Analytics solutions to corporations wishing to give their business users more raw analytic power to extract specific, real, and imminently usable information from their investments in SQL Server Analysis Services BI.”

In November 2008, the Microsoft BizSpark program was launched as a global program offering software, support and visibility to early stage startups. Microsoft BizSpark One is the latest expansion of the program. This unique invitation-only program is designed to help accelerate the growth of selected high potential startups through a one-to-one relationship with Microsoft and a global community of advisors, investors, and peers.

“We are pleased to welcome Pyramid Analytics to the BizSpark One Program and believe that their powerful analytics yet familiar and intuitive interface will encourage adoption of BI and will prove to be a valuable offering to our mutual customer” said Matthew Clark, Senior Director of the Emerging Business Team at Microsoft Corp.

With BizSpark One, Microsoft is committed to serving as a valuable technology and business partner for emerging startups and their investors. The program pairs each startup with a dedicated relationship manager at Microsoft who works with the startup to identify its unique opportunities and build a tailored plan to promote the startup’s visibility, expand its network of investors and mentors, expose it to business opportunities, and develop cutting-edge applications.

About Pyramid Analytics:

Pyramid Analytics produces Business Intelligence (BI) tools that render enterprise BI intuitive to the business user. Custom designed for the market leading BI products – Microsoft SQL Server and Analysis Services – Pyramid’s interface has both the familiarity and the seamless integration of an Office productivity suite, yet provides powerful analytic capabilities. The first module, bioXL, is a web-based OLAP viewer for Analysis Services cubes, giving users access to some 90% of Analysis Services’ functionality to easily navigate and explore enterprise data stores. Built from the ground up as a 64bit thin client, Pyramid’s BI tools are designed to handle very large datasets, and can be promptly deployed to 100s and 1000s of users, and finally making enterprise BI truly cloud compatible.

• Read more
• No comments

Hi All,

while looking for a pro

per deployment tool, I run into this project:

The PerformancePoint 2010 Content Deployment Tool is a command-line tool that allows you to deploy PerformancePoint content using an existing ddwx file and can be used to migrate content from development to production or between site collections on the same SharePoint server.
The tool allows you to:

• Re-map list locations - you can deploy content from one site to another site by specifying the new list location to deploy the content to

• Automatically deploy dashboards - by default, dashboards are automatically deployed to the previous path and master page

• Update server names and a ton of other properties - you can update the server name (and other properties) of data sources, reports, and dashboards to update them from development values to production values without manual steps

Enjoy it!

• Read more
• No comments