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 Computing
Conference & Expo
November 2-4, 2009 NYC
Register Today and SAVE !..

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
In many cases, the end of the year gives you time to step back and take stock of the last 12 months. This is when many of us take a hard look at what worked and what did not, complete performance reviews, and formulate plans for the coming year. For me, it is all of those things plus a time when I u...
Book Review: Murach's SQL Server 2012 for Developers
Get up to date with the new features

Murach's SQL Server 2012 for Developers by Brian Syverson and Joel Murach is an introduction to SQL Server 2012 and to developing key T-SQL (Transaction SQL) skills to become a successful developer. T-SQL is the language used by SQL Server to communicate with SQL Server databases. This book continues the Murach philosophy of using twinned pages to enhance the learning experience by repeating and enhancing the information on the first page with information on the facing page. I like this approach as it helps to reinforce the concepts being presented.

The book contains 23 chapters that are divided into five sections. There are also three appendixes that cover installing the examples used in the book and presenting suggested coding standards. The book also highlights changes made to SQL Server starting with SQL Server 2005. While the changes made to each new SQL Server version have not been huge, overall there are now a goodly number of functions, etc., which you are going to want to learn about. If you have not read any update books regarding SQL Server in the past several years then you're going to want to buy this book as it discusses the skills needed to build a well-designed database. The final section discusses SQL Server CLR integration using Visual Studio and SQL Server 2012.

The designer for SQL Server has been enhanced with IntelliSense (SQL Server 2008) and the ability to add code snippets (SQL Server 2012).

Here's a sample of the new features:

SQL Server 2005

SQL Server 2008

SQL Server 2012

Top accepts a variable

Insert multiple rows at one time

Offset & Fetch

Common Table Expressions

Date data type and time data type



Table Value Parameters

Triggers and DDL statements




There is a really neat feature that allows triggers to capture schema events and store them in a database table. This is accomplished by using the event data function, which captures event data after some of the following events are triggered: creating a table, updating a table, dropping a table, inserting a store procedure, updating a store procedure or dropping a store procedure. This is a great tool for being able to capture any schema changes made to the database especially in a production environment. There are two new logical functions introduced in SQL Server 2012. The IIF function, which returns one of two values depending upon the results of the conditional expression, and the CHOOSE function, which returns a value from a list of values depending upon the index you specify.

There are also several helpful functions that unfortunately are not mentioned in the book such as parsename, datalength, and cross apply. Cross apply is a very powerful function that was introduced with SQL Server 2005 and really needs to be discussed. I would also like the authors to give more concrete examples of how to use common table expressions.

Overall this is a fine book that I would recommend buying especially if you haven't done any refreshing of your SQL Server skills since SQL Server 2000. This book provides handy examples that will get you up to date with most of the new features.

About Steven Mandel
Steven Mandel has worked in the IT industry for over 15 years designing databases using Microsoft Access and SQL Server. He has developed Web and Windows applications using VB.NET and has written numerous articles and reviews about ASP.NET and VB.NET.

In order to post a comment you need to be registered and logged in.

Register | Sign-in

Reader Feedback: Page 1 of 1

SOA World Latest Stories
Countless business models have spawned from the IaaS industry – resell Web hosting, blogs, public cloud, and on and on. With the overwhelming amount of tools available to us, it's sometimes easy to overlook that many of them are just new skins of resources we've had for a long time. ...
Just over a week ago I received a long and loud sustained applause for a presentation I delivered at this year’s Cloud Expo in Santa Clara. I was extremely pleased with the turnout and had some very good conversations with many of the attendees. Over the next few days I had many more m...
DevOps is about increasing efficiency, but nothing is more inefficient than building the same application twice. However, this is a routine occurrence with enterprise applications that need both a rich desktop web interface and strong mobile support. With recent technological advances ...
As organizations realize the scope of the Internet of Things, gaining key insights from Big Data, through the use of advanced analytics, becomes crucial. However, IoT also creates the need for petabyte scale storage of data from millions of devices. A new type of Storage is required wh...
Microservices are a very exciting architectural approach that many organizations are looking to as a way to accelerate innovation. Microservices promise to allow teams to move away from monolithic "ball of mud" systems, but the reality is that, in the vast majority of organizations, di...
As organizations shift towards IT-as-a-service models, the need for managing & protecting data residing across physical, virtual, and now cloud environments grows with it. CommVault can ensure protection & E-Discovery of your data - whether in a private cloud, a Service Provider delive...
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