Share tech news, updates, or what's on your mind. Sign up to Post
Gigabyte starts to roll out fix for UEFI vulnerability affecting all its recent motherboards

Gigabyte's UEFI contains code to automatically download and install firmware updates without user intervention. Unfortunately with some very weak security allowing the possibility of bad actor exploitation of the feature.

Gigabyte have responded to security researchers  Eclypsium by announcing several fixes for boards containing their four leading chipsets.

Ironically the updates will use the existing flaw to fix themselves!

The lesson here is that the UEFI environment allows manufacturers to incorporate processes that run in the background without end-user intervention (or even their knowledge) it's difficult to secure your premises when you don't know where all the doors are!
MC556157 Microsoft is retiring the option to edit and reply with Word, Excel, and PowerPoint files from attachment previews in Outlook. Users will still be able to edit their files using web or desktop apps and then attach a copy or a link to the file in OneDrive to share it.
When this will happen:
Microsoft will start rolling out this change in late June 2023.
How this will affect your organization:
Users of this feature will now have to open the attachment using web or desktop apps and then download a copy or save the edited file to OneDrive before sharing it either as an attachment or a link.
I just saw where Google is trying to change limits of SSL Certificates to change every 90 days instead of every year.

For small sites I manage where automating is not easy, this is going to be a PITA.
I spent last week at Building Business Capability (BBC), the largest annual gathering of business analysts and business architects. The event is run by the International Institute of Business Analysis™ (IIBA®), a professional association for the global community of business analysis professionals.

Business Analysts (BAs) typically work as liaisons between the technology and business groups in an organization. They define needs and recommend solutions that deliver value to stakeholders and that enable positive change in their organizations.

Scott standing outside the Speaker Ready Room at the BBC conferenceThough I’ve never held the job title of Business Analyst, most of the work I’ve done over the years has been at the intersection described above – the boundary between business and technology. I've always had a foot in both worlds, consequently, I’m very comfortable sharing knowledge with and learning new things from people in the BA community.

I first spoke at BBC in 2018 and have presented there annually since, with the exception of COVID-induced interruptions.

I'm  grateful to EE for sponsoring a portion of my travel costs this year as part of the Reconnect program.

Do you work with Business Analysts? Or are you a BA in your organization? I’d love to hear about your experience with or as a BA.
LVL 77


by:Scott Fell
Scott, what were some new products that used AI for this?
LVL 32

Author Comment

by:Scott Helmers
Excellent question, Scott. There was a lot of talk and some demonstrations of gen AI in the conference sessions, including the opening keynote. However, I didn't see a lot of evidence on the exhibit floor. For context: This is a mid-sized trade show, and still recovering from the pandemic. Consequently, the exhibit area was smaller than in the before times. There were about two dozen vendors, about half of whom were product companies. The other half were education and consulting providers. Most of the vendors offer digital transformation, process documentation/mapping/automation, and business rules solutions. I didn't spend a lot of time with any one vendor but there wasn't as much obvious gen AI activity as I'm sure there will be in a couple of months.
Hi everyone!!

