Scott has given an example, and Erland is right. It depends. Test both ways for your situation.

Phil has good advice. If the patterns aren't consistent, then use REVERSE and find the first occurrence.

All of these products work well for making, compressing, and restoring backups. I'm biased because I work for Redgate, but I'd suggest you download an eval for different ones and...

I think the dev story in the cloud is hard. I've seen people want to use RDS/Azure SQL DB for dev work, but the backup thing causes pain. This still...

John,

I don't. MS has been very resistant to syntactic sugar, basically anything that isn't hard to program, they don't want to build and support. They think this is why you...

It might be interesting to just see your impressions and experiments. I'd think you present this as "what I learned" rather than "this is what you should do"

I haven't seen a comparison.

that being said, if you're learning it, maybe you want to write one. I'd pay you, even for a series of articles as you learn the...

I would concur that a calendar table is the best choice here. There aren't functions that map out specific dates to a custom calendar. While you can code for this,...

I think Phil is showing a restore of the database from the snapshot, essentially rewinding time.

If you want to update what's in the snapshot with new changed data, you cannot....

Haven't seen that. I did run across this item on learning BigQuery

https://codingisforlosers.com/learn-bigquery-sql/

Bug filed. Not sure why the revisions appear here.

I'm jumping in early, as I haven't yet read Leonard Lobel's blog post. As a developer I am very interested in NoSQL databases, and in particular CosmosDB. However, there's...

I'd assume that the NoSQL data model fits better for very specific approaches, where you can encapsulate a bigger part of data and assign it to a specific user...

Open a case with MS or call a consultant like sqlSkills. I've had similar issues, and what really happens is you have broken pages that the query engine cannot read...

Don't use alias, unless this is defined in the Native client (https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/create-or-delete-a-server-alias-for-use-by-a-client?view=sql-server-ver15)

A DNS entry is a particular type of lookup. Usually this is an A record, which is for...