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

Too much information can be counter-productive

This editorial was originally published on Aug 26, 2015. It is being re-run as Steve is traveling.

I find it ironic that presenting less information results in more effective decisions.

I had a colleague who was tasked with managing a multi-version upgrade and migration of a physical database cluster supporting multiple 24/7/365 systems to a new virtual environment.  He and his team set about planning this with their customary thoroughness and skill.  Their plan was meticulous and detailed and so when they submitted it to the Change Management Board they were somewhat shocked when their plan was rejected.

Taking the feedback from the board to heart my colleague examined each point in turn and proceeded to supply finer grained detail and also periphery information that he felt was pertinent.  At the next Change Management Board it was again rejected and further questions were raised. Again, he answered all these questions and broadened out his plan to include an analysis of the upstream and downstream systems, the client applications that would consume the system, the variations in operating system patch levels, SAN performance considerations.  In short everything he could possibly think of that might, no matter how improbably, affect the process.  Again it was rejected.

His mistake, as he explained to me later, was that board equated the amount of detail with the amount of risk.  The level of detail in his first submission made the task appear high risk and frightening to the Change Management Board. Any additional detail provided from that point simply compounded the problem.

The lesson is to target your message to your audience.

Perhaps you have heard the mantra “3 bullet points of 5 words each or 5 bullet points of 3 words each”?  Or perhaps more darkly “Presenting to management?  Few words with few syllables”. Both mantras are intended to draw focus on the effectiveness of the message, not on the IQ of those in management positions. One of my managers expressed it thus:

“My coverage of subjects at this level is broad rather than deep, I wish I had the time for depth but I don’t.  I expect my staff to know the detail.  That is their job and they must earn my trust that their competence is a fact”.

With this as a guiding principle he forbade us from entering any item on a risk register for which we had not proposed a solution.  We were the subject matter experts with the knowledge to solve the problem.  His role was to keep us on our toes, play devil’s advocate and judge which solution best fitted the overall plan for the organisation.

He was also clear that we should propose a maximum of three solutions and in order with our 1st choice at the top.  Any more than three solutions would be more likely to add delay than value to the decision making process.

Focussing on the three facts most relevant to your target audience is a discipline that will add strength to your position.  It is not an easy discipline to adhere to when you are brimming over with passion for your subject.  As we ask our audience to focus on more and more and we risk diluting our most important message and losing the impact we wish to create.

As a wealthy consultant put it to me “the point when my career really took off was when I learned how to talk to management”.

David.Poole

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

Redgate SQL Provision
 
  Featured Contents

The NoSQL Misdirections.

MVDBA from SQLServerCentral

Recently I have been working with a colleague who is doing a bit of a side projects outside of work. He's  trying to expand his skillset using a pet project at home. I encouraged him to look at NoSQL, in particular MongoDB. While I'm a traditional 3rd Normal Form relational developer, I still think there is […]

Introduction to DevOps: DevOps and the Database

Additional Articles from SimpleTalk

When the DevOps pipeline does not include the database, the database can become a bottleneck and slow down the delivery of new features. In this article, Robert Sheldon discusses the challenges involved with including the database and how to overcome them.

SQL in the City Streamed- the birthday edition

Additional Articles from Redgate

Wednesday September 4 14.00-19.00 BST/ 08.00-13.00 Central - Register for our free virtual learning event, to enjoy educational and entertaining sessions from Microsoft MVPs and celebrate 20 years of Redgate.

From the SQL Server Central Blogs - Why do DBAs dislike loops?

Kenneth.Fisher from SQLStudies

If you started out as a developer you were probably taught how important loops are. They are one of the ... Continue reading

From the SQL Server Central Blogs - Public and Demo Data Coming Soon!

Bradley Schacht from Bradley Schacht

Any database professional that has been around the Microsoft world for more than about 3 minutes will be familiar with the old, faithful sample dataset created and published by...

 

  Question of the Day

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

 

Server Roles

Which role(s) allows these permissions? Configure server-wide settings and shut down the 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)

Dropping Synonyms

I run this code:

CREATE TABLE #songs
(   SongKey     INT
  , SongTitle   VARCHAR(500)
  , ReleaseDate DATE);
GO

CREATE SYNONYM StagingSongs
FOR #songs;
GO

If I drop the temp table, what happens to the synonym?

Answer: It is not dropped and must be explicitly dropped

