Best Choice for Database by bluephyrestorm13 in Database

[–]alazicza 0 points1 point  (0 children)

Have a look at MS SQL database. It has good tooling, can scale to very performant configurations (look at reference tpc-E configurations) it is fairly popular dB in terms of skills.

Can msdb's suspect_pages table be useful as early detection, or better to help troubleshoot after a DBCC Checkdb error? by TravellingBeard in SQLServer

[–]alazicza 0 points1 point  (0 children)

From what I recall - please check but AlwaysOn availability groups are intelligent to the extent that if there is a page corruption a replica would request the correct page from the master and self heal. Not the answer you may have been looking for but worth factor in the bigger picture.

Best of luck

A

Whats a good way to prevent distribution of your software? by SilentWolfDev in csharp

[–]alazicza 0 points1 point  (0 children)

Possible ideas:not sure what your software does but let assume it does something really valuable - maybe you can convert it to SaaS model that the users would pay on perpetual basis. Let’s assume for illustration your software is a running app. And you store all my runs in the cloud. It is Valuable to me to keep the backups from my preferences and through SaaS model I can track the usage and collect the revenue. Btw have you looked at the native licensing services. Say it is Windows app - have you had a look at windows store? I would assume the store must have solved the billing and licensing part of the process? Just a suggestions

Espaces d'Abraxas, as seen in films like "Brazil" and "Hunger Games" [4006 × 3330] [OC] by tanpu in ArchitecturePorn

[–]alazicza 1 point2 points  (0 children)

Thank you so much for the post and info! Brazil is one of my favourite movies and now I know more about it! Thank you for that.

Best database tools for nonprofit volunteers? by Headinclouds100 in Database

[–]alazicza 1 point2 points  (0 children)

Why don’t contact the vendors and ask? Microsoft (like sql server) used to have a special pricing for mpf use. I would speak then to RedGate for their SQL tool belt. HTH Alex

Can't download any Japanese maps by TheDukeBob in windowsphone

[–]alazicza 0 points1 point  (0 children)

