netnerds.net
Home
Book
Links icon
Data Platform GitHub Org GitHub Profile GitHub Star Profile MVP Profile Twitch
About
Subscribe
  • PowerShell: Find/Replace Template

    Oct 20, 2011 · 1 min read  ·
    Share on:

    Brandon had this in some of his maintenance plan code and I found myself using it a bit so I thought I'd blog about it. Here is a simple script that reads a file (C:\scripts\maintenanceplans\$sqlversion\template.dtsx), replaces certain placeholders (in this case, [SERVERNAME] and [BACKUPPATH]), then writes a new file …


    Read More
  • SharePoint + PowerShell: Batch Import Models, Create ECT's, Set Permissions

    Sep 20, 2011 · 2 min read  ·
    Share on:

    Here is a script that will batch import Models, create associated ECT's, and set permissions for users and admins. Please modify the variables as needed. # script from netnerds.net # Make sure the namespace is the same as the namespace in your exported bdcm files # My $siteURL happens to be the same as my $namespace. …


    Read More
  • SharePoint + PowerShell: Import All BDCM Files in a Directory and Set Permissions

    Sep 20, 2011 · 1 min read  ·
    Share on:

    In order to invest as little effort as possible creating and recreating and recreating my External Content Types on my development server, I exported the ECT's then deleted External Content Types, External Systems, and BDC Models. I saved them all in a directory on the SharePoint server, then I placed …


    Read More
  • SharePoint 2010 + PowerShell: Export/Import Calendar Items

    Sep 20, 2011 · 2 min read  ·
    Share on:

    Today has been miserable. All I wanted to do was import a SharePoint 2007 calendar into SharePoint 2010 to use as sample data for a prototype site. I was caaarraaazzy enough to believe it would be a simple import/export, but no. There's no such thing. Maybe I could use Outlook calendaring or idq files as a medium? No. …


    Read More
  • SharePoint + Powershell: Remove Hold, Record Declaration on All Documents in a Library

    Sep 8, 2011 · 1 min read  ·
    Share on:

    In order to delete a Records Library or Records Center, all holds and records in a library must be removed and the Holds and Processing timer job must be run. If this criteria is not met, the "Delete this Document Library" will not be an option in the library settings. Here is how you can do this …


    Read More
  • SharePoint 2010 + PowerShell: Delete Site Content Type

    Sep 7, 2011 · 1 min read  ·
    Share on:

    So first, you have to delete all of the content type's children or you'll receive the error "Error: content type in use." Once the dependencies are gone, you can delete the custom site content type itself. $sitename = $args[0] $contentType = $args[1] $web = Get-SPWeb $sitename $ct = …


    Read More
  • PowerShell Workaround: "Replicate Directory Changes" Permissions in AD Required for SharePoint 2010 Profile Syncs

    Sep 6, 2011 · 3 min read  ·
    Share on:

    According to the SharePoint 2010 Communities FAQ, Microsoft is burdening SharePoint 2010 Administrators with new requirements to obtain Active Directory accounts with "Replicate Directory Changes" permissions because... In order to interrogate AD about “what has changed since time xyz”, we need the …


    Read More
  • SharePoint 2010 + PowerShell: View Dependencies of Content Types (aka Content Type Usage)

    Sep 6, 2011 · 1 min read  ·
    Share on:

    Earlier today, I created some test Content Types while playing around with the fancy new Content Organizer. I ran into a few errors, though, and subsequently wanted to delete the dummy content types to start over. I was unable to, however, because the content types were still in use. By what? I didn't know. Too bad …


    Read More
  • VBScript: When You Can't Use Powershell to Ping a Webpage...

    Jul 25, 2011 · 1 min read  ·
    Share on:

    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 a safe bet. The biggest issue with using VBScript or the command line is …


    Read More
  • Deploying Maintenance Plans with PowerShell or ASP.NET

    Apr 21, 2011 · 6 min read  ·
    Share on:

    I feel that my job as a DBA is very dynamic and usually keeps me busy with new things... except for deploying maintenance plans. I hate making maintenance plans. Luckily, I at least have a template that I can use to keep everything uniform, but it requires me opening up the plan in Visual Studio every time I want to …


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

Chrissy LeMaire

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

dbatools book

Physical books ship from manning.com on June 10, 2022! Arrives in stores and Amazon on July 5 🥳. Order or preorder now.

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 📊

recent posts

  • Signing Windows Software with GitHub Actions, Encrypted Secrets and PowerShell
  • ExpressVPN on macOS: No internet detected
  • RBAR Performance in PowerShell
  • Import-DbaCsv Design Considerations
  • Rebuilding a Proxmox cluster node
  • Default PowerShell Paths (PSModulePath) on GitHub Runners
  • Add existing directory storage to proxmox without wiping it first
  • InspecTools on Offline Windows

categories

sql-server 117 powershell 109 general 63 security 59 windows 47 sharepoint 41 active-directory 37 linux 31 networking 30 vbscript 30 apple 23 virtualization 22 iis 19 apache 7 exchange 7
All Categories
active-directory37 apache7 apple23 asp-net2 bi4 db24 exchange7 general63 github4 iis19 linux31 livestreaming4 lync2 networking30 oracle1 powershell109 security59 sharepoint41 sql-server117 vbscript30 virtualization22 windows47 wpf7
[A~Z][0~9]
 

Copyright 2003 -  Chrissy LeMaire. All Rights Reserved