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

Daily Coping Tip

Thank three people you feel grateful to and tell them why

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.

Is the Time of the DBA Ending?

I ran across a piece on the fall of the DBA (or part of a piece), and wondered if this is the time when the DBA is disappearing. I do know that plenty of organizations never formally adopted the DBA as a position, and plenty more have abandoned it. Not that there aren't people managing databases, but they have moved into Database Engineer, SRE, or plain old sysadmin. They might even have another job but function as an accidental DBA.

The DBA role has often been a mix of many things. Certainly, a tactical, operations role that keeps systems running, dealing with performance, security, and availability. DBAs also fix quality issues in production, deploy code changes, and often advise developers on what works well and what doesn't. They tend to be a bit of insurance against things going wrong as well as the scapegoat when anything does go wrong. I found it to be a constantly changing, never-ending grab-bag of challenges on a regular basis.

Those tasks don't go away with a title change, nor with a move to the cloud, the adoption of NoSQL data stores, or the move to a DevOps style of software development. They might get handled by another role or team, but they still need to be dealt with. The DBA might need to change roles, and they might need to learn how to use automation, GitOps, or some other new protocol for handling the work. As the article linked above mentions, they need to tackle work at a higher level, not the manual, click, click repetitive process they might have followed in the past.

As with any change, there will be people who succeed and do better in the future, as well as those that find their best days behind them. I find change often brings opportunities if I am open to them and make an effort to look for them. You might find your title changes and you can ask for more compensation or more interesting work.

Embrace change, learn something new and find a way to make change work to your advantage. There is always a way to make this happen.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Oracle ASM: Migrating from UDEV devices to the ASM Filter Driver

SOLVARIA from SQLServerCentral

This article looks at the way in which you can convert unmanaged devices to the ASM filter drive in an Oracle system.

External Article

How to back up and restore in PostgreSQL: Learning PostgreSQL with Grant

Additional Articles from SimpleTalk

You can perform PostgreSQL backups with the pg_dump command. In this article, Grant Fritchey explains how to back up and restore with the pg_dump and pg_restore utilities.

External Article

The evolution of SQL Monitor: it keeps getting better and better

Additional Articles from Redgate

With our four dedicated development teams, weekly updates and a commitment to listening to your feedback, SQL Monitor keeps getting better and better! If you haven't looked at it for a while, you might just be pleasantly surprised with how far it has come and how it can help your team work smarter. Take a look at the key features - and benefits - we've added since 2018 in this interactive infographic.

Blog Post

From the SQL Server Central Blogs - Recipe 1: Writing Extended Events to a CSV file

spaghettidba from SpaghettiDBA

Welcome to the first recipe of this Extended Events cookbook! You will find the first blog post of the series here and you can browse all recipes with the...

Blog Post

From the SQL Server Central Blogs - DP-900: What’s a Region and an Availability Zone

Steve Jones - SSC Editor from The Voice of the DBA

This is part of a series on my preparation for the DP-900 exam. This is the Microsoft Azure Data Fundamentals, part of a number of certification paths. You can...

 

 Question of the Day

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

 

Purchasing Separate Compute and Storage

Which purchasing model for Azure SQL Database allows you to purchase compute and storage separately?

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)

Synchronous XE Targets

Which of these Extended Event (XE) targets is processed synchronously?

Answer: Event Counter

