Skip to content
  • twitter
  • github
  • linkedin

SQL-Mac

trekking through databases and code

  • Home
  • DBA
    • Collection of Resources
  • Database
  • Dev
    • SQL Code
  • Technology
  • Projects
    • Home DevOps

Becoming an EMT

Posted on December 23, 2022December 23, 2022 by Garland MacNeill
EMT Star of Life

Since the world of work has changed so much since the pandemic, I, like so many others, have become a full time work from home employee. Like anything, there are pros and cons to this – I have lots of flexibility but I do tend to put in more hours.

Read More
SQLMAC Leave a comment

My experience at re:Invent 2022 – Part 1

Posted on December 8, 2022December 21, 2022 by Garland MacNeill
AWS re:Invent 2022

I attended AWS re:Invent 2022 and this is the blog series based on my experince, things I learned, with some of the mistakes I My experience at re:Invent 2022 – Part 2 I know it’s been a while since I’ve posted, and there are a lot of good reasons for

Read More
Events aws, re:invent Leave a comment

My experience at re:Invent 2022 – Part 2

Posted on December 8, 2022December 21, 2022 by Garland MacNeill
Swag Desk

Part two of my experience at re:Invent 2022 My experience at re:Invent 2022 – Part 1 I have a pretty established rountine when I get up in the morning. First thing first, make the coffee and pateintly wait for God’s go juice to help get me going with wanting to

Read More
Events aws, re:invent Leave a comment

Home network and lab overhaul.

Posted on July 27, 2022December 21, 2022 by Garland MacNeill
Infrastructure as Code

  Over the last few months, I’ve been tinkering with different OS’es, databases, and other stuff that requires the spinning up and down of VMs. Which has led to a number of headaches regarding DNS, annoyance with the lack of SSL certs internally, and just a general frustration with how

Read More
Home DevOps devops, learning Leave a comment

Obsidian and DevOps

Posted on April 3, 2022April 3, 2022 by Garland MacNeill
busy

It’s been another long stretch where I haven’t blogged, and that lies with a lack of discipline on my part. There’s also a part of me that hasn’t known what to write about, maybe that’s because I have been having a bit of an identity crisis lately. But I suppose

Read More
DBA Leave a comment

Adding Files to TempDb

Posted on December 31, 2021December 31, 2021 by Garland MacNeill
expand server and system

  The number of files TempDb has will affect the performance of your SQL server. Often times, and prior to SQL 2016, adding files to TempDb is the proper course of action. In SQL 2016+, the SQL installer correctly adds the number of files to core ratio – at least

Read More
Database SQL Server, tempdb Leave a comment

Frustration with work

Posted on December 28, 2021January 1, 2022 by Garland MacNeill
frustration

I think the last two years have finally caught up with me and is behind my current feelings of frustration. Well to be honest the last four years really. When my wife and I left Denver to move to our cabin in Northern Wisconsin four years ago, it was because

Read More
DBA Leave a comment

Operation requires server to be a registered server

Posted on December 21, 2021December 23, 2021 by Garland MacNeill

I’m working on setting up an upgrade/migration, and one of the tools I have embraced of late is Multiserver jobs for easy(ier) job administration, especially when it comes to Availability Groups. I was growing impatient and frustrated with trying to keep multiple jobs in sync in just one Availability Group

Read More
Database sql agent, SQL Server Leave a comment

Oh wow, what a year…

Posted on November 24, 2021January 1, 2022 by Garland MacNeill

This year has been, well….intense. I’ve been extremely busy, and extremely overworked. It wasn’t until I got a chance to go to Yellowstone and unplug for a few days that I realized just how hard this year has been. I’m thankful that the end of the year is here, which

Read More
DBA Leave a comment

Migrating my Blog

Posted on February 10, 2021January 1, 2022 by Garland MacNeill
Moving my blog

For a while, I have been unhappy with my blog. I don’t know if it’s just me being picky or what. I have gone back and looked at some of the posts, and I am very disappointed in myself for “creating” such … drivel. Anyway, that’s not the focus of

Read More
Technology Leave a comment

2020 changed everything

Posted on January 22, 2021January 1, 2022 by Garland MacNeill
change in 2020

The last year has been wild and it seemes everything changed. I was hopeful 2021 would get off to a better start than 2020, but alas, that doesn’t seem to the case. So many things have changed in the last year, it’s almost impossible to keep track of them all.

Read More
DBA Leave a comment

Error: SQL Replication – Remote Server does not exist, or not designated

Posted on October 13, 2020December 23, 2021 by Garland MacNeill

Here’s a quick post to remind myself and others, to check ALL of the permissions when working with replication.  For the past couple of days, I’ve been working on getting transactional replication set up between a couple of servers in between other projects I’ve been working on. For the last

Read More
Database replication Leave a comment

Don’t compromise relationships

Posted on May 15, 2020December 28, 2021 by Garland MacNeill

Today, I’m not thankful that it’s Friday, although I am happy about it. Today I am thankful for the wisdom of Grant Fritchey (b/ t). No Grant didn’t help me with any kind of problem, at least directly. Hell, I have never even met the man in person. No, I’m

Read More
DBA career, DBA Leave a comment

Be Wary of Windows Firewall

Posted on May 12, 2020January 1, 2022 by Garland MacNeill

