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.
What is Kubernetes?
In 2017, Microsoft introduced “SQL Server on Linux.” In 2019, you can configure Availability Groups to run on Kubernetes cluster. Another very interesting feature in SQL Serve 2019 is called Big Data Clusters (read the MS white paper here). The more I read about these new features the more I realize how *important* Kubernetes is becoming.
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”
How To Install Docker Desktop For Mac
In my previous blog post I talked about installing Docker Desktop for Windows. This post will be on Installing Docker Desktop for Mac. I have a Mac Mini 2018 model.
How To Install Docker Desktop For Windows 10
If you’re like me and fairly new to containers and want to give it a try, the question is how? What (and how) is the quickest way to get setup with a Docker container environment?
Continue reading “How To Install Docker Desktop For Windows 10”
What Are Docker Containers?
Containers, Containers, Containers. It’s one of those things that apparently has been around “forever” but I just recently started to hear about it. As a Windows SQL DBA, things like Containers seems absolutely foreign to me.
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: 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.
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):
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.
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!
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”
Impostor Syndrome in the SQLFamily?
This past week was the MVP Summit out in Redmond, WA. Now, I’m not an MVP but I do follow a ton of them on social media and had the privilege to interview a handful of them.
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 ):
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!
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.
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.
Blog Stats – 2018
HAPPY NEW YEAR!
Finally, another full year of web traffic! Time sure does go by fast! My goal was to blog more during 2018 than 2017. Below is the breakdown: Continue reading “Blog Stats – 2018”