netnerds.net
Home
Book
Links icon
Data Platform GitHub Org GitHub Profile GitHub Star Profile MVP Profile Twitch
About
Subscribe
  • SQL Server Discovery Tools and Scripts

    May 24, 2012 · 2 min read  ·
    Share on:

    Each time I start a new contract, the first thing I do is search for all SQL Servers across any network/subnet to which I have access. While the documentation I get is usually paltry or non-existent. When it does exist, it's usually only for the production SQL Servers. Sometimes, most production SQL Servers aren't even …


    Read More
  • Using Bookpedia, SQLite, Book+ and PowerShell to Organize Your e-Book Collection

    May 6, 2012 · 5 min read  ·
    Share on:

    This setup is so unlikely, I doubt anyone on the 'net will be looking for this solution but: if you're an eBook loving Windows developer who uses a Macbook Pro for your primary workstation, this may appeal to you. My Macbook Pro runs Windows 7 within Parallels. It's fast and slick and I <3 it. My eBook reader of …


    Read More
  • [Client-side Workaround] SharePoint 2010 Excel Services cannot Automatically Refresh Data when using SharePoint Lists as a Data Source

    Apr 6, 2012 · 4 min read  ·
    Share on:

    So far as I can tell, Excel Services is not capable of automatic data refreshes when using SharePoint Lists as a data source. If you're looking for this functionality, you have two choices: PowerPivot (best) or scheduled client-side data refreshing (ghetto). In order for Excel Services to communicate with other data …


    Read More
  • PowerShell: Copy-Item -recurse -force Does Not Create Directories when Using Get-ChildItem -include

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

    I recently wrote a PowerShell script which copied documents from a filter to my local hard drive. I chose PowerShell for this task because it was one of the few programs actually allowed on my ultra locked-down workstation (and 'cuz I love it.) Because I only wanted specific types of files, I gathered the list of …


    Read More
  • 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
    • ««
    • «
    • 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

  • New Encryption and Certificate Defaults in Microsoft's SQL Server Connection Provider
  • What's new and different in dbatools 2.0
  • Don't waste your time with ($PSEdition -eq 'Core') in your PowerShell module manifest/psd1
  • Exploring faster PowerShell import times.. again
  • 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!)

categories

sql-server 119 powershell 113 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 powershell113 security59 sharepoint41 sql-server119 vbscript30 virtualization22 windows47 wpf7
[A~Z][0~9]
 

Copyright 2003 -  Chrissy LeMaire. All Rights Reserved