2023

September 13, 2023 philosophical musings with chatgpt
April 25, 2023 saving a pc hard drive to a mac
January 05, 2023 organizing physical storage

2022

September 17, 2022 my mousepad doesn't work!!
July 27, 2022 how to enable passwordless ssh on windows 2012 r2
June 14, 2022 Migrating a dotnet CLI app to Blazor/WASM
June 08, 2022 Blog Migration/Update and GitHub Codespaces
June 04, 2022 Migrating index data from doclink to cosmosdb
May 20, 2022 Creating an app to search and retrieve documents on Azure
April 18, 2022 Moving 15 million documents to the cloud

2021

December 14, 2021 Helper script for devicon.dev
November 27, 2021 Using WEI to quickly compare two systems
November 13, 2021 Invoke-ExcelQuery on ImportExcel
April 19, 2021 Getting data out of Powershell Jobs/Runspaces in realtime

2020

November 18, 2020 how to convert a one line rollup plugin to an npm package
November 17, 2020 one line rollup plugin for svelte
October 28, 2020 Publishing Svelte app to Azure Web App using Azure Devops CI/CD
October 15, 2020 Switching from Master to Main in Git on Azure Devops
September 16, 2020 Switching from JSZip to unzipit
September 04, 2020 Adding Chart Labels with Chart JS to Bar Charts and Stacked Bar Charts
September 02, 2020 Extract data from Excel Spreadsheet using PowerShell
July 01, 2020 Add a work-item to devops with storypoints from CLI
June 30, 2020 Migrate users from ASP.NET Forms-based Auth to ASP.NET Core Identity
June 24, 2020 Uploading data to o365/spo with Powershell
June 18, 2020 Batch decode user agent strings
June 17, 2020 Download Azure WebApp / AppService Logs via CLI
June 15, 2020 migrating git repositories from one azure devops org to another
June 10, 2020 MS-SQL LAG window function and 31st
June 02, 2020 Hosting Blazor App on O365 Sharepoint

2019

February 05, 2019 Watching a folder for changes and sending an email with powershell

2018

November 27, 2018 Using powershell to compress data in flight
August 23, 2018 The fastest way to get a folder size in windows
July 24, 2018 Watching Files with Powershell
May 03, 2018 Bookmarklets for Scheduled Tasks in ServiceNow (creation and direct URL)
April 26, 2018 Listing Documents via Jekyll without collections
April 17, 2018 Running PiHole on a Raspberry Pi Docker Swarm
April 16, 2018 Add Global Admin Directory Role in Azure AD via Powershell CLI
April 14, 2018 Setting up Raspberry Pi Zero redundant PiHole Ad Blocker
April 12, 2018 VMware Snapshot Removal Stuck At 99 Percent
April 03, 2018 Queue up or pre-download windows updates with powershell
April 02, 2018 Quick Performance Monitoring from Powershell
March 28, 2018 Get Windows Update Info via Powershell/COM
March 25, 2018 Setting up PowerShell on my RasPi
March 25, 2018 Powershell Universal Dashboard on RasPi
March 25, 2018 Installing Docker on Raspi
March 24, 2018 Why does PowerShell Universal Dashboard hate my Mac?
March 23, 2018 Bug in Send-MailMessage in Powershell Core 6.0
March 22, 2018 Move inactive users to a new Exchange 2010 Database
March 22, 2018 How big is all of the data I have deleted in Exchange 2010
March 22, 2018 delete exchange database catalog index files
March 20, 2018 Simple FTP File Listing with PowerShell
March 05, 2018 query installed software from remote machine registry
March 02, 2018 ConvertFrom-CSV header weirdness parsing IISLogs with Powershell
March 01, 2018 select object with max value in powershell
March 01, 2018 How to relate VMWARE disks to Windows disks
February 28, 2018 How to deal with CSV with no header row
February 27, 2018 View SQL Job Steps as XML
February 22, 2018 For each file - CLI - MacOS
January 30, 2018 Encrypting and Decrypting SecureString values in Powershell
January 29, 2018 Decrypting VNC Passwords

2017

August 11, 2017 Audit Local User Accounts Using Powershell

2015

July 23, 2015 Archimate - Layer 2 Network Diagrams in Archi
February 06, 2015 P2V Windows 10 and Parallels

2014

September 10, 2014 Simple RIAK and C# Example
July 11, 2014 Pulling a Sharepoint 2007 list into Excel as Raw XML
June 30, 2014 Generating a Date Dimension table in C#
June 25, 2014 List Fields/Formfields data in a Word Document using C# and Microsoft.Office.Interop.Word
June 04, 2014 Find Recent Items in Windows 8
June 04, 2014 Amazon Workspaces ā€“ Usage Notes

2013

