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

Seagull Management

Last year, I read Surrender, a book by U2 lead singer, Bono. Bill Gates listed this as one of the top books to read at one point, so I picked it up and dove in. I have enjoyed U2s music since I was in high school, and was interested to hear what made Bill Gates recommend his book. The book is partially a journey of U2, but mostly a look at how Bono's view of the world and life has changed over time.

Bono grew beyond music in his life to become an activist and try to shape the world into a better place. Whether you agree with his efforts or focus or not, it's admirable that he has tried to be more than a rich and famous singer. He's had to build more skills around how to communicate with others, convince them to take a course of action, and educate himself about the world. In trying to build these skills, he's founded or worked in organizations around his time with U2.

As a part of that, he had a great quote about leaders who are busy elsewhere but try to be involved in different parts of the business. He called this seagull management, and it was something he tried to avoid doing as he only comes into the office periodically.

Seagull management is where you fly into the office, shit over what everyone is doing, and fly off again. I wonder how many people in management do this but think that they are motivating, helping, or improving their workers' efforts. Trying to bring their view, experience, knowledge, etc. to others, but invariably doing so in a way that doesn't resonate with workers. Perhaps it's not even helpful if management hasn't taken the time to understand why people are working in a certain way.

I also see this with technical leads or senior engineers who come into a situation, often with strong opinions. They might express how they would have coded or architected something completely differently. Perhaps even informing existing staff that they are doing something wrong. Whether good intentioned or not, seagull management doesn't help improve any situation.

We make bad decisions, we may build something without considering all the information, or perhaps the situation changes. We all find ourselves in situations where the technology doesn't seem to be well matched to the environment. We might wish things were different. However, no matter how we arrive at our present situation, we are there. Extracting ourselves from any legacy environment takes time and has to be a journey that is undertaken with support from both technical staff and management.

Most of us want to build great systems that work well for our clients and are admired by others. We rarely find ourselves in a place where we have the time and resources to do that. We can refactor, evolve, and grow our systems to be better, but it does take time. We need a goal, direction, support, and understanding that change is a journey, not something that a manager can fix on their rare visits to our environment.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Unlocking Power with Updatable Views in SQL Server

Almighty from SQLServerCentral

An updatable view in SQL Server is a view that allows modifications such as INSERT, UPDATE, or DELETE operations on the underlying tables through the view.

External Article

Kubernetes For Complete Beginners

Additional Articles from SimpleTalk

Container orchestration has become a cornerstone of modern application deployment. For beginners stepping into the world of modern application deployment and orchestration, understanding the essence and significance of Kubernetes is essential.

Blog Post

From the SQL Server Central Blogs - Azure SQL DB Failover Groups

hellosqlkitty from SQLKitty

In today’s fast-paced digital world, keeping your data safe and accessible is more important than ever. That’s where Azure SQL Database steps in, offering a suite of tools to...

Blog Post

From the SQL Server Central Blogs - The Basics of TRY CATCH Blocks–#SQLNewBlogger

Steve Jones - SSC Editor from The Voice of the DBA

I was working with a customer and discussing how to do error handling. This is a short post that looks at how you can start adding TRY.. CATCH blocks...

Pro T-SQL 2022: Toward Speed, Scalability, and Standardization for SQL Server Developers

Site Owners from SQLServerCentral

Learn how to write and design simple and efficient T-SQL code. This is a hands-on book that teaches you how to write better T-SQL with examples and straightforward explanations.

 

 Question of the Day

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

 

Using Table Hints in a Query

How many table hints can I include in a query?  

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

 

 

 Yesterday's Question of the Day (by Stewart "Arturius" Campbell)

Read Only Replica in SQL Server Standard

Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this.

Can we implement this?

Answer: No

