Quarantining is HARD!

For the last year (almost to the date), I have been working from home. At first I thought it would be temporary. I thought it would be “neat”. I thought I could be more productive since I would not be driving 2+ hours a day. Boy was I wrong!

Let me set the record straight, quarantining is HARD! Harder than going to the office. I do enjoy not being on the road for 2+ hours a day and I do enjoy not spending $150 in gas week (I drive a truck). Staying focused is not easy when you have 4 cats vying for your attention.

In November, I started a job with a new company that hired me as 100% remote. So, it seems I will be “quarantining” even after the quarantine period is over.

But, I am also going to do my best to get back on the preverible horse and ride! I do enjoy blogging and I have a tremendous amount of learning to do when it comes to PowerShell and Azure Cloud technologies.

In the coming week, I hope to outline a blogging goal for the next 3 months (baby steps). Hopefully, I can stick with this since I have 2 extra hours a week, right?

I hope to also get back involved in presenting topics to virtual groups, in person groups and conferences. Keep a loog out, you might find me here soon Data Architecture Virtual Group (davg.org). But, first comes baby step #1: time table/outline for blogging!

stay tuned.

Don’t forget me when I’m gone!

It has been almost exactly one year since my last post and quite frankly, I am embarassed, ashamed and down right just feeling close to failure.

But I hope to change that!

My last post announced that I was going to document my learning with PowerShell. Since then, SQL 2019 has been released and there are so many new “toys” with SQL! But before I go into that, I really must finish what I started.

Today, I not only downloaded SQL 2019 Developer Edition to install, but I also actually installed DB Tools for PowerShell!!!

Let’s get this Party Started!!!

Learning something new!

old-dog-new-tricks

You all know the old saying, “Can’t teach an old dog new tricks”. Well I am here to tell you, I AM old (at least in the IT world) and I can learn new tricks.

After study, testing, studying and testing; I finally passed enough exams to earn my Microsoft Certified Solutions Expert: Data Management and Analytics Certification. (Yeah me!). This is not to brag and this was not required of my job, but a personal endeavor for me to complete it. Yes, I know some people put zero stock in MSFT exams and certificaitons and I understand that, but again this was a personal goal.

So what’s next?

I know in the IT world if you are not always learning something new you will be left behind and become a dinasaur real quick. Since my current job role is primarily “to keep the engine running” and we have over 100 instances of SQL; I felt I needed to expand my toolbelt. The first logical option is Powershell for SQL and DBAtools (http://dbatools.io)

I know there are 100s if not 1000s of blog posts about SQL Powershell, but I hope to document this learning (i.e. take notes) and hopefully I can retain some of this information, because you know I am getting old and such!

Missing in Action (not really)

I know it has been a while since my last post, but when one is working, I mean really working, a full time job, plus kids, hobbies, and everything else, where does one find time to blog???

My work though is allowing me to learn new things, delve into different areas and become more proficient with SQL 3rd party tools.

Right now I am working on a T-SQL security report. A simple, or not so simple, batch of t-sql that will provide 2 options: 1) full or 2) deficiencies.

Option 1 will give you a list of every server principal in the system and what permissions it has, all the way down to the object level. Option 2 will only provide you with the things that need to be remedied based on security best practices.