November 26, 2013 Rename a Connection and change DNS servers
April 05, 2013 How Heroku made me sad today =(
April 04, 2013 AppHarbor and dealing with annoying firewall rules. šŸ˜›
March 27, 2013 passing csv to sql is still bad
March 22, 2013 Fit Window for All Pages Visio macro (FWAP!)
March 20, 2013 Minecraft Password Recovery from lastlogin file
March 13, 2013 Iā€™m looking at you Comcast!
March 12, 2013 SimpleSniffer Updated to 1.0.0.2 (stable)
March 11, 2013 Bitshift operator vs .Net Libraries (and False Advertisement regarding Performance)
March 08, 2013 How to write a basic sniffer in PowerShell
February 28, 2013 New and Improved InsertDateTime Macro for Outlook Tasks
February 13, 2013 Simple Sniffer in C#
January 28, 2013 How to make EA (Enterprise Architect) documentation available to those without EA using EAPtoHTML
January 15, 2013 How to search in a SharePoint 2007 list using JavaScript
January 14, 2013 How to check in multiple documents in Sharepoint 2007
January 03, 2013 How to save videos from YouTube for free using VLC Media Player in six easy steps
January 02, 2013 NeverAway v1.0 released

2012

June 14, 2012 How to create and close TFS 2010 tasks in one step using excel 2010
April 26, 2012 How to change the first day of the week on Windows 7

2011

January 17, 2011 How to make a laptop stand out of crap for your treadmill for almost free šŸ˜€
January 13, 2011 Setting the File DateTime properties

2010

September 14, 2010 which pid is which in iis and how much memory are they using
September 13, 2010 Normal and abnormal ways to display the logical scan fragmentation in sql database
August 30, 2010 Search all of the text fields in sql server database for a particular value
August 30, 2010 Search all of the text fields in a sql server database for a particular value... with LINQ (Pad)
August 20, 2010 LINQPad and Active Directory
August 13, 2010 set transaction isolation level read only uncommitted in LINQ
August 03, 2010 Space used by tables, long form
July 29, 2010 sp_spaceused for all the tables in your database in one table
July 29, 2010 How to regain administrative access to your own sql server
July 20, 2010 ah yes... LINQ is case sensitive...
June 25, 2010 Showing status in c# loop using the modulus operator (%)
June 22, 2010 ROW_NUMBER() AND PIVOT AND TEST DATA, OH MY!
June 08, 2010 Careful with your LINQ joins (WHERE IN TSQL with LINQ)
June 04, 2010 Some EF Weirdness (LINQ to Entities does not recognize the method 'System.String ToString()')
June 03, 2010 SQLCE on IIS
June 02, 2010 How to setup blogging to subtext from word2007
June 02, 2010 How to automatically play and loop a youtube video
May 26, 2010 Top 10 best LogParser links ( plus a bonus 7 šŸ˜› )
May 26, 2010 stupid macro for adding some leading text in an outlook window
May 26, 2010 how to graph / chart multiple ping results using shell scripting and logparser
January 12, 2010 print commands to give a group dbo in all the sql dbs

2009

November 09, 2009 making a custom google map (for ingles stores šŸ˜›)
October 15, 2009 Adding an task item to sharepoint with C# .net
October 15, 2009 Adding a task item to sharepoint with VBScript and Microsoft.XMLHttp
October 05, 2009 delete objects belonging to a schema in sql
September 03, 2009 how do i disconnect all of my network drives in windows
May 24, 2009 windows 7 rc
May 18, 2009 dsquery, dsget, etc
May 18, 2009 create a custom sendto item to process files... with powershell...
March 15, 2009 old ruby code for working with sugarcrm
January 22, 2009 create a custom sendto item to process files

2008

September 05, 2008 find sql users and roles assigned to my databases
August 01, 2008 cold hard truth
July 29, 2008 net command (net user, net localgroup, etc)
July 18, 2008 partial trust, permcalc, and caspol, OH MY!
July 13, 2008 fairness
June 11, 2008 count lines with linq
June 10, 2008 directory list with a stack instead of recursion
April 24, 2008 Microsoft CAB = Butter Building
March 21, 2008 SQL Server 2005 Emergency Diagnostic and Performance Queries
March 21, 2008 how can i get some performance statistics on my stored procedures in sql2005?
March 21, 2008 how can i find when a stored procedure was last executed in sql 2005?
March 19, 2008 how to create an extended stored proc in c#
March 19, 2008 enable clr procs on sql2005
March 08, 2008 multiple objects in a using and compression sample
February 21, 2008 Show ip addresses on the local machines
February 20, 2008 My MyBook World Edition II Fun šŸ˜€ - Part 1
February 19, 2008 My MyBook World Edition II Fun šŸ˜€ - Prelude
February 19, 2008 linux command line cheat sheet
February 18, 2008 Stupid Windows Shell Scripting Tricks
February 17, 2008 Gibson Robot Guitar
February 17, 2008 Amazon S3 Outage
February 17, 2008 Alienware Curved Monitor
January 12, 2008 S.W.A.G.
January 05, 2008 TLD (Top Level Domain) list
January 04, 2008 sql2005 recursion, common table expressions (CTEs), hierarchical data

2007

December 13, 2007 .Net DataReader to ArrayList
December 07, 2007 clear buffers in sql
November 29, 2007 Why Objects Suck
November 29, 2007 Colour
November 01, 2007 show proc dependencies
October 29, 2007 chunking binary or xml into sql
October 26, 2007 chunking varbinary into sql2005
October 04, 2007 HTTP Status and SubStatus codes
August 15, 2007 newsflash .NET > J2EE
July 31, 2007 404 error or XML Parsing Error - no element found error on IIS with .Net
July 24, 2007 alter column dbcc cleantable
July 18, 2007 More CLR Internal, Debugging, Etc reading material
July 18, 2007 First/Second Chance Exceptions Defined
July 18, 2007 Electronification of Paper aka EOP
July 17, 2007 Why "SET NOCOUNT ON" Sucks
July 17, 2007 Reflections on Tampa CodeCamp
July 11, 2007 use CommandBehavior.CloseConnection even with usings
July 11, 2007 how do i alter fill factor on all tables in a database or for a whole server
July 10, 2007 Testing your code
July 09, 2007 Top 10 "Why XML Sucks" Articles
July 09, 2007 Top 10 Fabian Pascal Articles/Pages/Responses
July 09, 2007 Imprisoning Mort?
July 09, 2007 Nulls to Codd to Fabian Pascal!
July 08, 2007 Top 10 Articles on Storing XML BLOB data in SQL2005, maybe using compression, sqlclr or encryption šŸ˜€
July 04, 2007 simple web service
July 03, 2007 Quote of the Day
July 01, 2007 Odds and Ends
June 24, 2007 upside down triangles
June 24, 2007 unicode paths in windows
June 24, 2007 Top 5 SOS.dll Tips
June 24, 2007 Top 10 WinDbg.exe Usage Articles
June 24, 2007 managed threads
June 24, 2007 for > foreach
June 22, 2007 Top 20 .NET Garbage Collection (GC) Articles
June 22, 2007 XmlDocument-to-Byte-Array - don't forget your usings. šŸ˜€
June 20, 2007 yes! you can rollback truncate
June 20, 2007 SHFBO Stored Procedures
June 20, 2007 bitwise logic in sql server
June 18, 2007 SQL 2005 XML Primer
June 15, 2007 how do i tell how big my xml docs (or vars) are in sql?
May 30, 2007 multi-touch computing is now microsoft surface computing
May 23, 2007 show all table sizes in sql
May 08, 2007 how do i find what nt domain groups i'm in?
May 08, 2007 Star Schema
May 07, 2007 switching to vista from os x
May 05, 2007 tempdb concurrency enhancement for sql2005
May 05, 2007 SQL SSIS Best Practices
May 05, 2007 OH NOS!!@@ I'm Locked OUT!
May 05, 2007 deploying ssis to file system or server
May 04, 2007 SSIS, Bulk Loading, 1TB in an hour??
May 04, 2007 ssd is coming!
May 04, 2007 SQL Testing with the WAITFOR Command
May 04, 2007 SQL native stack joins on text files
May 04, 2007 IBM Lays off 1 billion people!
May 03, 2007 command cancel vs close
April 05, 2007 stored procedure optimization
March 30, 2007 view svn change log, quick and dirty
March 30, 2007 stupid svn log tricks
March 30, 2007 more cool usage information for sql2005
March 30, 2007 identify most used indexes
March 28, 2007 top 11 colour tools on the web
March 28, 2007 ring buffer in tsql
March 28, 2007 faster random ids
March 27, 2007 select top 6 from (select top 10 from lists)
March 20, 2007 query snmp from vbscript
March 20, 2007 fork.vbs
March 20, 2007 basic sql load testing with a multithreaded c# console app
March 19, 2007 testing with a random id in sql
March 17, 2007 optional sql parameters
March 16, 2007 object_id vs exists performance comparison
March 14, 2007 tsql replace vs ltrim/rtrim performance
March 14, 2007 nopatchforstupid 4
March 14, 2007 nopatchforstupid 3
March 14, 2007 nopatchforstupid 2
March 12, 2007 bulk insert trc files
March 09, 2007 update statistics undocumented
March 09, 2007 sql2005 endpoint sample/example
March 09, 2007 SQL Query Processing
March 09, 2007 passing csv to sql is bad mm'kay
March 09, 2007 nopatchforstupid 1
March 09, 2007 ping check - aka isup
March 09, 2007 How to find a stored procedure that contains certain text
March 08, 2007 running wss 2 and wss 3 side by side
March 08, 2007 multi-tenant architecture
March 08, 2007 IP PBX
January 22, 2007 css and microformats

2006

December 07, 2006 the virtual cpu
December 07, 2006 rotating testimonials with javascript
December 06, 2006 simple .net connection page
December 05, 2006 recursion and file enumeration
December 05, 2006 TODO and more to RSS
December 01, 2006 qwinsta, rwinsta, and reg, OH MY!!
November 01, 2006 tables for layout... boo
November 01, 2006 graphic design
October 31, 2006 replacing carriage return
October 26, 2006 parsing eml files with ruby
October 25, 2006 parsing eml files with c#