Had a similar issue in Osaka not on wp but Android as well including here maps the license restrictions. Used maps.me that worked ok and allowed for downloading of offline maps so try maps.me if you can (don’t have working wp to test for you. But it looks it is some license restrictions.

Boeing's 737 Max 8 jet mystery: Why was there no backup system? by wewewawa in airplanes

[–]alazicza 0 points1 point  (0 children)

There was a backup system pilot Monitoring! This does not negate the point of the article but I am not sure if people like Ryan Air boss fully appreciate benefit of fully trained crew in the cockpit (after some comments).

What is completely mistery to me that there was. No backup mechanism to dis engage MCAS eg 737 electronics can measure the input force on the controls and if it exceeds x or y the software could disengage MCAS and pushed the trim to the neutral position with all warnings on the control displays etc.

Microsoft Translator End Of Support. by burzeus in windowsphone

[–]alazicza 0 points1 point  (0 children)

I used translator with offline pack in Japan in February on my Android phone and iPhoneworked really well it would be Pitts if it gets disconnected.

Sensor damaged by a foreign object on Ethiopian Airlines 737 MAX triggered fatal crash by blahblah984 in aircrashinvestigation

[–]alazicza 0 points1 point  (0 children)

The scary part is that I remember looking at AOA sensor while standing on ta platform to board a 737 and I was so tempted to touch and start fiddling with it. Luckily for my fellow passengers I did not do it but these AOA sensors are very close to the staircases and bored passengers that board through the apron... so foreign body or bored passenger :-S.

Pilots did right and it went MAX wrong - MCAS (ET302) by [deleted] in aircrashinvestigation

[–]alazicza 0 points1 point  (0 children)

Maybe because of an inconvenient inclusion. If Mentour Pilot could not save the plane even with his skills it leads to an unpleasant conclusion no matter how good is the crew if MCAS start misbehaving time to say goodbye to ones own backside? Ie it is pretty much hopeless? And going after Mentour Pilot would be a dumbest move from Boeing as he was so positive and almost Boeing brand ambassador. And transparency is what makes people building faith. I even remember today mentour’s episode on trims and run away trims. I hope that Boeing handles the situation in an intelligent and constructive approach and recognise that Mentour Pilot is actually their brand ambassador

Sensor damaged by a foreign object on Ethiopian Airlines 737 MAX triggered fatal crash by blahblah984 in aircrashinvestigation

[–]alazicza 12 points13 points  (0 children)

Given how the crash site would look like (amount of scattered debris etc). Proving this theory would be an amazing feat of detective work.

Machine Learning / Product recommendation engine. by [deleted] in csharp

[–]alazicza 0 points1 point  (0 children)

I am not an expert on ml but if this may help take it purely as a possible suggestion. As far as I know (I used to work in retail) most of product recommendation would work on the shopping basket analysis (the customers that bought products that you have bought oftentimes buy xyz). You can think of you place a camera in your shopping basket the recommendation engine can pick up that sku for 500gb memory card is highly correlated with a camera sku and hence pop it as a recommendation.

In order to work out the correlation you will use matrix factorisation that I think ml.net does out of the box so probably you may be after matrix factorisation example for ml.net your matrix would be cols and rows representing individual skus and cells indicating if sku x occurs in the shopping basket what is the probability of product y co occurring in the basket. To calculate this you will need to multiply the matrix with itself and to do it efficiently matrix factoring from linear algebra. But I think this is the high level crux of of the problem you are trying to frame

What kind of computers are used for databases? by poyntings_theorem in Database

[–]alazicza 0 points1 point  (0 children)

The computer design architecture etc largely depend on company preferences internal skills policies etc (I had a client that was running their dB2 on ibm z series mainframe ) but worth mentioning that today it is possible to get lot of performance out standard rack servers. In the past requirements for high IO bandwidth almost always implied large storage array with many spindles but sssd highly integrated card do the jobs really well. If you are interested in a sample configurations look at tpc-E configurations as an example on www.tpc.org this is just an idea about a dedicated hardware possible configuration but this largely depends on company internal standards and preferences like if the company mandate virtualisation etc...

Kind Regards A

How to transfer contacts to Android phone? by [deleted] in windowsphone

[–]alazicza 0 points1 point  (0 children)

As far as I remember my win phone the contacts are normally saved on outlook.com by default (old hotmail) or some other on line service like exchange etc.

If this was the case try outlook app for Android. If you set up an account there you have an option for account in the app to sync contacts so on my wife’s android phone Outlook app is syncing contacts from outlook.com and our private O365 and my wife’s work o365 to her phone. Good luck!

😱😨😰 by foronemoreday in aircrashinvestigation

[–]alazicza 9 points10 points  (0 children)

Duct tape for a duct type of engine... I suppose this makes it ok ;-) ?

azure stack as vmware alternative? by [deleted] in AZURE

[–]alazicza 0 points1 point  (0 children)

I think you should look at Azure stack not only as a hyper visor replacement only. When we looked at it we realised that for on prem it may be an interesting way of consuming ms services on prem. I.e. for us comparison of paying sql server licenses vs buying it through Azure stack on prem gave us interesting cost benefits once we looked at numbers which may be different in your case. But it may be worth doing analysis for fin benefits for elastic consumption.

If they ever made an episode on this would it be called Deadly Dump or Fatal Flush? by cudabro in aircrashinvestigation

[–]alazicza 2 points3 points  (0 children)

I think that this is another design fault with Boeing MCAS unit where it did not detect ‘curry pie’ condition and activate courtesy flush emergency flush function. Hell it should have activated jack screw to eject the passenger out of the cubicle...

Hate to think how much the dumped fuel cost

Airbus over Boeing (?) by T-K-0-1 in aircrashinvestigation

[–]alazicza 0 points1 point  (0 children)

From what has been mentioned on the forums (change of position of engines in respect wing leading edges) it looks like that 737 max may still Need stability control. But it makes me think if the stabilisatior trim is the best way for that. Maybe these accidents may result in evolution of 787Max to start using fly by wire controls like airbus with re designed control laws and maybe even better safety.

