New Job -> Week 3 -> Creating Alerts
This is part of a series of new job blog posts. You can find them all here. The main goal for week 3: setup much needed alerts on DTU...
2023-03-31 (first published: 2023-03-30)
179 reads
This is part of a series of new job blog posts. You can find them all here. The main goal for week 3: setup much needed alerts on DTU...
2023-03-31 (first published: 2023-03-30)
179 reads
I was planning to write a blog post on how you can find ways to be creative in any technical pursuit. Then, I found out from a friend that...
2023-03-24 (first published: 2023-03-15)
170 reads
Originally, I was going to write a post on troubleshooting SQL Server. This is because I’m writing up and reviewing a lot of documentation at my current job. I’ll...
2023-03-08 (first published: 2023-03-01)
425 reads
I got a call saying the database server is inaccessible because tempdb is full. I get online and try to connect because I want to see the error for...
2023-01-18 (first published: 2023-01-06)
1,083 reads
Why doesn’t SQL Server automatically check for the Group –> Object type when you are adding perms via SSMS? This hangs me up almost every time. I think “omg...
2022-10-27
8 reads
A short story about why standards matter and where they can help you with limiting the off hour calls from others in your organization.
2022-05-06
2,546 reads
published on SQL Server Central https://www.sqlservercentral.com/articles/standards-matter At first, this was going to be a technical article about an index maintenance horror story. I received an off-hours page. The index...
2022-04-21
3 reads
Just a short update. I haven’t blogged since May, and that’s because I’ve been presenting. Now, I have a publishing contract, so that’s keeping me busy. I want to...
2021-12-21
1 reads
We have a fair number of pretty large databases, and I was having a hard time scheduling full integrity checks to run at least once a week. For a...
2021-05-18
17 reads
This came up because a user had db_owner perms and it was only reading from a database and creating a table variable from it. I created a new user...
2021-04-05
5 reads
pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database...
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
Wondering how others keep track of the purpose for SQL Logins? I'm not talking...
Upgrading an instance of SQL Server 2019 to SQL Server 2022 - I am...
SQL Server SSRS 2022. Running into ' SSL Provider, error: 0 - The target...
How can I check what value I used for TEXTSIZE? I ran this code:
SET TEXTSIZE 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers