Re: Azure Table query "not null"

On 4 March 2016 at 18:03, Greg Keogh wrote: > Folks, anyone using Azure Tables Storage in anger? I really like it, simple > and effective. > > What is the query syntax equivalent of SQL "not null", that is, a row has a > named property? I have a table with tens of thousands of

Re: [OT] Windows.old folder

> > lol 20 gigawatts. Hate to see your power bill. [image: ] > And remember that you've got to pronounce it like The Doc in *Back To the Future* -- *GK*

RE: [OT] Windows.old folder

This will be from the 1511 update that happened to your machine a short while ago. It allows you to do a roll-back to the previous Windows 10 installation. From memory, you can use the Disk Cleanup Tool (diskmgr) to remove it. Otherwise, I believe it gets automatically removed after 30 days or

Re: [OT] Windows.old folder

lol 20 gigawatts. Hate to see your power bill. [] From: ozdotnet-boun...@ozdotnet.com on behalf of Greg Keogh Sent: Monday, 7 March 2016 6:50 AM To: ozDotNet Subject: Re: [OT] Windows.old folder Ian, I

RE: Azure Table query "not null"

“It becomes a technical quiz at times to figure out how to use the pair of string keys effectively. You can finish up putting all of the row data into the keys! One of my live tables has a natural triple compound key, simple in a SQL schema, but in the table I made the PartitionKey one value

Re: Azure Table query "not null"

OData may have a "null", but ATS certainly doesn't have the concept, or a schema, so I'm sympathetic to the fact that IS NOT NULL will not have any kind of direct efficient equivalent. However ... I need some way of finding all the rows with an ErrorMessage property. If there is no way of doing

RE: Azure Table query "not null"

Hi Greg, If you’re after simple, what does the Azure SQL DB T-SQL interface make hard? You don’t even need any NuGet package to work with it. They set up and run the DB. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under |

Re: Azure Table query "not null"

Hi Ian et al, I reckon most of the replies in the article are spot on regarding price, capacity, speed, transactions, etc (except for the last person who hates Table Storage for reasons I don't think are justifiable). You have to know in your bones if your data is *relational* (normalisable) or

RE: Azure Table query "not null"

GregL, thanks for the broad-ranging comments. It’s interesting that many of the discussions (Stackoverflow and elsewhere) get stuck on “to null or not to null”, or a black-and-white discussion about SQL vs NoSQL databases (with little differentiation between flavours of either). Some of them

RE: Azure Table query "not null"

Hi Ian, It’s a tough question. For me, the biggest issue is where the querying really will happen. If 100% of the querying will happen in the application, and every object will just be persisted to the table storage and rehydrated before querying, then a table might suit. That usually leads

RE: [OT] Windows.old folder

Greg, when the 15-11-2015 Windows 10 update (which is sometimes likened to a .1 update)occurred, all update records that you can see when back to zero so to speak. But it doesn’t create a Windows.old (or mine haven’t) – that is typical of an upgrade that can back off” to the previous installed

RE: Azure Table query "not null"

If it's NULL, why would you store it at all? Surely the lack of a value is NULL. In SQL Server when they issue XML, they have an option for a way to represent NULL. Normally they just omit the attribute. They normally only do that in case someone is trying to derive the schema from the data. In

[OT] Windows.old folder

Folks, probably a Friday topic, but FYI ... I was doing some Sunday evening backups and cleanups and I noticed a Windows.old folder taking about 20GB with ~12 files in it! Now the weird thing is that I have no clear idea when or where this came from. I didn't run or accept any major upgrades,