Explanation: The Event Counter is processed synchronously, as is the Event Tracing for Windows target. The others are asynchronous. Ref: Targets  for Extended Events - https://docs.microsoft.com/en-us/sql/relational-databases/extended-events/targets-for-extended-events-in-sql-server?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 2017 - Administration
Help with proper indexes - I am new to sql server and hav been researching indexes but I am still not sure on the best practice for indexes for one of my tables.  The table currently has over 12 million rows and has a primary key that is just and auto id field. I have several fields we usually search […]
SQL Server 2016 - Administration
Installed SQL 2019 and trying to uninstall 2016 stuff and am unsuccessful. - I have 2 items left in Add remove programs: SQL 2016 and 2016 setup I have ran through the SQL 2016 uninstall several times but it does not allow me to remove SQL Client Connectivity SDK. I check it and then it goes to the Ready to Remove and Edition is blank and Action is […]
SQL Server 2016 - Development and T-SQL
LAST MAX 2 DATES - Hi Expert,   I wanted to find out last max 2 dates from tabl but unable to do so i tried CREATE TABLE [dbo].[Table_1]( [div_id] [nchar](10) NULL, [customerid] [nchar](10) NULL, [div_status] [nchar](10) NULL, [logdate] [date] NULL ) ON [PRIMARY] GO   Insert Data: INSERT INTO [dbo].[Table_1] ([div_id] ,[customerid] ,[div_status] ,[logdate]) VALUES ('495','-1','1','2021-02-14'), ('495','-1' ,'1','2021-02-14'), ('495','-1' ,'1','2021-02-14'), ('502' ,'-1', […]
The step was retried the requested number of times (5) without succeeding. - We have one schedule job which is copying the backup to the offsite server through xcopy. This job successfully run for 4-5 days in a week and failed for 1-2 days due to following error. Executed as user: service_Account. The step was retried the requested number of times (5) without succeeding. The step failed. Sharing […]
Administration - SQL Server 2014
Instance restart with -m flag, SQLCMD unable to connect - Hi I have a SQL Server 2014 Enterprise Edition instance running on Windows 2012 O/S where I do not have the 'sa' password. I inherited the server after the previous DBA left and I am not sysadmin on the server therefore I am not able to perform DBA tasks such as backup/restore DB, attach DB, […]
SQL 2012 - General
How to get rows that have sourctype 484456 only when group by GivenPartNumber_No - I work on sql server 2012 i need to get rows that have source type 484456 when group by two columns group by GivenPartNumber_Non and vcompanyid so i need to make select query display every group of rows by GivenPartNumber_Non and vcompanyid have source type 484456 only may be this group one row or 2rows […]
SQL Server 2019 - Administration
THANKS ! - I just wanted to post a general "THANKS" to all the helpful people here who go out of their way to help others.
Using Availability groups with a named instance - Hello, I'm working on migrating from an existing multiple FCIs to Instances with availability groups.  I'm attempting to keep the impact to my customers as small as possible so I'm wondering about connection strings with availability groups. Current Environment, multiple instances some as named instances in existing FCI SQL1 and SQL2\NamedInstance Proposed new environment. Physical […]
Upgraded SQL 2008 to 2016 years ago and never removed 2008 correctly. - Upgraded SQL 2008 to 2016 years ago and never removed 2008 correctly and now on 2019 I am having issues uninstalling 2008. I removed the setup files by accident and now in the add remove programs is SQL 2008 but I can't get it uninstalled correctly. Is there a way to do this? Also, I […]
Cannot add SQL Listener to Always On - Hi all Hope someone can assist with my issue. I have a two node cluster running SQL Server 2019 ENT Edition CU14 and the nodes are on different subnets. Always On has been added and working fine however I can't add the SQL Listener, keep getting the following error: "None of the IP addresses configured […]
SQL Server 2019 - Development
Sub Query with incorrect column name doesn't error - Hi, Is there a reason that the following query doesn't error? select * from sys.objects where parent_object_id not in (select parent_object_id from sys.columns) The column parent_object_id doesn't exist in the sys.columns table, yet the query runs without an error. If it's a "not in" query, then an empty resultset is returned, whereas if it's an […]
Update records used in Group By - I have this query to create a summary of donations SELECT [DonorId], SUM([DonationAmount]) AS TotalDonation FROM [dbo].[Donation] GROUP BY [DonorId], [DonationYear] What I need to do is then create a single receipt for those records.  The receipt creation process can be run at any time (not just at year end) What method should be used […]
SQL Azure - Administration
SQL MI - DB Snapshot Alternative - We are about to migrate our on-prem SQL boxes to Managed Instances and currently use database snapshots for various reasons. They are unsupported in MI and I wondered whether anyone had found a creative alternative? Thanks
Reporting Services
Header Expression based on Parameters values selected - Hi all, I am new to this blog and also new to SSRS and I am hoping this forum can help me. I have a report created with some parameters and based on the parameters, my report shows the end user what they selected. Example: Parameter 1 = Rptg_Level (user can select Customers, Groups, Regions, […]
Analysis Services
Today my SSAS server died and I lost 500 DBs but I still have all DB files - The title sounds like a name to a new anime, and it's my daily life. All of a sudden, today after an update of Symantec Antivirus on the server (no relation, this was just the most recent change event), my poor SSAS server with 500 databases refused to start. The config of the server is: […]
 

 

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

 

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