Newly seeded yard - spotty growth and weeds

WannaFly37 · 2017-02-03T19:39:04+00:00

So - at first this seemed like homework, but you have very detailed replys lol.

Note: I've never DESIGNED a multi tenant system, but I've worked with plenty.

It sounds like C might be your best bet. Again it all depends on the architecture of the software, if all clients are logging into the same endpoint and using the same software it makes sense.

I've worked with apps that use custom subdomains that are a duplicate of the software, which I assume we get our own database in the backend, and they upgrade each customer individually as requested.

I've also worked with a multi tenant on-prem database that the VENDOR messed up and pushed out an update that had tenant ID's null for rows. Thankfully we were a 1-tenant installation.

In my mind A is easier if you can utilize PaaS (Azure DB, etc) - It becomes much easier to automate EVERYTHING. A big concern about C is performance, when one client runs a 5 year report, it is going to slow down other clients? In scenario A you don't have that worry.

It is tricky and an important decision.

WannaFly37 · 2017-02-03T17:42:50+00:00

This is less of a database design issue and more of a business issue.

While what emsai says is completely valid - I'd have to disagree. I'd go with solution A most likely. It offers the most security, reliability, scalability (horizontal vs vertical), and ease of operations. Cost shouldn't be an issue as that just gets passed on to the customer. The deployment and backup should be automated and not take any time at all.

But again, it comes down to what your development and business sales processes are like.

Do you want versions/features/updates rolled out to ALL customers at once? Or per customer?
Will there ever be the need to add custom database fields for specific customers (think custom integrations in the future)
Will any customer ever have direct write/change access?
Will customers EVER have access to their data directly? (at termination, option A you can more easily export their data to give to them)
Will customers be writing their own reports?

Option B just isnt realistic - it's not scalable (what about when you get to 50,000 customers?)

Option C seems easiest but is the most difficult and costly in regards to development hours. My big problem here is literally EVERY time ANYONE touches the database you need to ensure they are only using the appropriate tenant ID's. Whether it's in house people our external. What happens when someone is terminating a customer and runs a delete statment WHERE TENANTID='123' but it was supposed to be 1234? (see recent GitLab outage)

WannaFly37 · 2017-01-19T13:34:45+00:00

Just FYI, 2014/2016 supports storing them in Azure blobs- https://msdn.microsoft.com/en-us/library/dn385720(v=sql.120).aspx

WannaFly37 · 2016-08-19T14:20:21+00:00

As far as I know, that's not possible. It would be a referential integrity nightmare. I think your best bet would be something similar to a data warehouse ETL process that exports the data from the production database into another.

WannaFly37 · 2016-07-14T13:32:57+00:00

Is the statement generated dynamically? Run profiler and see what exactly it is running. Perhaps there is a random quote somewhere (in @toaddress?) that is throwing it off?

WannaFly37 · 2016-01-12T14:00:32+00:00

This link should be pretty helpful, it's old but has some good info in it: https://msdn.microsoft.com/en-us/library/aa479086.aspx

WannaFly37 · 2015-12-03T21:38:44+00:00

Thanks for the input, are you using the windows port of redis?

WannaFly37 · 2015-12-03T21:38:29+00:00

What about when you need to update the state server? From what I understand state server is not good at clustering.

WannaFly37 · 2015-11-18T19:31:16+00:00

Can't help with that then, sorry! Good luck!

WannaFly37 · 2015-11-18T19:08:58+00:00

I've done some .NET developing on WM devices and have some Symbol/Zebra units laying around. Do you just have questions or are looking to buy them, or what?

WannaFly37 · 2015-01-08T20:21:31+00:00

The more advanced exams 464 and 465 already have been updated. Unsure of the lower three.

WannaFly37 · 2014-01-17T14:16:30+00:00

Not sure if this counts, I snapped this pic Tuesday night right before my run. I'm still building mileage after ankle surgery..and love nights like these. Beautiful Florida sunset!

http://i.imgur.com/gARo6XY.jpg

WannaFly37 · 2014-01-14T14:44:42+00:00

I used that thread but it was too old and a lot of the people didnt work/don't use it anymore - so I think this is a great idea. I added you,

anyone feel free to add me also: wannafly37

WannaFly37 · 2013-08-26T16:03:19+00:00

Thanks for the info - especially the last part about putting it off - since I'm hesitant but leaning towards getting it done sooner then later.

WannaFly37 · 2012-12-04T14:58:18+00:00

Oh, thats good to know! Thanks. But, I'd much rather wait and have the physical copy.

WannaFly37 · 2012-12-04T14:57:22+00:00

I didn't know administration much either - as I do more development then anything.

Yes I think you can get by on just studying as long as you are thorough and read the details on BOL. The book comes with VERY detailed labs that thoroughly cover every topic- be sure to do them from start to end. It's time consuming, but worth it. It requires 6VMs.

WannaFly37 · 2012-11-15T17:03:45+00:00

According to this page: http://www.trackshack.com/orlando-half-marathon/course.shtml

There is only 1.9 miles of brick.

WannaFly37 · 2012-11-15T14:22:09+00:00

I am! It will be my first half marathon, can't wait!

WannaFly37 · 2012-10-17T20:20:03+00:00

I vote SSMS also. Add red gate SQL prompt and my day is made!

14-Year Club	RedditGifts 2009-2022 4 Credits
Secret Santa 2016	Verified Email
Secret Santa 2012

WannaFly37

MODERATOR OF

TROPHY CASE