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”
Review – Samsung T5 Portable SSD 1TB
Memory and Storage is cheap right?
I needed something fast, and at least 1 TB, to compliment my Surface Book 2. After some brief research (aka, read Amazon reviews), I decided to purchase the Samsung T5 Portable SSD.
IDERA ACE Class of 2019
I remember first hearing about the IDERA ACE program a little over a year ago (in 2017). Previous to that, I had no idea that companies existed that helped out the SQL Server community. As soon as I read-up about the ACE program I emailed asking how I could apply. Of course, I had missed the 2018 submission deadline by a few weeks. So I had to wait an entire year to apply…
Continue reading “IDERA ACE Class of 2019”
Interview – Drew Furgiuele
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: Drew Furgiuele (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?
Drew: I think we’re well enough into the era of cloud computing that everyone should at least know not just what a cloud provider like Azure or AWS is, but also what different services they offer. It’s not enough anymore to say “oh yeah, I’ve worked with the cloud.” I think most people who want to explore this space should be at least to say something like “I’ve stood up a database as a service in Azure” or “I’ve built a VM in EC2.” And if you can’t, there’s still plenty of time to start learning. Oh and by the way, more and more services are coming to cloud providers each and every day. I don’t think that NOT knowing these things puts any kind of expiration date on your current job, but if you’re looking for new opportunities, you might start to find yourself at a disadvantage.
Continue reading “Interview – Drew Furgiuele”
Review: Stellar Phoenix SQL Database Repair
Review: Stellar Phoenix SQL Database Repair
Of the several issues encountered with SQL Server — SQL Server gets slower with time, generation of reports becomes tedious, SQL Server crash, performance issues and more — the most troublesome for DBAs is the crash or failure of SQL Server. Reason being, the repercussion is a damaged or corrupt SQL Server database.
Continue reading “Review: Stellar Phoenix SQL Database Repair”
From System Admin to SQL Admin?
I received the following reader question today and want to reply via a blog post:
Hi, Nice website, the interviews are pretty cool. I am a system admins, I want to transition to the database world, it seems that based on what I’ve been reading AWS and Microsoft SQL developer certifications are the way to go. Could you guide me in terms on putting a list together of which certifications I should own along with what skills/knowledge I should obtain in order to be able to secure a job for now and well into the future? Best Regard
Interview – Matt Gordon
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.

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?
Matt: I certainly think they’ll be in a tougher spot than they are today. As a consultant, I’m seeing an increase in customer cloud adoption so logic follows that anybody dismissing the cloud as a fad is going to have a tougher and tougher time finding places that do not have any data resources in the cloud. That said, there are still companies running SQL Server 2000 so I’m sure there will still be DBA opportunities somewhere for folks who believe the cloud is a fad. Those opportunities, however, are likely to be a career dead end.
Continue reading “Interview – Matt Gordon”
Interview – Chris Yates
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.

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?
Chris: In a tough spot might be a stretch, but I do think it is something that all data professionals need to invest time in. While many companies are made great strides to get to the cloud there are still many financial institutions and other areas of business that have not got to that point yet. I am, and always will be, a huge proponent of never quit learning and the cloud is definitely the future.
Continue reading “Interview – Chris Yates”
Interview – John Q. Martin
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: John Q. Martin (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?
John: The trend I am seeing is for more of a hybrid data platform environment where there is a diverse mix of SQL Server both on-premises and in cloud platforms. I am seeing more and more companies look at the Platform as a Service offerings that are on offer such as Azure SQL Database, Amazon RDS for SQL Server, and Azure SQL Database Managed Instance. The latter option with its high degree of parity with the retail SQL Server product makes the jump from managing full blown SQL Servers to PaaS semi-manged platforms a lot more viable.
Continue reading “Interview – John Q. Martin”
What is the CLIUSR Local Account?
Recently I had to patch nodes in a failover cluster and encountered a very strange situation. I decided to post about it just in case someone else out there encounters the same issue.
How to do a SQL Vulnerability Assessment in SSMS
Making sure that your SQL Server environment is secured can be cumbersome and tricky. In SQL Server 2012 (and later), Microsoft introduced a tool called, “SQL Vulnerability Assessment“, which helps in finding potential database vulnerabilities. It’s a great tool to help proactively improve your SQL Server database security.
Continue reading “How to do a SQL Vulnerability Assessment in SSMS”
How to Enable Instant File Initialization SQL Server
There are few features in SQL Server that are disabled, or turned OFF, by default that, in my opinion, should be turned on/enabled. One of those features is something called “Instant File Initialization” (You can read about the other one here).
Continue reading “How to Enable Instant File Initialization SQL Server”
BEST SQL Server Indexing Course
Understanding how SQL Server indexing works is crucial for diving deeper into SQL Server internals and overall becoming a SQL Server “badass” :) Having said that, it’s definitely not an easy topic to pickup and comprehend.
How I Overcame My Fear of Public Speaking
One of my goals for 2018 was to start speaking at events (i.e. User groups, SQL Saturdays).
A handful of people (including attendees) have asked how I picked the locations to speak at (i.e. OC, Albuquerque, Dallas and Pensacola). Below is the logic (or lack there of) that went into picking the locations:
- Orange County, California – C’mon. Any excuse to go to California :)
- Albuquerque, New Mexico – Breaking Bad
- Dallas, Texas – My cousin lives there
- Pensacola, Florida – A dear friend/mentor of mine will be speaking there as well (Tim Radney)
How I Overcame My Fear of Public Speaking
As I sit in my hotel room after giving my 4th (and most likely last SQL Saturday event for 2018), I was wondering how I overcome my fear of public speaking?
Continue reading “How I Overcame My Fear of Public Speaking”