netnerds.net
Home
Book
Links icon
Data Platform GitHub Org GitHub Profile GitHub Star Profile MVP Profile Twitch
About
Subscribe
  • 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
    • ««
    • «
    • 9
    • 10
    • 11
    • 12
    • 13
    • »
    • »»

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

  • Making VS Code Themes with ChatGPT
  • Update-Module dbatools Authenticode Issuer Error
  • Install-DbaMaintenanceSolution now supports auto-scheduling
  • [Solved] OmniSharp RpcErrorException in VS Code Dev Containers for PowerShell-based Azure Functions
  • Exploring GitHub Copilot Chat
  • Offline Installation of dbatools 2.0 with the dbatools.library Dependency
  • New Encryption and Certificate Defaults in Microsoft's SQL Server Connection Provider
  • What's new and different in dbatools 2.0

categories

sql-server 122 powershell 117 general 63 security 60 windows 47 sharepoint 41 active-directory 37 linux 31 networking 30 vbscript 30 apple 24 virtualization 22 iis 19 github 8 apache 7
All Categories
active-directory37 ai1 apache7 apple24 asp-net2 azure-functions1 bi4 db24 devcontainers1 exchange7 general63 github8 iis19 linux31 livestreaming4 lync2 mastodon4 networking30 oracle1 powershell117 security60 sharepoint41 sql-server122 vbscript30 virtualization22 windows47 wpf7
[A~Z][0~9]
 

Copyright 2003 -  Chrissy LeMaire. All Rights Reserved