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…
netnerds.net
information is power
Category: VBScript
Accessing XML using the MSDAOSP Provider on Windows Server 2008
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,…
Posted in VBScript
Efficiently Compare Two SQL Server Tables Using Mostly VBScript
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…
Posted in SQL Server, VBScript
MSXML: Access is denied – 80070005 – MSXML4.dll
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…
Posted in VBScript
VBScript: Clean Up Imported SIM Card Contacts in Outlook
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.…
Posted in VBScript
T-SQL Equivalent of VBScript's FormatDateTime Function
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 ) ] ,…
Posted in SQL Server, VBScript
VBScript: Forward SQL Server Alerts/Windows Events to (Cingular) SMS
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…
Posted in SQL Server, VBScript
Active Directory: E-mail Notification for Newly Added Users and Computers
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…
Posted in Active Directory, VBScript
join chrissy on twitchdbatools 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 validates SQL Server environments using crowdsourced DBA checklists and outputs to Power BI 📊
Available from dbachecks.io and github
Chrissy LeMaire
Tweet to @cl
Brandon Abshire
Chrissy has been awarded the Microsoft MVP for her work both in the PowerShell and SQL Server communities.
Recent Comments