Search results

Think of an Orders Table where the Total is calc'd & value is not stored. I think I'm right in saying "only a column's data can be encrypted in SSMS". So it's not possible to protect your math in calculated fields. It also seems that an encrypted Stored Procedures weak-spot is the SP needs to...

I would imagine Doc is referring to 'access' in a protocol context; not MS Access. But you're right that I'm not really hooked up to MS Access & this is relating purely between SSMS-22 & Azure. Thanks Doc, my trial with Azure has ran-out but in the interest of learning I didn't have an...

I've purchased many licenses from Google's search results (not directly from the manufacturer). I wouldn't consider the firm's 'retail price' of a firm with an annual turnover of $282 billion to be what they pretend it to be; if that was an accurate reflection of it's true value they would not...

Thanks for doing that Albert, really appreciated. Yes must've been Azure 's latency on the most basic of Resource Group package spec... As per nr-22 ditched Azure for the time being as it was too slow to develop on. Locally much faster, which was always going to be the case for obvious reason...

Thanks Tom, ah I see, of course you have ltd info to go from. Yes it would just be to encrypt my intellectual property is all, but a good point to make as I was unaware.

Thanks Tom, 'holding back user data', was unaware. It would be a username, an ID for me to ascertain they have not exceeded the permitted nr of users so don't think this would constitute 'holding back user data'. I certainly don't want to breaking any laws so thank you for making me aware.

Thanks Isaac, I did think of hosting a CSV on a server & intermittently check that the user was permitted. The challenges are not exposing other customer's data in the permitted users table online/ sharepoint, which I would think would be possible via encryption. Stored Procedures - thanks...

Thank you Isaac, was what I was hoping to hear. It is a brilliant application.

Thanks sonic8, noted & apologies for my denseness. I thought it may be possible for me to create the user/ number of users & assign their names bespoke to whom buys the product but hide the 'unrestricted administrator account, deploy the application with default settings to hide the privileged...

Ok, in order to be able to sell the application outright I think I may be better to deploy with SSMS as the back-end installed locally/ LAN. I should be able to avoid reduce privileges by installing/ deploying via a script & create a restricted principal/ type user with restricted privileges in...

@Albert D. Kallal your posts always high-calibre, we are lucky to have you on the forum. I missed this completely & still don't see it; sorry @Isaac for bloating your thread with irrelevance. I read the OP as a static website builder, & if that was the case & there was no benefit to using a...

Thanks sonic8, that's very helpful. Found some courses on Azure which I'm looking into now to try to get a grasp: AZ900 MSN - Beginner Azure AZ104 - Azure Administrator

Thanks Ron, ah db level in Azure seems the way to go. Thanks Sonic, I was hoping that would not be the case as I'm just a learner & would've been able to just set permissions covariantly to objects/ schemas... Concentrating on just getting it working atm is what I really hope is possible. I...

I've got plenty to spare, it must be something else. Editing objects was really slow in using an Azure Db for me. Things definitely improved as stated in recent posts thanks to input from forum. However it was too slow to continue developing. I changed to a local instance of SSMS 22 with near...

Thanks Minty, you've got double my RAM. Hmmm I wonder if things will improve or this is as good as it gets for me.

Been working on the premise that if selling an .accde with an Azure db managed through SSMS 22, you can restrict important info/ stored procedures/ tables/ queries... from the customer. I imagine through creating different users/ schema's... creating an admin user account & encrypting data/...

It certainly is much better & the input rec'd has definitely helped (thanks all). Thanks Minty, really appreciated. I'm on minimum package; 5 DTU's; but don't think that's the issue as I'll be doing pretty basic stuff compared to you guys. Only 50 tables & < 20 rows in there; most tables have no...

Old thread & you're probably done now, but in case; I built several of mine handcoded < 10 years ago & yeilds far better SEO results than a templated builder/ type thing. Be careful who you buy the domain from, most of them are con merchants, need to make sure you own the domain. I used...

Thanks Tom, I would've thought that would've got done when reinstalling but giving it a go (EDIT actually not nowadays really, developers rarely delete all traces of their apps/ settings these days) I got warnings with GitHub. Just in case somewhere is aware of anything like this conflicting...

Thanks Tom & for the reasurrance something is wrong. I must fix it now as it's slowing me down too much. Yes I was set to relevant region (UK). I'm experiencing identical issues to this thread. So I changed Connection Protocol to TCP/IP & checked Trust Certificate; still no joy. Ping results...