> writing โ 248 posts, back to 2006
things i have written over time. what i was thinking at the time, not always what i think now.
2026
2024
- securing entra from the start2024-08-13
2023
- philosophical musings with chatgpt2023-09-13
- saving a pc hard drive to a mac2023-04-25
- organizing physical storage2023-01-05
2022
- my mousepad doesn't work!!2022-09-17
- how to enable passwordless ssh on windows 2012 r22022-07-27
- Migrating a dotnet CLI app to Blazor/WASM2022-06-14
- Blog Migration/Update and GitHub Codespaces2022-06-08
- Migrating index data from doclink to cosmosdb2022-06-04
- Creating an app to search and retrieve documents on Azure2022-05-20
- Moving 15 million documents to the cloud2022-04-18
2021
- Helper script for devicon.dev2021-12-14
- Using WEI to quickly compare two systems2021-11-27
- Invoke-ExcelQuery on ImportExcel2021-11-13
- Getting data out of Powershell Jobs/Runspaces in realtime2021-04-19
2020
- how to convert a one line rollup plugin to an npm package2020-11-18
- one line rollup plugin for svelte2020-11-17
- Publishing Svelte app to Azure Web App using Azure Devops CI/CD2020-10-28
- Switching from Master to Main in Git on Azure Devops2020-10-15
- Switching from JSZip to unzipit2020-09-16
- Adding Chart Labels with Chart JS to Bar Charts and Stacked Bar Charts2020-09-04
- Extract data from Excel Spreadsheet using PowerShell2020-09-02
- Add a work-item to devops with storypoints from CLI2020-07-01
- Migrate users from ASP.NET Forms-based Auth to ASP.NET Core Identity2020-06-30
- Uploading data to o365/spo with Powershell2020-06-24
- Batch decode user agent strings2020-06-18
- Download Azure WebApp / AppService Logs via CLI2020-06-17
- migrating git repositories from one azure devops org to another2020-06-15
- MS-SQL LAG window function and 31st2020-06-10
- Hosting Blazor App on O365 Sharepoint2020-06-02
2018
- Using powershell to compress data in flight2018-11-27
- The fastest way to get a folder size in windows2018-08-23
- Watching Files with Powershell2018-07-24
- Bookmarklets for Scheduled Tasks in ServiceNow (creation and direct URL)2018-05-03
- Listing Documents via Jekyll without collections2018-04-26
- Running PiHole on a Raspberry Pi Docker Swarm2018-04-17
- Add Global Admin Directory Role in Azure AD via Powershell CLI2018-04-16
- Setting up Raspberry Pi Zero redundant PiHole Ad Blocker2018-04-14
- VMware Snapshot Removal Stuck At 99 Percent2018-04-12
- Queue up or pre-download windows updates with powershell2018-04-03
- Quick Performance Monitoring from Powershell2018-04-02
- Get Windows Update Info via Powershell/COM2018-03-28
- Powershell Universal Dashboard on RasPi2018-03-25
- Setting up PowerShell on my RasPi2018-03-25
- Installing Docker on Raspi2018-03-25
- Why does PowerShell Universal Dashboard hate my Mac?2018-03-24
- Bug in Send-MailMessage in Powershell Core 6.02018-03-23
- delete exchange database catalog index files2018-03-22
- How big is all of the data I have deleted in Exchange 20102018-03-22
- Move inactive users to a new Exchange 2010 Database2018-03-22
- Simple FTP File Listing with PowerShell2018-03-20
- query installed software from remote machine registry2018-03-05
- ConvertFrom-CSV header weirdness parsing IISLogs with Powershell2018-03-02
- How to relate VMWARE disks to Windows disks2018-03-01
- select object with max value in powershell2018-03-01
- How to deal with CSV with no header row2018-02-28
- View SQL Job Steps as XML2018-02-27
- For each file - CLI - MacOS2018-02-22
- Encrypting and Decrypting SecureString values in Powershell2018-01-30
- Decrypting VNC Passwords2018-01-29
2017
2015
- Archimate - Layer 2 Network Diagrams in Archi2015-07-23
- P2V Windows 10 and Parallels2015-02-06
2014
- Simple RIAK and C# Example2014-09-10
- Pulling a Sharepoint 2007 list into Excel as Raw XML2014-07-11
- Generating a Date Dimension table in C#2014-06-30
- List Fields/Formfields data in a Word Document using C# and Microsoft.Office.Interop.Word2014-06-25
- Amazon Workspaces โ Usage Notes2014-06-04
- Find Recent Items in Windows 82014-06-04
2013
- Rename a Connection and change DNS servers2013-11-26
- How Heroku made me sad today =(2013-04-05
- AppHarbor and dealing with annoying firewall rules. ๐2013-04-04
- passing csv to sql is still bad2013-03-27
- Fit Window for All Pages Visio macro (FWAP!)2013-03-22
- Minecraft Password Recovery from lastlogin file2013-03-20
- Iโm looking at you Comcast!2013-03-13
- SimpleSniffer Updated to 1.0.0.2 (stable)2013-03-12
- Bitshift operator vs .Net Libraries (and False Advertisement regarding Performance)2013-03-11
- How to write a basic sniffer in PowerShell2013-03-08
- New and Improved InsertDateTime Macro for Outlook Tasks2013-02-28
- Simple Sniffer in C#2013-02-13
- How to make EA (Enterprise Architect) documentation available to those without EA using EAPtoHTML2013-01-28
- How to search in a SharePoint 2007 list using JavaScript2013-01-15
- How to check in multiple documents in Sharepoint 20072013-01-14
- How to save videos from YouTube for free using VLC Media Player in six easy steps2013-01-03
- NeverAway v1.0 released2013-01-02
2012
2011
2010
- which pid is which in iis and how much memory are they using2010-09-14
- Normal and abnormal ways to display the logical scan fragmentation in sql database2010-09-13
- Search all of the text fields in a sql server database for a particular value... with LINQ (Pad)2010-08-30
- Search all of the text fields in sql server database for a particular value2010-08-30
- LINQPad and Active Directory2010-08-20
- set transaction isolation level read only uncommitted in LINQ2010-08-13
- Space used by tables, long form2010-08-03
- sp_spaceused for all the tables in your database in one table2010-07-29
- How to regain administrative access to your own sql server2010-07-29
- ah yes... LINQ is case sensitive...2010-07-20
- Showing status in c# loop using the modulus operator (%)2010-06-25
- ROW_NUMBER() AND PIVOT AND TEST DATA, OH MY!2010-06-22
- Careful with your LINQ joins (WHERE IN TSQL with LINQ)2010-06-08
- Some EF Weirdness (LINQ to Entities does not recognize the method 'System.String ToString()')2010-06-04
- SQLCE on IIS2010-06-03
- How to automatically play and loop a youtube video2010-06-02
- How to setup blogging to subtext from word20072010-06-02
- how to graph / chart multiple ping results using shell scripting and logparser2010-05-26
- stupid macro for adding some leading text in an outlook window2010-05-26
- Top 10 best LogParser links ( plus a bonus 7 ๐ )2010-05-26
- print commands to give a group dbo in all the sql dbs2010-01-12
2009
- making a custom google map (for ingles stores ๐)2009-11-09
- Adding a task item to sharepoint with VBScript and Microsoft.XMLHttp2009-10-15
- Adding an task item to sharepoint with C# .net2009-10-15
- delete objects belonging to a schema in sql2009-10-05
- how do i disconnect all of my network drives in windows2009-09-03
- windows 7 rc2009-05-24
- create a custom sendto item to process files... with powershell...2009-05-18
- dsquery, dsget, etc2009-05-18
- old ruby code for working with sugarcrm2009-03-15
- create a custom sendto item to process files2009-01-22
2008
- find sql users and roles assigned to my databases2008-09-05
- cold hard truth2008-08-01
- net command (net user, net localgroup, etc)2008-07-29
- partial trust, permcalc, and caspol, OH MY!2008-07-18
- fairness2008-07-13
- count lines with linq2008-06-11
- directory list with a stack instead of recursion2008-06-10
- Microsoft CAB = Butter Building2008-04-24
- how can i find when a stored procedure was last executed in sql 2005?2008-03-21
- how can i get some performance statistics on my stored procedures in sql2005?2008-03-21
- SQL Server 2005 Emergency Diagnostic and Performance Queries2008-03-21
- enable clr procs on sql20052008-03-19
- how to create an extended stored proc in c#2008-03-19
- multiple objects in a using and compression sample2008-03-08
- Show ip addresses on the local machines2008-02-21
- My MyBook World Edition II Fun ๐ - Part 12008-02-20
- linux command line cheat sheet2008-02-19
- My MyBook World Edition II Fun ๐ - Prelude2008-02-19
- Stupid Windows Shell Scripting Tricks2008-02-18
- Alienware Curved Monitor2008-02-17
- Amazon S3 Outage2008-02-17
- Gibson Robot Guitar2008-02-17
- S.W.A.G.2008-01-12
- TLD (Top Level Domain) list2008-01-05
- sql2005 recursion, common table expressions (CTEs), hierarchical data2008-01-04
2007
- net datareader to arraylist2007-12-13
- clear buffers in sql2007-12-07
- colour2007-11-29
- why objects suck2007-11-29
- show proc dependencies2007-11-01
- chunking binary or xml into sql2007-10-29
- chunking varbinary into sql20052007-10-26
- http status and substatus codes2007-10-04
- newsflash net gt j2ee2007-08-15
- 404 error or xml parsing error no element found error2007-07-31
- alter column dbcc cleantable2007-07-24
- electronification of paper aka eop2007-07-18
- first second chance exceptions defined2007-07-18
- more clr internal debugging etc reading material2007-07-18
- reflections on tampa codecamp2007-07-17
- why quot set nocount on quot sucks2007-07-17
- how do i alter fill factor on all tables in2007-07-11
- use commandbehavior closeconnection even with usings2007-07-11
- re testing your code2007-07-10
- nulls to codd to fabian pascal2007-07-09
- re imprisoning mort2007-07-09
- top 10 fabian pascal articles pages responses2007-07-09
- top 10 quot why xml sucks quot articles2007-07-09
- top 10 articles on storing xml blob data in sql20052007-07-08
- simple web service2007-07-04
- quote of the day2007-07-03
- odds and ends2007-07-01
- for gt foreach2007-06-24
- top 20 windbg exe case studies2007-06-24
- top 5 sos dll tips2007-06-24
- unicode paths in windows2007-06-24
- managed threads2007-06-24
- upside down triangles2007-06-24
- XmlDocument to Byte Array2007-06-22
- top 20 net garbage collection gc articles2007-06-22
- bitwise logic in sql server2007-06-20
- shfbo stored procedures2007-06-20
- yes you can rollback truncate2007-06-20
- sql 2005 xml primer2007-06-18
- how do i tell how big my xml docs or2007-06-15
- multi-touch computing is now microsoft surface computing2007-05-30
- show all table sizes in sql2007-05-23
- Star Schema2007-05-08
- how do i find what nt domain groups i'm in?2007-05-08
- switching to vista from os x2007-05-07
- deploying ssis to file system or server2007-05-05
- OH NOS!!@@ I'm Locked OUT!2007-05-05
- SQL SSIS Best Practices2007-05-05
- tempdb concurrency enhancement for sql20052007-05-05
- IBM Lays off 1 billion people!2007-05-04
- SQL native stack joins on text files2007-05-04
- SQL Testing with the WAITFOR Command2007-05-04
- ssd is coming!2007-05-04
- SSIS, Bulk Loading, 1TB in an hour??2007-05-04
- command cancel vs close2007-05-03
- stored procedure optimization2007-04-05
- identify most used indexes2007-03-30
- more cool usage information for sql20052007-03-30
- stupid svn log tricks2007-03-30
- view svn change log, quick and dirty2007-03-30
- faster random ids2007-03-28
- ring buffer in tsql2007-03-28
- top 11 colour tools on the web2007-03-28
- select top 6 from (select top 10 from lists)2007-03-27
- basic sql load testing with a multithreaded c# console app2007-03-20
- query snmp from vbscript2007-03-20
- fork.vbs2007-03-20
- testing with a random id in sql2007-03-19
- optional sql parameters2007-03-17
- object_id vs exists performance comparison2007-03-16
- nopatchforstupid 22007-03-14
- nopatchforstupid 42007-03-14
- nopatchforstupid 32007-03-14
- tsql replace vs ltrim/rtrim performance2007-03-14
- bulk insert trc files2007-03-12
- How to find a stored procedure that contains certain text2007-03-09
- ping check - aka isup2007-03-09
- passing csv to sql is bad mm'kay2007-03-09
- nopatchforstupid 12007-03-09
- SQL Query Processing2007-03-09
- sql2005 endpoint sample/example2007-03-09
- update statistics undocumented2007-03-09
- IP PBX2007-03-08
- multi-tenant architecture2007-03-08
- running wss 2 and wss 3 side by side2007-03-08
- css and microformats2007-01-22
2006
- the virtual cpu2006-12-07
- rotating testimonials with javascript2006-12-07
- simple .net connection page2006-12-06
- TODO and more to RSS2006-12-05
- recursion and file enumeration2006-12-05
- qwinsta, rwinsta, and reg, OH MY!!2006-12-01
- graphic design2006-11-01
- tables for layout... boo2006-11-01
- replacing carriage return2006-10-31
- parsing eml files with ruby2006-10-26
- parsing eml files with c#2006-10-25