How to get current MS SQL 2008 Version

Here's a quick T-SQL to get you the current version of your SQL server. SELECT SERVERPROPERTY('ProductVersion') AS ProductVersion, SERVERPROPERTY ('ProductLevel') AS ProductLevel, SERVERPROPERTY('Edition') AS Edition, SERVERPROPERTY('EngineEdition') AS EngineEdition GO You can also use: SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY … [Read more...]

VBScript Informix DSN Test Script

So I have an Informix Dynamic Server (7) and I want to setup a Microsoft Windows ODBC system profile and then connect to it using VBScript. I will go the easy route and install IConnect 2.90 Informix Driver for Windows. After installing the driver, I will configure the ODBC connection:   After this is configured, I Apply & … [Read more...]

MySQL CLI Output Formatting Tips

I’m sure you’ve seen results similar to this on a standard query: Now, if you use the \G option (Send command to mysql server, display result vertically.): That makes reading the output from command line really nice. One more tidbit that I’ve found I like to do is use the \p option (Print current command.) combined with … [Read more...]