Upgrading your SQL Server 2019 BDC

Published On: 2020-04-06By:

If you’ve been running your SQL Server 2019 Big Data Cluster (BDC) for a while now, you probably want to patch it to the current (or a specific) build version.

Upgrading a BDC is actually fairly easy. A couple of commands will do the trick.

Before you upgrade you’ll need to know the namespace of the BDC that you are working with. I published how to get your namespace earlier. To recap, getting your list of namespaces is pretty straight forward.

az aks get-credentials --name aks-cluster --resource-group aks-resource-group

Once you have your credentials, you can request the list of namespaces.

kubectl get namespaces

From there you can use azdata to auth against the cluster. Keep in mind that this is the admin account for the cluster, not your windows or Azure AAD credentials.

azdata login

Once you have provided your namespace, username and password you can request the upgrade.

azdata bdc upgrade -n {namespace} -t latest -r mcr.microsoft.com/mssql/bdc

If you want a version of SQL Server 2019 other that the latest, change the -t value from latest to something like “2019-CU2-ubuntu-16.04”. You can see what the various tags are if you are looking for a specific build over on Microsoft Docs.

The azdata bdc upgrade command may take a while to upgrade, so be patient.

Now if you are running your BDC in aks in Azure, you’ll probably get an upgrade failure. This is because you need to upgrade the timeouts. To do this run the following command.

kubectl edit configmap controller-upgrade-configmap -n {namespace}

To run it successfully you’ll need the namespace that you used earlier.

This will open a notepad document. In that document find controllerUpgradeTimeoutInMinutes and set its value to 40. Find totalUpgradeTimeoutInMinutes and set its value to 45. Find componentUpgradeTimeoutInMinutes and set its value to 45. If the upgrade fails again, you may need to increase these values and run the upgrade again.

Denny

Contact the Author | Contact DCAC

Denny Cherry and Associates Consulting – A Globally Renowned Expert in Cloud and Database Solutions

Published On: 2020-04-03By:

Insights Success recently published an Interview with Denny Cherry from Denny Cherry & Associates Consulting. You can find an excerpt below, or you can download the article for reading at your leisure.

No one can deny the fact that cloud solutions have brought transformation across all the industries. Over traditional solutions, cloud helps consumers in ease of access, scalability, and easy data recovery. In the business world, companies use cloud tools and technologies to gain competitive edge and drive disruption.

However, to take advantage of such smart technologies, businesses need a reliable service provider such as Denny Cherry and Associates Consulting (DCAC).

Let’s learn more about the Innovative Tech firm.

Brief us about your company and its history since inception. Also, do let us know about you mission and vision.

Founded in 2012, Denny Cherry and Associates Consulting is a cloud and database solutions company driven by globally renowned award-winning expertise. Started by Microsoft MVP Denny Cherry, his vision was to gather the most renowned experts in the world to provide rapid, reliable cross-platform transformations for small to medium sized businesses that frequently do not have the dedicated IT resources to achieve those goals alone. With DCAC’s staff of Microsoft MVP’s, working collaboratively across a variety of disciplines from Performance Tuning to Business Intelligence, clients can achieve optimal solutions reliably, within a timeline and budget that won’t break the bank.

Read more by downloading the article today.

Contact the Author | Contact DCAC

5 Tips for New Remote Learning Teachers

Published On: 2020-03-24By:

Teaching in front of a classroom of kids is a skill that many (including myself) don’t have. As many schools have transitioned from in-classroom learning (what we all did in school) to remote learning there are going to be a few differences that at teachers you are going to notice as you do these remote teaching sessions.

I’ve been teaching classes remotely to IT Professionals for years now, and I wanted to share some of what I’ve learned over time to explain some things, and hopefully make you realize that others are totally normal.

1. Talking to your monitor

