royashbrook
Home
About
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#