File Sizes
There are two scripts I like to use to look at the file sizes on servers. The first one is...
2013-05-14
442 reads
There are two scripts I like to use to look at the file sizes on servers. The first one is...
2013-05-14
442 reads
Don’t trust the name of an index to tell you what it is. The name is wrong, or at least...
2013-05-14
1,397 reads
Sp_who2 is not used by this DBA. That info is amazingly good to have, but I want more. Don’t get...
2013-05-14
852 reads
Copy / Paste formatted text is a nightmare in WordPress. I’m singling out WordPress because I use it, and, from what...
2013-05-13
570 reads
This script looks much more intimidating than the results it produces, so I recommend running it before reading through it. ...
2013-05-11
464 reads
2013-05-10
400 reads
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 50 Years of Microsoft
Comments posted to this topic are about the item Multiple Collations
Comments posted to this topic are about the item Retrieving Data Using the REST...
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