Code Beautifier

2017-04-27 0 Comments

One of the challenges I've faced as a blogger is quickly reproducing code that looks good in HTML. I've tried a few different online code conversion sites, and even a C# library. But I never quite got the results I wanted. I found myself revising the HTML to fix up key words, comments, and operators that sometimes got missed, were the wrong color, or the wrong font. All that HTML editing was tedious and time consuming.

What I really wanted to do was copy my code from SSMS, Visual Studio, or the PowerShell ISE and paste it into my blog so I could spend less time as a web dev and more time writing. Since none of the other tools I found gave me the results I wanted, I wrote my own.


The PowerShell Disconnect

2017-04-16 0 Comments

Dave Mason - SQL Server-The PowerShell Disconnect

Not long ago, I installed the first instance of SQL Server 2016 in a production environment. I ran some scripts to create standard SQL Agent jobs, including one that resulted in this error:

Msg 14234, Level 16, State 1, Procedure sp_verify_subsystem, Line 28
The specified '@subsystem' is invalid (valid values are returned by sp_enum_sqlagent_subsystems).


T-SQL Tuesday #89: The Times They Are A-Changing

2017-04-11 0 Comments

For T-SQL Tuesday #89, Koen Verbeeck (b|t) wants to know how we feel about technology and change. What impact has it had on our jobs, our education, and our psyches? It's a really good topic for us data professionals and Koen gets the ball rolling with some excellent questions.

I touched on this topic pretty heavily not too long ago. Some of you probably already know how I've been feeling lately about all the change happening around us. If I had to sum it up in one word, it would be


Certified And Inexperienced: The Kiss Of Death

2017-04-05 0 Comments

Ask someone that has hired a DBA which is more important: real world experience or education? To be fair, most will say their ideal candidate has a good mix of both. But if you can't get both, what matters more? Without hesitation, the overwhelming response is "Give me the candidate with experience." Why is that? Why is the combination of inexperience and certification the kiss of death?