Hidden Killers of SQL Server Performance
I’ve been working with SQL Server for a very long time. Out of the box, SQL Server works great, however there is regular care and feeding that needs to...
2025-03-17
1 reads
I’ve been working with SQL Server for a very long time. Out of the box, SQL Server works great, however there is regular care and feeding that needs to...
2025-03-17
1 reads
Over the years I’ve been called in to work with numerous clients that were hit with ransomware. Even the times that the customer paid the ransom to unlock their...
2025-02-10
A full transaction log can occur for a number of reasons. Typically it is due to the log not being truncated with regular transaction log backups, or something else...
2025-01-15
5 reads
SQL Server has evolved a great deal since I first started working with SQL Server 6.5 in 1998. Unfortunately I continually come across newer systems that are configured with...
2024-12-10
1 reads
In the United States, we have our Thanksgiving this month. This is a time where families come together for a huge meal. For many, it is a time to...
2024-11-11
I often need to shrink database files. I know, ‘shrinking is bad’, however there are situations where it is very much needed. In my line of work, I come...
2024-10-07
3 reads
Many organizations do not have in-house DBAs. This can be due to a number of reasons. Most commonly it is smaller organizations that cannot justify a full time DBA....
2024-09-16
As a data professional, you’ll often get a phone call, email, or trouble ticket that says “SQL Server is slow, my query is slow, or things are slow”. This...
2024-08-12
1 reads
Working with SQL Server over the past 25 years for various organizations all over the world, I usually always find a database server that is well outside of support....
2024-07-15
3 reads
It seems like every few weeks I come across a database server with a very large msdb. After a small amount of investigation work, I determine that the largest...
2024-06-10
By Steve Jones
Many organizations list customer testimonials and quotes on their websites or literature. It makes...
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...
Comments posted to this topic are about the item Life Moves Pretty Fast
Hello SSC, Happy Friday! I have to optimize a process that uses dynamic SQL...
Comments posted to this topic are about the item 50 Years of Microsoft
Can I have a collation expression like this in SQL Server 2022?
... WHERE ColumnA = ( 'abc' COLLATE French_CI_AS) COLLATE French_CS_AS ...See possible answers