Managing apps involving Sybase SQL Anywhere DBs

How Sybase SQL Anywhere works? Most of the apps that embed the SQL Anywhere DBs use’s OEM Authenticated Edition, for complete list of editions refer to this page. Consists: The SQL Anywhere server : The network server, for managing databases using a client/server arrangement on networks The SQL Anywhere engine : The database engine, for managing databases on a single computer in a standalone mode Difference: The SQL Anywhere server and SQL Anywhere engine manage databases in exactly the same way and are completely compatible. However, the SQL Anywhere engine has no support for network communications. You can use SQL […]

Read more

PS: Windows UI Automation/Scripting

Windows Automation Snapin for PowerShell WASP is a PowerShell snapin for Windows Automation tasks like selecting windows and controls and sending mouse and keyboard events. It has automation cmdlets like Select-Window, Select-Control, Send-Keys, Send-Click, Get-WindowPosition, Set-WindowPosition, Set-WindowActive, Remove-Window … etc.   BELT (A PowerShell Snapin for IE Browser Automation) BELT is a PowerShell snapin for IE browser automation. BELT makes it easier to control IE by PowerShell. “BELT” originally stands for “Browser Element Locating Tool”    

Read more

PS: Managing Windows Services

List all services that a service is dependent on on: [5]: Get-Service -Name LanmanWorkstation -DependentServices Status   Name               DisplayName                           ——   —-               ———–                           Running  SessionEnv         Remote Desktop Configuration          Running  Netlogon           Netlogon                              Stopped  Browser            Computer Browser                        This will be helpful in identifying the possible service start up failures due to dependent service unavailability. List all services that depend/require a selected service: [6]: Get-Service -Name LanmanWorkstation -RequiredServices Status   Name               DisplayName                           ——   —-               ———–                           Running  MRxSmb10           SMB 1.x MiniRedirector                Running  NSI                Network Store Interface Service       Running  MRxSmb20           SMB 2.0 MiniRedirector                Running  Bowser             Browser Support Driver                This will be helpful in assessing the impact of […]

Read more