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

Daily Coping Tip

Take of a photo of something that brings you joy and share it

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.

Titles and DevOps Confusion

Alex Yates has become quite the DevOps consultant in the last few years. I used to work with Alex at Redgate before he left to start his own consulting firm. I hear nothing but good things about his work, and if you are looking for someone to help guide your database development team, he'd be a good choice.

He wrote a piece on the Octopus Deploy blog about the title of DevOps Engineer and why that doesn't quite make sense. He essentially notes that this doesn't really describe what a person does and it might not be a good title. I tend to agree, since DevOps isn't a thing, per se, but rather a set of guiding principles. While this might include building software, or deploying it, there are titles for those things (build engineer or release engineer). It could include Infrastructure-as-code, but that's the domain of sysadmins.

There are any number of titles that have come about in this business, and likely more being created all the time. If you have a new job, often you can finagle your way around some pay structures because after all, if you invented the term, the HR department doesn't have a pay scale to limit you. I suspect that's part of the reason someone started calling themselves a DevOps Engineer in the first place and got someone to hire them under that title.

I suspect titles used to be more descriptive and important in the past, when we had fewer of them and the work that each of us did was more tightly scoped. Throughout my career, I've started to see more people doing more types of work all the time. Especially in technology where we usually do the work that needs to be done, often crossing over the duties between job titles when something is broken. Getting a system working often takes precedence over any claims of some task being "my work" or "your work."

Titles ought to be somewhat consistent, if for no other reason than to easily allow us to compare the work we do in different organizations and allow us to easily promote ourselves to a new employer. If every organization had different titles, we'd waste a lot of time trying to decide if we wanted a position, as would hiring managers trying to decide if we could do the work. Certainly the we find that a DBA or a Developer moving organizations might have some different tasks, but we have a general idea of what work they should be able to complete.

I've never been too concerned about my titles, though I have worked to become "senior" at different employers. That's usually a function of proving you can do the work well, across a period of time. Of course, if you get work done effectively and efficiently, the title likely doesn't matter. Someone, likely many someones, will want to hire you.

Steve Jones - SSC Editor

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

 
 Featured Contents

Stairway to Snowflake Level 2 – Create a Snowflake Account

Reeves Smith from SQLServerCentral

In this next level of the Stairway to Snowflake, we look at the considerations for creating an account and how to set one up.

SQL Server Resource Governor Game

Additional Articles from MSSQLTips.com

Learn about the SQL Server Resource Governor and how it can be used to manage your SQL Server workloads via this game format that can help your team gain better insights.

The changing landscape of continuous database integration

Additional Articles from Redgate

Considering introducing continuous database integration? Learn the principles in this ThoughtWorks webinar hosted by Pramod Sadalage, expert in this discipline and author of several books about database refactoring and development.

From the SQL Server Central Blogs - A Basic Encryption Primer for SQL Server

Steve Jones - SSC Editor from The Voice of the DBA

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Encryption is a function call in SQL Server,...

From the SQL Server Central Blogs - How to extend your existing SQL Server Failover Cluster Instance to the Cloud for Disaster Recovery

david.bermingham from Clustering for Mere Mortals

I get asked this question all the time, so I figured it was time to write a blog post, record a video and write some code to automate the...

 

 Question of the Day

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

 

Flatten a Multidimensional List in Python

I have this list in python:
mdlist = [[10,20,30],[40,50,60],[70,80,90]]
I want to remove the grouping and get this list:
[10, 20, 30, 40, 50, 60, 70, 80, 90]
Which of these does this and stores the result in a variable?

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)

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?

Answer: GRANT EXECUTE ON schema::[xyz] TO [MyDomain\SQLAppUser]

Explanation: The GRANT EXECUTE ON schema::[] is the way to do this. This allows any procedures that exist, or are created, in this schema to be executed by the target. Ref: GRANT - https://docs.microsoft.com/en-us/sql/t-sql/statements/grant-database-principal-permissions-transact-sql?view=sql-server-ver15

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

 

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