netnerds.net
Home
Book
Links icon
Data Platform GitHub Org GitHub Profile GitHub Star Profile MVP Profile Twitch
About
Subscribe
  • VBScript: When You Can't Use Powershell to Ping a Webpage...

    Jul 25, 2011 · 1 min read  ·
    Share on:

    Sometimes, there's a need to schedule a "ping" to a webpage (that needs to be pre-compiled, for instance). While using PowerShell is the easiest way to do this, it's not always available on older server, while VBScript is nearly always a safe bet. The biggest issue with using VBScript or the command line is …


    Read More
  • Accessing XML using the MSDAOSP Provider on Windows Server 2008

    Jan 31, 2010  · Brandon Abshire   · 2 min read  ·
    Share on:

    For quite some time now, I have been using a scheduled task that executes a VBS file on my web server in order to update local weather information in a database. After porting the site to a Windows 2008 server, the scheduled task began to fail. The script is a bit out of date since the implementation of PowerShell, but …


    Read More
  • VBScript: Running a Simple Script from the Command Line Without "defining a billion vars"

    Feb 12, 2009 · 1 min read  ·
    Share on:

    A frustrated administrator friend just messaged me, asking how he can, in VBScript, "run a simple batch file using a simple command line without defining a billion vars and initting a bunch of bullshit." Apparently, this isn't well documented on the web, so I'm taking a stab at it. Set WshShell = …


    Read More
  • Efficiently Compare Two SQL Server Tables Using Mostly VBScript

    Jan 14, 2009 · 3 min read  ·
    Share on:

    Recently, a friend of mine asked to write a script to compare two SQL Server tables using mostly VBScript. The very thought made me shudder; I wanted desperately to compare the tables in SQL Server but ultimately, the company's requirements prevented us from doing so. Here were the stipulations: First, the script …


    Read More
  • MSXML: Access is denied - 80070005 - MSXML4.dll

    Dec 30, 2008 · 2 min read  ·
    Share on:

    Recently, I wanted to see if my ex in DC was reading my blog so I ran my referer log against an outdated copy of the MaxMind GeoIP locator database. I figured the database could use some updating so I ran the ImportMaxMindGeoIP.vbs script I posted awhile back, and much like in real life, I received an "Access …


    Read More
  • VBScript: Clean Up Imported SIM Card Contacts in Outlook

    Apr 11, 2008 · 2 min read  ·
    Share on:

    The other day, I was texting a friend and some guy looked at me and said "Oh hey, 2002 called, it wants its T9 back." Haha, slightly cliche but I laughed anyway. Then I went and bought myself a Blackberry. I totally love it, I won't lie. So I imported my contacts into Outlook from a Sony Ericsson mobile phone …


    Read More
  • T-SQL Equivalent of VBScript's FormatDateTime Function

    Jul 3, 2007 · 2 min read  ·
    Share on:

    Looking for the T-SQL (somewhat) equivalent to VBScript's FormatDateTime function? I've been too, for years. I finally found it within the CONVERT() function. As stated in SQL Server Books Online: In CONVERT ( data_type [ ( length ) ] , expression [ , style ] ), style is the style of the date format used to convert …


    Read More
  • VBScript: Forward SQL Server Alerts/Windows Events to (Cingular) SMS

    May 11, 2007 · 3 min read  ·
    Share on:

    Someone recently asked why I don't use SQL Mail on my SQL Servers (2000 and below). The answer is: I don't want to install Outlook on my SQL Servers. Sure, there are ways around it but I prefer just using "net send" to alert the Operator (moi) then forwarding those messages on to my inbox and phone. Although …


    Read More
  • Active Directory: E-mail Notification for Newly Added Users and Computers

    Feb 12, 2007 · 6 min read  ·
    Share on:

    Recently, someone asked if there was a way to be notified when servers have been added to an Active Directory domain. I looked around the Internet and it seems there's not a direct way to do this without some large software package. So in lieu of having an instant notification, I created a script that tallies up newly …


    Read More
  • VBScript & SQL: Programatically Find the Location of an IP Address

    Jan 30, 2007 · 2 min read  ·
    Share on:

    This is more of a post for proper keywords. My previous entry titled "Import MaxMind City CSVs into SQL Server 2005" assumes the user has already conducted research to find that MaxMind's free GeoIP database provides the functionality to look up the location of an IP address. So, if you wish to quickly and …


    Read More
    • ««
    • «
    • 1
    • 2
    • 3
    • »
    • »»

Chrissy LeMaire

SQL & PowerShell MVP. GitHub Star. Creator of dbatools. Need to oil my knees.

dbatools book

Now available in bookstores and amazon 🥳 Buy it at manning.com for 50% off with code bldbatools50

dbatools

dbatools is an awesome PowerShell module that helps you migrate entire instances with a single command, plus a whole lot more.

available from dbatools.io and github

dbachecks

dbachecks validates SQL Server environments using crowdsourced DBA checklists and outputs to Power BI and is available on github.com 📊

Find me

Find me on Mastodon

recent posts

  • New Encryption and Certificate Defaults in Microsoft's SQL Server Connection Provider
  • What's new and different in dbatools 2.0
  • Don't waste your time with ($PSEdition -eq 'Core') in your PowerShell module manifest/psd1
  • Exploring faster PowerShell import times.. again
  • You just joined Mastodon, now what?
  • Using GitHub Pages to Setup an Alias on Mastodon
  • Aliases on Mastodon: Add me! I'm also [email protected]
  • Moving to Mastodon: I actually like it better (Updated!)

categories

sql-server 119 powershell 113 general 63 security 59 windows 47 sharepoint 41 active-directory 37 linux 31 networking 30 vbscript 30 apple 24 virtualization 22 iis 19 apache 7 exchange 7
All Categories
active-directory37 apache7 apple24 asp-net2 bi4 db24 exchange7 general63 github7 iis19 linux31 livestreaming4 lync2 mastodon4 networking30 oracle1 powershell113 security59 sharepoint41 sql-server119 vbscript30 virtualization22 windows47 wpf7
[A~Z][0~9]
 

Copyright 2003 -  Chrissy LeMaire. All Rights Reserved