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

  • [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

  • SQL Server: Advanced SUSPECT Database Recovery

    calendar Sep 10, 2011 · 1 min read  ·
    Share on: mastodon facebook linkedin bluesky copy
    I hope I never have to use this article, but if I do, it will be a lifesaver. Check out Paul Randal's post on recovering a SUSPECT database that's been detached. He shows not only how to corrupt a database whilst keeping it functional, he also shows just why detaching a SUSPECT database is a horrible idea....and how …
    Read More

  • SQL Server Maintenance Plan Recommendation: Use Ola Hallengren's Pre-Built Scripts

    calendar Sep 1, 2011 · 1 min read  ·
    Share on: mastodon facebook linkedin bluesky copy
    This set of maintenance plans has been recommended by SQL Pros one too many times to ignore. If you have a rather standard environment, check out Ola Hallengren's scripts for SQL Server Backup, Integrity Check, Index and Statistics Maintenance. Actually, if you have a pretty high end environment, you can explore it as …
    Read More

  • SharePoint 2010 Gotcha: Associated ECT Column Does Not Show Up in Filter Choices

    calendar Aug 1, 2011 · 1 min read  ·
    Share on: mastodon facebook linkedin bluesky copy
    I have a relational table in SQL Server that I access in SharePoint 2010 as an External Content Type. The table, disks, has an FK (serverID) that is associated with a PK in another table, servers, via an Association Operation. Once I create a list and add it to a webpage, I am unable to select the serverID column or …
    Read More

  • SQL Server: Block Level Replication Failures Causing Suspect Database

    calendar Aug 1, 2011 · 2 min read  ·
    Share on: mastodon facebook linkedin bluesky copy
    Recently, I worked with a client who uses block level replication software (think XOSoft/ArcServ) for their clustered SQL Server databases. During proactive testing one night, replication was broken and the failover server was brought up. For the first time in years, the procedure failed and the primary application …
    Read More

  • SharePoint 2010: External Content Types for DBA's

    calendar Jul 26, 2011 · 2 min read  ·
    Share on: mastodon facebook linkedin bluesky copy
    One of the biggest annoyances of SharePoint 2007 was the lack of a native ability to work directly with SQL Server tables. SharePoint 2010 has addressed that issue with External Content Types. ECT's combine the best of both worlds -- you can modify and manage tables as usual in SQL Server, and display them (somewhat) …
    Read More

  • SQL Server: Surefire Restore Method for Connection Hammered Databases

    calendar Jul 26, 2011 · 1 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    Recently, I had a database go into the dreaded SUSPECT mode after a failed byte-level replication. Once I brought it into EMERGENCY mode, an unknown, automated program immediately connected to it from several different servers.

    Killing the connections and setting the db to single-user mode only created more headaches …


    Read More

  • SQL Server: Compress SQL Server Backups using Native Windows Tool

    calendar Jul 25, 2011 · 1 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    SQL Server 2008 has backup compression built-in, but for SQL Server 2005 and below, you can compress backups using makecab from the command line or xp_cmdshell. Makecab even has a better compression ratio than gzip and does not require additional software to be installed on the server.

    makecab D:\backups\dbname.bak …


    Read More

  • SQL: Guaranteed Way to Quickly Shrink the T-Log

    calendar Jul 19, 2011 · 1 min read  ·
    Share on: mastodon facebook linkedin bluesky copy
    My hero, Brad McGehee, has often advised against shrinking the transaction log when it's unnecessary. According to his (really amazing) SQL Server DBA Best Practices PowerPoint Presentation, shrinking too often can lead to increased file fragmentation and excessive use of resources allocated to grow/shrink the file. …
    Read More

  • Deploying Maintenance Plans with PowerShell or ASP.NET

    calendar Apr 21, 2011 · 6 min read  ·
    Share on: mastodon facebook linkedin bluesky copy
    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
    • ««
    • «
    • 6
    • 7
    • 8
    • 9
    • 10
    • »
    • »»

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

  • 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
  • Asking Tiny Questions: Local LLMs for PowerShell Devs
  • Local models mildly demystified

categories

powershell 129 sql-server 124 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 ai1 apache7 apple24 asp-net2 azure5 azure-functions1 bi4 db24 devcontainers1 exchange7 genai14 general64 github10 iis19 linux31 livestreaming4 lync2 mastodon4 networking30 oracle1 powershell129 security61 sharepoint42 sql-server124 typescript1 vbscript30 virtualization22 windows47 wpf7
[A~Z][0~9]
 

Copyright 2003 -  Chrissy LeMaire. All Rights Reserved