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
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
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
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
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
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.
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
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
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
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
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
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
“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
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
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
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
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.
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
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
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
I came across an article on SQL Server Central written by Claudio Silva (b/t) discussing that you can’t do arithmetic operations on DateTime21 like you can with DateTime. For example: Old Way OrderDate < GETDATE() -1 You need to do something like this: OrderDate < DATEADD(dd, -1, @vOrderDate) Original Article
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
The 101st addition to the SQL monthly blog party is being hosted by Jens Vestergaard (blog/twitter). For the topic this month, Jens has asked which tools are essential to our daily job. Or rather, which tools do I depend on as a DBA. Interesting Topic I would love to say
I have recently been working on tuning a job that purges data out of various tables that are older than 13 months using GetDate(). Pretty straight forward right? Well originally the job consisted of 6 different statements like so: Except, the tables have become so large the generic deletes were
I had a flash of brilliance this week, and that’s a rare thing for me. I came to an understanding with myself that I can’t solve all the world’s problems, most people disagree with me, and if I want to continue to discussing heated topics than I need to remain
This month’s blog topic for TSQL Tuesday is learning goals in 2018 and is being hosted by Mala Mahadevan (blog/twitter). Mala has challenged the SQL community to list out specific learning plans for the upcoming year. It’s an awesome topic for this time of year, especially as we’re slowing a
I think I’m actually going to make this TSQL Tuesday, it’s the first for me in a while. I kind of have a valid excuse, I left my job at the hospital in Denver and took a job in Duluth, MN. So currently I’m in the middle of a cross