Using PowerShell to parse XML

Sample Data Let’s start with some sample data, and store it in a file c:\temp\university-node.xml. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 <University> <Department> <Name>English</Name> <Chair>Professor Lit</Chair> </Department> <Department> <Name>Mathematics</Name> <Chair>Professor Calc</Chair> </Department> <Department> <Name>Biological Science</Name> <Chair>Professor Nature</Chair> </Department> <Department> <Name>Environmental Science</Name> <Chair>Professor Green</Chair> </Department> </University> Let’s format the same data as attributes, and store it in a file c:\temp\university-attribute.

Font ligatures when saving HTML to PDF

I have an HTML document which I have been printing to PDF. The document includes words like configure which has fi which turns into a ligature when saved to PDF. If I’m just reading the PDF document on the screen, it will appear to look fine. However, the problem arises when I copy the text and discover the ligature when I paste the text into other places. Character sequences you may run into this problem with include: ff, fi, fl, ffi, and ffl.

Query Tuning Implicit Conversion

What are implicit conversions An implicit conversion is when SQL Server has to convert from one data type to another data type to be able to make a comparison. Generally, implicit conversions are most problematic when they turn what could have been an index seek into an index scan. Implicit conversion can also affect cardinality estimates. Often this is a issue that can be fixed relatively easily. Sample Data This sample code creates a table with 1,000,000 rows.

S3 website with CloudFront distribution 403 access denied error

Problem I’m using an AWS S3 bucket configured as a static website endpoint as the origin of a CloudFront distribution for this website. I pulled up my website to browse it and I started getting access denied errors as soon as I tried to click any link. My endpoint was specified incorrectly. Solution Open the CloudFront console. Choose your CloudFront distribution, and then choose Distribution Settings. Choose the Origins and Origin Groups tab.

How to use C# interactive

Introduction Sometimes I just want to quickly run or test out a snippet of C# code. Over the years, I’ve done that a few different ways: a project in Visual Studio that I use solely for the purpose of playing with small pieces of code C# interactive PowerShell Today I’m going to talk about using C# Interactive inside Visual Studio or by running csi. Inside Visual Studio with or without a project open, go to View > Other Windows > C# Interactive.