Dell Updates SQL Server Tools -- Visual Studio Magazine

Data Driverby David Ramel

Dell Updates SQL Server Tools

The software arm of Dell Inc. yesterday announced new versions of a bevy of products for the caretaking and development of SQL Server relational database management systems (RDBMSes).

Dell Software updated five different tools for monitoring, managing, protecting and boosting the performance of SQL Server databases, highlighted by version 11 of its Spotlight on SQL Server Enterprise.

That tool provides operational monitoring, diagnostics, administration and automatic tuning of physical on-premises, cloud-hosted or virtualized databases.

Reflecting the new "mobile-first" industry mindset, Spotlight on SQL Server Enterprise 11 features a new mobile app for remotely diagnosing issues from a smartphone. The app is available in native versions for Apple iOS, Google Android and Microsoft Windows Phone platforms.

The updated monitoring software also adds new multi-dimensional workload analysis and a new System Center Operations Manager management pack for users of the Microsoft cross-platform datacenter management software for OSes and hypervisors.

Spotlight also works with the new Toad for SQL Server 6.5, which helps developers and DBAs check system health and performance analytics.

The Dell data management Toad tool has been updated to work with the latest versions of SQL Server 2014 Enterprise and SQL Server Express running on the Amazon EC cloud or the Microsoft Azure cloud, as well as other Microsoft platforms such as SQL Server Analysis Services (SSAS), Azure Marketplace, Azure Table services and SharePoint.

The company also announced "the newly released Foglight for SQL Server 5.7, for real-time and historical database performance monitoring of both virtualized and non-virtualized databases." Dell said it features the new SQL Performance Investigator for workload analytics.

Another updated tool is LiteSpeed for SQL Server 8.0 for backup and recovery, now supporting the Amazon S3 storage service and SQL Server 2014. It also has a new UI and multiple-database restore functionality.

While the aforementioned products are available now, Dell said it plans to introduce later in the year version 8.6 of SharePlex for database replication and integration.

"The updated solution enables IT staff to offload reporting, migrate data and provide immediate data integration services from Oracle databases to Microsoft SQL Server for better business insight," Dell said. The tool now provides replication support for eight platforms: Oracle, SQL Server, Apache Hadoop, SAP ASE, Open Database Connectivity (ODBC), Java Message Service (JMS), SQL flat files and XML files.

Dell said developers and DBAs will be able to see the new products at next week's PASS Summit.

Posted by David Ramel on 10/29/2014

comments powered by Disqus

Featured

Full Stack Hands-On Development with .NET

In the fast-paced realm of modern software development, proficiency across a full stack of technologies is not just beneficial, it's essential. Microsoft has an entire stack of open source development components in its .NET platform (formerly known as .NET Core) that can be used to build an end-to-end set of applications.
.NET-Centric Uno Platform Debuts 'Single Project' for 9 Targets

"We've reduced the complexity of project files and eliminated the need for explicit NuGet package references, separate project libraries, or 'shared' projects."
Creating Reactive Applications in .NET

In modern applications, data is being retrieved in asynchronous, real-time streams, as traditional pull requests where the clients asks for data from the server are becoming a thing of the past.
AI for GitHub Collaboration? Maybe Not So Much

No doubt GitHub Copilot has been a boon for developers, but AI might not be the best tool for collaboration, according to developers weighing in on a recent social media post from the GitHub team.
Visual Studio 2022 Getting VS Code 'Command Palette' Equivalent

As any Visual Studio Code user knows, the editor's command palette is a powerful tool for getting things done quickly, without having to navigate through menus and dialogs. Now, we learn how an equivalent is coming for Microsoft's flagship Visual Studio IDE, invoked by the same familiar Ctrl+Shift+P keyboard shortcut.