Day 23 Replication
Replication means making copy of the objects and moving transaction from primary server to secondary/standby/Slave server. There are two type...
2018-05-23
281 reads
Vinay Thakur
Day 22 Other Storage Engines
So far we have discussed InnoDB, MyIASM and NDB Storage engine which are most standard/common and important storage engine MySQL...
2018-05-21
211 reads
Day 21 NDB Storage Engine (Cluster)
MySQL also support High Availability, NDB Storage engine provides high availability- shared-nothing system, NDB Cluster integrates the standard MySQL server...
2018-05-21
299 reads
Day 20 Innodb Storage engine
InnoDB is the major Storage engine and is default Storage engine after MySQL 5.5 version. As standard RDBMS requires ACID...
2018-05-21
217 reads
Day 19 MyIASM Storage engine
MyIASM storage engine is available from the early stage of MySQL this engine is developed from IASM language and it...
2018-05-19
216 reads
Day 18 Storage engine
MySQL is special compare to all the other RDBMs System because of its special architecture, the STORAGE Engine. MySQL has...
2018-05-18
269 reads
Day 17 Backup and Recovery
There are there types of Backup: Full Backup Incremental Backup Bin-Log Backup Full Backup: is a complete backup of the...
2018-05-17
250 reads
Day 16 Security
MySQL user format it as ‘User_name’@’hostname’ To create the user account use following syntax: CREATE USER ‘User_name’@’Host_name’ IDENTIFIED BY <Pwd>;...
2018-05-16
231 reads
Day 15 Server Logs
There are 6 types of logs available for MySQL environment, Logs are important information for DBA to troubleshoot or understand...
2018-05-15
220 reads
Day 14 MySQL sys Schema
MySQL 5.7.7 and higher includes the sys schema, This has View, Stored Procedures and Functions to gather the performance related information, as...
2018-05-14
216 reads
Blogs
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Access + ODBC Driver 18 + SQL Server 2025: ~150–250 ms per request
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers