Apply powerful window functions in T-SQL-and increase the performance and speed of your queries.
Optimize your queries-and obtain simple and elegant solutions to a variety of problems-using window functions in Transact-SQL. Led by T-SQL expert Itzik Ben-Gan, you'll learn how to apply calculations against sets of rows in a flexible, clear, and efficient manner. Ideal whether you're a database administrator or developer, this practical guide demonstrates ways to use more than a dozen T-SQL querying solutions to address common business tasks.
Discover how to:
If you are a TechNet UK subscriber you can get this book at a 40% discount with this month’s newsletter which is due out on the 7th June 2012. Just subscribe to the newsletter and it will drop into your inbox!
(Remember to select UK when you subscribe or you’ll get the US offers and news!)
The data explosion is happening at every level of the business: across devices, applications, and individual roles. Become certified on Microsoft SQL Server 2012 and prove your knowledge and skills in designing, building, and maintaining the next wave of cloud-ready database and information solutions.
1. What are the SQL Server 2012 Certifications?
From the 11th of June IT Professionals can achieve the following SQL Server 2012 Certifications:
· Microsoft Certified Solutions Associate (MCSA) in SQL Server 2012.
· Microsoft Certified Solutions Expert (MCSE) in Data Platform or Business Intelligence.
The MCSA: SQL Server 2012 certification validates a set of core SQL Server 2012 skills and is a pre-requisite for both the higher Data Platform and Business Intelligence MCSE certifications. Achieving the MCSE: Data Platform certification will demonstrate your indispensable expertise to build enterprise-scale data solutions on-premise, or in the cloud. And the MSCE: Business Intelligence certification will showcase your skills in developing and deploying visually rich business intelligence solutions and reports.
IT professionals can schedule their SQL Server 2012 exams through Microsofts testing partner Prometric.
2. What SQL Server 2012 Training is available?
Aligned to each exam is a new official SQL Server 2012 course, delivered by Microsoft Learning Partners, which will prepare you for the MCSA and MCSE exams. IT Pros can help prepare for these courses by getting hands-on with SQL Server 2012, through either downloading a SQL Server 2012 Trial and or using Virtual Labs. You can also get-up to speed with the new features of SQL Server 2012 through the Microsoft Virtual Academy, which provides bite-sized online training.
3. Can I Upgrade my SQL Server 2008 Certifications?
For those who currently hold the MCTS or MCITP in SQL Server 2008, you can sit upgrade exams in order to transition your SQL Server 2008 credentials into SQL Server 2012 MCSA and MCSE certifications. For more information about upgrade courses, please choose your destination below.
· MCSE in Business Intelligence
· MCSE in Data Platform
Eurobase Insurance Solutions, one of the world’s leading insurance and reinsurance software providers and a Microsoft Partner with Gold ISV Competency, recommends Microsoft SQL Server as the database platform for its insurance software solutions.
Eurobase has more than 20 years’ experience providing business solutions to the global insurance and reinsurance market, and its latest Synergy product suite covers the end-to-end business process life-cycle for a comprehensive range of classes of business including Reinsurance, Large Commercial and General Insurance. By aligning our product technology strategy closely with Microsoft and its expertise in developing mission critical business software platforms, clients and the wider market are able to benefit from an unrivalled scalability, high performance, robustness and availability both now and in the future.
Speaking about this strategic move, Boris Hurinek, Group Technical Architect for Eurobase International Group, said,
“Further strengthening our partnership with Microsoft and selecting SQL Server as the preferred database platform for our insurance software solutions allows Eurobase to take full advantage of the database platform specific features to provide enhanced security, even higher performance and availability of the systems to our customers. The days of database engines offering similar features are long gone. Until now our technical designs had to be constrained by the features available in all the supported platforms or adapters were required to fill the gaps at the cost of additional development effort and complexity. Being able to fully utilise Microsoft’s robust and well integrated development tools with the database engine from the same supplier significantly accelerates development processes and allows us to focus our technical skills and expertise on the key areas that add further value to our customers”.
As part of the database platform selection process Eurobase carefully considered the following criteria:
Based on demand from their end customers, Eurobase has been able to deliver more functionality using SQL Server 2008 R2 and SQL Server 2012 for its new version of Synergy. This has been achieved at a lower cost of both development and support whilst still meeting the original delivery dates.
For more information on Eurobase contact: Boris Hurinek (Group Technical Architect) email@example.com