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

On Looking and Acting the Part

This editorial was originally published on Jan 18, 2020. It is being republished as Steve is on holiday.

A neighbour of mine blamelessly became unemployed at a dangerous age. In some desperation, he took a job as a driver for a firm of undertakers. Though good humoured, and the perfect companion for an evening at the pub, his looks are dark, taciturn, sad. He drove in sunglasses, enhancing the effect, and was habitually solemn whilst driving. His rise through the ranks of undertaking was meteoric. Soon he was a pallbearer and leading a team at funerals. In no time, grieving relatives asked for him specifically. His face, his demeanour, was perfect. To his surprise, a shining and lucrative new career now lies ahead of him, for as long as he wants it.

I thought of my friend when advising someone who wanted a career as an IT consultant. I recounted the hard lessons I'd learned whilst working as a database consultant over several decades, advising banks, large corporates and government departments. Your face must fit. You must look and act the part. If you do, the work is easy because the muddles that large corporates get themselves into with databases are almost always technically simple, but all attempts at resolution become gridlocked by human nature, preconceived notions, embedded interests and persuasive false prophets.

The ideal consultant first gets a clear idea of the nature of the logjam by listening, and then facilitates a resolution while humiliating nobody and convincing everyone that it was their own skill that fixed the problem. This requires a straight face. I have seen the careers of rookie consultants die in front of my eyes, as they throw themselves back from their workstation laughing and bellowing, 'who the hell wrote this garbage?' Technical competence is insufficient for the role.

There are certain disadvantages to being self-effacing. I once dealt so successfully with a sticky database problem within a government department that a couple of years later, they asked to have me back. However, I'd been so anonymous the first time around that they'd forgotten my name. The agency, in their usual amoral way, said they didn't know either and offered them someone cheaper who happened to be 'on the books'. I only heard about it later.

Appearance works both ways. Now that I look like Grandpa, the sort of Grandpa that has to be told how to switch on a mobile phone or use a handset for the telly, I encounter a sense of disbelief, in most of the workplaces I visit, that I could possibly know anything about technology. Youngsters often feel obliged to explain simple database concepts to me.

I could no longer do consultancy. Ironically, I know far more about databases now than I did then, but on the other hand, I'd stick out like a sore thumb, looking absurd in a suit and grumpier when confronted with foolishness. Much of IT work is less to do with the technology and more about working easily in a team. Perhaps a career in undertaking beckons, but I'm not sure that, even there, a role can be found for someone who looks like a biblical illustration of a vengeful Jehovah.

Phil Factor

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

 
 
  Featured Contents
SQLServerCentral Article

How to Repair Corrupt MySQL Tables

Nisarg Upadhyay from SQLServerCentral

In the modern world, the companies are not solely dependent on a specific database server platform. There are many database platforms available that are adequate to handle moderate workload and client requirements of high availability and disaster recovery. MySQL is one of those database platforms which provides a lot of features and high performance. Just […]

Technical Article

SQL Server Forced Plans Overwite the Query Hash

Additional Articles from SQLServerCentral

A 16-year old SQL Server bug that means 'forced plans' have the query plan hash in place of the expected query hash. Includes an explanation and discussion of the term 'morally equivalent plan'.

Blog Post

From the SQL Server Central Blogs - Playing with the Data API Builder

Steve Jones - SSC Editor from The Voice of the DBA

I published an article today on the Data API Builder, which is a way of presenting your database tables as a REST or GraphQL API for developers. You can...

Blog Post

From the SQL Server Central Blogs - How to Find Where Your Databases Reside In The File System

SQLPals from Mission: SQL Homeostasis

How to Find Where Your Databases Reside In The File System

SQL Script:

Copy

