ssms – Alternative to SQL Server Management Studio and Azure Data Studio to initially change my password

Background

I’m having to connect to a customer’s Microsoft SQL Server. I generally don’t need to do much in databases besides your average SQL, so using the database features in IntelliJ IDEA have so far been more than sufficient for various PostgreSQL and Orcacle databases. In this case though I was given a heads-up that I will have to change my password first, and when I use IDEA to connect with the credentials I received it does indeed reject them and gives me an error message saying I need to change my password. I was also told to use SQL Server Management Studio (SSMS) to do so.

Problem

SSMS is only for Windows, I’m running a Mac. The SSMS download page refers to Azure Data Studio for use on a different OS. An initial try of the latter did not let me change the password though. Even if I eventually find a way to do it, is there really no other easier way to do this that doesn’t involve installing another full-blown db tool that I have no intention of using in the long run? Or worst case: buy a windows computer for the sole purpose of installing SSMS so I can change a password? Surely there must be a bunch of Mac- or Linux-using DBA’s that know of a simple command-line tool or alike that allows them to change their password initially on a Microsoft SQL Server, after which they just use their favorite db management tool to access it?

virtualization – Is Windows Sandbox a viable alternative to conventional VM solutions considering its design?

The idea of having a fast, disposable VM at the palm of my hand appeals to me very much. It makes adding an extra layer of security to any thing I want to do so easy – just launch the sandbox application in a matter of seconds and you’re done. Of course, that is considering the VM actually does the job it’s supposed to do…

A little disclaimer beforehand – I’ve read the article Beware the perils of Windows Sandbox at Magnitude8, describing how the Windows Sandbox comes with a NAT pre-enabled and thus any malware running on the guest would still get a direct access to your intranet, which is already a large problem. But for the purpose of this question, let us just consider the host-guest scenarios.

Windows Sandbox claims to “achieve a combination of security, density, and performance that isn’t available in traditional VMs”, by leveraging a different approach to memory and disk management. If I understand things correctly, everything that in theory can be safely shared between the host and the guest, gets shared. According to the official documentation, the Sandbox shares both the host’s immutable system files, as well as the physical memory pages.

Despite that, Microsoft seems to remain confident that their solution is secure as implied by one of bullet points mentioned in the Sandbox overview:

Secure: Uses hardware-based virtualization for kernel isolation. It relies on the Microsoft hypervisor to run a separate kernel that isolates Windows Sandbox from the host.

This obviously raises a lot of questions, because at the first glance, all this resource sharing should increase the attack surface greatly, leaving more space for exploits to be found. Also, even the most sophisticated technology, which changes only the implementation and not the design, does ultimately make the discovery of an exploit only more time and resource consuming, but not less possible, doesn’t it?

So, my question is

Would you consider Windows Sandbox to be a viable alternative to conventional VM solutions in terms of security, or do the shortcuts used to achieve the performance undermine the VM’s core principles too much? Or am I just not understanding the technology and all of what the Sandbox is doing is technically safe?

An extra question: Does the situation change when we’re talking about a web-based attack, such as opening a malicious site in a browser from within the Sandbox, or does it come down to the same situation as running an infected executable? (disregarding the extra layer of sandboxing done in the browser itself)

postgresql – Performance of indexing varchar or text as an alternative to UUIDs?

I was reading up on nanoid and was possibly considering using the generated ids as the primary key for a table. The generated IDs are strings such as V1StGXR8_Z5jdHi6B-myT.

In my research I came across the following comment:

One of the benefits at least in postgres is that uuid v4 can be treated like a native type when stored which makes it fast to search.

Is it necessarily true that a primary key based on a UUID column would be more performant than a primary key based on a text or varchar column? If so, is there some other data type I can use to store nanoids which would match the performance of the native UUID type?

javascript – Is there a less complicated alternative to handling this simple mySQL query in Node?

To Put My Question In Better Context…

I am about done writing my first real-world Node application, which would be classified as a REST API. For myself, it was a bit challenging to wrap my head around Node’s Async event processing. I still don’t think I fully grasp it, as you will see by the specifics of this post. That being said…

Am I Making This Overly Complicated?

I found some code snippets online that helped me get my API working. Below is one function that deals with finding a client. I guess you would call the file this is in, a Controller, for those of you familiar with MVC. But this being Node, and NOT MVC, my question is this:

GET http://localhost/clients/3 -> brings me to this code…

// Find a single client with a Id
exports.findOne = (req, res) => {
  Client.findById(req.params.clientId, (err, data) => {
    if (err) {
      if (err.kind === "not_found") {
        res.status(404).send({
          message: `Not found Client with id ${req.params.clientId}.`
        });
      } else {
        res.status(500).send({
          message: "Error retrieving Client with id " + req.params.clientId
        });
      }
    } else res.send(data);
  });
};

