May 28, 2009
I’ve received this email from PASS Community
Dear SQL Professional,
Why move all the data when you can just move the changes?
What’s the point purchasing expensive ETL software when you already have SQL Server?
Learn about Attunity Oracle-CDC for SSIS, a complete and affordable solution for integrating continually changing Oracle data using wizards built into SQL Server Integration Services, leveraging best-of-breed CDC technology that identifies, captures, and delivers only the changes made to your Oracle data.
Leverage your SQL Server skills and software to reduce cost and accelerate Oracle data replication, synchronization, and real-time integration and enable operational reporting, business intelligence and data warehousing projects.
Join a free webinar and demonstration to learn about:
- Log-based CDC technology for Oracle
- Using SSIS for real-time and efficient Oracle data integration
- A simple and affordable solution you can implement in days
Date: Wednesday, June 3, 2009
Time: 2:00pm – 3:00pm EDT
May 27, 2009
Microsoft® SQL Server® Project code-named “Madison” is a highly scalable data warehouse appliance that delivers performance at low cost through a massively parallel processing (MPP).
- Data warehouse scalability into the petabyte range
- Low cost of ownership through industry standard hardware
- Appliance model simplifies deployment and maintenance
- Integrates with existing SQL Server 2008 data warehouses via hub-and-spoke architecture
- Greater ROI from BI investments through integration with SQL Server 2008
- Reduced risk through use of redundant, industry standard hardware
- Balanced reference architectures deliver predictable performance
- Better agility and business alignment through hub and spoke architecture
More on: http://www.microsoft.com/sqlserver/2008/en/us/madison.aspx
May 16, 2009
Reporting and Business Intelligence in Microsoft Dynamics AX 2009
FREE From Microsoft E-Learning
About this Course
This two-day instructor-led course provides students with the knowledge and skills to leverage the extended Reporting and Business Intelligence (RBI) features of Microsoft Dynamics AX 2009. The training course covers installation of pre-requisites and supporting technology, creating and deploying reports using SQL Server Reporting Services, creating, adjusting and deploying business intelligence projects using SQL Server Analysis Services, and integrating all these features together in the Rich client, Enterprise Portal or Role Centers, for the end-user.
The course is intended for developers or those individuals who will be creating and deploying reports and business intelligence projects.
At Course Completion
After completing this course, students will be able to:
– Differentiate between Microsoft Dynamics AX 2009 reporting features, SQL Server Reporting Services and SQL Server Analysis Services.
– Appreciate the benefits of leveraging SQL Server Reporting Services and SQL Server Analysis Services with Microsoft Dynamics AX 2009.
– Explain what the Role Center in Microsoft Dynamics AX 2009 is used for.
– List the system requirements for Reporting and Business Intelligence for Microsoft Dynamics AX 2009.
– Step through the procedures for installing SQL Server Reporting Services and the integration components for Microsoft Dynamics AX 2009.
– Design reports in Report Builder and Visual Studio using Microsoft Dynamics AX 2009 data sources.
– Integrate SQL Server Reports with Microsoft Dynamics AX 2009 Client, Enterprise Portal and Role Centers.
– Step through the procedures for installing SQL Server Analysis Services and the integration components for Microsoft Dynamics AX 2009.
– Become familiar with SQL Server Business Intelligence Studio.
– Navigate the multi-dimensional space of OLAP cubes.
– Import cubes from Microsoft Dynamics AX 2009.
– Fix broken cubes.
– Create new cubes from Microsoft Dynamics AX 2009.
– Deploy and process cubes.
– Read and write MDX expressions in KPIs.
– Step through the procedures for installing Role Centers for Microsoft Dynamics AX 2009.
– Modify existing Role Centers.
– Create new Role Centers.
To add this course to your Microsoft learning or start it right now; here you’re: http://www.microsoft.com/learning/en/us/syllabi/50195A.aspx
May 16, 2009
First to be honest I don’t remember who gave me this link or where I got it from, but once I remember I’ll update this post.
SQL Server 2008 Training Kit: http://download.microsoft.com/download/9/1/1/911EC8F9-4407-42F0-A7EE-335BA0E61F50/SQL2008TrainingKit.Setup.20090505.exe
What’s its goal:
The goal of the SQL Server 2008 Developer Training Kit is to provide information about new features in SQL Server 2008. Its primary audience is solution architects and developers already familiar with SQL Server who want to learn about new functionality available in this release. The content focuses on development aspects and illustrates how to design more effective database applications that take advantage of improved capabilities in SQL Server 2008.
The material is organized into several feature areas:
- Spatial Support provides an overview of the new spatial data types that allow for the creation, comparison, analysis, and retrieval of spatial data.
- FILESTREAM describes how SQL Server 2008 enables the storage of binary large object (BLOB) data as files on the file system in a manner that ensures transactional consistency with the database.
- CLR introduces the common language runtime integration feature and describes new support for nullable types and additional .NET Framework libraries supported in SQL Server 2008.
- Reporting Services highlights enhancements to SQL Server Reporting Services including the new Report Builder 2.0 authoring tool.
- Date and Time introduces the new ANSI standard compatible data types that provide increased range and accuracy.
- T-SQL shows several new language enhancements including table-valued parameters, row constructors, grouping sets, and the MERGE statement.
Within each feature area, you will find presentations, demo scripts, and hands-on labs that will help you understand important aspects of each feature.
In the training kit, you will find the AdventureWorks Racing Community application. This sample application highlights some of the new functionality introduced in SQL Server 2008.
May 10, 2009
This website is designed for the developers and administrators who work with Microsoft SQL Server Analysis Services (SSAS) 2005 or 2008. Here you will be able to find latest news, MDX FAQs, OLAP design FAQs, links to articles, BI blogs, webcasts, forums, job postings, products and any other information that is related to SSAS.
Personally, I recommend every BI Developer to follow up this portal http://www.ssas-info.com/
May 6, 2009
What is Microsoft’s Gemini?
Gemini is essentially an add-in to Excel that allows very large sets of data to be manipulated. Why Excel? Simply because it’s a familiar environment for most people and the place where they expect to perform analysis.
But there’s more. Not only can Gemini handle very large sets of data, but it can also allow data from disparate sources to be cross analyzed. So, for instance, you might pull in some data from your data warehouse and cross-correlate it with data from the Internet or with data you already hold in Excel.
Let’s face it — Excel doesn’t have a great track record of being able to handle big sets of data. So Microsoft has added a new in-memory column store to handle the data. Can Gemini? Well, the demo I watched was run on a desktop with 8 GB RAM and a quad processor, and costs just less than $1,000. It was handling 100 million rows of data effectively instantaneously. So, I’d take that as a yes.
Read the rest of this entry »