Explanation: The synonym created is a regular object and exists in the database. If the temp table is dropped, this still exist, just like if any other object the synonym referred to was dropped. Ref: Synonyms - https://docs.microsoft.com/en-us/sql/relational-databases/synonyms/synonyms-database-engine?view=sql-server-2017

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
SQL Login Issues between replicated VM's - The issue is that this server (BFS-DEV02) in a virtual clone of another server (BFS-DEV01). Within SQL Server, windows login BFS-DEV02\Administrator is being viewed by SQL Server AS BFS-DEV01\Administrator. Here are some screen shots shows what I mean about the logins…I believe what we ultimately want is to remove BFS-DEV01\Administrator and make it BFS-DEV02\Administrator.   […]
Always on - Planing to go with SQL Server 2017/2019 for Biztalk latest version of 2019/2020. So i would like to go with Always as DR option. Do you guys have seen any issues setting up always on for Biztalk DB server ? If yes, what are the issues have you seen for setting up always on with […]
SQL Server 2016 - Administration
Can't drop database in "restoring" state from secondary instance of AG - MSSQL version: 2016 (13.0.5026.0) Situation: Removed a database from an availability group so it could be restored. When I'm ready to add it back to the group, I go to drop the copy on the secondary instance. It's in the "restoring" state, but that's ok, that's what's expected. But when I try to drop the […]
Extended events - I'm trying to teach myself ExtendedEvents (trying to move from profiler). I've attached a configuration and the output. I've got 'statement' selected in event fields and 'sql text' selected in global fields but the output doesn't show the sql statement that has been run and I'm not sure why?  
AOAG Secondary Checkdb - I'm looking into setting up a AOAG with a DR server which will have the option as NO for readable secondary. Under my understanding will mean I will not have to license the DR box. As best practise (Brent Ozar advice) indicates CHECKDB should be preformed all on nodes as they reside on different disks. […]
SQL Server 2016 Archive Strategy advice. - Greetings. I’m after some advice. I’m helping a colleague with a SQL Server 2016 database that is getting quite large and they are considering an archive strategy. The database essentially stores data from a number of sensors on machines that are building stuff. Readings are taken every 1, 5 and 10 seconds from a variety […]
Multiple tables created in CDC - Hello Team, I have enabled CDC for a particular database in SqlServer and enabled it for multiple tables. I see duplicate tables have been created for each of the table that I have enabled CDC. Is it by design or have I done anything wrong in configuration. Thanks
2 core machine with 4 Tempdb files - Just curious if there is a performance hit by having 4 tempdb files with a 2 core machine? running SQL 2016 (SP2 CU7 +GDR)  
User datareader access problem - I went to give a user (via AD account) datareader access to a number of databases. Everything seemed alright, her read permissions show up in server level security, and in each of the assigned databases. However she still cannot view them, getting a 'not accessible' message. If I try viewing tables in these databases 'execute […]
SQL Server 2016 - Development and T-SQL
sp_executesql with multiple parameters - I'm trying to write a stored procedure that will select the entire table if all parameters are null, otherwise select the table filtered by the non-null parameters using an AND condition. Here is some skeleton code: DECLARE @ProjectID VARCHAR(100) = 300; DECLARE @ProjectName VARCHAR(100) = 'Some project name'; DECLARE @sql NVARCHAR(4000) = '' SET @sql […]
Administration - SQL Server 2014
Upgrade to SQL Server 2008 R2 SP2 from SQL Server 2005 SP3 - Hello, I noticed that SQL Server 2005 SP3 is not in the in the supported version to be upgraded to SQL Server 2008 R2 as shown in the link below. Please let me know if there any issues with in place upgrade.   thanks iosman
Data source error - Security protocol not supported - Hi Experts, I have a report that fetches data from a cube .I have an issue with a data source which is returning an error "Security protocol not supported".This is only happening in SSRS reporting server  after deployment but in visual studio the report is working perfect.I have been working on this without no success. […]
Development - SQL Server 2014
How to copy rows from the same table and update the ID column? - I appreciate it is utterly trivial question, and yet... When you have a small amount of columns, there is a simple solution, sort of INSERT INTO myTable SELECT MAX(table_id) + 1, column2, column3 FROM myTable WHERE table_id IN (SELECT list of table id's to be replicated); alas I have circa 200 columns, so I don't want […]
Reporting Services
ReportServer Database upgrade fails - I've tried several times to successfully  migrate a SQL Server 2008R2 ReportServer and ReportServerTempDB to SQL Server 2017.  Every time it fails and one of the log files says that the database upgrade failed. I install SSRS 2017 but don't configure.  I backup the 2008R2 SSRS databases and the encryption key.  This database is joined […]
SQLServerCentral.com Website Issues
Website search - Does SQLServerCentral have any advanced search features, or can anyone share any tips?  Does everyone just use google with site:sqlservercentral.com?
 

 

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

 

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