2018-01-29
57 reads
2018-01-29
57 reads
Kathi Kellenberger wonders what's keeping your business from upgrading.
2017-12-25
51 reads
When I began using LAST_VALUE, the results were not what I expected at all. Read on to learn the secret!
2016-06-03 (first published: 2015-04-14)
26,365 reads
2015-04-27
1,827 reads
2015-04-15
1,933 reads
2015-04-03
1,883 reads
I have several speaking events coming up, and I would love to see you there!
First of all, I'll be...
2012-07-11
1,033 reads
One of my favorite features of SQL Server Management Studio (SSMS) is the ability to run a script on multiple...
2012-03-02
2,498 reads
I drove the over 250 miles from my home in Edwardsville, IL, to attend the SQL Server 87 in Louisville,...
2011-11-02
1,307 reads
Once again I am back at home recovering from another PASS Summit. This year the attendance has exceeded all expectations...
2011-10-16
1,385 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 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