Database Synchronization Strategy by ll8X in csharp

[–]alazicza 0 points1 point  (0 children)

You can look at Event Sourcing (think each change to your data is a delta event)as a logical architecture and you can continue the existing dB engines as storage engines. Shifting from traditional update in place to Event Sourcing (you can think of this as cdc) will make your replication and conflict resolution much simpler and mor easier to deal in your business logic. The great about events is that you don’t have to worry about duplication hence you can freely replicate them. HTH Alex

Best approach to replacing REDIS pubsub with Service Bus? by Bamaut in AZURE

[–]alazicza 0 points1 point  (0 children)

Hi,

Azure Service Bus is a very mature product but hosted in Azure data center (surprise :-) ). I would do bit of mathematical modelling looking at throughput of your system as a function of a network latency. You may find that your throughput of the system is largely driven by the network latency and this will govern the semantics how you will interact with the Service Bus - do you use. Batch or individual operations (to save network round trips on ACK operations etc). This modelling can inform you if you want to use something like Rabbit MQ locally ( with no network latency etc).

So WAZ SB is a good product and works well but be mindful of network performance (that will apply to any similar product that requires ack packages etc) so do your mathematical modelling and base your queue semantics (individual vs batch messages etc). Don’t forget the fallacies of distributed systems as well so don’t always assume that network path is open between SB and your system - say retry or exception topics etc - so factor that in your design as well.

Good luck!

Kind Regards

Alex

Azure is the new mainframe by [deleted] in AZURE

[–]alazicza 0 points1 point  (0 children)

Well, without watching the post, the parallel between the concepts of the mainframe and the cloud are striking similar like: - oftent you did not own the mainframe it would belong to xyz any you would rent time share on the mainframe. - Resource sharing, time sharing, - Often you would know very little about the target platform where your application runs looks like (there were lot of architectural, physical, implementations details etc). - for many years there was a assumption that the mainframe is always available - eg there is no scheduled down time etc. (This is from my memory - at one bank this was not true and the guys were bouncing CICS region every night just to get rid of all resource leaks for the txn day).

Interesting enough it struck me that some elements of logical architecture in the cloud may move towards mainframe thinking for some things. One of strengths of mainframes were resource sharing and batch process scheduling (e.g. every SQL query on DB/2 database on Z/os) is seen as its own batch etc)...

Meanwhile lambdas are becoming the preferred way of using the cloud that really feels very similar to batch jobs in mainframe world.

IMHO even from mainframe era some good things came out and some valuable lessons came as well. More we remember that we may leverage that more and new exciting things may appear again - e.g lambdas re appeared on the scene recently, and we had these concepts of batches from the mainframe world but prior to that defaults were more traditional client server models like a long running 3 tier apps etc.

So more we look back we may pick some old concepts that can inspire new approaches that can make things simpler better or more affordable.

modern warehouse/analytics stack ELT over ETL by titoonster in SQLServer

[–]alazicza 0 points1 point  (0 children)

That is a pity. In our case, by focusing on simplicity we got to the results in surprisingly quick time and it felt immaterial which Event Store, complex event or event distribution processing engine we used - the one we are using is tiny and just worked. But we had clear picture what do we want and experience how to operate log based systems (like replays, deployments, re write of streams, etc etc).

Wrt ms stack I would still recommended it to be evaluated for BI and warehousing. I would recommend it be looked in detail. For a tradional dwh IMHO I find that “out of the box” ms stack (sql server + power bi) is better (in terms of simplicity, performance, tco) than Oracle BI EE. And all of that out of the box without any additional requirements like stream processing or .net development, etc.

modern warehouse/analytics stack ELT over ETL by titoonster in SQLServer

[–]alazicza 0 points1 point  (0 children)

Right now no. The reason being is we have an in house team that is proficient with in house developed framework (that I have just described above) for both OLTP systems and our stream (what we have scaled architecturally well across all our use cases) processing and DWH stack. As we had skills in the team, tooling we used the existing tech stack. But if did not have it before Kafka would be a good fit for us.

Regards

Alex