The following error message has occasionally been reported by SSRS users who browse the online portal after installing it. The report server cannot open a
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
ProxySQL – Add Host group or Server
ProxySQL is a powerful software load balancer and an open-source database protocol-aware proxy for MySQL that provides high performance, high availability, and high availability. You
mysqldump: Couldn’t execute ‘FLUSH TABLES’: Access denied
The following error messages are frequently encountered by EC2 instance users, particularly when they lack the privileges necessary to perform a database backup from the
Kill multiple connections at once in AWS RDS
The quickest method for generating the kill statements that end the sleeping threads in RDS MySQL is as follows. SELECT CONCAT(‘CALL mysql.rds_kill(‘,ID,’);’) FROM INFORMATION_SCHEMA.PROCESSLIST WHERE
SQL Server Triggers
This is a list of articles about SQL Server Triggers that have been published on this website. This is intended to be a quick reference.
Triggers in SQL Server
A trigger is a sort of stored procedure that is triggered when an event happens in the database server. There are 3 types of triggers
Big Data & SQL 