T-SQL & Development
What Are Your Coworkers Learning Right Now?
Not a poll, no fixed list of answers, just totally open comments.
What are the developers, sysadmins, and data professionals on your team learning these days? Any particular topics that they’re really excited about?
Let me know in the comments.
(I think this is the shortest post I’ve ever written, hahaha!)
Free, 3× a week
Get my new posts by email
Three posts a week, plus a Monday roundup of the best database news from around the web.
Powershell… All the non C# programmers I have got going on powershell are simply amazed at what it can do and how easily it can do it (as am I) and dive in with both feet. Seems like daily we find a solution in powershell and shake our heads at how powerful and elegant it is.
The C# programmers however seem to fear it will upset the pecking order and resist learning it.
jupyter notebook
Ansible and Terraform (DevOps), MariaDB and Galera Cluster (administration), Oracle (administration and PL/SQL), Microsoft SQL (performance tuning), ITIL, Scrum
PowerShell…Automation, monitoring scripts working on building in house SQL Server Monitoring using PowerShell.
Python, elastic and spinnaker
.NET Core 2.2, 3.0, Blazor, Power BI
To bitch!
They didn’t know how to do that already?!?
🙂
Power BI Dashboards for reporting on SCOM, MIM, and now also SQL Server (thanks for your recent post on this).
Management love the dashboards.
PowerShell, dbatools, DSC
My brother works for a large bank, and apparently the big drive there now is to start using PostgreSQL at the moment due to it being open source. Must say I found it surprising. I started reading up on it and see it seems pretty well established – never worked with it though.
Powershell and dbatools
Elasticsearch, Kibana, UiPath
powershell, dbatools, docker
Developers are moving to low code, no code using Appian.
ahh yes, the holy grail. no code development. Been hearing about that for 25 years. And the new marketing is “no thinking needed development” (the AI buzzword).
Did your managers ever buy a bridge in New York by any chance?
Learning Ansible & VRealize Automation. Creating a self service platform for multiple DB techs including SQL Server, Oracle, PostgreSQL, MySQL, etc…
Microsoft SQL Administration & Performance tuning,Powershell, Tableau
SAP HANA, Powershell, they are wandering around the edges of Docker, SAP c/4, some of the BI folk are getting involved in Python, SSAS Tabular.
Javascript, HTML, and dare I mention the dark arts…they’re exploring using Kubernetes
Depends on which team we’re discussing:
— BI Team = PowerShell, Snowflake, Scrum
— Cloud Team = PowerShell, Terraform, Elastic Stack
Powershell and dbatools
Containers
Kubernetes, Docker, Big Data Clusters in SQL 2019
In our shop most of the sysadmins are focusing on AWS stuff, since we have a corporate initiative to get everything into the cloud.
Our principal DBA has also been focusing on AWS related services, mainly DMS and RDS. Our backup DBA (me) is still learning the ropes.
Our developers have (very grudgingly) been learning that PowerShell is a, well, powerful tool when used correctly. Additionally, the DBA team is trying to teach developers about some of the worst anti-patterns that we see hitting our servers hard, and how to avoid them (implicit conversions, table variables with tons of rows, tons of optional parameters EVERYWHERE, etc…)
VMware ESXi upgrades, Outlook add-in development, Swift, Chrome extension development, Azure API management. It’s 2020 budget planning time, so everyone is pretty excited from all the hopes and dreams for next year.
R and Python (Data Science) and some Postgres
Python, PowerBI, MySql (Percona), Galera, Ansible, Tableau, these same things relative to Azure
powershell, kubernetes, PowerBI, and C#
Terraform, AWS glue and database migration services, dynamoDB streams, lambda functions(to put into aurora triggers).
kubernete, grafana, prometheus, Python, django and Poweshell
For most: Angular & Angular JS ; JSON ; ML.NET ; Python. For me (as an old fart database developer): Python and Powershell, with some DBA dabbling on the side (since we don’t have one in the company that I work for).
SQL Server parameter sniffing (unstable plans), SQL Server Resource Governor (stop bad plans from killing rest of system), AWS, Containers, production monitoring
Python,Postgres & AWS,
Postgres, Ansible, Docker, Kubernetes and … SQL Server (I am an Oracle DBA)
SQL Server, Azure, PowerShell, and agile. I was a DB2 (mainframe) DBA.
BigQuery and many of my team are working towards the GCP Data Engineering certification.