Skip to content

Developer's Closet

A place where I can put my code and discuss big data.

Script to Add a New SQL Differential Backup Job

  • SQL
June 7, 2009April 15, 2013 kevin No comments

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 reading

Script to Add a New SQL Backup Job

  • SQL
June 6, 2009April 15, 2013 kevin No comments

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

Cannot turn on the status bar in Notepad

  • Windows
June 4, 2009February 22, 2013 kevin No comments

Very helpful. Works on Windows XP: 1. Open Notepad and enable “Status Bar” from “View -> Status Bar”. If this option is disabled, then first […]

Continue reading

How to Repair a MySQL Database

  • MySQL
May 26, 2009April 15, 2013 kevin No comments

If a server is shutdown unexpectedly (power outage or hardware failure), one or more MySQL tables can be locked open and may need to be […]

Continue reading

Output the Date in a Windows Batch Script

  • Windows
May 25, 2009April 13, 2010 kevin 1 comment

This simple script will output the date in the MMDDYYYY format. The script can be used to enhance other scripts, for log files, etc. @echo […]

Continue reading

Function to Create an Array from Database Results in PHP

  • PHP
May 5, 2009April 13, 2010 kevin No comments

This simple function will create an array out of the multi-dimensional rows returned from a database query. function mysql_fetch_array_r($result,$result_type=MYSQL_NUM) { $arr = array(); for($i=0;$i<@mysql_num_rows($result);$i++) { […]

Continue reading

Function to Format a Date in PHP

  • PHP
April 21, 2009April 13, 2010 kevin No comments

This is a really simple function to format a date. function date_formatter($date) { return date(“Y-m-d G:i:s”,$date); }

Continue reading

Output File Size in PHP

  • PHP
April 16, 2009April 16, 2010 kevin No comments

Pass a file size to this function like this: $filesize = get_file_size(2048); And return a nicely formatted file size: 2 MB // function to get […]

Continue reading

Script to Set a Proxy Server

  • VBScript
March 11, 2009April 5, 2010 kevin No comments

This VBScript will set a user’s proxy on a Windows XP workstation. This is great for login scripts. The script will enable the proxy, set […]

Continue reading

Script to Zip Log Files

  • VBScript
February 5, 2009April 5, 2010 kevin No comments

This is a very simple VBScript that will zip all files and folders within a specified folder. This script is useful if you want to […]

Continue reading

Posts pagination

«Previous Posts 1 … 14 15 16 17 Next Posts»

Pages

  • About
  • Accumulo
  • Ansible
  • Apt-Cacher
  • Azure API Management
  • Azure Cosmos DB
  • Azure Data Catalog
  • Azure Data Facory
  • Azure Data Lake Store
  • Azure Virtual Machine Scale Sets
  • Couchbase
  • Drill
  • Flume
  • HBase
  • HDFS
  • Hive
  • Hue
  • Impala
  • Kafka
  • Oozie
  • OpenTSDB: Timeseries Database
  • Redis
  • Solr
  • Sqoop
  • Yarn
  • ZooKeeper

Categories

  • Azure (1)
  • Bash (3)
  • C# (1)
  • Citrix (1)
  • Cloudera Manager (13)
    • HBase (5)
    • HDFS (4)
    • Kafka (1)
    • Solr (1)
    • Sqoop (1)
  • Continuous Delivery (1)
  • Drill (1)
  • JavaScript (3)
  • jQuery (2)
  • Linux (24)
    • Ubuntu (12)
  • MySQL (4)
  • Oracle (1)
  • PHP (5)
  • PowerShell (19)
  • SQL (48)
  • System Center (13)
    • DPM (1)
    • Ops Manager (1)
    • Orchestrator (9)
    • Virtual Machine Manager (1)
  • Uncategorized (4)
  • VBScript (19)
  • Visual Studio (4)
  • Windows (95)

Tags

Active Directory API Backup Bash Batch Connections Database Date Differential Disaster Recovery Email Event Viewer Excel Find Kill Linux Logs Microsoft MySQL Opalis Performance PHP Query Replication rsync Scheduled Tasks Script Shell Shortcut SQL SQL 2005 Stored Procedure String Sub T-SQL Table Terminate Users VBScript Windows WinZip WMI WScript wss2 wss3

Recent Posts

  • Azure Price Comparison Chart
  • HBase: ReplicationLogCleaner: Failed to get stat of replication rs node
  • HBase: Unable to start Master: TableExistsException: hbase:namespace
  • List DPM Backups
  • PowerShell Script to Query VMM

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Kevin Verhoeven
WordPress Theme: Occasio by ThemeZee.