Skip to content

Developer's Closet

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

Call VBScript from a Windows Batch Script

  • VBScript
  • Windows
August 14, 2009April 13, 2010 kevin 2 comments

This very easy bit of code will call a VBScript script from a Windows Batch Script: call script.vbs

Continue reading

How to Create a Shortcut with VBScript

  • VBScript
August 12, 2009April 13, 2010 kevin No comments

This script came in handy when I needed to roll out a desktop shortcut to every employee at the company I work for. The script […]

Continue reading

List Databases from an SQL 2005 Server

  • SQL
  • Windows
August 3, 2009April 15, 2013 kevin No comments

There are a number of ways to list databases from an SQL 2005 Server. — Easiest way is to use the undocumented SQL 2005 stored […]

Continue reading

Transfer SQL Logins to Another SQL 2005 Server

  • SQL
  • Windows
August 2, 2009August 2, 2010 kevin 1 comment

After you move a database from one instance of SQL 2005 to another instance of SQL 2005, the users may not be able to log […]

Continue reading

Query for the Citrix Server List

  • Citrix
  • SQL
  • Windows
August 1, 2009August 1, 2011 kevin No comments

SQL query for the Citrix server list. Substitute the dbid for the current id or simply use the name: select rtrim(hostname) as hostname, rtrim(program_name) as […]

Continue reading

Transfer SQL Logins to Another SQL 2000 Server

  • SQL
  • Windows
August 1, 2009August 2, 2010 kevin No comments

The following script will transfer logins and passwords from one SQL 2000 server to another. This script is intended to be used in the rare […]

Continue reading

Scheduling a Backup Job in Microsoft SQL 2005 Express Edition

  • VBScript
  • Windows
July 24, 2009April 13, 2010 kevin No comments

SQL 2005 Express Edition does not offer a way to schedule jobs. The following steps outline a way to schedule jobs in SQL 2005 Express […]

Continue reading

Changing the Maximum File Upload Size in IIS 6.0

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

Large file uploads in ASP.NET Uploading files via the FileUpload control gets tricky with big files. The default maximum filesize is 4MB – this is […]

Continue reading

How to Turn on xp_cmdshell for SQL 2005

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

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 reading

Script to Add a New SQL Differential Backup Job With Daily Incremental Zip Archives

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

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 reading

Posts pagination

«Previous Posts 1 … 13 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.