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”
3 Keys To Successful Consulting
There are tons of videos and talks out there that address consulting. How to brand yourself, how to start a business, how to fill out a 1099, why to get into consulting, how to get clients, etc. But I couldn’t find anything addressing one of the most difficult aspects of consulting.
Review – Brent Ozar’s Performance Tuning Classes
Importance of a Methodology
There are tons of scripts and “how-to” videos on the internet that teach a wide range of topics. My problem is whenever I want to learn something niche. I want to go deep into a niche topic and learn it “A-Z”, but rarely find a guide for that. It’s always been in piecemeal fashion. So when I find a course that offers that “A-Z” style, it definitely grabs my attention. But, the cherry on top for me is when that course/s teaches a methodology.
Continue reading “Review – Brent Ozar’s Performance Tuning Classes”
Book Review – “Microsoft SQL Server 2017 on Linux” by Benjamin Nevarez
Microsoft SQL Server 2017 introduced something absolutely new. It can run on Linux! SQL Server is no longer “Windows only.” Whether you’re into using Linux or Windows, it’s interesting to see where Microsoft is going with SQL Server. The background of why/how Microsoft decided to create a SQL Server version that runs on Linux is intriguing in itself. This blog post is a review of my dear friend Benjamin Nevarez‘s latest book, “Microsoft SQL Server 2017 on Linux.” Continue reading “Book Review – “Microsoft SQL Server 2017 on Linux” by Benjamin Nevarez”
SQL Server 2019 – Certificate Management in SQL Server Configuration Manager
Among the cool new features in SQL Server 2019, one stands out that I remember being a pain in the butt with earlier versions: Certificate Management in SQL Server Configuration Manager.
Continue reading “SQL Server 2019 – Certificate Management in SQL Server Configuration Manager”