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

Daily Coping Tip

Stay positive in your conversations with others

I also have a thread at SQLServerCentral dealing with coping mechanisms and resources. Feel free to participate.

For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from The Action for Happiness Coping Calendar. My items will be on my blog, feel free to share yours.

The Tech Blame Game

Last year Solarwinds was hacked and blamed an intern for a security lapse. When Equifax was hacked, in testimony to the US Congress, the former CEO blamed a specific, though unnamed, person for not patching a system. British Airways blamed their USD$200+mm IT issue on an engineer that rebooted a system too quickly.

I don't know that any large company from my younger days, say before 1990, would have blamed a massive failure on a single person. While any single person can influence more systems in the age of technology, no one should have the power to cause such a massive failure. If they do, I think I'd look towards poor system design, rather than individuals.

These aren't the only examples of management trying to scapegoat an IT worker, and I suspect we'll see more examples in the future. However, I hope that governments and shareholders start to demand better management from management. If you don't understand how IT works, get auditors or consultants to evaluate things and explain them to you. If you don't think that your systems are well put together without single points of failure, address that. If you worry about security, make that a priority. Microsoft did after the Slammer worm, and arguably they have a difficult job where most employees want to control their laptops and workstations entirely and run them in their individual manner. Microsoft built better controls into infrastructure and software development, and everyone else should as well. Management needs to own their responsibility for failures.

We should expect mistakes in security, in design, in coding, and more. We should also be placing guardrails, tests, and limits inside our environments to ensure that we catch most of the issues. Software development and system design have improved dramatically the last decade to help us improve quality and security, but we have to embrace the knowledge that's been gained, as well as ensure we have circuit breakers to prevent runaway failures. If a sysadmin can alter a Chef script to set the max memory in SQL Server to 1MB, this shouldn't get deployed to all instances. Moreover, we ought to be testing for all sorts of potential changes that can cause issues.

To me, this is the area that DevOps, GitOps, anything Ops, automated, or at scale, needs to mature. We need to allow for, expect, and assume mistakes and failures will happen and build in controls to our build and test systems. Once we start to better understand how someone can make simple mistakes, we can attach more checks and balances to ensure that we continue to improve quality, without sacrificing speed, or lowering security.

Steve Jones - SSC Editor

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

 
 Featured Contents

Finding the Optimal Value of Hyperparameters through Grid Search

Prashant Tyagi from SQLServerCentral

Summary This article aims at demystifying what grid search is and how we can use to obtain optimal values of our model parameters. It would be highly beneficial for the reader if the prequels to this article are read to gain a holistic understanding of the various techniques that can be used in optimizing the […]

Redgate Streamed: Embracing technology trends for database success

Additional Articles from Redgate

Innovating in the database is crucial for success, and we’re seeing new trends impact the database, like cloud migration, SRE, and the growing need for big data and tools to support growing estates. On 23 June, Redgate Streamed brings you organizations who have implemented these database technology trends, including speakers from Google, Microsoft, and AWS, who will share their success stories and tips for embracing technology changes.

DBA in training: SQL Server high availability options

Additional Articles from SimpleTalk

DBAs must make sure data is highly available, and there are many SQL Server high availability options. Pamela Mooney discusses those options in this article.

From the SQL Server Central Blogs - Database Fundamentals #30: Create Foreign Keys With T-SQL

Grant Fritchey from The Scary DBA

You can create foreign keys using TSQL roughly the same way as you created primary keys. You can either use the ALTER TABLE statement to add the foreign key,...

From the SQL Server Central Blogs - Changing a Drive Letter with PowerShell

david.bermingham from Clustering for Mere Mortals

Here is a short but sweet post on how to change the drive letter of a partition. Despite using my best Google skills I couldn’t find an example that...

 

 Question of the Day

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

 

Executing All Procedures From a Group

I have a schema in my SQL Server 2019 database, called xyz. I have an Active Directory user added as a user to my database as MyDomain\SQLAppUser. How can I allow this user to execute all stored procedures, current and future, in this schema?

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)

Another PowerShell Alias

If I want to use an alias for the Copy-Item cmdlet in PowerShell, what would I type?

Answer: cp

