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...

It's often a SAN driver/hardware/etc that can cause this, but it could be memory module issues, so movement of the VM an be a pain to diagnose. Get the SAN...

You can't dynamically join all <db name>.sys.database_files for all databases with master.sys.master_files. You can join for a particular db and easily get the sizes that way.

If you want to try...

In a SELECT, there is no late binding of columns. You have to use dynamic SQL, as Phil noted, but there are all sorts of security problems here. You are...