CDC for Oracle in SQL Server 2012

יום שישי, יוני 21, 2013

One of the new features introduced in SQL Server 2012 is the ability to use SQL Server CDC for tracking changes on an Oracle table. In the following post you will understand how to setup such a service for tracking changes on your Oracle tables.Configuring your Oracle serverBefore creating the service, you must ensure that the following configuration steps have been performed on your source Oracle database:1. The database is set to ARCHIVELOG and is OPEN2. The user that is going to connect to the Oracle database has DBA privileges on the database (since you will look up the...
תגיות: , , ,
אין תגובות

SSAS distinct count wrong results

יום שישי, יוני 14, 2013

I have added a connect item today.please vote for it: https://connect.microsoft.com/SQLServer/feedback/details/790216/ssas-distinct-count-wrong-results Issue:ssas distinct count results wrong number.While querying the table as follow: SELECT count (distinct USER_ID ) FROM Table I get this results -- 1033612while querying SSAS I get 257.sample data for USER_ID:42348-3648-1368306010878-D41D8CD98F00B204E9800998ECF8427E42348-3648-1368074987484-B26463A0EE1A5F27718A14533D020E6042348-3648-1368011144064-65DD703A82FFA13A98305295317C86AD42348-3648-1368049679418-D41D8CD98F00B204E9800998ECF8427EI have also tried to convert this Varchar(100) into checksum()sample data -235875173535581043287814888-1894147417still getting same results.the measure is located in stand alone measure group. and configured with default settings.Solution: No Solution so far.
אין תגובות

"GeoFlow" for Excel 2013

יום שישי, יוני 7, 2013

 Project codename “GeoFlow” Preview for Excel 2013 allows you to plot geographic and temporal data visually, analyze that data in 3D, and create interactive tours to share with others. This preview gives you an early look into the new features that provide 3D data visualization for Excel and a powerful method for people to look at information in new ways, enabling discoveries in data that might never be seen in traditional 2D tables and charts.download it from here->
תגיות: , ,
תגובה אחת

Whats New in SSIS 2012 (SP1)–מה חדש ב

יום שני, ינואר 28, 2013

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

Microsoft® SQL Server® 2012 PowerPivot for Microsoft® Excel® 2010

יום שני, נובמבר 12, 2012

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 data with incredible speed into meaningful information to get the answers you need in seconds. You can effortlessly share your findings with others. You can: Process large data...
תגיות: , , ,
תגובה אחת

Microsoft® SQL Server® 2012 SP1 Data Mining Add-ins for Microsoft® Office®

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 this add-in, you can create, test, explore, and manage data mining models within Excel using either your spreadsheet data or external...
תגיות: , , ,
תגובה אחת

SQL Server Data Tools – November 2012 is now available!

יום חמישי, נובמבר 8, 2012

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 information about your current SSDT installation and verify that it's up to date by selecting "Check for Updates…" under the top-level SQL menu in Visual Studio. Check...
תגיות: , , , ,
אין תגובות

SQL Server 2012-RTM demo

יום שבת, אוקטובר 20, 2012

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 loadedThis image also includes demos of the RTM version of AutoSales, TailspinToys, Contoso Energy, Telco (PowerPivot and Power View), Contoso Schools and the Telco demo. You can  download the Virtual...
תגיות: , , ,
אין תגובות

Microsoft SQL Server 2012 SP1 Feature Pack

יום חמישי, אוקטובר 11, 2012

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 CTP4Add-on providers for Microsoft® SQL Server® 2012 SP1 CTP4It can be download here.
תגיות: , , , ,
אין תגובות

Linked Cubes

יום שבת, ספטמבר 8, 2012

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 server contains the source cube upon which...
אין תגובות