Tag Archives: db

MS SQL Server SQLExpress 2014 TCP/IP

MS SQL Server 2014 SQL Express 2014 TCP/IP connections

SQL Server 2014 / SQL Express 2014

  • Enable MS SQL Server TCP/IP connections
  • Restart MS SQL Server
  • Check MS SQL Server Log for port being used
  • This may not be 1433 but might be 49445 instead
  • Enable port through firewall

SQL Server Client

  • Run Sql Server 2014 Managerment Studio
  • Connect via Server Name or IP and specify Port after a comma
    • MYSERVER,1433
    • 10.10.10,10,49445

GNU/Linux PHP PDO MS SqlServer & ODBC connectors and drivers

GNU/Linux PHP PDO MS SqlServer & ODBC connectors and drivers

mariadb, mysql and percona 5.5 general query and slow query logging

mariadb, mysql and percona 5.5 general query and slow query logging

mysql> select @@general_log;
+---------------+
| @@general_log |
+---------------+
|             1 |
+---------------+


mysql> select @@general_log_file;
+-------------------------------+
| @@general_log_file            |
+-------------------------------+
| /var/lib/mysql/data/query.log |
+-------------------------------+


mysql> select  @@slow_query_log;
+------------------+
| @@slow_query_log |
+------------------+
|                1 |
+------------------+


mysql> select @@slow_query_log_file;
+------------------------------------+
| @@slow_query_log_file              |
+------------------------------------+
| /var/lib/mysql/data/mysql-slow.log |
+------------------------------------+