Quick Takes: Backup, Data Modeling Tools for SQL Pros -- Visual Studio Magazine

Data Driverby David Ramel

Quick Takes: Backup, Data Modeling Tools for SQL Pros

Red Gate Updates Backup Tool
SQL Backup Pro 6 comes with a new backup compression mode and backup compression analyzer that the company claims can be used to analyze optimal compression levels. The company also said this version comes with the ability to skip initialization if a database has already been through a full backup. Restore operations have been improved, with a "kill existing connections" option during a restore if users try to connect.

Data Modeling for Oracle Pros
Oracle recently shipped its Oracle SQL Developer Data Modeler, which developers deploy with SQL Developer to provide all manner of data modeling features: visual entity-relationship modeling, ERD-to-relational transformations, and physical database definition support among them.

Posted by Michael Domingo on 07/16/2009

comments powered by Disqus

Featured

Visual Studio Devs Demand Claude 3.5 Sonnet AI: 'Why Is VSC Always Preferred?'

The brand-new Visual Studio 2022 v17.12 lets devs specify the AI model they want to use with the baked-in GitHub Copilot, but some are clamoring for more options, such as the latest/greatest Claude 3.5 Sonnet model from Anthropic that is available in VS Code.
SQL Database in Microsoft Fabric in Preview for Faster AI Apps

Microsoft's early embrace of advanced AI in its dev tooling continues apace with the new public preview of SQL database in Microsoft Fabric, the company's analytics/data platform.
Microsoft Seeks to Sort & Simplify its Agentic AI Dev Story

The company will infuse multi-agent runtime tech developed in its AutoGen research project into its production-ready Semantic Kernel SDK, both open source.
Uno Platform Unveils 'Hot Design' Tool for Cross-Platform .NET Apps

Uno Platform provided a new take on visual designers for .NET app development, claiming a breakthrough that changes code at runtime rather than the design stage.
Simple k-NN Regression Using C#

Dr. James McCaffrey from Microsoft Research presents a complete end-to-end demonstration of k-nearest neighbors regression to predict a single numeric value. Compared to other machine learning regression techniques, k-NN regression is often slightly less accurate, but is very simple to implement and customize, and the results are highly interpretable.