SQL

Information On Azure Databases for Visual Studio Code.

Submitted by DataPrimeCloud on Mon, 02/28/2022 - 07:21

Information on Azure Databases for Visual Studio Code.  With Azure databases user’s can have their databases on premise, example in a data center, or in the cloud using scrapbooks, with rich Intellisense, users then connect to Azure to manage their PostgreSQL and Cosmos DB databases, with support for MongoDB, Graph Gremlin, and SQL.  Visual Studio Code is a graphical code editor for Linux, macOS, and Windows. It supports extensions, including the mssql extension for querying a SQL Server instance, Azure SQL Database, an Azure SQL Managed Instance. 

Information On Azure SQL Optimizing For Virtual Machine Storage.

Submitted by DataPrimeCloud on Fri, 07/30/2021 - 06:55

For today’s post, I would like to share a video from “Microsoft Developer,”  YouTube Channel. Talking about working with Azure SQL optimizing  for Virtual Machine storage, is a critical areas to focus on when architecting for performance with SQL Server, on a  Azure Virtual Machines.

Information On SQL Assessment Checks in Azure SQL.

Submitted by DataPrimeCloud on Sun, 03/14/2021 - 14:21

Information on how to run SQL assessment checks in Azure SQL. SQL Assessment API provides a mechanism to evaluate the configuration of your SQL Server for best practices. The API is delivered with a rule set containing best practice rules suggested by SQL Server Team. The rules are designed for customization and extensible. Microsoft's rule set is designed to work for most environments. Users can write their own JSON files and customize existing rules or add new ones. link below.

 

Link below to a website, with a video.

Information On Entity Framework.

Submitted by DataPrimeCloud on Thu, 05/21/2020 - 07:49

Entity Framework is an open source object-relational mapping framework for ADO.NET. It was a part of .NET Framework, but since Entity Framework version 6, it is now separated from .NET framework. Entity Framework serve as an object-relational mapper, enabling .NET developers to work with a database using .NET objects, and eliminating the need for most of the data-access code they usually programmer need to write.

PHP framework “Phalcon” Based on C++.

Submitted by DataPrimeCloud on Thu, 04/11/2019 - 13:26

Topic for this post will be the PHP framework “Phalcon.” Phalcon differs from other PHP frameworks as it is based on C and C++ coding style. Phalcon mission is to “offer developers an advanced, feature rich tool, which they can use to develop powerful applications with low server consumption and high performance,” comment found on there website. One of the features I would like to talk about is Assets Management.