Unless you’ve got a professional setup for recording in your house you will probably find yourself doing what most of us to, talking to your computer screen with some sort of microphone and webcam pointed at yourself. What you normally get from your audience is feedback, even if you don’t realize it. People sigh and fidget if they aren’t getting what you are trying to explain. You won’t get those little queues when you are presenting online. That means that you’ll need to explain things in more detail and ask questions, more than normal, to make sure the students get the topic. What this boils down to is that teaching remote classes just sucks because you don’t get that level of interaction from the students. But right now, it’s what we need to do.

2. People don’t ask questions

One thing that I’ve noticed after doing hundreds of hours of professional training for people, is that remote audiences don’t ask questions. I really hope that this is different for kids than the IT Professionals that I give classes to, but I get far fewer questions when I present a session remotely than I do when I present the same session in person to people. Part of it is because it’s remote people don’t think that they can ask questions, so if you’ve got an interactive way of talking to the students, ask if there questions. Ask that a lot. If they send if their questions via text (they have to type in the question) take a few minutes to let them type in their question before you move on. It’ll break your flow a little bit, but it will give those that aren’t great typers a chance to finish their question before you start talking about the subject again.

3. Order a decent Microphone and Camera

With the assumption that this remote learning approach is going to be happening for a while now (some schools like the ones here in San Diego, CA are going to be closed the rest of the school year) you’ll want to invest in a decent microphone and camera. The ones that are built into your laptop probably aren’t going to cut it long term. Personally I use this microphone from Rode which you can get on Amazon (only get the one that is fulfilled by Amazon, otherwise you risk getting a fake). The Rode that I linked to has a breath shield so that it’ll pick up your breathing while you talk less. A good microphone will pick up your breathing really well, and it’ll be really distracting to the people watching.

When it comes to the microphone play a little with the gain knob on the microphone. You want it to be fairly high, without picking up to much background noise. Keep in mind that if you turn up the gain on the microphone really high, it’ll pick up cars driving by, even if they a couple of streets away. When I first got my Rode microphone it could pick up cars driving by that I couldn’t hear.

For a camera, I use the Microsoft LifeCam Studio which is also available on Amazon. The camera I have is a few years old so I’ve got an older model, but even the older model has pretty good video quality. The microphone in it isn’t great, which is why I have the Rode.

4. Don’t put your microphone on your desk

Putting your microphone on your desk is a horrible plan. The microphone will pick up every tap of the desk that you make. Every time you tap the keyboard keys or click the mouse the microphone will pick up the vibration and it will be incredibly loud for the people that are watching. I use a swing arm that is similar to this one by Innogear (I can’t find the exact one that I have, but I bought it years ago). Mine is mounted clamped to a monitor arm, which is bolted to the wall. So unless I kick the wall by accident (and I’d have to kick right under the monitor) the microphone doesn’t pick up any tapping on the desk or the keyboard. If you think you can tap quietly enough on the mouse that a microphone on the desk won’t pick it up, you can’t. The microphone is picking up the touch to the desk and converting that into sound. If you don’t want to mount a microphone in the wall (which I totally get) look into a microphone stand like this one from Pyle. That way it can sit on the floor and it will come to you instead of you having to do to the microphone.

5. Speak Slowly

You’re a teacher so you probably know this one, but it’s worth saying. When doing remote teaching speak slowly. Slower than normal, painfully slow. What the watchers hear, will sound a lot faster then you think it does. Personally, this screws me up all the time, as I’m a fast talker naturally, so speaking slowly just feels so weird to me. But that’s how I know that I’m speaking slowly enough. Do a quick recording of you talking at your normal speed and see how it sounds. Odds are that you’ll want to slow down your sleep.

This whole working and teaching from home thing is going to be very weird, but this is going to be the new normal for a while. Hopefully, the pain that I went through when I started holding remote classes will help others so they don’t have to go through the same pain.

Denny

Contact the Author | Contact DCAC

5 Ways to Survive Working from Home for Adults and Children

