Check out this great Gizmodo article about Microsoft’s Cloud computing data warehouses. Microsoft racks servers in shipping containers and can ship and install the containers […]
Continue readingTag: Microsoft
Move Your Mouse Using VBScript and Excel
This script uses the GetMessagePos and SetCursorPos Windows API functions to move your mouse. The script will first get the current position of the mouse […]
Continue readingFinding Duplicate Rows in SQL
I used this to solve a problem today. // Finding duplicates in a table SELECT email, COUNT(email) AS NumOccurrences FROM users GROUP BY email HAVING […]
Continue readingHow to Turn on xp_cmdshell for SQL 2005
The xp_cmdshell function can be very helpful for running commands on an SQL server. However, turning on the function comes with risks. I’ll discuss those […]
Continue readingScript to Add a New SQL Differential Backup Job With Daily Incremental Zip Archives
This script builds on the differential backup script, adding a zipped incremental backup. This script will create a zip file for each day of the […]
Continue readingScript to Add a New SQL Differential Backup Job
I know you’ve been waiting for this… This script will add a differential backup job to Microsoft SQL Server 2005. Use this script in conjunction […]
Continue readingScript to Add a New SQL Backup Job
This script is for the times when I like to automate the task of adding database backup jobs to Microsoft SQL Servers. I’ll sometimes add […]
Continue reading