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

Can You Become a More Productive Engineer?

The short answer is of course, most of us can learn and improve our skills to become better developers, engineers, DBAs, etc. While we might not be able to become the 10x engineer that many aspire to be, we can certainly become a better employee inside of an organization.

There's a piece on becoming a more effective engineer, which is actually titled know how your org works. It a piece from an engineer that started with a tweet: The text was:You can either complain and pontificate on Twitter on how the tech industry *should* ideally work, or you can learn how your org *really* works and what’s rewarded, and optimize for that. Or quit and find another job.  This might sound cynical - but it’s what it is.

That sounds a little harsh, but the reality of how your org works or is structured or interacts is a reality. We all have hindsight to look back and wish someone (including us) had written code better. We might be sure if we could change one thing, or add/remove someone else, or make some other change, then things would be better. We might feel that there is a simple solution. Those things might be true, but they aren't the reality of the situation.

Learning to be more effective an engineer in your situation does involve learning to work within the reality of your position in your organization. You need to learn to work well with others, to understand what needs to be completed from the perspective of you and your group, and what the organization places importance on getting done. That last one might not be what the organization expresses, as there can be a big disconnect between words and actions.

You also need to learn how to deal with uncertainty. Often when we build applications, we don't have all the information, and we can't get it. We can't necessarily count on everyone we work with to have the same shared understanding or work at the same pace. We have to learn what levels of trust we can extend, work within ambiguity and be prepared to change our plans in response to how things work.

In other words, most organizations have a lot of chaos and to become a better engineer you must learn to navigate the chaos and still get the things done that others notice.

The piece has a section that soft skills are hard skills, which is true. When I see people who are very effective engineers, they can be the brilliant, 10x engineer, but that's rare. Usually it's the engineers that have strong soft skills in both working with others and understanding the power hierarchy in the organization that succeed.

Of course, some organizations are full of bureaucracy, favoritism, and disfunction that it's hard for anyone to become effective. It's amazing these places continue to exist, but they do. I've been in a few and I've left as soon as possible, which is my advice to you. Don't work in a dysfunctional environment. If you can avoid it. If you can't, then work to leave.

Effectiveness is part being better at coding (or tuning or admin or whatever), but it's also part learning to work well with the rest of the organization.

Steve Jones - SSC Editor

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

 
 
  Featured Contents
SQLServerCentral Article

Boosting Data Accuracy: Resolving Common Data Quality Issues Using SQL

Ganesh Gopal Masti Jayaram from SQLServerCentral

Poor data quality significantly hinders large enterprises from deriving meaningful value. The variety of data is a crucial factor to account for when assessing & rectifying data quality, as diverse data types introduce unique challenges in maintaining accuracy and consistency. Good data quality and integrity are essential for accurate insights, good decision-making, and potential success of large enterprises. Inconsistent, incomplete, and inaccurate data significantly affect business operations, customer satisfaction, and financial performance. SQL provides robust functions to proactively identify and resolve these data quality issues, ensuring accurate, reliable, and consistent data for reporting and analysis.

External Article

Oracle Architecture Overview

Additional Articles from SimpleTalk

In this document I will share an overview of Oracle’s architecture that isn’t complete, but it will give you a basic understanding of how the architecture works, especially if you are coming from other database platforms.

From the SQL Server Central Blogs - Data Masking with Azure Databricks

Rayis Imayev from Data Adventures

“Alice: Would you tell me, please, which way I ought to go from here?The Cheshire Cat: That depends a good deal on where you want to get to.”— Lewis...

Pro SQL Server 2022 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server and Azure SQL Database

Site Owners from SQLServerCentral

Use this practical guide to analyze and troubleshoot SQL Server performance using wait statistics. You'll learn to identify precisely why your queries are running slowly. And you'll know how to measure the amount of time consumed by each bottleneck so you can focus attention on making the largest improvements first. This edition is updated to cover analysis of wait statistics current with SQL Server 2022. Whether you are new to wait statistics, or already familiar with them, this book provides a deeper understanding on how wait statistics are generated and what they mean for your SQL Server instance’s performance. 

 

  Question of the Day

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

 

Counting Bits

What does the BIT_COUNT function do in SQL Server?

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)

Sparse Column Defaults

What are the restrictions for defaults on columns declared as sparse?

Answer: sparse columns cannot have a default

