Saturday, November 29, 2014 9:04 PM
How-To , Mac
Have you ever spent the time clicking on each level in a Finder window to expand the tree below? Have you ever wish that there was a way on your Mac to expand all the subfolders below a folder? While there isn’t an option on the menu you can accomplish this by pressing and holding the Option button while you expand (click the triangle to the left of the folder) a folder. Pressing and holding the Option button as you click will expand all the folders below a folder while in list view mode.
Sunday, November 2, 2014 6:58 AM
How-To , Information , Tech
You can see the version of the PowerShell Engine by using the $PSVersionTable.PSVersion
table. If you run Get-Help about_Automatic_Variables
and read the contents of the $PSVersionTable you will get the following information:
Contains a read-only hash table that displays details about the version of Windows PowerShell that is running in the current session. The table includes the following items:
: The version of the common language runtime (CLR)
: The build number of the current version
: The Windows PowerShell version number
: The version number of the WS-Management stack
: Versions of Windows PowerShell that are compatible with the current version
: The version of the serialization method
: The version of the Windows PowerShell remote management protocol
Saturday, November 1, 2014 6:58 PM
How-To , Information , Tech
If you need to upgrade a server running Windows Server 2008 R2 Standard
to either the Enterprise, or Datacenter editions you can use the installation image and choose the Upgrade option or the new command-line utility, introduced in Windows Server 2008 R2, DISM (Deployment Image Servicing and Management
). With DSIM
it is possible to perform the upgrade online, without the need to reinstall Windows or have the installation image.
To perform the upgrade in-place online, without the media image, first open an elevated command prompt (run as administrator) on the server to be upgraded.
Type the command DISM /Online /Get-CurrentEdition. This will display the current Windows version.
Type the command DISM /Online /Get-TargetEditions to list the Windows editions to which this server can be upgraded.
Type the command DISM /Online /Set-Edition: <TargetEdition> (replace <TargetEdition> with the syntax for the desired edition returned by Get-TargetEditions).
If you receive a message (Error 87) indicating that you need to specify a product key you can include it with the /ProductKey: parameter
If you receive a message (Error 50) indicating that Setting an Edition is not supported then the machine may be a Domain Controller (DC) and it must be demoted before performing an online upgrade. You do not need to demote it if you are using the installation image.
As always, be certain that you back up all of your settings and data prior to performing the upgrade.
Monday, August 13, 2012 10:38 PM
How-To , Dynamics NAV
The NAV Application Server is (NAS) is a middle-tier server that executes NAV business logic (code) without user intervention. The NAS operates as an unattended client that is connected to the database server and runs as a service on a computer. One benefit of the NAS is that if it loses communication with the database server due to connection or server issues it does not stop, instead it will continue to attempt a connection to the database server.
When you install a NAS the setup will prompt you for the parameter information to use for connecting and communicating with the database server. This makes for an easy installation; however you may need to run more than one NAS on a computer. In this case you will need to install the NAS from the command line.
In the Application Server directory there are two executable files for launching the NAS; nas.exe and nassql.exe. To install the application server you can enter the following at the command line (example is for SQL Server) and substituting your values where appropriate:
nassql appservername=<appserver service name>, servername=<SQL Server/instance>,database=<database name>,Company="<Company Name>",startupparameter=<parameter to pass>,installasservice
To uninstall as NAS from the command line enter the following command:
nassql uninstallasservice, appservername=<appserver service name>
Sunday, May 22, 2011 6:21 PM
Code , How-To , SQL
For various reasons a SQL transaction can take an amount of time to complete. OPENTRAN is the Databas Console Command (DBCC) that can be used to display information about the oldest active transaction. The TABLERESULTS argument will display the results in a table format.
DBCC OPENTRAN WITH TABLERESULTS, NO_INFOMSGS
The information in the table may be limited, however, once you identify the process ID (SPID) you can see the last statement sent from a client to the server with the INPUTBUFFER command.
DBCC INPUTBUFFER (64)