The NoSQL misdirections (2019-09-02)

 SQLServerCentral Newsletter for September 2, 2019 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [The NoSQL misdirections]( - [Introduction to DevOps: DevOps and the Database]( - [SQL in the City Streamed- the birthday edition]( - [From the SQL Server Central Blogs - Why do DBAs dislike loops?]( - [From the SQL Server Central Blogs - Public and Demo Data Coming Soon!]( Question of the Day - [Server Roles]( [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 - [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 Feed]([Twitter]( 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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -