netnerds.net
Home
Book
Links icon
Data Platform GitHub Org GitHub Profile GitHub Star Profile MVP Profile Twitch
About
Subscribe
  • Fix Slow External DNS Resolution in Microsoft/Active Directory DNS Server

    Apr 4, 2007 · 2 min read  ·
    Share on:

    Aw yaille! I just wrote up a whole explanatory blog post then lost it so this one will likely be brief... or not. Recently, we found that one of our DNS servers was resolving external hostnames unacceptably slow -- about 5 seconds, give or take. The resolution was so slow, in fact, that all of the clients hopped on to …


    Read More
  • Testing Ping Times from an Outside Source

    Mar 21, 2007 · 2 min read  ·
    Share on:

    My blogless friend Zach shared this great tip with me: if you would like to test ping times to a machine from an outside source, telnet to route-server.ip.att.net. There, you will be presented with a command line which allows you to ping from the AT&T servers. ############## route-server.ip.att.net ############### …


    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
  • MaxMind GeoIP: Import MaxMind City CSVs into SQL Server 2005

    Jan 29, 2007 · 4 min read  ·
    Share on:

    Inspired by kitty0's GeoIP Demo, I created two scripts which automatically import the free MaxMind GeoIP database (which resolves IP addresses to city locations) into SQL Server using VBS and BCP. The VBS file can be set as a Scheduled Task for MaxMind's free once-a-month updates. I also created a SQL Server UDF to …


    Read More
  • T-SQL UDF: Convert Traditional IP into Numeric IP

    Jan 25, 2007 · 1 min read  ·
    Share on:

    This user-defined function (only available in SQL 2000 and above) is part of a larger project I'm working on. PARSENAME in SQL Server is my new favorite function.. Thanks to Jeff Smith for the heads up. CREATE FUNCTION [dbo].[IPtoNumeric] (@strIP varchar(255)) RETURNS bigint AS BEGIN DECLARE @intIPNum bigint IF …


    Read More
  • VBScript: Use an LDAP Query to Find All Windows Servers on a Domain

    Jan 9, 2007 · 1 min read  ·
    Share on:

    Damn, the ADsDSOObject rocks! This script, which weighs in at less than 20 lines, finds all machines running any form of Windows Server on a given domain. Note that this script isn't useful in finding domain controllers, but rather any machine running Windows Server. …


    Read More
  • Setting Up Bluetooth in Windows Server 2003

    Jun 5, 2006 · 1 min read  ·
    Share on:

    This is a bit recycled from the last post but I'm reframing it so that Googlers can easily find the solution. I've gotten Bluetooth to work in Windows Server 2k3. Here's are the steps: Download the bt_stack_rtm.exe and extract to a temporary directory. Navigate to that directory and, within the ENU directory, copy …


    Read More
  • TCP/IP Name Resolution Order

    May 30, 2006 · 2 min read  ·
    Share on:

    I found this gem in Addison Wesley's Inside WIndows Server 2003: A simple way to remember the order in which TCP/IP uses these tools is the phrase "Can We Buy Large Hard Drives?" The first letters are keys for cache, WINS, Broadcast, Lmhosts, Hosts, and DNS. Update: I just found the DNS query resolver …


    Read More
  • Site-to-Site VPN using Windows 2003

    Apr 28, 2006 · 4 min read  ·
    Share on:

    [super old post, reposted] A few weeks ago, I asked in an IT forum if it was possible to have a "perma-VPN" connection with Windows XP. After searching for awhile, I found that Microsoft calls perma-VPNs "Demand-Dial Interfaces" and these can only be found in the Windows Server family, not Windows …


    Read More
  • AppleScript: McVPN

    Apr 10, 2006 · 2 min read  ·
    Share on:

    This bandaid is mighty handy for pesky OSX disconnects. I don't really know what causes it and unfortunately, I don't have time to fully figure it out. I do know that changing my gateway back to my local gateway helped tremendously. Also, changing my default nameserver to a local nameserver helped too. Now, I get …


    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

  • 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!)
  • Docker on GitHub Actions macOS Runners (2022)
  • Signing Windows Software with GitHub Actions, Encrypted Secrets and PowerShell
  • ExpressVPN on macOS: No internet detected
  • RBAR Performance in PowerShell

categories

sql-server 117 powershell 109 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 powershell109 security59 sharepoint41 sql-server117 vbscript30 virtualization22 windows47 wpf7
[A~Z][0~9]
 

Copyright 2003 -  Chrissy LeMaire. All Rights Reserved