What is the reason for this call to have a callback itself???

Client.findById(req.params.clientId, (err, data) => {

which in turn, looks like this:

Client.findById = (clientId, result) => {
  sql.query(`SELECT * FROM clients WHERE id = ${clientId}`, (err, res) => {
    if (err) {
      console.log("error: ", err);
      result(err, null);
      return;
    }

    if (res.length) {
      console.log("found client: ", res(0));
      result(null, res(0));
      return;
    }

    // not found client with the id
    result({ kind: "not_found" }, null);
  });
};

This seems like a lot of work for a simple query function. Coming from a PHP background, this could be done in very few lines of code there.

The whole thing seems complicated. Is all this really necessary for such a simple API that returns a client record of only four columns?

For that matter, do I even need that intermediate function (controller)? What’s the matter with just routing right to the final function (in this case, a function named findById ) ??

I’d sure appreciate some input on this before I get too far ahead. I have another dozen endpoints to code, so if I need to change directions, now would be the time.

Thanks!

Alternative to online.net | Web Hosting Talk


Hello,

I’m looking for an alternative to online.net, I have around 20 servers there an a billing close to $2,000 per month. I’m looking for something similar (regarding prices/quality) but with a customer support that care about their customers. Each time I have to deal with their tech guys is a nightmare. I don’t think I send more than 5 tickets per year and most of them are for asking questions about their infrastructure, servers are managed 100% buy me.

My immediate needs are 3 servers with at least 1TB in SSD disk and interval private network between them (is for a mongodb db). 64GB Ram and unlimited public bandwidth (however my last month I spend around 300GB.

I would appreciate your recommendations.

Thanks.

Compact BaseForm Alternative that Extends to Bases > 36

I recently created a document listing the terms of OEIS sequence A256112 in BaseForm. Term #164 and #165 at the end of the document are the two solutions in base 35. As I continue to search for additional terms in the sequence I am about to hit the BaseForm limitation of bases needing to be integers less than 37.

A viable alternative is to list these numbers as comma-separated IntegerDigits. I would prefer something more compact, say a BaseForm that incorporates the Greek alphabet starting at base 37. I don’t know how to do that. Or, if it was possible to enclose each digit of an IntegerDigits list in a standard-sized square, that might look ok as an output. I’m asking for a good-looking, compact BaseForm alternative that extends the current limitation to bases beyond 36.

Alternative to iOS Google App

I have been using the Google App for both search but maybe even more to have a start page that shows news Nd story content that I have shown interest previously which is not a bad thing even if it is a bit of a privacy invasion to tech me. The thing is aside form the privacy concerns, the app runs worse in every IOS release to where it blocks and crashes constantly. Even on an 2020 iPad Pro is sluggish and sloppy and really there is no excuse at this point.

Because Apple has really trapped users to stick with Apple default software and much of this has improved greatly (except Mail which is still awful) I can tolerate using Safari as its faster than Chrome and meshes nicely with other iOS features like sharing, Apple Maps, etc… is there a good start page that can be customized which is either just a personalized web page or an app that works like Google? It seems Google doesn’t care their app runs terribly (probably sabotaged endlessly by Apple), but as a user I can play favorites. I just need something that works and is pleasant to use.

Basically, the key features in feeds shoud have:

  • Customizable subsections like iFrames or Atlassian Dashboards so like can control what is on the page
    • Dynamic RSS feeds which use some seeding info but then let’s you “rate” feed content so it keeps getting better tailored to your interests
    • Subsections can have different formats from simple lists to photos with comments
    • subsections can be dedicated to specific sources
    • subsections can be made to show articles with keywords from specific sources
    • have an “index” of how much new and unfamiliar content it should try on you to see if you might want some alternative takes on topics you care about. (I.E. hear more than what’s in the echo chamber)

RSS feed tools are dated now and it’s time to use theme in more nuanced ways. I like when I get present with a days worth of “what’s trending” but have control over what content I see as quality and what I don’t. Also. The sky”s the limit on how metics could be applied, but if the user is the final arbiter of what goes and what doesn’t, it is less likely to be using people for “anger clicking” if they chose not to be. Your being tracked by ads as always depends on whether you use ad blockers, but I have seen home pages that leave this i your hands without selling your data. The problem is that they are simply old and clunky.

Suggestions?

website design – Icon alternative for items per page

I understand that you are trying to reduce the number of text in the page, which is a good thought, however as a best practice try to use the standard UX pattern which is well known and proved to work well. Also, users may interpresent an icon differently according to their content and culture, so it is difficult to design a good icon. I assume the ‘items per page’ is used in your context for data tables. So here I am submitting my idea for icon.

Disclaimer – icon is not tested for your context, you need to test it with the users.

Note – Always provide Alt text description for an icon, so that it will adhere accessibility norms.

If used in a table

If it is used for a table

If it is for document page

enter image description here