Microsoft Readies SQL Server 2012 SP1 CTP4 -- Visual Studio Magazine

Data Driverby David Ramel

Microsoft Readies SQL Server 2012 SP1 CTP4

Microsoft today released a new Community Technology Preview for SQL Server 2012, Service Pack 1. The CTP4 includes improved AlwaysOn Availability Group migration, better query capabilities over XML data and a better SQL Server Management Studio (SSMS) for Express users.

The AlwaysOn Availability Group cross-cluster migration lets users move to a higher-level version of Windows Server cluster, which keeps intact service-level agreements when upgrading to the higher-level version, such as Windows Server 2012 cluster.

The new Selective XML index can boost query performance over XML data, resulting in faster indexing of big XML data workloads, along with improving scalability by lowering storage costs of an index, the company said.

Finally, users of Express editions now get a full-featured edition of SSMS, matching the functionalities in the SSMS included with full editions of SQL Server. The Express editions include SQL Server Management Studio Express, SQL Server Express With Tools, SQL Server With Advanced Services and SQL Server Express COMP.

The last update, CTP3 was released in July, including support for self-service business intelligence functionality in Office and SharePoint 2013 Preview.

Posted by David Ramel on 09/20/2012

comments powered by Disqus

Featured

Copilot Agent Mode Preview Highlights New Visual Studio 17.14 Release

Agent mode, now in public preview for Visual Studio 17.14, marks a major step forward for AI-assisted development. Unlike previous Copilot features, agent mode can autonomously plan, edit, iterate, and invoke trusted tools-completing complex coding tasks from a single natural language prompt.
Microsoft Busts the 'Myth of AI/ML and Java'

Microsoft, contradicting beliefs of Java developers responding to a survey, said they don't need to learn AI, master machine learning, or switch to Python to build intelligent, production-ready applications.
Predicting the Future Using Azure Machine Learning

Eric D. Boyd of responsiveX previews his VSLive! 2025 session at Microsoft HQ in August where he explains how Azure ML empowers teams to build, deploy, and manage machine learning models with ease and confidence.
VS Code 1.10 Showcases New, Detailed Markdown Copilot Prompting

The new way to get the most out of GitHub Copilot is from markdown prompting, or writing detailed, reusable natural-language instructions in files like README.md or copilot-instructions.md to guide different AI models in generating context-aware, accurate code.
Uno Platform Studio and 'Hot Design' Reach General Availability

Uno Platform, a .NET-centric open source project for building single-codebase apps across multiple platforms, this week announced v6.0 of its flagship offering, which introduces a zero-install, web-based IDE for rapid cross-platform development, alongside a modernized app architecture that embraces MVU and .NET-style extensions.