The Business Intelligence Blog

Slicing Business Dicing Intelligence

Archive for the ‘SQL Server’ tag

Microsoft names SQL Server 2012 launch date  

Microsoft’s SQL Server 2012 will be officially launched on 7 March. More from All about Microsoft.

Microsoft Server and Tools chief Satya Nadella revealed last fall that SQL Server 2012 (codenamed “Denali”) would launch in the early part of 2012. Microsoft delivered the final public test build of SQL Server 2012 in November 2011.

The March 7 launch event topic list includes everything from big data, to StreamInsight complex event processing, to the new data-visualization and analysis tools that are part of the SQL Server 2012 release.

Disclosure: I work at Microsoft.

The article has

one response

Written by Guru Kirthigavasan

January 24th, 2012 at 7:41 am

Microsoft Unveils Database Products at PASS Conference  

Microsoft released the first community technology preview (CTP) for the next-generation version of SQL Server, codenamed Denali, Nov. 9. But that is just one of several announcements to come out of the PASS Summit 2010 conference in Seattle this week. In addition to unveiling Denali, Microsoft also announced the release of SQL Server 2008 R2 Parallel Data Warehouse and the new Critical Advantage Program, which offers an end-to-end suite of pretested hardware and software configurations, services and support.

“SQL Server code-named Denali will help empower organizations to be more agile in today’s competitive market,” the SQL Server Team touted on its blog. “Customers will be able to efficiently deliver mission-critical solutions through a highly scalable and available platform. Industry-leading tools will help developers quickly build innovative applications while data integration and management tools help deliver credible data reliably to the right users and new user experiences expand the reach of BI to enable meaningful insights.”

More on EWeek

SQL Server 2008 – from semi-relational to sublime  

Microsoft has made much of the self-service Business Intelligence and integration with Office. In order to make best use of the BI features it is definitely worth upgrading to Office 2010, released to beta last week. A beta version is available for download here. Excel 2010 allows much better slicing and dicing of data, and through the SQL Server PowerPivot add-in for Excel that was known as Gemini, users can investigate data to reveal the information hidden therein.

The Report Builder is also much improved and looks much more like one of the Office 2010 family. It has become much easier to split out various components of a report: If you have a grid, a map and a logo in a report, these can be copied to a Report Part Gallery, effectively a library of elements that can be used time and time again.

A look at SQL Serrver 2008 R2 Preview.

The article has

one response

Written by Guru Kirthigavasan

November 21st, 2009 at 3:51 am

Companies Turn to BI Platform Consolidation  

The challenging economic climate has caused many organizations to take a closer look at their IT strategies in an effort to reduce costs while still maintaining quality. One particular emerging area that is being reevaluated because of its significant licensing, maintenance and specialized support cost is that of business intelligence platforms.

The release of Microsoft SQL Server 2008, with enhanced business intelligence features, has provided Innovative Architects, a Microsoft Gold Certified Partner located in Duluth, GA, with several clients ready to migrate from various competing platforms solely to SQL Server. Innovative Architects has developed proprietary conversion accelerators that provide software automation for converting from other competing point products to the Microsoft BI platform. Innovative Architects’s BI conversion accelerators can reduce the time and cost of replatforming by as much as 50%.

“Our clients rarely use the sophisticated modeling features that they are paying hundreds of thousands of dollars for and, ultimately, ‘export to Excel’ to actually perform much of their data analysis. When we demonstrate the full capabilities for information insight that the combination of SQL Server 2008 and Excel 2007 can provide, our clients have been amazed,” said Tony Baldwin, Director of Enterprise Solutions at Innovative Architects.

More from PRNewsWire

The article has

one response

Written by Guru Kirthigavasan

March 21st, 2009 at 10:08 am

Microsoft Slowly but Surely Pushes into the Enterprise  

A news article on how Microsoft’s SSRS[SQL Server Reporting Services] is making its way into the business.

“[Recently,] Reporting Services [has been] getting very close to functionality — in our estimates [it has] about 80 percent of the Crystal functionality –and we are looking more into migrating to a single reporting platform.”

Tangra finished migrating from SQL Server 2000 to SQL Server 2005 about a year ago. Once it went live on SQL Server 2005, Tangra started shifting more of its Crystal assets over to SSRS. If — as expected — Microsoft closes at least some of the gap with Crystal Reports in the next revision of SSRS, which is scheduled to ship with SQL Server 2008 later this year, Tangra will almost certainly make additional use of that product, Ratchev reports.

The article has

no responses yet

Written by Guru Kirthigavasan

March 26th, 2008 at 7:51 am