All posts tagged: GCP

SQL Server 2017 windows 2019

        SQL Server 2017 represents a major step towards making SQL Server a platform that gives you choices of development languages, data types, on-premises or cloud, and operating systems by bringing the power of SQL Server to Linux, Linux-based Docker containers, and Windows. This topic summarizes what is new for specific feature

SQL Server 2017 on Cloud

        SQL Server consistently leads in the TPC-E OLTP workload, the TPC-H data warehousing workload, and real-world application performance benchmarks. Get record-breaking performance now on Windows and Linux. Cognosys Provides Hardened images of SQL Server 2017  on the cloud ( AWS marketplace, Azure and Google Cloud Platform) with multiple utilities to help in easy

MySQL on cloud on aws azure google cloud

MySQL 8.0 on cloud

MySQL is the most popular Open Source Relational SQL database management system. MySQL is one of the best RDBMS being used for developing web-based software applications.MySQL is a fast, easy-to-use RDBMS being used for many small and big businesses. MySQL is owned by MySQL (https://www.mysql.com/h) and they own all related trademarks and IP rights for

SQL Server 2016 on Windows 2016

        SQL Server consistently leads in the TPC-E OLTP workload, the TPC-H data warehousing workload, and real-world application performance benchmarks. Get record-breaking performance now on Windows and Linux. Cognosys Provides Hardened images of SQL Server 2016  on the cloud ( AWS marketplace, Azure and Google Cloud Platform) with multiple utilities to help in easy

SQL Server 2016 SP2 Standard on Windows Server 2016

        SQL Server consistently leads in the TPC-E OLTP workload, the TPC-H data warehousing workload, and real-world application performance benchmarks. Get record-breaking performance now on Windows and Linux. Cognosys Provides Hardened images of SQL Server 2016  on the cloud ( AWS marketplace, Azure and Google Cloud Platform) with multiple utilities to help in easy

SQL Server 2016 SP2 Web on Windows Server 2016

        SQL Server consistently leads in the TPC-E OLTP workload, the TPC-H data warehousing workload, and real-world application performance benchmarks. Get record-breaking performance now on Windows and Linux. Cognosys Provides Hardened images of SQL Server 2016  on the cloud ( AWS marketplace, Azure and Google Cloud Platform) with multiple utilities to help in easy

SQL Server 2016 SP2 Enterprise on Windows 2016

        SQL Server consistently leads in the TPC-E OLTP workload, the TPC-H data warehousing workload, and real-world application performance benchmarks. Get record-breaking performance now on Windows and Linux. Cognosys Provides Hardened images of SQL Server 2016  on the cloud ( AWS marketplace, Azure and Google Cloud Platform) with multiple utilities to help in easy

SQL Server 2017 on Windows Server 2016

        SQL Server consistently leads in the TPC-E OLTP workload, the TPC-H data warehousing workload, and real-world application performance benchmarks. Get record-breaking performance now on Windows and Linux. Cognosys Provides Hardened images of SQL Server 2017  on the cloud ( AWS marketplace, Azure and Google Cloud Platform) with multiple utilities to help in easy

PHP MYSQL and IIS on cloud

PHP is a server-side scripting language designed for web development but also used as a general-purpose programming language. PHP code may be embedded into HTML code, or it can be used in combination with various web template systems, web content management system and web frameworks. PHP code is usually processed by a PHP interpreter implemented

Google Cloud : Connect using RDP to Windows Instance on GCP

To connect to a windows instance in Google Cloud: Step 1) Go to your project: Step 2) Click on RDP Button drop down to set new RDP password: Step 3) Click create or reset windows password: Step 4) Enter User name ( admin or administrator or any other name) Step 5) Click Set to get

LEMP server on cloud

    LEMP is a variation of the ubiquitous LAMP stack used for developing and deploying web applications. Traditionally, LAMP consists of Linux, Apache, MySQL and PHP. Due to its modular nature, the components can easily be swapped out. With LEMP, Apache is replaced with the lightweight yet powerful Nginx. LEMP is owned by LEMP

Centos 7.3 On Cloud

    CentOS on cloud is a Linux distribution that attempts to provide a free, enterprise-class, community-supported computing platform functionally compatible with its upstream source, Red Hat Enterprise Linux (RHEL). In January 2014, CentOS on cloud announced the official joining with Red Hat while staying independent from RHEL, under a new CentOS governing board. CentOS

SQL Server 2012 Express on Cloud

SQL Server 2012 Express edition is the entry-level, free database and is ideal for learning and building desktop and small server data-driven applications. It is the best choice for independent software vendors, developers, and hobbyists building client applications. If you need more advanced database features, SQL Server Express can be seamlessly upgraded to other higher

SQL Server 2016 Enterprise Edition On Cloud

SQL Server 2016 Enterprise edition is the premium editions of all in SQL Server 2016. This edition has all the features of SQL Server 2016. SQL Server 2016 Enterprise edition delivers comprehensive high-end data center capabilities with blazing-fast performance, unlimited virtualization and end-to-end business intelligence — enabling high service levels for mission-critical workloads and end user

