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.
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”
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?
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”
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.
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
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”
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”
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?
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”
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.
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.
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).
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.
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:
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?
Back in 2015, I attended IEPTO1 by SQLSkills. It was there that I met Tim Radney. I remember asking him for advice on the best way to get out there in the community, etc. He said, “start a blog, then start speaking at user groups and SQL Saturdays…”