All posts tagged: SAC

SQL Server 2017 on Cloud

        Major Features of SQL Server : Security and compliance Protect data at rest and in motion with a database that has the least vulnerabilities of any major platform for six years running in the NIST vulnerabilities database (National Institute of Standards and Technology, National Vulnerability Database, Jan 17, 2017). Security innovations

MySQL on cloud on aws azure google cloud

MySQL 8.0 on cloud

  An Overview of DDL Algorithm’s in MySQL 8   Database schema change is becoming more frequent than before, Four out of five application updates(Releases) requires a corresponding database change, For a DBA schema change is a more often a repetitive task, it might be a request from the application team for adding or modifying

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 is available, and supports both clustering and cloud computing to exceed the performance and reliability of any single platform. SQL Server is an indemand, capable database system.  SQL Server Express is quite usable for many of our classesAlthough Express has limitationon database size, computing capacity, and available features,the core SQL engine is the same as with other SQL Server versions, and it provides for an easier install and a lighter load on your computer. Microsoft has mostly maintained upward compatibility for SQL between SQL Server versions for many years, so if you have ready access to an older SQL Server installation, version 2008R2, 2012 or 2016, you will also be able to use it. SQL Server Express is a freely-available small-brother version of Microsoft’s enterprise system, SQL Server. It is also a huge improvement over it, especially regarding the user interface design and the included feature-set. Its main features are: Database size limit of 4GB. This excludes logfiles and can be overridden by using

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 Standard 2017 on Windows 2016 with Vulnerability Assessment

        SQL Server 2017 delivers breakthrough mission-critical capabilities with in-memory performance and operational analytics built-in. Comprehensive security features like new Always Encrypted technology helps protect your data at rest and in motion, and a world class high availability and disaster recovery solution adds new enhancements to AlwaysOn technology.Microsoft SQL Server 2017 is

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

SQL Job Manager on cloud

SIMPLIFY SQL SERVER JOB MONITORING AND MANAGEMENT SQL Enterprise Job Manager provides comprehensive monitoring and management of SQL Server agent jobs across all your SQL Servers. The familiar calendar layout makes it easy to view status, manage details, and review history for any job or instance in your environment. Manage jobs proactively by chaining jobs

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 A

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

What is MYSQL, and why it is a popular choice? MySQL is an open-source relational database management system (RDBMS) that is widely used for managing and organizing large amounts of structured data. It is one of the most popular database systems in the world and has a strong reputation for reliability, scalability, and ease of

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

SQL Ping is a nice little command line enumerator that specifically looks for SQL servers and requires no authentication whatsoever. It works on all versions of SQL server up to and including 2005 and also Express editions.SQL Ping is a cool utility that’s useful for both discovering SQL Server systems in your environments as well

sql prompt  on cloud

SQL Prompt is the SQL IntelliSense and code-formatting tool, and is an asset in developer flexibility and output. It will both increase personal coding efficiency and improve team-based development practices, leading to advanced quality, more consistent and more consistent code. Why Developers need SQL Prompt Improved coding productivity (code suggestions and completion) The most immediate

SQL Check on cloud

Real-time SQL BI Performance Monitoring Monitor the performance of physical server activity as well as analysis services to get a better picture of your SQL BI systems. Set the refresh rate to as little as 1 minute and see up to 2 ½ hours of data. The configurable dashboard provides an at-a-glance view of the

ApexSQL Complete with SQL Server 2016 on cloud

Automatically complete SQL statements Improve productivity with snippets Keep track of all your tabs Easily navigate to SQL objects Review an object’s script and description Identify the structure of complex SQL queries Log every executed query Check queries in test mode Description To enable the Auto-complete feature, navigate to the ApexSQL Complete menu, and click the Enable auto-complete command:    

ApexSQL Refactor with SQL Server 2016 on cloud

ApexSQL Refactor is a free SQL formatter, and database refactoring tool for SQL Server. Format SQL queries, refactor SQL code and database tables with ease. It can format and refactor code directly in SSMS or VS, qualify objects, expand wildcards, encapsulate SQL, locate and highlight unused variables and parameters, and much more for FREE. ApexSQL

ApexSQL Search with SQL Server 2016 on cloud

ApexSQL Search analyzes SQL Server database object’s dependencies within the database, across databases, scripts and even applications. It recognizes all database dependencies, even those not recognized by SQL Server itself. Search for SQL objects directly in SSMS and VS, quickly find data in SQL tables and views, visualize complex relationships between objects and rename SQL

ApexSQL Snapshot utility with sql server 2016 and SSMS on Cloud

What is a snapshot? A snapshot is a read-only file in a binary format that stores the complete information of a database schema. It can be used as a data source in ApexSQL Diff. The ApexSQL Snapshot utility enables creating snapshots without ApexSQL Diff. The utility is free and can be installed on multiple remote

SQL Log Rescue on cloud

SQL Log Rescue protects your data in the event of mistakes or accidents, recovering dropped tables, undoing rogue queries, identifying who has done what to your database, and when they did it. It minimizes data loss as well as downtime.  SQL Log Rescue then automatically finds the backup files and log files needed to investigate