Browse by Tags

Whats New in SSIS 2012 (SP1)–מה חדש ב
28 January 13 10:30 AM | Ronen Chenn | 1 comment(s)

גרסת SQL 2012 חושפת בפנינו יכולות חדשות אשר מחזקות את מעמדה בשוק בסיסי הנתונים ככלל וה bi בפרט . לקראת השתתפותי במספר כנסים בשנה הקרובה במערב אירופה וצפון אמריקה, אני שמח לשתף אתכם בתובנות שהועלו עד כה ב SolidBI.com . במאמר זה, אתייחס ל integration services בגרסת sql2012 sp1. למידע נוסף, הגדרות ארכיטקטורה, שיפורי ביצועים ו -best practices , הנכם מוזמנים ליצור קשר ב noya@solidbi.com או alberto@solidbi.com או דרך האתר שלנו ב http://www.solidbi.com אז מה חדש בגרסת ssis 2012? הפצת נתונים deployment ניהול...

תגים:ITPRO, DEV, TECH, SSIS 2012, מה חדש ב SSIS 2012

Microsoft® SQL Server® 2012 PowerPivot for Microsoft® Excel® 2010
12 November 12 07:30 PM | Ronen Chenn | with no comments

Microsoft PowerPivot for Microsoft Excel 2010 provides ground-breaking technology, such as fast manipulation of large data sets (often millions of rows), streamlined integration of data, and the ability to effortlessly share your analysis through Microsoft SharePoint 2010. Microsoft PowerPivot for Microsoft Excel 2010 is a data analysis tool that delivers unmatched computational power directly within the software users already know and love — Microsoft Excel. You can transform mass quantities of...

תגים:ITPRO, DEV, TECH, SolidBI.com

Microsoft® SQL Server® 2012 SP1 Data Mining Add-ins for Microsoft® Office®
12 November 12 07:21 PM | Ronen Chenn | 1 comment(s)

Microsoft SQL Server 2012 SP1 Data Mining Add-ins for Microsoft Office helps you take advantage of SQL Server predictive analytics in Office Excel and Office Visio. The download includes the following components: Table Analysis Tools for Excel: This add-in provides easy-to-use tasks that leverage SQL Server 2012 data mining models within Excel using either your spreadsheet data or external data accessible through your SQL Server 2012 Analysis Services instance. Data Mining Client for Excel: By using...

תגים:ITPRO, DEV, TECH, DataMining

SQL Server Data Tools - November 2012 is now available!
08 November 12 04:55 PM | Ronen Chenn | with no comments

Get it here SSDT for Visual Studio 2012: http://msdn.microsoft.com/en-us/jj650015 SSDT for Visual Studio 2010: http://msdn.microsoft.com/en-us/jj650014 What's new? Selective XML Index support We've added support for selective XML indexes , enabling users to import, edit, add, refactor, build, and publish selective XML indexes in SSDT. Add new selective XML index in Table Designer Check for SSDT Updates This release adds support for automatic and manual checks for SSDT updates. You can view...

תגים:ITPRO, DEV, TECH, SolidBI.com, SolidBI

SQL Server 2012-RTM demo
20 October 12 03:00 PM | Ronen Chenn | with no comments

The new SQL Server 2012-RTM demo is fully integrated with SQL Server 2012, SharePoint 2010 and Office 2010 including: PowerPivot and MDS Excel integration Reporting Services integration with SharePoint Power View integrated with SharePoint Data Quality Services Master Data Services Multidimensional and Tabular instances of SQL Server 2012 Analysis Services Visual Studio 2010 Silverlight 5 Picnic Power View sample loaded This image also includes demos of the RTM version of AutoSales, TailspinToys...

תגים:ITPRO, DEV, TECH, SolidBI.com

Microsoft SQL Server 2012 SP1 Feature Pack
11 October 12 08:43 AM | Ronen Chenn | with no comments

The Microsoft® SQL Server® 2012 SP1 Feature Pack CTP4 is a collection of stand-alone packages which provide additional value for Microsoft® SQL Server® 2012. The packages provided include the latest versions of: Redistributable components for Microsoft® SQL Server® 2012 SP1 CTP4 Add-on providers for Microsoft® SQL Server® 2012 SP1 CTP4 It can be download here .

תגים:ITPRO, DEV, TECH, 2012 SP1, ctp4

Linked Cubes
08 September 12 08:29 PM | Ronen Chenn | with no comments

This is something I used to use in SQLR2 to solve the perspective security challenge. What is it? A linked cube is an MDStore cube object with a Subclass Type of sbclsLinked. The contents of a linked cube are based on another cube that is defined and stored on a different Analysis server. Unlike a virtual cube, which can contain portions of one or more cubes, a linked cube references the entire contents of a single cube. A subscribing server is an Analysis server that contains a linked cube. A publishing...

