I’ve had to do some work on PostgreSQL, and I wrote an article at SQLServerCentral about getting started. Once I had things working, and could connect from Azure Data Studio(ADS), I also wanted to get pgadmin working in a container for admin tasks.
However, when I checked status, it would always be down. When I checked the logs (docker container logs pgadmin4), I’d see this:
Ugh. I kept looking through docs and checking different posts. Lots of different options with quotes that I kept trying, but eventually when I went with double quotes, things worked.
Leaving off the –d let me see this was actually starting up.
This was on Docker for Windows, with Linux containers for me.
I would swear that I tried just double quotes before this, but I bet I kept adding single quotes and double quotes in different ways, like this:
At the Microsoft Ignite conference recently, I saw a talk that mentioned the Microsoft Garage Project, Trove, which is designed to help people provide data for AI projects in a new way. You can read more about it and get the app for Android mobile devices.
Trove is built to help AI researchers find images and use them in projects. However, the data they get is provided by users, who make the choice to include their data. This is different than many AI projects, where anyone doing AI work often just gets data from various sources, sometimes without permissions, but often without the individuals who own the data understanding where their data is being used or for what purposes.
I like the idea here of people specifically giving permission for their data to be used. It’s a good way for volunteers to provide data, and have some control over how the information you provide might be used and where it is used. That doesn’t mean this is necessarily a good model for the future. First, I’m not sure we can easily verify that the images someone submits are their own. I could see that if there are payments made, I’m sure people will try to game this and earn more money by using images they don’t own. We already have problems with people publishing content they didn’t create. I’m sure we’ve have plenty more with something like Trove.
The other issue, and likely the biggest one I think is a problem, is that trying to understand what data is collected and how it’s used by many companies is a challenge. Even when there is some disclosure, it can be difficult to understand what is being released. Even while reading this document on SQL Server data collection, I’m not sure what might be collected on my system that could be an issue.
I don’t think this is malicious or deceitful on Microsoft’s part, I’m just not sure I can understand the implications. That is where I feel we, as a society, and certainly with regards to regulations, are woefully immature. We don’t have good controls, but I’m not sure we really know what we’d want.
This is a thorny problem, and one I know we need to find better solutions to over time. Especially as we use more and more data for large scale research and applications in areas such as Artificial Intelligence and Machine Learning.
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here.
Today’s tip is to remember that you are enough, just as you are.
I can be better, but my wife tells me how she appreciates me. My kids will let me know as well. At times, I hear this at work or from attendees at events. The girls I coach always ask me to repeat a year with them.
I’m successful and I appreciate all those comments. I do strive to be better, to not only gain wisdom with age, but learn to apply it. However, I also know that being who I am is enough, even if I never get better.
I think about accepting myself more and more as I can see retirement. I’m still driven, but I’m less concerned about it.
There’s a lot of stress in prepping for conferences and talks. I’m used to it, but whenever something is new, I get a little nervous. How are the AV staff? Will my laptop connect to the right resolution? Will I fall off stage (I’ve done that).
With the Virtual Summit, I’m nervous for other reasons, not the least of which is that this is the first time we’ve used the platform. With that in mind, I made two videos.
Bottom line is that most of you will want to record your own video and upload it. If you’re worried, contact me or Jen Stirrup and we’ll try to help..
The Portal
The first one below is the initial login for me. I get into the portal, look around, see data privacy, etc. This was my checking it out, and not being ready to speak.
This second video is my experience trying to record my lightning talk on the platform. This wasn’t a real take, but I wanted to see how things work before I need to.
Preparation is key. Remember that for your sessions.
Below you will see how my recording practice went.
The big thing with this platform is that you need to upload your slides first. The rendering was relatively quick, minutes for my 15 slides, but prepare for that.
Second you need to record each slide separately. That means pauses and being careful with transitions. I’d be ready to click stop, as well as be ready to start talking when you click record. It takes about a second to start, but long delays will make the presentation look funny.
Next, no animations in PPT, or video, but also no animated gifs. Not a lot of you use those, so probably not an issue, but beware. Essentially, each slide becomes an image you record over.
The big issues is no demos. Not on the platform. If you need demos, then you need to record your own video. Sorry, don’t see a way around this. I’ll reach out to PASS, but I would rather get you prepared and be wrong than have you expecting something else.
This isn’t a deal breaker, but you do want to be prepared.
Most of you will need to record your own video.
Jen Stirrup made a promise to help speakers. I agree, and I’ll do the same. If you aren’t set up to record video, ping me on Linked In or Twitter and I’ll set up a Zoom call and record your share. I’m happy to get the video processed and then put it on a share for you to download. You’ll still have to download and upload, but at least you don’t need to worry about some of the audio video stuff.
Update: There are two options people have noted that might help some of you. If you just need slides, you can record directly in PowerPoint. You can also record in Teams, if you have access to that platform.
I’ll give you feedback as well on how things go if you want. If not, I’ll just send video.
Get ready early, and start planning for recording in the next two weeks so you’re ready for the Summit.
Voice of the DBA 