What is Azure Kubernetes Service (AKS)

Installing and deploying a Kubernetes cluster on-prem can be a pain in the arse. Especially if you are new to Kubernetes. That’s where a cloud provider like Microsoft’s Azure comes in handy. Instead of having to go through the arduous task of installing, setting up, configuring and deploying Kubernetes clusters, you can just use Microsoft’s AKS, or Azure Kubernetes Service, to quickly deploy clusters. That way you can focus on your organization’s mission critical issues, rather than worring about ongoing operations and maintenance of your Kubernetes cluster.

Continue reading “What is Azure Kubernetes Service (AKS)”

Book Review – “The Kubernetes Book” by Nigel Poulton

As a SQL Server professional, I find it extremely exciting when new features come out. For example, when Microsoft launched SQL Server 2017, you could install it on Linux. SQL Server 2019 supports availability groups on containers in a Kubernetes cluster. Also in SQL Server 2019, there is the new Big Data Clusters feature, and guess what it uses for container orchestration? You guessed it, Kubernetes.

The average SQL Server DBA might not have much experience with setting up HA/DR solution utilizing Availability Groups, let alone installing it on Linux or figuring out the ins and outs of containers and Kubernetes. But for those who like to push themselves by learning new things and securing their future, this blog post is a review of a book by my friend Nigel Poulton (b | t), titled, “The Kubernetes Book.” Continue reading “Book Review – “The Kubernetes Book” by Nigel Poulton”

Interview – Melody Zacharias

I decided to start a series of blogs where I interview key people in the SQL Server community. Instead of me asking technical questions, I plan on asking about their outlook on the future, books they read (non-fiction and/or technical), and their overall thoughts on where technology (mainly SQL Server) is headed. You can find more interviews here.

Next up: Melody Zacharias (b | t):

Mohammad: Do you think people who dismiss the cloud as a “fad” or just don’t take it serious enough to learn about it (i.e. Azure, AWS, etc), will be in a tough spot to find a job 5 years from now?

Melody Zacharias
Melody Zacharias

Melody: Will people who do not embrace the cloud be in a tough spot to find a job in 5 years. I don’t have a crystal ball, but, I would be surprised if they would be happy with their decision. 😊 Our industry is constantly changing and if we do not change with it we will be unhappy. That is not a cloud vs non cloud issue but just a general, we as professionals should try to continue to learn to ensure we can stay relevant.

Continue reading “Interview – Melody Zacharias”

Interview – Derik Hammer

I decided to start a series of blogs where I interview key people in the SQL Server community. Instead of me asking technical questions, I plan on asking about their outlook on the future, books they read (non-fiction and/or technical), and their overall thoughts on where technology (mainly SQL Server) is headed. You can find more interviews here.

Next up: Derik Hammer (b | t):

Derik Hammer
Derik Hammer

Mohammad: Do you think people who dismiss the cloud as a “fad” or just don’t take it serious enough to learn about it (i.e. Azure, AWS, etc), will be in a tough spot to find a job 5 years from now?

Derik: I believe that there are three categories of IT professionals.

Continue reading “Interview – Derik Hammer”

How To Install SQL Server 2019 on Linux (CentOS)

Everyone is talking about Linux. SQL on Linux? Wow! I think it’s about time I start to dive into it. If you’re like me, then the only thing you know about Linux is that you know it’s an OS. That’s it. I have never installed/configured it let alone installing/configuring an app on it.

Then came along SQL Server 2017 (and now 2019), and the ability to run it on Linux. That was really eye-opening to me. Microsoft definitely loves Linux!

Microsoft and Linux

This post will go into how to install Linux (CentOS) and SQL Server 2019.

Continue reading “How To Install SQL Server 2019 on Linux (CentOS)”

Could Not Locate Statistics In The System Catalogs of Secondary Replica

Recently I encountered an error that I have never seen before:

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Msg 2767, Level 16, State 1, Procedure sys.sp_table_statistics2_rowset, Line 105
Could not locate statistics ‘_WA_Sys_00000058_XXXXXXXX’ in the system catalogs.

Continue reading “Could Not Locate Statistics In The System Catalogs of Secondary Replica”

applicationintent=readonly in Azure Data Studio

Recently, I had to use Azure Data Studio to access a application intent read only secondary replica. I had to use Azure Data Studio because I was using a Mac. I usually use SSMS on my Windows machines. If you want to connect with the “applicationintent=readonly” property via SQL Server Management Studio, you do so by typing it out in the “Additional Connection Parameters” as shown in the screenshot below:

Continue reading “applicationintent=readonly in Azure Data Studio”

Interview – Erland Sommarskog

I decided to start a series of blogs where I interview key people in the SQL Server community. Instead of me asking technical questions, I plan on asking about their outlook on the future, books they read (non-fiction and/or technical), and their overall thoughts on where technology (mainly SQL Server) is headed. You can find more interviews here.

Next up: Erland Sommarskog (b ):

Erland Sommarskog
Erland Sommarskog

Mohammad: Do you think people who dismiss the cloud as a “fad” or just don’t take it serious enough to learn about it (i.e. Azure, AWS, etc), will be in a tough spot to find a job 5 years from now?

Erland: The cloud is certainly not a fad. Fads don’t last this long. At this same time, the cloud does not really seem to take off like Microsoft and others want us to believe. I work very little with the cloud myself, and I have only had one client that was cloud-based. All my other client seem to be on-prem, although there is more than one for which the cloud would make perfect sense.

So, yes, I think there will still be work for earth-based people five years from now, but I think more and more people will start to look into the cloud, and they will be dragged into, whether they like or not. It may even happen to me!

Continue reading “Interview – Erland Sommarskog”

Interview – Sunil Agarwal

I decided to start a series of blogs where I interview key people in the SQL Server community. Instead of me asking technical questions, I plan on asking about their outlook on the future, books they read (non-fiction and/or technical), and their overall thoughts on where technology (mainly SQL Server) is headed. You can find more interviews here.

Sunil Agarwal
Sunil Agarwal

Next up: Sunil Agarwal (b | t):

Mohammad: Do you think people who dismiss the cloud as a “fad” or just don’t take it serious enough to learn about it (i.e. Azure, AWS, etc), will be in a tough spot to find a job 5 years from now?

Sunil: Most businesses are moving to cloud to leverage ease of development, deployment and operationalizing which ultimately leads to lowering the cost and the competitive advantage. I expect many new development projects will gravitate towards the cloud but the IT landscape will be hybrid with some legacy, not all, applications still running on-premise either due to business regulations or compliance issues. IT expertise will remain in demand even in cloud worlds but the shift will be towards more value add expertise like troubleshooting rather than the routine activities like installing software, upgrading hardware and such.

Continue reading “Interview – Sunil Agarwal”