Category: Home

Pyautogui

On By AfterowlIn HomeLeave a comment

Using pyautogui to automate your daily work or play a video game for you.

Copy the code below into a text file and run it in your Python IDE. You may need to install the three libraries first

pip install webbrowser

pip install time

pip install pyautogui

import webbrowser
import time
import pyautogui

webbrowser.open(‘www.youtube.com’)
print(‘waiting for 6 seconds for youtube to open’)
time.sleep(6)

print(‘clicked search bar’)
step1 = pyautogui.locateOnScreen(“search bar.png”)
pyautogui.click(step1)

print(‘typing’)
pyautogui.typewrite(‘afterowl python’)
time.sleep(3)

print(‘clicking on search button’)
step2 = pyautogui.locateCenterOnScreen(“search button.png”)
pyautogui.click(step2)
time.sleep(3)

print(‘clicking on Python Graph image’)
step3 = pyautogui.locateCenterOnScreen(“python graph.png”)
pyautogui.click(step3)

FREE SQL System Reports!

On By AfterowlIn Home, SQLLeave a comment

Are you a DBA that has no funding for fancy SQL System Health Reports like RedGate, SQLTools, Foglight, SentryOne, etc? Do you hate looking at dmv queries because there are so many of them to remember? Well did you know that SQL Management Studios comes with System Health Reports? Below are steps to get System Health Reports at no cost.

To view the System Reports

Right click on “your Server” -> Reports -> Standard Reports -> “select a report”

To view the Database Specific Reports

Right click on “your Database” -> Reports -> Standard Reports -> “select a report”

Each report can be expanded for detail information.

As always, hope this helps!