I saw this post this morning about how ChatGPT has affected that other supposed expert site (okay in all fairness I have from time to time gotten some good information from Stack Overflow and although there is not as much garbage and misinformation to sift through as Google it can't hold a candle to us here).

Anyway, speaking of sifting through garbage here you go...

Honestly I still don't get the hype over ChatGPT.  To me, here it is in a nutshell:  Let's take the most powerful server farm we can find, put some analyzing software on it, feed it EVERYTHING THAT HAS EVER EXISTED, and...  see what it does!!


Author Comment

by:Robert Derman
Scott, I totally agree with your last statement.  It is a mix of AI and human interaction that is the key.  What concerns me right now with the hype over ChatGPT is that the focus is on the AI alone and not on the human interaction which is required.

AI is an evolving technology.  It is evolutionary, not revolutionary, and still has a long way to go.  ChatGPT is a step in that evolution, but only a step.  It is valuable and useful, but not the answer to everything.  Not without a lot of help.
LVL 77


by:Scott Fell
What concerns me right now with the hype over ChatGPT is that the focus is on the AI alone and not on the human interaction which is required.

We humans gravitate for the easy and cheap. Working with people creates some degree of friction in one form or another. I would prefer the mix, but with the very low barrier to entry, it makes for a potentially bad situation.
Title: Modern Data Warehousing: Empowering Insights with Azure Platform

In the era of data-driven decision-making, organizations are increasingly relying on efficient and scalable data warehousing solutions to unlock valuable insights. Azure, Microsoft's cloud computing platform, offers a robust suite of services that revolutionize traditional data warehousing. In this blog, we will delve into the world of modern data warehousing using Azure, exploring its key features, benefits, and how it empowers businesses to gain a competitive edge.

The Azure Data Warehouse Advantage:
Azure provides an extensive range of data warehousing tools and services that are designed to meet the modern demands of big data analytics. At the core of Azure's data warehousing capabilities is Azure Synapse Analytics, a unified analytics service that combines big data and data warehousing into a single, integrated platform. With Synapse Analytics, organizations can seamlessly ingest, prepare, manage, and serve data for immediate insights.

Scalability and Flexibility:
One of the significant advantages of Azure for data warehousing is its scalability. Azure allows you to scale your data warehouse resources up or down based on your specific requirements, ensuring optimal performance and cost-efficiency. Azure Synapse Analytics employs a distributed architecture, allowing you to elastically scale your data warehousing resources to handle large volumes of data and complex analytics …
Looking to connect with fellow experts here! :)

I hope this message finds you well. I am reaching out to connect with fellow experts on ExpertsExchange and expand my knowledge and contacts in the field.

I believe that forums like this provide an excellent opportunity for like-minded professionals to network and exchange ideas. I am excited to engage in discussions and collaborate on projects with members of this community.

Do connect with me on my linkedin:

I hope to connect with other experts who  share the same passion for technology. Cheers! :)
A little summary of the first day at EIC.
This conference is a good mean to update all his knowledge on all actual and important aspects of the security.
The security is using a lot of acronyms, and it is often important to better understand of what we are speaking.
Of course, a lot of partners are there to explain their technologies.
But, nearly all the sessions are trying to be generic and usable with different products.
So, the atmosphere is different of the usual "Microsoft" conferences that I usually attend.
Curiously, it seems also that the dressing is a little more formal.
I don't know if these elements are linked. :)
Hello, I  have now started the EIC conference in Berlin, thanks to Experts-Exchange.

Here are some photos of the event:
I arrived in time for my first workshop Sunday at the Microsoft 365 Conference in Las Vegas. It was a great workshop, as well as the second workshop Monday. The conference starts tomorrow, Tuesday, May 2, 2023. Looking forward to some great sessions. If there are any EE members here besides me, send me a message and let's get together.

I'm excited to attend the Microsoft 365 Conference in Las Vegas during the first week of May! I'll be working with EE to get some posts about the conference online. If you're going to be there, let me know! It would be great to meet you in person.
It took way to long, but LAPS is finally integrated into Windows. The migration path asks for a lot of trouble if you ask me!
Microsoft has released the new Edge Web Browser control for Microsoft Access to the Insiders and Current Preview channels.

Nice that we'll finally be able to execute Java script!
Microsoft is introducing a new Exchange Online security feature that will automatically start throttling and eventually block all emails sent from "persistently vulnerable Exchange servers" 90 days after the admins are pinged to secure them.
How to replace Dlookup and Dsum In MS Access

Many beginners struggle to replace Domain functions in Microsoft Access in order to gain speed when using MS Access as a front end and MS SQL Server a back end, the golden rule has been to transfer or convert all complex queries in access to SQL server views. But there are situations where you want to get a value or a summed figure from unrelated table/query, this where many people have been relying on domain functions.
Using the afore mentioned domain functions makes Microsoft Access extremely slow or if there are many domain functions, access can easily stop responding and give up finally. So, what is the way forward?
Open record set is the way to go! Simply assign the control that require receiving a new value from a query as demonstrated below:


Dim db As DAO.Database
Dim strSql As String
Dim prm As DAO.Parameter
Set db = CurrentDb
strSql = "SELECT StatusFour FROM [tblOrder] WHERE [OrderID] =" & [Forms]![frmOrder]![CboGrnstocopy]
With db.CreateQueryDef("", strSql)
For Each prm In .Parameters
prm.value = Eval(prm.Name)
    With .OpenRecordset(dbOpenSnapshot, dbSeeChanges)
        If Not .EOF() Then
         Me.txtOrdersAuditing = .Fields(0).value
    End If
    End With
End With
Set prm = Nothing
Set db = Nothing

Open in new window

Where there StatusFour if you want sum that control, simply Sum(StatusFour) AS Total (This becomes DSum) if you leave it just as StatusFour , then that will take like Dlookup.


In case you haven’t heard:

The full agenda of the virtual Access DevCon Vienna 2023 on April 27+28 is online now. So, this is the right time to sign up if you haven't already.

Topics and speakers:
•      Update by the Access Team (Microsoft Access Engineering Team)
•      Exploring the Future of twinBASIC and Access Development  (Mike Wolfe)
•      Defensive Programming: Some Bugs are Better than Others  (Mike Wolfe)
•      Dataverse for Access Developers?  (Ynte Jan Kuindersma)
•      Making Automatic Form Resizing work for you  (Colin Riddington)
•      Draw Gadgets on Access Reports  (Crystal Long)
•      Access in an Azure VM  (George Young)
•      Access Help Content and Documentation Deep Dive  (Jeff Conrad, Microsoft)
•      Northwind 2 – Comeback of a Superstar  (Tom van Stiphout, Kim Young)
•      Advanced Database Design  (Armen Stein)
•      Modern UI Design Tips  (Daniel Sanders)
•      Click Here to Add Feature X!  (Kevin Bell, Karl Donaubauer)
Take a look at the detailed descriptions on the agenda page.

Access Bug Trackers
Access News
Access DevCon

 Been some pretty fantastic stuff shown over the past few years.

Who is attending RSA, MS Ignite, or Black Hat conferences this year?


by:Richard Young
I'll be at RSA.
If there is one reason you need to regularly patch your Windows desktops and servers with latest security patches for Windows, just try this lab from TryHackMe ! (for 5 minutes!) and you can see how easy it is for my Grandma, to obtain Local Administrator rights to a Windows OS, using the LocalPotato Exploit! I told you! No excuses! #tryhackme #CVE-2023-21746 #LocalPotato #lpe #eop #windows #privesc #StorSvc #Potato #localpotato 
Hadoop vs. Spark vs. Kafka - How to Structure Modern Big Data Architecture?
Applocker for Win10 Pro!
Updates removed the edition checks for Windows 10, versions 2004, 20H2, and 21H1 and all versions of Windows 11 (and Win10 22H2 and higher). You can now deploy and enforce AppLocker policies to all of these Windows versions regardless of their edition or management method.
Have you tried AG Grid before?
Cheap smart watch brand LIGE. It do have all sophisticated functions and it is what you can rely on.  For student, it is a good choice, believe me.


by:Kasey Hart
Thanks for the rec!
A very good training to understand the OpenAI services provided by Microsoft Azure.


by:Kasey Hart
Awesome recommendation for the community, thanks Munib!


by:Kasey Hart
I've enjoyed following all of your content on OpenAI
Excited to go to the Developer Week Conference in Oakland this week.  If anyone in the EE community is going to be there, let me know, would love to connect with anyone in person.


by:Kasey Hart
Maybe an article to share what you learned? :)
LVL 17

Author Comment

by:Jeffrey Dake
We've got two new writing prompts on the EE Featured Content Program. Go check it out!

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month