Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
The Voice of the DBA
 

Daily Coping Tip

Make a list of new things you want to do before the end of the year

I also have a thread at SQLServerCentral dealing with coping mechanisms and resources. Feel free to participate.

For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from The Action for Happiness Coping Calendar. My items will be on my blog, feel free to share yours.

Losing Skills Because of Automation

When I was younger, it seemed that everyone I worked alongside in technology knew how to build a computer. Most knew how to work with a BIOS, were comfortable with command lines, and could assemble complex compiler directives into a Make file. Over time, it seems many people, especially Windows and MacOS users, became focused on the things they needed for their job, lacking a lot of knowledge about how computers process instructions and the low level operations they perform in our software.

There are plenty of very talented developers out there, and many great data modelers, but as I work with many of them that try to make the transition to DevOps, I see lots of uncertainty and tentative behavior. They often approach builds, automated tests, and deployments as though these are completely new skills they need to learn. New software that is foreign to them.

I wonder if the increased use of automation will make this worse in the future? Already plenty of companies are looking to low code and no code solutions as a way to handle the lack of staff to perform development. Will that be exacerbated in the future as more and more automation is put in place that mocks up a shell (or more) of a project and handles work for the developers and even operations staff? Will they struggle to debug complex problems, which are the more likely problems to occur in modern software?

There is an interesting article about surgeons that might be losing some skill with the advent of robots helping in surgery. While there are some worrisome aspects to this for me, as someone getting older and possibly needing medical care, I find that some of this applicable to the world of software. How well do we apprentice people new to our environment and give them the chance to build new skills? Often we have senior people taking on interesting work, making data modeling decisions, troubleshooting issues and more. Do we allow more junior people the chance to get hands-on experience with them getting the chance to take charge and lead others?

In a few places, I've seen senior people fixing bugs and junior people developing code. That seemed strange at first, until I realized that fixing problems is more than likely something I want the better developer dealing with, not the worse one. These don't even have to be issues in production. In a DevOps world, I might have the senior people looking at and fixing the bugs that are caught in CI. While I appreciate giving someone the chance to correct their mistakes, I also think that a "refactoring" or improving of code might be a place senior people can do better.

Of course, I think rotating people in and out of roles, giving them a chance to experience difference sides of our industry, including learning how dev works (for Ops people) and how Ops works (for developers) can bring about empathy, understanding, some skills, but likely a better culture of collaboration. A tenet of DevOps.

What skills are we worried about learning? Or losing? To what extent ought we try to ensure others grow wide and deeper outside of their core skills? I find this to be a area that the best DevOps companies do well. They have champions that can provide assistance, knowledge, and teaching, not just do the work. Companies that pretend to adopt DevOps aim for specialization, letting others do the work when they can. Over time, I think they'll end up like some of today's surgeons: only practicing their craft for the first time with no training when someone else isn't available.

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums

 
  Featured Contents
SQLServerCentral Article

The Art of Data Ingestion - Part 1

Sarah from SQLServerCentral

Data movement is a fundamental piece of a data engineer’s duties, and recently I’ve been thinking about the art of data movement. What are some of the most important pieces that a data engineer needs to think about when confronted with data ingestion? There is of course data exporting as well, and in that case, […]

External Article

Join a community like no other at Summit

Additional Articles from Redgate

There's less than one week until PASS Data Community Summit takes place, and there's still time to register for an in-person or online pass, and unlock access to over 300 world-class sessions. Join liked-minded attendees at the year's largest hybrid data platform conference. Register now.

External Article

Refresh a Power BI Dataset using Microsoft Power Automate

Additional Articles from MSSQLTips.com

Learn how to refresh a Power BI dataset by integrating Power Automate into the report.

Blog Post

From the SQL Server Central Blogs - Create Service Principal Names Along with a Managed Service Account

Patrick Keisler from Everyday SQL

In a few previous articles, I have talked a lot about Managed Service Accounts (MSA) and Service Principal Names (SPN) and given examples of managing the separately. As a...

Blog Post

From the SQL Server Central Blogs - Improved data loads from Snowflake to Azure Synapse Analytics

sqlrunner from SQLRunner

My responsibilities revolve around providing the business with the data they need to make informed business decisions. One of those processes requires us to shift data from a Snowflake...

 

  Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

Adding SQL Variant Data

 

Think you know the answer? Click here, and find out if you are right.

 

 

  Yesterday's Question of the Day (by Steve Jones - SSC Editor)

THROW Messages

What are my options for the message returned by THROW?

Answer: both custom messages not in sys.messages and sys.messages values can be returned

Explanation: THROW requires an error number above 50000 is used, and then a custom message and state. However, if THROW is within a CATCH block, you do not need to provide parameters and the error from sys.messages will be returned. Ref: THROW - https://learn.microsoft.com/en-us/sql/t-sql/language-elements/throw-transact-sql?view=sql-server-ver16

Discuss this question and answer on the forums

 

 

 

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.


