Here are the posts collected from week three of the SQL New Blogger Challenge. It’s been compiled the same way previous weeks’ posts were. Everyone’s doing a great job keeping up with the challenge! Author Post @MtnDBA #SQLNewBlogger Week 3 – PowerShell Aliases | DBA With Altitude @ceedubvee A Insider’s View of the Autism Spectrum: Autism and…

Read More SQL New Blogger Digest – Week 3

Fixed-position data formats will seemingly be with us forever. Despite the relative ease of parsing CSV (or other delimited formats), or even XML, many data exchanges require a fixed-position input. Characters 1-10 are X, characters 11-15 are Y and if the source data is fewer than 5 characters, we have to left-pad with a filler…

Read More Padding Fields for Fixed-Position Data Formats

This post is part of Ed Leighton-Dick’s SQL New Blogger Challenge. Please follow and support these new (or reborn) bloggers. I’m working with a number of SQLite databases as extra data sources in addition to the SQL Server database I’m primarily using for a project. Brian Davis (b|t) wrote a blog post a few years ago…

Read More Connecting SQLite to SQL Server with PowerShell

On Thursday, February 26th I presented “Easing Into Windows PowerShell” to a packed house at the Rochester SQL Server User Group meeting. Thanks to Matt Slocum (b | t) for being my semi-official photographer. We set a chapter attendance record! I had a lot of fun presenting this (my first time speaking outside my company) and we…

Read More Rochester SQL Server User Group February Meeting – Slides & Demos

On Thursday, February 26th at 6:00 PM EST I will be speaking at the Rochester PASS chapter meeting. The topic is “Easing Into PowerShell – What’s It All About?“. You’ve been hearing a lot about Windows PowerShell, but you’re wondering if it’s something you should be looking into. In this introductory session, we’ll talk about what PowerShell is,…

Read More Rochester PASS Chapter February Meeting – I’m Speaking!