netnerds.net
Home
AI Integration Series
AI Usage
About
Subscribe
github bluesky youtube github-star rss

  • SharePoint/Excel 2010: Relative Hyperlinks and Local Documents

    calendar Apr 16, 2012 · 2 min read  ·
    Share on: mastodon facebook linkedin bluesky copy
    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

    calendar Apr 13, 2012 · 1 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    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

    calendar Apr 12, 2012 · 1 min read  ·
    Share on: mastodon facebook linkedin bluesky copy
    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

    calendar Apr 6, 2012 · 4 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    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

    calendar Mar 29, 2012 · 1 min read  ·
    Share on: mastodon facebook linkedin bluesky copy
    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

  • When xp_delete_file doesn't work as expected...

    calendar Mar 29, 2012  · Brandon Abshire   · 2 min read  ·
    Share on: mastodon facebook linkedin bluesky copy
    Whether you use a Maintenance Cleanup Task as part of a SQL 2005 or 2008 Maintenance Plan, or script out your own cleanup t-SQL, you are probably using the xp_delete_file extended procedure. For quite a while, I've occasionally come across old TLog or backup files that were missed. Without questioning it, I would clean …
    Read More

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

    calendar Mar 14, 2012 · 6 min read  ·
    Share on: mastodon facebook linkedin bluesky copy
    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

    calendar Mar 13, 2012 · 1 min read  ·
    Share on: mastodon facebook linkedin bluesky copy
    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. …
    Read More

  • [SOLVED] PowerPivot for SharePoint 2010: An error occurred connecting to this data source.

    calendar Mar 7, 2012 · 4 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    I'm currently working on a project where I need to quickly make pretty graphs and charts for data in small but important SharePoint lists. After looking through a number of books and consulting with my SharePoint buddies, PowerPivot for SharePoint 2010 seems to be the best tool for the job.

    Getting it to work hasn't …


    Read More

  • Patterns and Practices: A Guide to Claims-Based Identity and Access Control - Free ebook.

    calendar Feb 24, 2012 · 1 min read  ·
    Share on: mastodon facebook linkedin bluesky copy
    While I usually like conversation-style technical books (think: Manning's In Action series and many Wrox books), Microsoft's Patterns and Practices series is one of my favorite even though they feel so formal. Recently, my buddy Buck Woody posted a link to the freely available Patterns and Practices book for A Guide to …
    Read More
    • ««
    • «
    • 17
    • 18
    • 19
    • 20
    • 21
    • »
    • »»

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

  • 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
  • Asking Bigger Questions: Remote LLMs for Automation Engineers
  • AI Integration for PowerShell Developers: Getting Started with PSOpenAI and GitHub Models
  • AI Automation with AI Toolkit for VS Code and GitHub Models: A Visual Guide

categories

powershell 131 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 14 github 10
All Categories
active-directory37 ai2 apache7 apple24 asp-net2 azure5 azure-functions1 bi4 db24 devcontainers1 exchange7 genai14 general64 github10 iis19 linux31 livestreaming4 lync2 mastodon4 networking30 oracle1 powershell131 security61 sharepoint42 sql-server125 typescript1 vbscript30 virtualization22 windows47 wpf7
[A~Z][0~9]
 

Copyright 2003 -  Chrissy LeMaire. All Rights Reserved