/*
RETURNS LIST OF FOLDER NAMES WHERE SQL SERVER DATABASE
FILES ARE STORED.

It is dynamic...

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):

 

The Funny Dynamic SQL

What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';

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)

The Reindeer Count

How many reindeer does Santa have pulling his sleigh? (according to the famous song)

Hint, the answers are not base 10.

Answer: 1001

Explanation: Merry Christmas It's 9, or 1001 in binary

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 - Administration
Backup issues - I''m running a stripped backup (2 files) to a Network share. It's a 32gig machine in which 10gig free and has 4 cpu's .. Cpu % around 50%. I'm using compression and it's creating those 2 files 340gig each runs for about 10 minutes then fails. I have plenty of space on the network share. […]
Tempdb is filling due to background process. - I have it narrowed down to which session id is causing the issue, but that session is a background session with a command of "DB Startup"... I just cycled the instance less than a week ago due to the same issue, and I don't want to do it again without understanding why. DB is part […]
Development - SQL Server 2014
How can I tell which action happened from the UPDATE or INSERT in my SP? - I have the following Stored Procedure that attempts to UPDATE a table, and if there is no corresponding record INSERTS one. How do I indicate which case happened? GO /****** Object:  StoredProcedure [dbo].[insupd_tblMRBHistory]    Script Date: 2024-12-17 9:27:52 AM ******/SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[insupd_tblMRBHistory] (@BusinessUnit char(30) ,@PartNum char(25) ,@Description […]
SQL Server 2019 - Administration
Moving DB to new drive - Hi everyone I am planning on buying a new SSD to store my SS DB.  I plan to leave the actual SS on the old drive and just move the DB to the new drive.  I found the steps to do this online: https://learn.microsoft.com/en-us/sql/relational-databases/databases/move-user-databases?view=sql-server-ver16 I have a few questions: Should I move the SS to […]
Filter a SQL Server Audit with a predicate - Hi Gents, Silly question, but it's been a long time since I've done this. I need an audit of all successful and failed login attempts, so I created an Audit, but I don't want to log everything, so I added a filter: WHERE ([action_id]=(538990668)) based on https://techcommunity.microsoft.com/blog/sqlserver/filter-sql-server-audit-on-action-id--class-type-predicate/384140 SELECT [class_type] FROM sys.dm_audit_class_type_map WHERE [class_type_desc] = 'LOGIN'; SELECT […]
Copy a large table from one table to another - Hi, I have large table with 75 columns and 1.1 billion rows. Want to know the fastest way to copy from one table(non partitioned) to another(partitioned) table. Did anyone tried this. If yes, how long it took to load the data. I tried SSIS package with multiple threads, select- insert in batches and OPTION MAXDOP. […]
SQL Server 2019 - Development
New SSIS Package fails in Sql Agent when it includes a script component - I'm creating a new SSIS package using VS2022 to target Sql Server 2019 server. I have ended up with a new, very basic package that contains a script component to use C# only. This simple package will execute in VS2022 without errors. I have made no changes to the script and no code. When I […]
Aggregate Data to New Table - Hi , I am using webedition of 2019 MSSQL on AWS. I don't have SSAS or other license . I have a big table that is growing and part of active read and DML operations. I have a stored proc that is applying SUM and count on few columns. as this table has data for […]
how to generalize the LAG function so it keeps looking until a value is found? - Hi everyone There are situations where a value for a particular day is NULL so I use the previous day's value hoping it isn't NULL.  I use LAG for this.  The problem is that sometimes even the previous value is NULL so I have to use LAG(2) to get the 2nd previous value.  This approach […]
How to speed up this query? - Hi everyone I have a query that is taking a real long time.  It takes close to 30 minutes to process about 14 million records.  Is there any way to speed it up? Query: DROP TABLE IF EXISTS #TestTable DROP TABLE IF EXISTS #TEMP1 CREATE TABLE #TestTable ( [UNIT] [nvarchar](10) NOT NULL, [PURCHASE_DATE] [date] NOT […]
Azure Data Factory
Need ADF pipeline suggestion to copy 1 million files - I have an ADF pipeline that copies Files from source to destination. Both Source and destinations are different folders within adls only. My pipeline design is as follows   1.) Lookup activity-  A sql server Stored procedure that returns sourcepath and the destination path. This is connected to a Foreachloop 2.) Foreachloop activity - Has […]
Testing
Understanding allowed topics for testing - Hi, I am a first time writer looking to author some content here. I am in the software testing industry. Are we allowed to submit content that is not related to SQL or databases or should they all be related to databases?   Thanks, Arun
Analysis Services
Issue with IIF - I am creating a new measure in an SSAS cube and encountering an issue. The result is being displayed in an Excel pivot table sourced from the cube. Here’s the code I’m working with: MDX CREATE MEMBER CURRENTCUBE.[Measures].[New Column] AS IIF( [Date].[Month Of Year].[1] OR [Date].[Month Of Year].[2] OR [Date].[Month Of Year].[3], -- Logical condition […]
SQLServerCentral.com Website Issues
Topic marked as spam - by mistake? - I received the following notification a few hours ago. It seems legit but has been marked as spam – should it be resurrected? harrylune wrote: Do you have any advice on how to set up git repositories for the things indicated in the title? I'm particularly interested in hearing from anyone who have experience with […]
PostgreSQL
Permission issue in updating cron.job table in postgresql - I am using postgreSQL database for azure flexible server. I have enabled pg_cron extension on azure portal and created pg_cron extension on the database. I am able to see all the required tables/functions on the cron schema of postgres database. I am able to insert a cron job using cron.schedule function, since this inserts by […]
 

 

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

 

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