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
214 reads
Vinay Thakur
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
206 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
191 reads
Day 13 MySQL Performance_Schema
performace_schema is a dynamic database created when you restart the mysql, all the data from performance_schema database will be clear....
2018-05-13
244 reads
Day 12 INFORMATION_SCHEMA database
Yesterday we discuss about mysql system database, today we will see “INFORMATION_SCHEMA” database, this we cannot call as database because...
2018-05-12
277 reads
Day 11 MySQL System Database
Previous days we discuss Variables and configurations which are quite important for DBA to know. As stated earlier there are...
2018-05-11
214 reads
Day 10 Option file
So far we have discussed various mays to configure MySQL, Environmental Variables, Global Variable, Session Variables, Status Variable and Server...
2018-05-10
202 reads
Day 9 Variables
In earlier days we have discussed about providing options with environmental variable and command line, today we will be discussing...
2018-05-09
185 reads
Day 8 Configuration- Command-line
Yesterday we discuss about different ways of options and configuring with environment variable which will place MySQL locate for values...
2018-05-08
214 reads
Day 7 Configuration – Environmental Variable
On day 6 we discussed about Programs. today is very important day, we will discussing about Configuration options or parameters. All...
2018-05-07
237 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers