Migrating a Large Database
Large database upgrades are stressful, but a little planning and practice can help things go smooth.
2022-04-27
161 reads
Large database upgrades are stressful, but a little planning and practice can help things go smooth.
2022-04-27
161 reads
Building software can seem like a crazy process, especially to a developer who joins a project.
2022-04-25
176 reads
A major outage from Atlassian because of a bad script has Steve thinking about the challenges of recovering from mistakes. When we are making changes to portions of our data and we need to plan for mistakes to occur and ensure we can restore the data.
2022-04-22
167 reads
When do you choose to use one tool or language over another. Steve discussed T-SQL vs. PowerShell.
2022-04-20
140 reads
We used to work in offices, now we work at home. Do we need a third space? Steve does.
2022-04-18
158 reads
This week I noticed a number of changes in the Azure platform from their change feed. Actually, every week has a crazy number of changes across the entire platform, but this week a number of these were related to data and databases. That isn't always the case, but I saw some interesting items. We have […]
2022-04-16
59 reads
Many of us have spent time looking through manuals or the documentation for some software or product. I know I'm on the MS docs site regularly for work, and there is no shortage of times I've used various manuals to help me fix something around the house. We usually use a manual when we want […]
2022-04-15
110 reads
Charts and graphs need a scale to be meaningful. When to include zero in your scale is a question that is more complicated than Steve expected.
2022-04-13
105 reads
A developer has some harsh things to see as he leaves the MySQL team. Is he right?
2022-04-11
201 reads
Some organizations have policies in place to make sure that everything in their IT infrastructure is documented. There are runbooks, procedures, wikis, diagrams, charts, code comments, and more to make sure that knowledge is available if an employee leaves or when disaster strikes. Not only does the documentation exist, but it’s also organized and easy […]
2022-04-09
152 reads
You can find my slidedeck for the session “Introduction to Azure Data Factory” on...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Andy Warren
I drove up to Jacksonville Friday afternoon to allow for bad traffic and immediately...
Hi, Whenever I get an high cpu alert , be it non-working hours or...
I am using .LDF file to get the information about when was DB last...
Ahoi, we are using the ola hallengren scripts to run the weekly index optimizer....