Explanation: cp or copy or cpi are valid aliases for Copy-Item. Ref: Top PowerShell aliases - https://ilovepowershell.com/2011/11/03/list-of-top-powershell-alias/

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
unable to see data in select - Result set sample: event_name TIMESTAMP IsCached IsRecovered IsDac Duration CpuTime PhysicalReads LogicalReads Writes ClientConnectionID ContextInfo SessionID ClientAppName SessionNTUserName UserName DatabaseName DatabaseID EventSequence CollectSystemTime ClientHostName ServerPrincipalName NTUserName ActivityIDXfer ActivityID database_name logout 2021-05-31T16:29:46.776Z false false false 0 0 0 76 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL […]
Automate restore - Any one help to automate the restore of a database  from one server to another server through sql job
SQL Server 2016 - Development and T-SQL
Snapshot Isolation on Transactional Replicated DB _slow ???? - Hi We went from a backup and restore Reports database to a transactional Replicated DB. I have a job overnight that creates a table, the jobs took about an hour, now on the replicated copy of the DB the job take 12+ hours The job does do a bunch of updates . I tried adding […]
SQL 2012 - General
This query is very slow how to enhance it to be more faster? - I work on sql server 2012 I face issue this query when run is very slow so how o enhance it to be more faster query and execution plan exist on link below : https://www.brentozar.com/pastetheplan/?id=S1wEKwf5O sql query as below ; ;WITH cte AS ( SELECT Po.GlobalPnId , Po.FamilyId, po.CompanyID, Po2.GroupId, CAST( CONCAT(LTRIM(RTRIM(CASE WHEN Po.PortionKey=N'Blank' THEN […]
Database stuck in recovery mode after server restart - Hello, We were running a particular update on a huge table and SSMS got stuck, it gave the error "Locked timeout exceeded limit" on the database. After doing some search, we decided to do a server restart. The DB in question is coming in "Recovery" mode after restart. Does it recovers on its own or […]
SQL Server 2012 - T-SQL
add another check for update - This SP updates prices and now I need to add an additional check coming from the MTD_INV_LINE_ITEM and the mtl_addr_price  tables. In the MTD_INV_LINE_ITEM  there is a field called channel, it can have 3 different values z1a,z1b,z1c and in the mtl_addr_price there is a field called division that has 2 values rrb,rrc. If the channel […]
SQL Server 2019 - Administration
TempDB for multi instance - I plan to deploy a 2019 standard with two instances on a virtual machine (vmware with backend iscsi san for datastore). For a physical machine, I would definitely allocate separate volume for tempdb. But wanted to get some ideas on how to go about designing when it came to a VM. Should I create a […]
Opening DBF Files thru Linked Server in Windows Server 2019/SQL Server 2019 - I am in the process of migrating a Database from Windows Server 2012/SQL Server 2014 environment to a Windows Server 2019/SQL Server 2019. I have a Linked Servers defined with 'Advantage OLE DB' provider to open .DBF files. As SAP does not have a latest Driver for Windows Server 2019, the Linked server hangs after […]
SQL Server re- installation at windows core system - I was asked to install SQL Server at the machine with windows without GUI installed. I had an .ini file prepared and installation files were mounted. So I logged into the machine with RDP connection, copied ini file to 'C:\Temp' folder and triggered installation with the below command: Setup.exe /ConfigurationFile = 'C:\Temp\install.ini' The installation completed […]
CMS on an AOAG? - Hello everyone, is it possible, to put the CMS on a AOAG? We do a lot of maintenance jobs from our CMS, and we are afraid, if the server will crash. Therefor we thought, if it is possible, to put the CMS on an AOAG. Are there any tricks, or just try it? We use […]
SQL Server 2019 - Development
SQL Subqueries - Hi ! i got a task where i am to post only the Reshnum of the Department with the highest count of admissions. there are two tables relevant to this quary. Admission and Department as you can see in the picture. where Department.ID and Admission.DepartmentID is the relation. (the reshnum is like serialnumber/name of the […]
Reporting Services
New line based on fixed characters in a field - hi i have a field available in ssrs that has all of the address lines joined together split only by ~ eg 164 street~city~state~postcode i want this to post as 164 street city state postcode   i have tried using replace statements, with no luck, what is the most efficient way of doing what i […]
Powershell
Load folder full of csv files - I have a folder with csv files that has 2 columns a datetime, and a integer value. I want to load them all to a SQL table, but I need to create a 3 column in my table called filename. In this filename column I need to capture the filename of the file it's loading, […]
Strategies and Ideas
Factless fact to resolve business requirements or other design approach? - Our client would like to have the list of candidates/employees with their corresponding position, job capacities (consultant, analyst, etc.) and work history. Employee list will be turned into a dimension table linked to other fact relationships (e.g. fact_salary, fact_proposal_investment, etc.) same with job position as a candidate dimension. My worry is on the Work/Job history  […]
Integration Services
Rename file extensions on FTP site - Hi We have a need to rename some *.tmp files to *.txt files on a suppliers FTP site and wanted to know if this is possible to do using a script task in SSIS? If so please can an example be provided Thanks Andy
 

 

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

 

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