Explanation: SQL Server Standard with Basic Always On availability Groups does not allow a read-only secondary replica. To do this, one would have to upgrade the environment to SQL Server Enterprise. Ref: Basic availability groups for a single database - SQL Server Always On | Microsoft Learn

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 2019 - Administration
given value of type String from the data source cannot be converted to type nvar - Hi, I have created a variable in Powershell to export to a SQL table. The variable looks like this $DateTime = $((Get-Date).ToString('yyyy-MM-dd-hh_mm_ss')) When I try to insert this into the table I get the following message: The given value of type String from the data source cannot be converted to type nvarchar of the specified […]
Problems Connecting to Sybase using ODBC Drivers - Hi All, I have recently migrated a sql database from an old server to a new one. This database is populated from an old sybase database. I have made the required changes to the SSIS job using visual studio and runs there fine. I have setup  the ODBC DSN connectors and they test successfully. However […]
SQL Server 2019 - Development
Match the String in a join - i have Two tables T1 , T2 Create table T1( Activity varchar (100)) Create Table T2 ( Activity varchar (100)) T1 table has data as below Activity (field) SendToUser% (data) T2 table data Activity (field) SendToUser-U12345 So , both tables should match ...because the string SendToUser% means  "SendToUser"+"....." How can i use it in join? […]
SQL Azure - Development
Tunning or alternative to PIVOT - Hi everyone, we have a table containing kind of key-value pairs, which are the columns of some entities. This is how master data is ingested in the platform. Then a query does some joins, filtering and finally a PIVOT to only output a row by entity, with all their columns denormalized. The query plan looks […]
General
Identical SQL Jobs failing (SSIS package) - I have a SQL Server 2022 application running on 2 nodes redundantly, one of the jobs (SSIS) is failing on the primary node saying the service account can not find the specified file, the exact same job, works fine on the secondary node using the same service account (domain account). Job works fine when running […]
Integration Services
SSIS package not parsing statement with exec (SP) with resultset - I have a package that loops through a bunch of SQL Servers  and executes a stored procedure that uses temp tables. It was build in 2008 and I am now moving it to 2016 but having issues getting it to work in 2008 the OLE DB sql was simply  "uspSystem_GetDatabaseInfo" That was giving me grief […]
SSIS Execute Package Utility Issue - Hi everyone, So I have a ssis package that performs various operations like import, export etc based on values provided in config files. Today I have added some more code in the script task that downloads a pdf file, converts it to excel format and then reads this file and perform ETL operations. It loads […]
Design Ideas and Questions
EF Schema Deployment - Just looking for some background on if anything has changed around "code first" for building schema. I've always preferred designing first, then building the schema (usually in a database project) and handling changes to schema that way. I'm in the position now where there is a project where it appears the developers picked EF and […]
Designing two tables considering following scenario. - I want to design two tables considering the following scenario. Consider the image below:     I’m moving blue boxes (which shows up on screen after Show Options the button is clicked) from left to right (on the grid) after clicking Move Text Content! button. Here are the steps I follow: Select one option from […]
SQL Server 2022 - Administration
Reporting Services Configuration Problems - Greetings!  I am hoping to get some help trying to set up reporting services. 1st problem - when we load the Reports URL, it is requesting credentials to even get the dashboard to load.  We have to provide an administrator account in order to get the URL to load.  But once we do that, we […]
Backup to Azure blob storage via Maintenance Plan - Am trying to set up backups to a storage container on Azure government. If I backup a database using Tasks -> Backup database I am able to backup successfully; it generates the following script which works: BACKUP DATABASE [BLAH] TO URL = N'https://myURL.net/backup-container/BLAH_backup.bak' WITH NOFORMAT, NOINIT, NAME = N'BLAH-Full Database Backup', NOSKIP, NOREWIND, NOUNLOAD, STATS […]
Always On-manual failover - warning on possible data loss - Hi, I'm testing basic alwayson with SQL Server 2022 Standard on two servers (primary and secondary replica with an old Adventureworks database). The idea is to allow sql clients to continue to operate while one server is down for updating and rebooting (monthy windows and sql server updates). I'm testing the manual failover: Although the […]
SQL Server 2022 - Development
How to use custom replication stored procedure for transactional replication - I previously posted a question about setting up replication with custom replication stored procedures (for delete especially) to allow for a longer retention period on the subscriber than on the publisher. The following two MSDN articles were referenced, and I thought I understood them. Transactional Articles - Specify How Changes Are Propagated Transactional Articles - […]
Contained availability groups error - Hello, I am testing the setup of contained availability groups. I am getting some strange errors while creating contained availability groups both through wizzard and with TSQL. I started with creating a contained availability group with the wizzard on MSSMS. Setup: I clicked the contained checkbox. The databases Meet prerequesites (FULL backup was made beforehand). […]
Seeding Contained availability groups - /  
 

 

RSS FeedTwitter

This email has been sent to {email}. 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

 

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