Azure AKS when your DNS servers are in a different Azure vNet
SQL Server with Mr. Denny
by Denny Cherry
3d ago
If you have an Azure environment when you have your DNS servers in a separate vNet from your new AKS environment you’ll notice that you get an error when deploying the AKS environment which looks something like this. Agents are unable to resolve Kubernetes API server name. It’s likely custom DNS server is not correctly configured, please see https://aka.ms/aks/private-cluster#hub-and-spoke-with-custom-dns for more information. The fix for this is actually pretty straightforward, but I’m going to give you a little background on why this happens. The reason that this happens is that as part o ..read more
Visit website
View a Blog Post, Make a Donation – 2022 Edition
SQL Server with Mr. Denny
by Denny Cherry
2M ago
As DCAC has done in prior years we are looking for your help with our donation program to the Elizabeth Glazer Pediatric AIDS Foundation. As today, December 1, 2022, is world AIDS day we are kicking off our (almost) month-long donation matching program. By visiting our donation webpage for 2022 DCAC will automatically donate $1 to the Elizabeth Glazer Pediatric AIDS Foundation in support of its goal of creating an AIDS-free generation. If you would like to donate more than $1, you can do so by clicking through to the donation page that EGPAF has set up whe ..read more
Visit website
Stop using global forwarders in DNS when you don’t need them
SQL Server with Mr. Denny
by Denny Cherry
2M ago
Microsoft DNS Server has a feature where you can set up forwarders that forward DNS queries that the server can’t answer to answer server. In most cases, probably 99% of the time that people set up global forwarders, the global forwarders aren’t needed. This is because that when a DNS server can’t satisfy a DNS lookup, it will automatically go to the root DNS servers to satisfy the query. When the machines are running as virtual machines in the Microsoft Azure cloud, having global forwarders set up and pointing to external DNS servers can cause problems. When using private DNS zones within Az ..read more
Visit website
Top 5 Reasons to Check SQL Server’s Page Life Expentency
SQL Server with Mr. Denny
by Denny Cherry
3M ago
One of the very misunderstood values that you can monitor in Microsoft SQL Server is Page Life Expectancy (PLE). I’ve read online that many people think that the value of Page Life Expectancy is worthless to monitor. And that really isn’t true. While Page Life Expectancy won’t tell you a specific problem by itself, it can be used to point you in the correct direction so that you know where to look. Construction workers monitor a building build process. The first thing to do in order to make use of the Page Life Expectancy value is to measure a baseline and keep that baseline where you can refe ..read more
Visit website
DCAC’s Newest Promotion
SQL Server with Mr. Denny
by Denny Cherry
4M ago
I’m happy to announce that our own Intern, Yuki Hata has been promoted to Junior Consultant. Yuki has shown an amazing aptitude for the SQL Server product and the SQL Server world. He has spent the last year+ completely immersing himself in Microsoft SQL Server, Microsoft SQL DB, SQL Managed Instance, and of course the SQL Server Community (given how much everyone else at DCAC does in conjunction with the SQL Server community he didn’t have much of a choice here). You’ll need Yuki blogging here as he works more with our existing clients as well as our new clients. You’ll be able to find him a ..read more
Visit website
PASS Summit Speaker Idol is Off for 2022
SQL Server with Mr. Denny
by Denny Cherry
4M ago
Selective focus photography of microphone I’m sad to report that there will not be a Speaker Idol competition at the PASS Data Community Summit this year. The reason for this is actually good news. Due to the fact that the PASS Data Community Summit has so many first-time speakers, there weren’t enough people attending the PASS Data Community Summit who had spoken at other events (but not at the PASS Summit) that we couldn’t fill the contest with contestants. But for those looking to enter the contest next year, we are planning on having the contest again. Maybe next year, maybe the year after ..read more
Visit website
Microsoft is changing the Microsoft Partner Program today. Here’s what it means for your vendors.
SQL Server with Mr. Denny
by Denny Cherry
4M ago
As of today (October 3rd, 2022), Microsoft has made some pretty radical changes to the Microsoft Partner Program. As of today, the Silver and Gold Partner awards are gone and are the logos are no longer valid to be shown to customers. Starting today Microsoft is introducing the Microsoft Cloud Partner Program. Instead of the Silver and Gold awards, the new program has 6 different solution areas. Those focus areas are Data & AI, Infrastructure, Digital & App Innovation, Business Applications, Modern Work, and Security. Microsoft Solutions Partner in Data & AI The Changes in the Part ..read more
Visit website
If You Are Buying a New SAN and Spending Under $100k, You Should Strongly Consider the Cloud Instead
SQL Server with Mr. Denny
by Denny Cherry
5M ago
Etch A Sketch with a robot Storage Area Network (SAN) storage has gotten much cheaper over the last few years. But cloud costs have decreased as well over the last few years, while reliability and security in the cloud have simply gotten better over the years. If you are looking at purchasing a new SAN (either expanding your existing infrastructure or building out a new infrastructure) and you are looking at spending under $100,000 for the storage array, you should strongly consider using the cloud to host your servers instead of hosting them at a local data center. The reason for this is that ..read more
Visit website
Selecting an Azure SQL Server-Based Solution
SQL Server with Mr. Denny
by Denny Cherry
5M ago
Everyone that uses Microsoft Azure knows that it has a wide variety of SQL Server-based solutions for hosting your SQL Server databases. These include Azure SQL DB, Azure SQL Managed Instance, and SQL Server running in an Azure Virtual Machine. But when it comes to selecting between those three options, there can be some confusion as to which to pick. Azure portal showing searching for the phrase “Azure SQL” Microsoft has a tool available within the Azure portal that can help you choose between the various options. That tool is the Azure SQL Deployment Chooser (I have no idea if that’s the off ..read more
Visit website
Your #sqlpass 2022 Speaker Idol Judges are…
SQL Server with Mr. Denny
by Denny Cherry
5M ago
Selective focus photography of microphone As we get ready for the 2022 PASS Data Community Summit and the Speaker Idol competation we need to know about our judging panel for this year. I’m pleased to announce that we have a fantastic team lined up to be our event judges for this year. Without further ado, our judges for this year are: Rob Sewell Anthony Nocentino Melody Zacharis Tim Mitchel Joey D’Antoni You’ll notice that we have 5 judges for this year to ensure that we don’t have a tie in the judges voting as we’ve had in years past. I can’t wait to see our judges, contestants (no we haven ..read more
Visit website

Follow SQL Server with Mr. Denny on Feedspot

Continue with Google
OR