Published On: 2020-03-23By:

As a lot of people have started working from home, a lot of kids are now doing school from home as schools are being closed due to the Coronavirus (also known as COVID-19).

Taken by Dineshraj Goomany

We’ve talked about working from home before, but with kids being home we need to plan for that, as the schools may be closed for months depending on where you live. A perfect example is California, where it was just announced that the schools would be closed for the rest of the year.

Create a Work Space


As kids are going to be doing school from home they need a decided space that they can use to do their schoolwork, much like parents need a dedicated workspace. This could be a desk in their room or a desk in the home office. But there should be a dedicated space, if possible avoid having them work at the kitchen/dining room table. Much like parents shouldn’t be working from the kitchen table, kids shouldn’t be either. If you do work from the kitchen table, it feels like you are going to work when eating, and it’ll feel like this even after this is over. In extreme cases, it can lead to eating disorders, especially in young people who are already dealing with those sorts of issues.

Take Breaks


Kids need to take breaks from work. School has breaks, learning from home should as well. An elementary school has a few breaks throughout the day as well as recess, when doing learning at home the same basic schedule should stay. If you’ve got a back yard, send the kids out there on breaks so they can get some sunshine and fresh air. If you are in an apartment that doesn’t have a back yard, the kids may require some supervision in the front yard. But this isn’t a bad thing, this will give you a break from working which is good for you as well.

School stops before work ends


It’s normal for a school to end their day before the workday ends. If the learning from home is done before you are done working, then support the kids being done. This may involve kids watching TV, or playing a game. Be supportive of their being done, and help them come up with an activity that doesn’t disrupt your finishing working.

This is not an extended vacation


This is all happening around Spring Break time. Kids may want to take advantage of this by treating this as an extended spring break by going to the mall, or the movies with friends. This is not an extended spring break. This is a different beast. Kids should not be going out anywhere doing this. This is going to mean a lot of “bring mean” and “not understanding” by parents in order to keep the kids at home. Kids are going to have to settle for talking to their friends on Skype, FaceTime, Text Message, Snap Chat, whatever else that they use to talk to their friends that I don’t know about. Along with this, kids shouldn’t be congregating in groups, even in someone’s back yard or in their house. I remember being a teenager, and this is going to be hard for a lot of teenagers to do, especially long term. But the risk of someone in their social group having Coronavirus and passing it to someone else in their social group, who then passes it to parents/grandparents/etc. is very high.

Keep in touch with Grandparents … by phone


People like grandparents are going to feel really isolated during this as they are in the highest risk group. Be sure to call them regularly so they can keep up to date on how the rest of the family is going. Sadly we don’t want to see them so that we can keep them up to date in person, the risk of passing the Coronavirus to them is just too high. This means making regular phone calls, or even facetime calls so that grandparents can see the grandkids. It might even be a good idea to put making these phone calls into a calendar so that you get a reminder about making these calls. The other advantage to talking with Grandparents regularly (or daily) is that you can check in on them and see if there are any differences in how they look or any symptoms that need to be reported to their doctor or emergency medical staff.

Obviously this isn’t an extensive list but check back for other tips as this emergency continues.
Denny

Contact the Author | Contact DCAC
1 2 3 356

Video

Globally Recognized Expertise

As Microsoft MVP’s and Partners as well as VMware experts, we are summoned by companies all over the world to fine-tune and problem-solve the most difficult architecture, infrastructure and network challenges.

And sometimes we’re asked to share what we did, at events like Microsoft’s PASS Summit 2015.

Awards & Certifications

Microsoft Partner    Microsoft MVP    Microsoft Certified Master    VMWare vExpert
FT Americas’ Fastest Growing Companies 2020    Best Full-Service Cloud Technology Consulting Company   
Insights Sccess Award    Technology Headlines Award    Golden Bridge Gold Award    CIO Review Top 20 Azure Solutions Providers