SQL Server 2016 Web Edition on Cloud

        SQL Server 2016 Web edition is a low total-cost-of-ownership option for Web hosters and Web VAPs (Value Added Providers) to provide scalability, affordability and manageability capabilities for small to large scale Web properties. Secure, cost effective and highly scalable data platform for public web sites. The Web edition is available to third

SQL Job Manager on cloud

SQL job manager is Idera’s next generation solution for scheduling and managing SQL Server jobs across your enterprise. SQL job manager gives you a simple way to see jobs that have run or are scheduled to run on one or many SQL Servers, schedule or edit jobs and quickly and easily re-schedule jobs by dragging

SQL Permissions Extractor on cloud

SQL permissions extractor a free tool which extracts and migrates permissions from objects in SQL. It generates T-SQL scripts for copying of user permissions. It can edit, save, and execute permissions scripts and includes object level permissions for selected databases. Once SQL permissions extractor has generated a permissions script, apply this script to any object

SQL QUERY STORE OPTIMIZER ON CLOUD

Query Store by optimizing its properties and contents. This affects how the Query Store captures per database a history of queries, plans, and run-time statistics. 1. Improve SQL Server 2016 Query Store performance 2. See all Query Store properties in single summary table 3. Execute predefined actions that modify Query Store properties and contents 4.

SQL Heat Map on cloud

SQL Heat Map is a tool for easy-to-read analytical imaging to rapidly identify your largest capacity of users. Get one visual view of storage in all tables of a database See storage allocation, utilization, and type of data Great for capacity reviews and planning Quickly locate tables and indexes that need more allocated storage SQL

MySQL Query Explorer on cloud

The MySQL Query Explorer Monitor highlights top resource consuming queries in execution and provides summary statistics to give a quick overview of status and places to investigate further. Set the sampling interval between 30 seconds and 10 minutes or manually refresh to get a real-time view. Select queries for further investigation or Kill a problem

SQL Backup Status Reporter on cloud

Quickly identify databases which have not had backups View backup history including the backup date and type Simplified grid view for easy sorting and navigation Identify full and differential backups for many databases Connect to cloud and run in cloud (provisional)   One of the most important DBA roles is to perform daily health check

SQL Instance Check on cloud

Discover all SQL Server versions Patch compliance checks on SQL servers Discover important information about SQL Server instances Simple installation, no agents required   SQL Instance Check on cloud for AWS       Major Features of SQL Instance Check  Discover All SQL Server Versions Discover what versions of SQL Server you have by scanning

SQL BI Check on cloud

1.  Real-time performance monitoring for SQL Server Analysis Services (SSAS) 2. See physical server metrics for CPU, disk, and storage. 3. View analysis metrics for SSAS processing, memory, and cache. 4. Get up and running in minutes, no agents required.   Major Features of  SQL BI Check Real-time SQL BI Performance Monitoring : Monitor the

SQL Hekaton Memory Check on cloud

SQL Hekaton Memory Check, a free tool that allows database administrators (DBAs) to see real-time memory usage on all SQL Server instances that use Hekaton, and take immediate action to avoid downtime and optimize appropriately. Hekaton, Microsoft’s in-memory database for online transaction processing in SQL Server, can increase processing speeds up to 30x using a

SQL Statistics Aggregator on cloud

SQL Statistics Aggregator tool allows users to speed up the aggregation and analysis of Statistics IO data that is common when doing query tuning by creating an interactive table of the data making it much easier to view and interpret. Using this information, database administrators (DBAs) can quickly see where the problems are that otherwise

SQL Update Statistics on cloud

Launch directly within SSMS for optimal usability Identify out-of-date SQL Server table and index statistics View and change database statistics options Create graphical histograms for each column’s statistics Easy point-and-click rebuilding of statistics Connect to cloud and run in cloud (provisional) SQL Update Statistics on cloud for AWS   Major Features of SQL Update Statistics

SQL Page Viewer on cloud

Stop digging through confusing DBCC Page output to troubleshoot SQL Server issues. With a single click, SQL Page Viewer gives you quick insight into how the SQL Server data is stored. Get the page level data you need to quickly diagnose locking, blocking or wait events caused by a given table, index or corrupted data.

SQL XEvent Profiler on cloud

IDERA’s SQL XEvent Profiler emulates the functionality and simplicity of SQL Server Profiler, letting you quickly view data from SQL events and see what’s happening on the server. Plus, it leverages SQL Extended Events (XEvents) as the backing technology — making it more efficient, more powerful and more scalable than SQL Trace. View sessions running

SQL Fragmentation Analyzer on cloud

Idera’s SQL fragmentation analyzer displays a graphical view of the fragmentation level of your SQL Server indexes, helping you see what indexes might require maintenance. Idera’s commercial SQL defrag manager 3.1 takes this a step further and lets you automate defragmentation. You can find SQL fragmentation analyzer at the Idera site. Analyze fragmentation by one

Sql Ping on cloud

SQLPing scans your network to locate new and unprotected SQL Server and Microsoft SQL Server Desktop Engine (MSDE) instances. SQLPing works with SQL Server 2000 and later, and requires the .NET Framework. SQLPing uses both active and passive scans to find SQL Server and Microsoft SQL Server Desktop Engine (MSDE) installations that need to be