Explanation: Columns declared as sparse cannot have a default. Ref: Restrictions for using sparse columns - https://learn.microsoft.com/en-us/sql/relational-databases/tables/use-sparse-columns?view=sql-server-ver16#restrictions-for-using-sparse-columns

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 2016 - Development and T-SQL
Read data from json file - I am using the following code to read a json file. I can display the keys and coreentitykey info. However, I am unable to view the attributes (Enable and Name). Not sure how to display with the other fields. Any help is greatly appreciated. DECLARE @json NVARCHAR(MAX) = N'[ { "metadata": { "numNodes": "1329", "metadataKey": […]
SQL Server 2019 - Administration
Cannot restore new DB - I have made an empty DB called "HJEM_BB" I try to fill it from a backup (From device) When i select the backup, it opens nicely. Sets it to overwrite, some time goes, and i get this message: TITLE: Microsoft SQL Server Management Studio ------------------------------ Restore of database 'hjem_bb' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks) ------------------------------ ADDITIONAL INFORMATION: Microsoft.Data.SqlClient.SqlError: […]
SQL Server Data...is it encrypted? - Hi Suppose someone gained unauthorized access to the physical SS data stored on my machine.  Is the data encrypted?  Will the user need a password to access the data?  Here is how I login to SS: Thank you
SQL Server Setup - We don't have an IT department that can help us. We have our SQL server on a laptop that an employee owns and manages. He no longer wishes to support us with the SQL database on his laptop. The employee is disgruntled, so we need to make sure he does not have access to the […]
SQL Server 2019 - Development
standard deviation function doesnt seem to be behaving like an aggregate - hi i have 6 statistical populations in my overall data set.  They run across 21 data points.  No matter what i try with the standard dev function, i get back all 21 data points, each with a repeated std dev for the population that data point is in.  from the looks of the function it […]
Using ROW_NUMBER() to increment every time a value occurs - Hello folks, I have some rather unstructured data coming into a staging column from a file. I can guarantee the order of the data on load using a column I am calling RowNumber. I like to group the data using ROW_NUMBER() every time the value 'CreateDate' occurs. Here is current my effort. Thanks if you […]
SQL Azure - Administration
Transfer data from azure vm to blob storage - Hi Experts I want to move data/ some million rows from a Azure vm table to Azure blob storage. What all are the best ways to complete this task?   Thanks Manoj Bhadiyadra
Issue with Creating Linked Server from Azure SQL Managed Instance to On-Premises - Hi, Interestingly, I was able to create a linked server in the reverse direction—from the on-premises SQL Server to my Azure SQL MI—using a remote login and password for authentication. However, when I attempt to establish the link from Azure SQL MI to the on-premises SQL Server, it consistently fails. Additional Details: I have an […]
Reporting Services
The user data source credentials do not meet the requirements to run this report - I am trying to implement a SSRS reporting dashboard similar to the SQL-performance-dashboard-reports that allows me to click on a link to pull up another report (sub-report) passing it a server name as a parameter. The Data Source is setup to use Embedded connection with the following connection string: ="Data Source=" & Parameters!ServerName.Value & ";Initial […]
General
When trying to use a LocalDB, I get an error - I tried to find an appropriate forum to post the question. This one seems to be the closest. I'm sorry if I'm wrong. This is a long story, which I haven't time to go into now. I'm starting a new Blazor Web app using .NET 9 and include what's called Individual Accounts (or Individual Users, […]
Powershell
display bytea image - I moved a table from MsSql to Postgresql that had a field defined as Image in Mssql now in Postgres it's a Bytea field. How can I make sure data copied across with success? Is there some code I could run to make sure Image looks correct from PostgreSQL ? Thanks.
Analysis Services
MDX SSAS Calculated measure for last totals + turnovers - I have a measure with totals for specific dates with the LastNonEmpty aggregation, and a measure with turnovers with the Sum aggregation. Help create a measure with totals for each day that would take into account the last known totals + turnovers from the date of the last totals to the current date. I tried […]
SQL Server 2022 - Administration
How do I fix the, "Unable to process the existing user settings" error message? - I'm sure I've asked this question in either this forum, or another one, in the last 6 months, but I am still struggling with it. Over the Christmas break, desktop support reimaged my dev box, so I would have thought this problem would have disappeared. But I am sadly mistaken. When I open SSMS 20.2 […]
I need help accessing my local SQLExpress - My PC has been causing me problems for months. I've told my desktop support team. They reimaged my machine, but it hasn't helped. I cannot run SSMS against the LocalDB I get this error: and that's as far as that goes. If I try to connect to LocalDB I get this error: and that ends […]
SQL Server 2022 - Development
What approach should I take in getting two databases to work together? - At work I am rewriting an old application which no longer builds. It was poorly written to begin with. The original developers, who wrote it about 15 years ago, didn't follow any convention that was used at the time. They created a database to collect data and added one table to handled identity. All users […]
 

 

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

 

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