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

Hands On: New VS Code Insiders Build Creates Web Page from Image in Seconds

New Vision support with GitHub Copilot in the latest Visual Studio Code Insiders build takes a user-supplied mockup image and creates a web page from it in seconds, handling all the HTML and CSS.
Naive Bayes Regression Using C#

Dr. James McCaffrey from Microsoft Research presents a complete end-to-end demonstration of the naive Bayes regression technique, where the goal is to predict a single numeric value. Compared to other machine learning regression techniques, naive Bayes regression is usually less accurate, but is simple, easy to implement and customize, works on both large and small datasets, is highly interpretable, and doesn't require tuning any hyperparameters.
VS Code Copilot Previews New GPT-4o AI Code Completion Model

The 4o upgrade includes additional training on more than 275,000 high-quality public repositories in over 30 popular programming languages, said Microsoft-owned GitHub, which created the original "AI pair programmer" years ago.
Microsoft's Rust Embrace Continues with Azure SDK Beta

"Rust's strong type system and ownership model help prevent common programming errors such as null pointer dereferencing and buffer overflows, leading to more secure and stable code."
Xcode IDE from Microsoft Archrival Apple Gets Copilot AI

Just after expanding the reach of its Copilot AI coding assistant to the open-source Eclipse IDE, Microsoft showcased how it's going even further, providing details about a preview version for the Xcode IDE from archrival Apple.