SQL Server 2017 - Administration
Db is slow - Hi SQL Gurus, One of our production database is running very slow. I checked blocking , I didn't see any blocking. Also, check for running processes and look for any waittype. I see null. How to get more insights on a running sql server for a specific databases? What all can he checked in this […]
Datafile full, but it isn't a table - Hi all, I currently have a SQL Server 2017 with a filegroup full. I temporarily added a file as a workaround, but need to solve the issue. The problem is that it is not a table that is filling up the space, numbers are completely different (table size will make it currently around 10% of […]
SQL Server 2019 - Development
Float - Hi, I am having problem with generating a Float which generates a output of adding 1 every second month. Currently, I have a solution of dividing the target by 365, but then I wont get the value to change exactly when the month starts. My data consists of date, employee id and target Hope one […]
Sql subquery poor perf - Need to rewrite to optimise - I have a sql query as below which takes endless time to execute. Any help in rewriting this query to better way would be appreciated greatly. Select PolNr , (select value from tblPolSpec d where m.PolNr=d.PolNr and d. Category='Holder' ) as HolderName , (select value from tblPolSpec d where m.PolNr=d.PolNr and d. Category='Status' ) as […]
Issue with converting Varchar to Numeric so I can add them - I have this so far . . . SELECT * INTO #tempValue FROM ( SELECT t.HTS_98_Value, t.HTS_99_Value, t.HTS_B_Value, t.HTS_A_Value, t.HTS_C_Value, t.Customs_Entry_Number, SUM(convert(numeric,replace(isnull(hts_a_value, '0'), '','0')) + convert(numeric,replace(isnull(hts_b_value, '0'), '','0'))) AS New --HTS_A_Value + HTS_B_Value) AS new --+ HTS_B_Value + HTS_A_Value + HTS_99_Value) AS Header_Val FROM #temp1 t GROUP BY t.HTS_98_Value, t.HTS_99_Value, t.HTS_B_Value, t.HTS_A_Value, t.HTS_C_Value, t.Customs_Entry_Number ) […]
Tools needed for designing SSIS package - Hi All, I am using SQL 2019 developer edition. I want to develop and test SSIS package, which tool I need to download and install it. Searched in google and found Visual studio , Azure studio and SSDT etc., Do I need all three.
SQL Azure - Development
Azure Data Studio Intellisense Cache Notebooks vs SQL Files - Hi, I've noticed that my SQL notebooks will take a long time to refresh the intellisense compared to a .sql file. When I create a new object, no matter how many times I "Refresh Intellisense Cache", the object will not show up in intellisense until I close the notebook, reopen, reconnect, etc (and even then, […]
General Cloud Computing Questions
Cloud Hosting - Hello. How much does it cost to host an Unifi controller in the cloud (Linode, Digital Ocean, AWS, Azure)? I'm an individual user with a VERY small setup (two desktops, iPhone, and an iPad). My Unifi setup will be: USG AC-Pro Switch 60W I'm wondering if anyone else with a small setup has real-world experience […]
Azure Data Factory
Question about using Azure Data Factory with MySQL - I went ahead and signed up for the free Azure trial and created my first data factory last night. Right now I have 3 databases running on my computer. SQL 2019 Developer Edition Full Install SQL 2017 running in Docker container MySQL running in Docker assuming it's the most recent version. Using Data Factory as […]
Reporting Services
Multi valued parameter is passing multiple values as one string - So I've got this report that has two date parameters and a multi choice var char parameter. When I choose 1 option it runs fine, but when I select more than one it failes because the parameter is being passed as a single string with no commas seperating the values.   I tried adding an […]
SSRS 2016
Definition of the Report is invalid when Deploying Report - I'm a little new to SSRS and I hope I can get some direction. I have a Report which consists of 4 different Subreports all in their own rectangle to facilitate page breaks (See attachment). Some of the Subreports were copied and slightly altered (new text) and some are used as is. They all run […]
General
Unsecured site error in Edge Only - some of the pages showing unsecured in Edge even though the SSL certificate is binded (the same error doesn't happen in other browsers... The site is loading as IE5 compatibility mode) Can someone please help! its urgent.
Suggestions
Plase fix the "Post Offset" problem. - Clicking on post notifications takes us to the correct thread but frequently takes us to the wrong post.  I've determined that the issue is that posts on any given thread that are marked as "SPAM" are not counted in the "15 posts per page" count. Any chance of getting this fixed (along with the broken […]
Email Notifications is broken again. - Howdy folks... The email notifications for subscribed posts is broken and has been since about 26 Oct 2022.  At least that seems to be when I stopped getting them.  Others (on "The Thread") have confirmed this issue, as well. The emails for what followers post is fine, though.
MySQL
Best method to migrate 8 GB database from MSSQL to MYSQL - All, Best method to migrate 8 GB database from MSSQL to MYSQL. The server is in windows 2019 with express installed. I have used workbench with ODBC - It says all the time not responding I have tried to install VS 2019 and 2022, both are not working in windows 2019 server to test SSIS. […]
 

 

RSS FeedTwitter

This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -