Another Year Gone, Another Year as a VMware vExpert

Published On: 2019-03-25By:

Another year has past, and VMware has decided to make me a VMware vExpert again. I believe that this is the 5th time I’ve been a VMware vExpect (the 4th time in a row, there was a gap year because I forgot to fill out the form, it was a thing).

I’m thrilled that VMware has decided to give me this award for the 4th time in a row.  It’s a great honor to be selected for the VMware vExpert award, more so because I’m not a sysadmin by trade, but I’m able to talk to sysadmins about databases and what the best options for hosting them within your VMware environment are.

Thank You, VMware for recognizing all the work that I’ve been doing, and that I plan to keep doing throughout the next year.

Denny

The post Another Year Gone, Another Year as a VMware vExpert appeared first on SQL Server with Mr. Denny.

Contact the Author | Contact DCAC

I thought my days of Linux were over

Published On: 2019-03-18By:

Oh, how wrong I was. Back in the day, all I worked on was Microsoft SQL Server. These days I’m doing some Microsoft SQL Server and a decent amount of Microsoft Azure and Amazon AWS cloud work. With all three of those, there’s a lot of Linux in play. Microsoft SQL Server has supported Linux since the release of SQL Server 2017 at Ignite 2017.  Microsoft Azure and Amazon AWS have both supported Linux since (I believe) they first supported VMs in their cloud platforms (forever is the world of computers).

Back when I had just a few years expense with SQL Server (and IT in general) I also owned and managed a large (at the time) Oracle database which ran on Unix. Once that was no longer my baby to manage, I assumed by *nix carrier was over. And it was, for a while, but now Linux is back and this time in the SQL Server world.

Looking at the servers that DCAC has in our Azure environment, we have more Linux boxes than Windows. Our website runs off of PHP running on a pair of Linux servers. Our database is MySQL running on a couple of Linux server (eventually we’ll move all this over to Azure PaaS, but still running on Linux). The only production servers in Azure that we have running Windows, our the Active Directory domain controllers, one of which also syncs from Active Directory to Azure Active Directory to handle our sign in, Office 365, etc.  That’s it. Everything is Linux.

Our lab environment in our CoLo is also a mix of Windows and Linux.  We have a few tools that were built by Microsoft that we run that are running on Windows, but we’ve also got a decent amount of Linux in the data center as well.  By the time this is published (I’m writing this on the flight to the PASS Summit in November 2018) we’ll have a Docker cluster up and running as well (unless I get lazy and I don’t get up to the CoLo to rack the servers for it). This Docker cluster is Linux based as well and will let us run a bunch more Linux servers as well.

Your point is?

The point that I’m trying to get to in all of this is that if you are a database administrator that thought they were going to stay in the Windows world forever, think again. You have to be an expert in Linux to manage these systems, but you’ll need to understand the difference between Windows and Linux. SQL Server has a few differences between the platforms, and these differences are significant to the platforms.  As a Windows DBA you’ll want to be able to navigate the Linux Operating System, and tell your system teams where SQL Server is storing the database files (they are in /var/opt/mssql/data if anyone asks) so that they know which mount points need to be made bigger.

You don’t need to know everything, but the basics of Linux are doing to take you a long way.

Denny

The post I thought my days of Linux were over appeared first on SQL Server with Mr. Denny.

Contact the Author | Contact DCAC

William Ryan Homes Azure Migration

Published On: 2019-03-14By:

The Client:

Home Being Built
Founded in 1992, William Ryan Homes is the award-winning home builder of more than 10,000 new homes across the United States.
IT Support Coordinator Peter Guzman has been with the company for six years.

The Challenge:

When employees and clients of William Ryan Homes started complaining about slow applications, Peter Guzman knew it was time to go to the cloud.

“Our contractors couldn’t see what their next task was on the schedule, so they couldn’t move things around to reschedule vendors in accordance with construction. Everything was SLOW,” Peter explains.

The on-premise server critical to ERP/ERM was on its last legs and their SQL Server software was out of support. The fiscally prudent choice was to migrate to the cloud to spare the company major capital expenditures. But as the lone IT support coordinator for the whole company, Peter couldn’t manage a migration in addition to production needs. He needed an expert capable of doing the migration seamlessly and the consultant had to be willing to work around the company’s multiple time zones of production. He turned to an expert he trusted in the IT community, who gave him two names. Peter called them both.
Read Now >

Contact the Author | Contact DCAC

Webcast: Power BI: Where Should My Data Live?

Published On: 2019-03-11By:

At 11 am Pacific /2 pm Eastern on April 5th, 2019 DCAC will proudly be presenting the webcast “Power BI: Where Should My Data Live?” which is being presented by our own Meagan Longoria and Kerry Tyler.

Power BI provides many options for acquiring and creating datasets. Do you know the difference between an Imported Model, a Live Connection, and DirectQuery? Have you tried Composite Models? Are you aware of the newest features related to Power BI Dataflows and XMLA endpoints? This webcast will review your options for where to store data and explain the factors that should be used in determining what option is right for you. Obvious requirements such as data size, license costs and management, and desired data latency will be discussed. We’ll also talk about other factors such as the desire for self-service BI and avoiding data model sprawl. Join us for this webcast to learn how to determine the most appropriate type of Power BI dataset for your use case.

Click through and sign up for the webcast today. You’ll be able to download a calendar entry to remind yourself about the webcast. See you on April 5th.

If you register for the webcast and you can’t make it, fear not the session will be recorded and available for viewing after the fact as well.

Denny

 

The post Webcast: Power BI: Where Should My Data Live? appeared first on SQL Server with Mr. Denny.

Contact the Author | Contact DCAC
1 2 3 4 5 343

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       Insights Sccess Award    Technology Headlines Award    Golden Bridge Gold Award    CIO Review Top 20 Azure Solutions Providers    VMWare Partner
Microsoft Certified Master    Microsoft MVP