SQL Time Zone Conversion Functions

I did a lot of research on Microsoft’s website, and the only time zone conversion functions that I could find were relative to analysis services, and would not provide me with a solution to my problem. So, my options were to pay someone to modify our application, or create a process in the database environment to perform the conversions as data is inserted into the common database environment.

Read More

Netstat command

netstat -ano … This command displays process IDs (PIDS) that are associated with active TCP or UDP network connections. netstat -abn … This command displays the process names associated with active TCP or UDP network connections. NOTE: The option ” > c:\PortsList.txt” after the above command will allow generating a text file. Help ?

Read More

Telnet [servername] [port]

This command will help you determine if there is a process listing in that server with a specific port. We used this command in DocuWare to help find a service such Authentication server is listing in that DocuWare server. It is typically done from a machine that you think you do not have a connection. telnet dwserver 9000

Read More

How can I speed up queries on a large table?

Any process or action that requires querying the database and getting results can be optimized by adding database indexes. An index is used to speed up the performance of queries. It does this by reducing the number of database data pages that must be visited/scanned. In SQL Server, a clustered index determines the physical order of data in a table. There can be only one clustered index per table (the clustered index IS the table) What is an index?So,…

Read More

How to Restore a MySQL Database with Command Line

In MySQL, you can use the mysql command to restore the database from a dump file. mysqldump is a command-line utility used to generate a MySQL logical database backup as a single .sql file with a set of SQL statements. The utility helps you dump MySQL tables, multiple databases, or their objects. Keep in mind that it is not possible to back up MySQL databases or data to separate .sql files with the mysqldump utility Step 1: Create the database In the command prompt,…

Read More

Posted in MySQL, SQL Tagged , Comments Off on How to Restore a MySQL Database with Command Line
Illegal mix of collations (utf8_general_ci,IMPLICIT) – MySQL

— Preparations SET SESSION group_concat_max_len=4294967295; SET SESSION foreign_key_checks=0; — Set default character sets and collations ALTER DATABASE dwdata CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER DATABASE dwnotification CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER DATABASE dwsystem CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER DATABASE dwworkflowengine CHARACTER SET utf8 COLLATE utf8_general_ci; — Create statement that adjusts collations for tables in dwdata SELECT GROUP_CONCAT(CONCAT(‘ALTER TABLE ‘, TABLE_SCHEMA, ‘.’, TABLE_NAME, ‘ CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;’) SEPARATOR ‘\n’) AS “Prepared statement” FROM INFORMATION_SCHEMA.TABLES…

Read More

Posted in MySQL Tagged , , Comments Off on Illegal mix of collations (utf8_general_ci,IMPLICIT) – MySQL
Microsoft Hyper-V Virtual Machine Keyboard Shortcuts

With Hyper-V we now have the “Virtual Machine Connection” to use when interacting with a virtual machine (unlike Virtual Server which used “VMRC”).  The Virtual Machine Connection window wraps the standard Remote Desktop Client and uses this to connect to the virtual machine.  As such – we are now using the Remote Desktop key combinations.  Here is a brief summary of the key combinations that can be used with the Virtual Machine Connection. Standard Windows Key combination Virtual Machine…

Read More