Skill Up or Give Up: Azure Data Studio or Bust

One of the things I have found over the years is that it is easy to get into a rut and do things “the way I’ve always done them.” While this is perfectly natural, it also leads to a degradation of skills over time. Even more importantly, there may be a MUCH easier way to do something with newer tools or techniques.

A great example of this is going back to when SQL 2005 was released. This was a massive change to SQL Server with the introduction of SQL Server Management Studio (SSMS), Dynamic Management Objects (i.e. DMVs and DMFs) and much more. For those of us who had been using the product for quite some time, getting rid of Enterprise Manager and Query Analyzer was big deal and a steep learning curve.

DMVs were even worse. To this day I still find myself querying old system tables such as sysfiles or sysprocesses when I’m not thinking about it. In fact, in the spirit of full disclosure, I did not really focus on using DMVs and upgrading those skills until 2008 or so when I attended a pre-conference workshop on DMVs given by Kevin Kline (Twitter).

What does this have to do with being a DBA in 2021? Everything. We have seen massive changes to the Microsoft Data Platform over the last 5-10 years — PowerShell, Azure, other cloud platforms, and the advent of technologies such as NoSQL databases and Big Data to name a few.

In 2018, Microsoft released Azure Data Studio (ADS). ADS is a fork of Visual Studio Code, so if you’ve used that at all it will be very familiar. Like many others, I have not been super fast to adopt and start using it.

In the spirit of skilling up, my co-worker Scott Klein and I were discussing this a couple of weeks ago and we hatched a plan: For the next 30 days, we are both going to force ourselves to use ADS for everything we do.

Then, on March 17th, Scott will host a Webinar on SSMS vs. ADS and what our experience has been. Watch for a blog from Scott in the next day or two for background on this battle of the apps.

Fasten your seat belts! This is going to be a blast.

 

Please share this
Tags
#microsftcertifedmaster #microsftpartner #parallelism #azure #SQLAB #SQlatino #SQlatinoamerica #sqldatabase #sqldeveloper #SQLgroupie #sqlimer #sqlimerbymay #sqlinjection #sqlinternals #sqlite #sqlite3 #SQLLearning #SQLMagazine #sqlmanagementstudio #sqlmanager #Sqlmap #sqlrun #sqlsaturday2017 #sqlsatvienna #sqlserver #SQLserver2012 #sqlserver2014 #sqlserver2017 #sqlserver2022 #SQLServeronLinux #SQLsolutionsgroup #SQLTraining #SQLYog Events Extended Events learning SQL SQL Administration SQL Internals SQLPASS SQLSaturday SQL Saturday SQL Server SSG SSIS T-SQL
Picture of Randy Knight

Randy Knight

Randy Knight, a Microsoft Certified Master, founded SQL Solutions Group in October 2010, after more than 20 years in the technology industry. Randy has a passion for solving what can seem to others to be insurmountable problems. His prowess with SQL Server earned him the label “database whisperer” from one satisfied customer. Randy is a Microsoft Certified Solutions Master in SQL Server 2008. In 2020 he completed certification for Azure Fundamentals. In addition, he has numerous Novell, Microsoft, and Cisco legacy certifications. Prior to founding SSG, he spent many years as a Database Administrator in a variety of industries, including financial services, telecommunications, and with well-known dot com properties. As a data professional, Randy says he has done lots of fun stuff, encountering the most interesting data during his time as database architect for match.com (and no, he didn’t meet his wife while working there). In addition to getting elbow-deep in data, Randy enjoys taking part in and presenting at SQL Server events nationwide, including SQLSaturday, User Groups, SQL PASS Rally and SQL PASS Summit. In Randy’s words, “We've assembled a great team of SQL Server Consultants at SQL Solutions Group, and we have the talent to tackle anything."

This Post Has 2 Comments

Leave a Reply

Related Articles