תגים:ITPRO, DEV, TECH, SQL 2012, Linked Cubes

BI User Group Meeting #33 (13.09.2012)
06 September 12 08:35 AM | Ronen Chenn | with no comments

מפגש ה – BI הקרוב יתקיים ביום חמישי- 13.09.2012 במשרדי מיקרוסופט רעננה, אולם דקל. מצורף לו"ז לקראת המפגש. להרשמה והבטחת מקום חניה, יש להירשם באתר : http://biug33.eventbrite.com/ לו"ז ל Bi User Group Meeting #33 (13.09.2012) 17:30 התכנסות והרמת כוסית לראש השנה הממשמש ובא :-) 18:00 Excel 2013, כלי ה-BI הטוב ביותר. תחזיקו חזק-> ממריאים. המרצה- מר דני חוטר, Senior Program Manager at Microsoft ILDC (Israel R&D) 19:15 הפסקה 19:30 המשך 20:00 שאלות ותשובות

תגים:ITPRO, DEV, TECH, Ronen chenn, EXCEL 2013

עדכון מפגשי יולי ואוגוסט
23 July 12 08:15 AM | Ronen Chenn | with no comments

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

תגים:DEV, TECH

The advantages in deploying a model using DirectQuery mode
16 July 12 09:46 PM | Ronen Chenn | 1 comment(s)

There are many advantages to deploying a model using DirectQuery mode: It is possible to have a model over data sets that are too large to fit in memory on the Analysis Services server. The data is guaranteed to be up-to-date, and there is no extra management overhead of having to maintain a separate copy of the data. Changes to the underlying source data can be immediately reflected in queries against the data model. DirectQuery can take advantage of provider-side query acceleration, such as that...

תגים:ITPRO, DEV, TECH

Tabular Models with DirectQuery Mode
16 July 12 09:43 PM | Ronen Chenn | 1 comment(s)

Tabular models are authored by using the model designer SQL Server Data Tools (SSDT). The model designer creates all models in memory, which means that when you are modeling, if your data is too large to fit into memory, you should import only a subset of data into the cache used by the workspace database. When you are ready to switch to DirectQuery mode, you can change a property that enables DirectQuery mode. For more information, see Enable DirectQuery Design Mode (SSAS Tabular) . When you do...

תגים:DEV, TECH, SQL 2012, InMemory, In Memory, Tabular mode, TPRO

SSAS Tabular Impersonation (Sql2012)
08 July 12 09:42 AM | Ronen Chenn | with no comments

Impersonation is the ability of a server application, such as Analysis Services, to assume the identity of a client application. Analysis Services runs using a service account, however, when the server establishes a connection to a data source, it uses impersonation so that access checks for data import and processing can be performed. Credentials used for impersonation are different from the credentials of the user currently logged on. Logged on user credentials are used for particular client side...

תגים:ITPRO, DEV, TECH, SQL2012, Impersonation, Tabular

Tabular AMO 2012
23 June 12 11:07 AM | Ronen Chenn | with no comments

Great news on codeplex. it is very good to know that people are working hard to share their knowledge with the community. Tons of credits to JuanPablo Jofre! Tabular AMO 2012 is about creating and managing tabular models using the AMO api. It is a developer’s sample, for those interested in managing Analysis Services. The sample is made of two project parts. The first part is a library of functions to manage tabular models -AMO2Tabular V2-. The second part is a sample to build a tabular model -AdventureWorks...

תגים:ITPRO, DEV, TECH

Microsoft® SQL Server® 2012 Master Data Services Add-in For Microsoft® Excel®
23 June 12 11:02 AM | Ronen Chenn | with no comments

The Master Data Services Add-in for Excel gives multiple users the ability to update master data in a familiar tool without compromising the data’s integrity in MDS. From within the Add-in, users can publish data to the MDS database with the click of a button. Administrators can use the Add-in to create new model objects and load data without ever launching any administrative tools, helping to speed deployment. With the Master Data Services Add-in for Excel, all master data remains centrally managed...

תגים:ITPRO, DEV, TECH

Microsoft® SQL Server Integration Services Balanced Data Distributor For Microsoft® SQL Server® 2012
23 June 12 10:59 AM | Ronen Chenn | with no comments

Microsoft® SSIS Balanced Data Distributor (BDD) is a new SSIS transform. This transform takes a single input and distributes the incoming rows to one or more outputs uniformly via multithreading. The transform takes one pipeline buffer worth of rows at a time and moves it to the next output in a round robin fashion. It’s balanced and synchronous so if one of the downstream transforms or destinations is slower than the others, the rest of the pipeline will stall so this transform works best if all...

תגים:ITPRO, DEV, TECH