yourfanat wrote: I am using another tool for Oracle developers - dbForge Studio for Oracle. This IDE has lots of usefull features, among them: oracle designer, code competion and formatter, query builder, debugger, profiler, erxport/import, reports and many others. The latest version supports Oracle 12C. More information here.
Cloud Expo on Google News

2008 West
Data Direct
SOA, WOA and Cloud Computing: The New Frontier for Data Services
Red Hat
The Opening of Virtualization
User Environment Management – The Third Layer of the Desktop
Cloud Computing for Business Agility
CMIS: A Multi-Vendor Proposal for a Service-Based Content Management Interoperability Standard
Freedom OSS
Practical SOA” Max Yankelevich
Architecting an Enterprise Service Router (ESR) – A Cost-Effective Way to Scale SOA Across the Enterprise
Return on Assests: Bringing Visibility to your SOA Strategy
Managing Hybrid Endpoint Environments
Game-Changing Technology for Enterprise Clouds and Applications
Click For 2008 West
Event Webcasts

2008 West
Get ‘Rich’ Quick: Rapid Prototyping for RIA with ZERO Server Code
Keynote Systems
Designing for and Managing Performance in the New Frontier of Rich Internet Applications
How Can AJAX Improve Homeland Security?
Beyond Widgets: What a RIA Platform Should Offer
REAs: Rich Enterprise Applications
Click For 2008 Event Webcasts
Introduction to SQL Server 2012
The new and advanced features

In our previous article, SQL Server 2008 Overview, we looked over the different features that the Microsoft SQL Server provides. In this article we will focus on the new and advanced features of the latest SQL Server release – SQL Server 2012. They include, but are not limited to, the new High Availability solution AlwaysOn, improved security, and the capability of syncing with the cloud.

AlwaysOn consists of two main components – AlwaysOn Availability Groups and AlwaysOn Failover Cluster Instances. Let’s first focus on the Availability Groups. An availability group is a combination of databases that are hosted on a primary server and up to four secondary servers. Each availability group member is capable of replying to clients’ requests in the event that the primary group member is unavailable. All the databases in an availability group fail over to another group member together. This functionality is built on top of the Windows Server Failover Clustering feature and requires its installation.

The high availability of the SQL server can be further enhanced by using Failover Cluster Instances (FCI). However, this approach requires shared storage. Shared storage is not required for the AlwaysOn Availability Groups. The servers in an availability group are required to have shared storage only if they are also acting as FCI. Be aware that AlwaysOn Availability groups automatically failover to a different replica when a problem with primary one is detected. This automatic failover is not supported in FCI, so you will have to set the availability group members acting as FCI to manual failover.

Another service Microsoft offers for high availability of your SQL databases is SQL Azure Data Sync. It allows you to easily sync your on-premise SQL Server 2012 with your SQL Azure’s data. That’s why SQL Server 2012 is considered a cloud-ready application. Furthermore, it gives you the ability to specify exactly which columns you want to be synchronized. It is a full implementation of a service and there is no need for you to write extra code for this synchronization to occur. You can use it within your Disaster Recovery plan so that you will have a complete copy of your on-premise database on a different physical location.

Let’s now focus on the new features that SQL Server 2012 brings to the main SQL features:

1) Analysis Services
SQL Server 2012 offers a unified model for all the needs your organization may have. This is the BI Semantic Model. It has the benefits of the tabular and the multidimensional models and it includes: PowerPivot for Excel to meet end users’ needs; PowerPivot for SharePoint to meet teams’ needs; and Analysis Services to meet corporate’s needs. It offers you the choice between cached and passthrough storage mode and security on both row and cell level.

2) Reporting Services
In SQL Server 2012 the Reporting Services are now a SharePoint’s shared service taking advantage of all the native SharePoint service’s capabilities. Another big improvement is the enhanced end user alerting functionality. In SQL Server 2012 users can be notified when data in a report of their interest change.  This is done through a new user-friendly interface. It’s worth mentioning that the Reporting Services in SQL Server 2012 now support the 2007 and 2010 versions of Word and Excel.

3) Integration Services
One of the new characteristics of Integration Services is the new Project model for deployment. The traditional Package model is still supported. However, with the Project model you can take advantage of some advanced features, such as:  eased centralized management of parameters and connection managers; and enhanced security, since the projects can be automatically encrypted and access to them easily controlled. Amongst the enhancements in SQL Server 2012 Integration Services is also the support of Visual Studio for Applications 3.0 and .NET 4.0.

You can use all of these new features with SQL Server 2012. The editions basically remain the same as with SQL Server 2008 with the addition of SQL Server 2012 Business Intelligence. This is a customized version of SQL Server that provides a platform for building and deploying business intelligence solutions in the most secure and scalable way. All the supported features that an SQL Server 2012 edition offers can be found and compared here:

Read the original blog entry...

About Hovhannes Avoyan
Hovhannes Avoyan is the CEO of PicsArt, Inc.,

Latest AJAXWorld RIA Stories
The standardization of container runtimes and images has sparked the creation of an almost overwhelming number of new open source projects that build on and otherwise work with these specifications. Of course, there's Kubernetes, which orchestrates and manages collections of cont...
Digital Transformation: Preparing Cloud & IoT Security for the Age of Artificial Intelligence. As automation and artificial intelligence (AI) power solution development and delivery, many businesses need to build backend cloud capabilities. Well-poised organizations, marketing sm...
DXWorldEXPO | CloudEXPO are the world's most influential, independent events where Cloud Computing was coined and where technology buyers and vendors meet to experience and discuss the big picture of Digital Transformation and all of the strategies, tactics, and tools they need t...
@DevOpsSummit New York 2018, colocated with CloudEXPO | DXWorldEXPO New York 2018 will be held November 11-13, 2018, in New York City. From showcase success stories from early adopters and web-scale businesses, DevOps is expanding to organizations of all sizes, including the worl...
DXWorldEXPO LLC announced today that Dez Blanchfield joined the faculty of CloudEXPO's "10-Year Anniversary Event" which will take place on November 11-13, 2018 in New York City. Dez is a strategic leader in business and digital transformation with 25 years of experience in the I...
Subscribe to the World's Most Powerful Newsletters
Subscribe to Our Rss Feeds & Get Your SYS-CON News Live!
Click to Add our RSS Feeds to the Service of Your Choice:
Google Reader or Homepage Add to My Yahoo! Subscribe with Bloglines Subscribe in NewsGator Online
myFeedster Add to My AOL Subscribe in Rojo Add 'Hugg' to Newsburst from CNET Kinja Digest View Additional SYS-CON Feeds
Publish Your Article! Please send it to editorial(at)!

Advertise on this site! Contact advertising(at)! 201 802-3021

SYS-CON Featured Whitepapers