SQL Server with Mr. Denny
2,087 FOLLOWERS
Interesting tidbits about Microsoft SQL Server (and lots of other stuff about IT) that will help you build a rock solid database server and keep it running for many years to come.
SQL Server with Mr. Denny
3d ago
So, I ran across a problem with QuickBooks that involves some of the most basic math that we were all taught in elementary school: how to round numbers properly. You’d think that a company that makes accounting and invoicing software for a living would understand how rounding of numbers works. But based on the last […]
The post Properly Rouding Numbers is Important appeared first on Denny Cherry & Associates Consulting ..read more
SQL Server with Mr. Denny
3w ago
Last week, at the PASS Summit in Seattle, the DCAC team, including John, Monica, Yuki, and myself, were able to volunteer at the “Community Experts Clinic” booth sponsored by Redgate. I always enjoy speaking to community members about their technical challenges and how we can solve their problems. An area like that, a great process […]
The post PASS Experts Clinic Was a Huge Success appeared first on Denny Cherry & Associates Consulting ..read more
SQL Server with Mr. Denny
2M ago
Recently, I was working on a PowerShell script that would access all our clients’ Azure environments and gather metrics from them. While testing this, I used my account, which prompted me to get MFA credentials for every tenant. While this worked for my development and testing of the PowerShell script this wasn’t going to work […]
The post Using PowerShell to Access Mutiple Azure Tenants Without MFA Prompts appeared first on Denny Cherry & Associates Consulting ..read more
SQL Server with Mr. Denny
3M ago
If you wanted to join the PASS 2024 Attendee Briefing call on September 4, 2024, but didn’t have the time, the session was recorded and is available for viewing now. You can view the video below and download a PDF of the slides that I presented. See you in November in Seattle. Denny ..read more
SQL Server with Mr. Denny
4M ago
Are you planning on attending the PASS Summit in November 2024? Then this webinar is for you. In this hour-long webinar, we will review the conference center space (the conference is in a different spot than it has been in the past), the hotel options, places to get food (that aren’t at the convention center ..read more
SQL Server with Mr. Denny
4M ago
If you are using Azure SQL DB for MySQL Standalone server and upgrading to MySQL Flex server and using Power Automate, you may see an error message from your Power Automate flows if you are using a Data Gateway. The error message that you’re getting could look something like this. The problem in my case ..read more
SQL Server with Mr. Denny
5M ago
If you didn’t notice yesterday (July 18, 2024), the Azure US Central region had a pretty major outage where a good portion of the services in that region for a number of customers were not available. The outage was even bad enough that in the communications that Microsoft sent out about the incident they even recommended activating your disaster recovery plans. Needless to say, this was a pretty bad outage. Various companies were affected by this outage as they were hosted in US Central and only US Central.
Some of DCAC’s services, like this website, were impacted by this outage. In our case ..read more
SQL Server with Mr. Denny
5M ago
The team of Microsoft MVPs at DCAC can all report that they were rewarded the Microsoft MVP Award by Microsoft yesterday when Microsoft announced the awardees on July 10th, 2024. Like in prior years, our team has 5 Microsoft MVPs who are awarded in 6 Microsoft MVP Award Categories. All 5 of our MVPs received Microsoft MVP Awards in the Data Platform award category, and Denny received an award for the Microsoft Cloud Platform award category.
Our team of Microsoft MVPs (Denny, Joey, Monica, John, and Meagan) spends a lot of personal time working on community activities, and DCAC is proud to sup ..read more
SQL Server with Mr. Denny
7M ago
One of the great features of running Windows 2022 Virtual Machines (VMs) in Azure is that you can log into them using Entra ID (Azure Active Directory). However, if you deploy a new VM and simply try to log into that VM with the Remote Desktop application (RDP), you’ll be presented with the error message from RDP which says, “The Target Identifier in the Request was not Found in the Tenant”. Thankfully this error
message is easy enough to fix, but there are a few steps that you’ll need to take.
Fix DNS
The first step is to add the machine to DNS. If your VM has a Public IP Address (I don’t re ..read more
SQL Server with Mr. Denny
7M ago
Today, World AIDS Day, DCAC is launching its annual matching funds campaign on behalf of the Elizabeth Glaser Pediatric AIDS Foundation (EGPAF). Since 2018, we’ve raised more than $70,000 to support an AIDS-free generation. And there’s still work to do. That’s why DCAC has again pledged to match up to $10,000 in your donations!
It’s easy to participate! From December 1-24. Every dollar you donate to EGPAF gets doubled by DCAC. Donate more, and DCAC donates more…up to $10,000!
For 35 years, the Elizabeth Glaser Pediatric AIDS Foundation has led the charge to prioritize children in ..read more