I started of setting up an SQL Availablity Group but quickly ran into problems caused by windows firewall.  After getting the environment setup, I performed a failover test, verified everything was working okay. After failing back over to the original primary, I added a database to the availability group via

Read More
DBA availability group, firewall Leave a comment

Adjusting to Working from Home

Posted on March 24, 2020December 28, 2021 by Garland MacNeill

As a DBA, working from home is not a new concept nor a new experience, I do it a lot. However, this shift to working from home due to the office being closed for Covid-19 is a little different. First off, I’m enjoying getting my commute time back and saving

Read More
DBA wfh Leave a comment

DBATools

Posted on March 20, 2020December 28, 2021 by Garland MacNeill

I don’t know why I am slow to take up new tools, but I am. I recently, like back in December, began working with DBATools. In case you’re not familiar, DBATools is a PowerShell module assembled by the community over at DBATools.io. This module, oh this wonderful module, makes some

Read More
DBA DBA, powershell, tools Leave a comment

Just fix it

Posted on February 11, 2020December 22, 2021 by Garland MacNeill

Kids, it’s 2020. That means it is way past time to stop kicking the can down the road. Most of us in IT have been around long enough to see us shift from a centralized CPU (mainframes) to decentralized (client/server) architectures back to a centralized approach again (cloud). That means

Read More
Technology DBA Leave a comment

New Decade, More Change

Posted on January 17, 2020January 1, 2022 by Garland MacNeill

“The Only Thing That Is Constant Is Change ” – Heraclitus The rate of change is always about the same, as fast as possible, but the directions have shifted back on themselves. Twenty years ago, when I was starting out in IT, the focus was to move off the centralized

Read More
DBA devops, learning Leave a comment

Cloud Computing, but where’s the ground?

Posted on November 13, 2019January 1, 2022 by Garland MacNeill

Everyone has seen the meme that the cloud is just someone else’s computer. Or that people don’t understand the cloud. I think either has become too simplistic of an explanation. The fact of the matter is, we all have embraced the cloud in some fashion. No ground under the cloud

Read More
Technology backups, cloud Leave a comment

Can’t we just get along?

Posted on November 1, 2019December 23, 2021 by Garland MacNeill

When it comes to working with other people it is always best to remember that others are not always on the same page. In fact, when dealing with others that work alongside you, it is imperative to remember they are most likely to see and evaluate issues and opportunities differently

Read More
DBA career, office environment Leave a comment

SQLSaturday #913 Minnesota

Posted on October 13, 2019December 26, 2021 by Garland MacNeill

It’s been a couple of years since I have been able to attend a SQL Saturday. I was grateful I was able to make it this year. This year however was a first for me, it was my first SQL Saturday in Minnesota and the first time I went to

Read More
DBA SQLsaturday Leave a comment

Always On Failover Cluster Instance

Posted on August 12, 2019December 23, 2021 by Garland MacNeill

Recently, I was working with a gentleman in our IT department and we were discussing adding redundancy to a couple of SQL Servers that were used for web apps. Turns out, VMware’s disk consolidation can, and will, take a server offline. That tends to make customers unhappy, and rightly so.

Read More
DBA availability group, microsoft Leave a comment

Year end review and thankful

Posted on November 22, 2018January 1, 2022 by Garland MacNeill

It’s Thanksgiving Day and before we know it, Christmas and the New Year will be upon us. 2018 hasn’t worked out as I planned. In fact, 2018 has been a difficult year for me personally. The first half of the year Jan – April was rough for a number of

Read More
DBA Leave a comment

Office Conditions

Posted on July 19, 2018December 23, 2021 by Garland MacNeill

I have worked in an office environment for a long time. Going on twenty years in fact. I have worked in a number of different types of environments, but cubicles have been the standard. In fact, in my career I have only had a walled office a couple of times

Read More
Technology office environment Leave a comment

Expanding horizons a touch, looking at Postgres

Posted on May 24, 2018December 23, 2021 by Garland MacNeill

This week I got asked to help a developer figure out why a failover wasn’t working on a Postgres cluster. Interesting enough I guess. Especially because I don’t know anything about Postgres. Good time to learn I guess? I don’t know. Anyway, I accepted the directive and started trying to

Read More
Database postgres Leave a comment

DateTime2 not like DateTime

Posted on April 20, 2018December 23, 2022 by Garland MacNeill

I came across an article on SQL Server Central written by Claudio Silva (b/t) discussing that you can’t do arithmetic operations on DateTime2 like you can with DateTime. For example: Old Way OrderDate < GETDATE() -1 You need to do something like this: OrderDate < DATEADD(dd, -1, @vOrderDate)  

SQL Resources Leave a comment

Database Administration is evolving

Posted on April 12, 2018December 23, 2021 by Garland MacNeill

Steve Jones (t|b) wrote a blog post talking about the death of the title Database Administrator. Mind you, he was talking about the title of DBA, not the actual job of being a DBA. Semantics, right? If you look across the inter-webs, the death of the DBA has been a

Read More
DBA career Leave a comment
  • 1
  • 2
  • Next →
Built with BoldGrid
We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
.
Cookie SettingsAccept
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
CookieDurationDescription
cookielawinfo-checkbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Functional
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
Advertisement
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
SAVE & ACCEPT