How HADR_SYNC_COMMIT waits can wreak havoc
It has been a decade since I have blogged. Or at least it feels like it. Today I would like...
2015-11-25 (first published: 2015-11-17)
4,283 reads
Roy Ernest
SQL Saturday # 103 in Curacao a Success
On 25th of February 2012, Curacao hosted its first SQL Saturday event. The event was held at the University of...
2012-03-01
2,305 reads
Ready for the new year?
The New Year is just around the corner. Every year I make a resolution. And every time I fail. That...
2011-12-29
2,277 reads
Junior DBA
At our company we have two DBAs to take care of all the databases in the production and QA. It...
2011-12-08
1,466 reads
It was a pleasure to work with the NomCom
With the announcement of the official slate for the BoD election for this year, the job of the NomCom is...
2011-11-30
2,532 reads
SQL Pass Update - Day 1
So far SQL Pass Summit has been great for me. I have had a great time from day one onwards....
2011-10-12
1,737 reads
PASS Summit is almost here
This is my second trip to Seattle for the annual bash. Last year I was a newbie. I did not...
2011-10-07
1,446 reads
Who says you cannot mix business with pleasure?
There is an advice out there that says never to mix business with pleasure. It is not true in all...
2011-09-21
2,001 reads
One hectic month ahead
The SQL Pass community summit is just around the corner. There is so little time and so much to do....
2011-09-07
1,374 reads
Why you should blog more
I was trying to write an article for a long time. Every time I start writing one, I would put...
2011-09-01
1,228 reads
Blogs
The Book of Redgate: Customer Quotes
By Steve Jones
Many organizations list customer testimonials and quotes on their websites or literature. It makes...
Using Cron in Postgres Flex
pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database...
Can I Change a Primary Key Value? #SQLNewBlogger
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
Forums
Parse XML data from SQL table using temp tables and variables
Hello SSC, Happy Friday! I have to optimize a process that uses dynamic SQL...
50 Years of Microsoft
Comments posted to this topic are about the item 50 Years of Microsoft
Multiple Collations
Comments posted to this topic are about the item Multiple Collations
Question of the Day
Multiple Collations
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