netnerds.net
Home
AI Integration Series
AI Usage
About
Subscribe
github bluesky youtube github-star rss
  • SQL Server 2005: Creating Your First C# CLR UDF in 10 Easy Steps (One of Which Includes Partying)

    calendar Feb 14, 2007 · 3 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    Well, 10 steps, give or take. This could have been executed in fewer steps had we not chosen such a useful function as an example . This function, which is only supported in SQL Server 2005 with CLR enabled, esentially performs a reverse IP lookup (nslookup -type=ptr), uses System.Net.Dns.GetHostEntry and thus requires …


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

    calendar Feb 12, 2007 · 6 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    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
  • Craptacular Microsoft Software Installs

    calendar Feb 12, 2007 · 2 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    My friend Brandon messaged me this morning telling me that he ran into the same issues with Office 2007 Professional (which he won & subsequently downloaded from Microsoft's website). The Office 2007 file extraction locked up even though memory & cpu usage was next-to-nothing so, eventually, he cancelled out …


    Read More
  • CHM: Download Scripting Guy Archive Volume 1 (August 2004 - June 2006)

    calendar Feb 10, 2007 · 1 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    I'm nearly a year behind on this but I just found the free 7MB CHM of the Scripting Guy archive which contains every published article from August 2004 to June 2006. This is a great compliment to the Windows IT Pro Master CD which is still 50%off (now $30).


    Read More
  • AIM 6: Err.. Port 443 Isn't Encrypting Anything But the Initial Login

    calendar Feb 6, 2007 · 2 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    A friend asked me what port AIM used and I guessed something along the lines of 5190. I wanted to check to make sure and, after issuing the command netstat -n from the comamnd prompt, I couldn't find any port even close to that in use. But I did see 443 in use.. SSL, eh? I was connected to the IP 205.188.10.248 at port …


    Read More
  • T-SQL: Don't Run This in a Production Environment

    calendar Feb 2, 2007 · 1 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    Here's some code that I'm posting mainly for my future reference. I do not recommend running this anywhere near a production machine. DECLARE @SQL varchar(8000) -- if you use nvarchar for whack table names, change this to 4000 SET @SQL = '' SELECT @SQL = @SQL + 'ALTER DATABASE ' + NAME + ' SET RECOVERY SIMPLE; ALTER …


    Read More
  • T-SQL: Reindex All Indexes in All Databases (sans tempdb)

    calendar Feb 2, 2007 · 2 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    As you probably know, Microsoft provides two undocumented/unsupported stored procedures for iterating through databases, sp_msforeachdb and sp_msforeachtable. I've always wondered, then, why the following code never showed up in Google searches: sp_MSforeachdb @command1 = 'EXEC sp_msForEachTable @COMMAND1= ''DBCC …


    Read More
  • T-SQL: Quickly Kick All Users Out of a SQL Server Database

    calendar Jan 30, 2007 · 1 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    There are a few ways to do this but here's one that I like. I believe it works in SQL Server 7, 2000 and 2005. ALTER DATABASE myDatabaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE GO USE myDatabaseName GO Go ahead and do what you need to do then set it back: ALTER DATABASE myDatabaseName SET MULTI_USER


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

    calendar Jan 30, 2007 · 2 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    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
  • BCP: Remove Quotes from CSV Import using BCP Format File

    calendar Jan 29, 2007 · 2 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    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
    • ««
    • «
    • 35
    • 36
    • 37
    • 38
    • 39
    • »
    • »»

Chrissy LeMaire

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

GenAI book

Buy now at manning.com for 45% off with code gaipbl45

AI Integration Series

  • Automation with AI Toolkit + GH Models
  • Getting Started with AI for PowerShell
  • Asking Tiny Questions: Local LLMs
  • Local Models Demystified
  • Asking Bigger Questions: Remote LLMs
  • PDF Text to SQL Data with OpenAI
  • Document Classification in SharePoint
  • Azure Functions Doc Parser

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 Bluesky

recent posts

  • Update Your Blog with GitHub Copilot CLI
  • Rebuilding dbatools.io: From Notepad++ to Cursor to Claude Code
  • Update your blog with an AI CLI (No, really)
  • Have You Considered Not Using SQL Server High Availability?
  • PowerShell Output Redirection with AI CLIs
  • dbatools is moving to Azure Trusted Signing
  • Document Intelligence with Azure Functions: A Practical Implementation
  • Automating Document Classification in SharePoint with Power Platform and AI

categories

powershell 134 sql-server 125 general 64 security 61 windows 47 sharepoint 42 active-directory 37 linux 31 networking 30 vbscript 30 apple 24 virtualization 22 iis 19 genai 17 github 10
All Categories
active-directory37 ai5 apache7 apple24 asp-net2 azure5 azure-functions1 bi4 db24 dbatools1 devcontainers1 exchange7 genai17 general64 github10 iis19 linux31 livestreaming4 lync2 mastodon4 networking30 oracle1 powershell134 security61 sharepoint42 sql-server125 typescript1 vbscript30 virtualization22 windows47 wpf7
[A~Z][0~9]
 

Copyright 2003 -  Chrissy LeMaire. All Rights Reserved

Start typing to search

Search across posts, pages, and commands

    ↑↓ to navigate ↵ to select esc to close
    Powered by Fuse.js