HuggyBear

Born and raised in Vancouver, Canada, with a brief excursion to study in Brussels, Melbourne & Washington D.C., Hugo has been working with SQL Server since 1998. He’s busied himself as a DBA since 1999 (with mcdba & mcitp certifications in ‘01 & ‘08 respectively), as independent consultant with his own company, Intellabase Solutions, since 2002 (now part time), and has held various permanent position with Transcontinental, Sun Life Canada, and now Alithya as a consultant. He enjoys writing documentation for quick, safe infrastructure rebuilds and expansions, and most challengingly, propositions to Executives Management on how to improve enterprise Security. He has spoken at SQLteach/DevTeach, Montreal Dot Net User Group, SQLGulf, Vermont User Groups over 5 times, has a blog on SQLServerCentral, and has been recognised as a SQL Server MVP in 2010.
  • Interests: Lately (2019): windfoiling or windsurfing with a Skroka foil....amongst many other supposedly 'extreme' sports, but which are really just the norm for people raised in Lotusland aka Vancouver, BC, lower-mainland region, Sea-to-Sky country as we know it.
  • Blog: http://dbhive.blogspot.com/
  • Jobs: SQL DBA, Data Engineer, Migrator, Clusterer, Security Implementor

All authors

All authors

Blogs

Using Cron in Postgres Flex

By

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

I heard someone say recently that you can’t change a primary key value in...

SQL Server Index Primer

By

Indexes 101: What, Why, and When? “What Is an Index?” I get this question...

Read the latest Blogs

Forums

50 Years of Microsoft

By Steve Jones - SSC Editor

Comments posted to this topic are about the item 50 Years of Microsoft

Multiple Collations

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Collations

Retrieving Data Using the REST API in Data API Builder

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Retrieving Data Using the REST...

Visit the forum

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