We hear the common refrain among DBAs all the time. Back up your data! Test your restores! If you can’t restore the backup, it’s worthless. And yes, absolutely, you have to back up your databases – your job, and the company, depend upon it. But are you backing everything up? Saturday night was an ordinary…Read More Are You Backing Everything Up?
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
I didn’t intend for last week’s digest to also be my post for week two of the challenge, but life got in the way and I wasn’t able to complete the post that I really wanted in time. So, that post will be written much earlier in week three and completed well ahead of the deadline.…Read More SQL New Blogger Digest – Week 2
Watching all of the tweets as people posted their first entries in the SQL New Blogger Challenge earlier this week, I quickly realized that keeping up was going to be a challenge of its own. Fortunately, there are ways to reign it in. My first stop was IFTTT (If This Then That). IFTTT allows you to…Read More SQL New Blogger Challenge Weekly Digest
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!
Wayne Sheffield (b|t) is hosting this month’s T-SQL Tuesday and his topic is Giving Back to the SQL Community. More specifically, he’s asking how each of us is planning on giving something back to the SQL Community in 2015. He offers up a few suggestions, so I’ll start by addressing those and then move on…Read More T-SQL Tuesday #61 – Giving Back
We’re already in the early stages of preparing for our 2015 SQL Saturday. One thing that was missing from this year’s event was local speakers; we just didn’t have many, and I’m hoping we can change that the next time around. For a lot of people (myself included), getting into speaking can be intimidating. Do I…Read More Lightning Talks at SQL Saturday?