While researching how connect to a detached MDF and read the internal file structure of the internal files, including LDF files, I kept seeing suggestions for using the undocumented DBCC command DBCC checkprimaryfile. Initially, my code looked like this:

 1# SQL Server is required to read the file contents
 2 …

Here are two straight-forward ways to create Scheduled Tasks within Windows using PowerShell. One script creates a PowerShell Scheduled Job, and the other creates a classic Windows Scheduled Task. You can read about the differences here. PowerShell v3 and above required.

Create a Scheduled Job

The following script …

Microsoft ConnectM isn't letting me sign in to post this workaround, but I just ran into a bug with the OleDbProviderSettings within SMO.

<img
  loading="lazy"
  decoding="async"
  alt="smobug"
  
    class="image_figure …</picture></figure></a></p>

Tonight, I published Invoke-Locate.ps1 to ScriptCenter because I was tired of mounting my Windows drive to my Linux servers to quickly and reliably find files. Originally, it was going to be a small script, but then I decided to trick it out, add an installer and automatic Task Scheduling to run updatedb.

The installer …

I'm currently working on a PowerShell/SQL set of scripts to ease SQL Server Migrations. A few of the scripts have been posted to Microsoft's ScriptCenter. Recently, one of the ScriptCenter visitors asked:

Can this script be used to backup all server configuration and restore at a later date. The use case I have is that …

About 8 years ago, I wrote a blog post that provided a VBScript to create easy-to-read shortcuts to IIS Log directories. W3SVC56 just wasn't helpful enough to identify which website logs to which directory.

Today, I ported that same script to PowerShell. I'm too lazy to explain, so this is what it does: …

I'm not super familiar with ThinApping, but converted portions of this VMware login script at the request of a consultant.

I tried to automate the script a bit more than the one from VMware's blog. Their script required that you put in the path to each EXE. This script will find all exes within a directory and register …

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 …

Need your External IP address? Just use the following in PowerShell 3 and above

$ip = (Invoke-WebRequest https://ipinfo.io/ip).Content.Trim()

As a bonus, you can also get additional IP information using ipinfo.io's JSON web service.

$jsonip = Invoke-WebRequest https://ipinfo.io/json $ipinfo = Convertfrom-JSON …