netnerds.net
Home
Book
Links icon
GitHub Org GitHub Star Profile MVP Profile Twitch
About
Subscribe
  • [Solved]: New-WebServiceProxy / GetListItems Excessive Lookup Issue

    Oct 30, 2013 · 2 min read  ·
    Share on:

    Recently, while trying to use New-WebServiceProxy to automate some SharePoint form entries, I ran into a lookup issue. First, I got this rather generic error: Exception calling "GetListItems" with "7" argument(s): "Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was …


    Read More
  • PowerShell & SharePoint: Using New-WebServiceProxy to Post New Completed Tasks Automatically

    Jul 22, 2013 · 3 min read  ·
    Share on:

    Recently, I was asked to help automate a friend's super boring daily duty of logging repetitive activities to a SharePoint Task list. Even though I'm no longer regularly working with SharePoint (yay!), I accepted the challenge. Below is the script I created, which can be scheduled (and mixed up, even using $a = …


    Read More
  • Resolving Restore-SPSite Errors occurring within Web Apps with Multiple Site Collections

    Feb 13, 2013 · 2 min read  ·
    Share on:

    Recently, a colleague requested that I perform a backup of a development site collection at https://sp.ad.local and restore it to the test site collection https://test.ad.local/sites/sp. The test site collection was one of two site collections on the test.ad.local web app. It's been a while since I've done anything in …


    Read More
  • SharePoint/Excel 2010: Relative Hyperlinks and Local Documents

    Apr 16, 2012 · 2 min read  ·
    Share on:

    Relatively linking to local documents is much simpler you'd expect. Just save the Excel file and the documents in the same directory and =HYPERLINK(filename,filename). No need for "file://" or any fancy hyperlinking. This method works anywhere -- your local drive, a CD-ROM drive, USB stick, or a networked …


    Read More
  • Install Project Server 2010 on Windows 7

    Apr 13, 2012 · 1 min read  ·
    Share on:

    Google is kind of hiding this French guy's webpage (at least in America) so I thought I'd point it out. You can install Project Server 2010 and few other Office App Servers on Windowes 7 by making two changes: modify the setup\config.xml and adding a faux ServerManagerCMD.exe to your System32 directory. To compile your …


    Read More
  • SharePoint 2010 Task List Validation: Comparing Two Columns, Status and % Complete

    Apr 12, 2012 · 1 min read  ·
    Share on:

    Did you know that SharePoint supports list validation in addition to column validation? I've seen the option 100 times before but it never clicked before I actually needed to use it. In this case, I needed to make sure that anyone setting a task item Status column to Completed" was also filling setting the % …


    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
  • SQL Server 2012 PowerPivot Services: Service Account Keeps Getting Locked Out

    Mar 29, 2012 · 1 min read  ·
    Share on:

    Okay, I've had to call Helpdesk an embarrassing 8 times today because my PowerPivot upgrade is going horribly wrong and locking out my AD account that, admittedly, I use as a "service" account. I'm really left with no choice -- I'm only granted one account on this network. Restrictive networks are so …


    Read More
  • SharePoint 2010: Creating Dashboards and Charts for SharePoint Lists using PerformancePoint and Excel Services from Start to Finish

    Mar 14, 2012 · 6 min read  ·
    Share on:

    I really thought making SharePoint Lists into pretty graphs and charts in SharePoint would be far more straightforward than it's turned out to be. Recently, I was given a project where I had to do just that and while I read through about 30 SharePoint BI books, none really gave a straight answer on which of the various …


    Read More
  • [Solved] Annoying Scrollbars in Excel Web Access Web Parts and PerformancePoint w/ Excel Services

    Mar 13, 2012 · 1 min read  ·
    Share on:

    Recently, while using Excel Services to access PivotCharts and PivotTables within Excel Web Viewer Web Parts and PerformancePart Dashboards, I encountered vertical and horizontal scrollbars that would not go away, no matter how much I tried resizing. god don't like ugly To accomplish the above, you have to do two …


    Read More
    • ««
    • «
    • 1
    • 2
    • 3
    • 4
    • 5
    • »
    • »»

Chrissy LeMaire

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

preorder

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

  • 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
  • Chef inspec: Unable to detect your platform
  • Migrating my WordPress sites to GitHub Pages
  • URL Shortening/Redirects using GitHub Pages and Jekyll
  • My Windows Terminal Retro Theme

categories

sql-server 115 powershell 106 general 63 security 58 windows 47 sharepoint 41 active-directory 37 linux 31 networking 30 vbscript 30 apple 22 virtualization 22 iis 19 apache 7 exchange 7
All Categories
active-directory37 apache7 apple22 asp-net2 bi4 db24 exchange7 general63 github3 iis19 linux31 livestreaming4 lync2 networking30 oracle1 powershell106 security58 sharepoint41 sql-server115 vbscript30 virtualization22 windows47 wpf7
[A~Z][0~9]
 

Copyright 2003 -  Chrissy LeMaire. All Rights Reserved