netnerds.net
Home
Book
Links icon
Data Platform GitHub Org GitHub Profile GitHub Star Profile MVP Profile Twitch
About
Subscribe
  • BCP: Remove Quotes from CSV Import using BCP Format File

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

    I'd like to start this post by saying that BCP is limited and ghe-toe, but it gets the job done to some degree. One of the guys over at SQLteam.com wrote a really informative post on Flat File Bulk Import methods speed comparison in SQL Server 2005 that you should check out if you are into that sort of thing. BCP ranks …


    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
  • T-SQL: Parse Top Level Domain from URL

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

    I keep track of all hits to my website RealCajunRecipes.com in a SQL table called hitcounter which has columns for the user's IP, browser, referring URL and the date. Recently, I saw a surge in traffic and wanted to know which domains were sending the traffic our way. After getting tired of issuing ad-hoc queries that …


    Read More
  • SQL: 6.5 Compatibility in SQL Server 2005

    May 15, 2006 · 3 min read  ·
    Share on:

    This isn't a very common scenario, but I figured I'd write about it anyway. We recently implemented a Windows 2003 Active Directory domain at work. I suggested to my employer that, going forward, we only install SQL Server 2005 when we need a database server (phasing out 2000). I'd also suggested consolidating a couple …


    Read More
  • SQL: Quickly count instances of a variable within a string.

    Apr 27, 2006 · 1 min read  ·
    Share on:

    Using SQL and want to know how many times 'http' appears in a string using about one line of code? Find out by creatively using the replace() function. Declare @myStr varchar(1500), @countStr varchar(100) Set @myStr = 'https://www.buydrugshere.com go here! https://www.onlinemortage.com right there!' Set @countStr = …


    Read More
  • VBScript & SQL: Centralize Windows Events in SQL Server

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

    This is a barebones script that gathers server events across a domain and stores them in SQL Server using asyncronous notifications as seen in this sample of the code: strWQL = "Select * from __InstanceCreationEvent where TargetInstance isa 'Win32_NTLogEvent'" objWMIService.ExecNotificationQueryAsync …


    Read More
    • ««
    • «
    • 8
    • 9
    • 10
    • 11
    • 12
    • »
    • »»

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