Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
Ad for State of Database Landscape survey
The Voice of the DBA
 

The Improvement Limit

I caught a short post from Gary Bargsley on LinkedIn that had this quote: "Many people do not believe this is true. If there isn't a fire to put out, then you are not doing a good job." He included a repost from Shaik Ashraf with that quote and an image that explains better what things a DBA is doing because they aren't always busy.

I would say that by busy we think of a DBA as rushed and always trying to fix something that isn't working well. I've certainly walked into operational positions where this was the case. Things weren't working smoothly or breaking regularly. My phone was always ringing, as I moved from crisis to crisis. For some systems, rebooting them regularly was the fix, not because I didn't want to determine a root cause and fix them, but because I had too many other priorities. A reboot at least recompiled plans, cleared caches, and got the system working for a few days.

In those environments, it often took me about 6 months to make changes, implement some standards, find root causes and fix them, and change the way others worked. My approach was to find a problem, consider a solution, and present it to others in a rational way with evidence. I could almost always get approval to start making changes. Or I could convince a manager/director to get others to make changes to stabilize the environment.

Almost always.

Not always. And I've had a few jobs where things were broken, but everyone else wanted to keep their existing process and keep adding new features/apps/database/etc. and let the DBAs deal with the instability. After all, if I'm working for a salary, does my boss care how much I work? If he/she doesn't, then I have learned I need to find a new job.

After 6 or so months, I often find that I've reached an improvement limit of some sort. There isn't a lot I can continue to change and fix, usually because of dependencies and a lack of desire by someone else to change. New work can often be built better, but I've often found that I have to live with anything else I haven't been able to change. Even something as simple as adjusting a query can be a problem when the app developers don't have an incentive to help.

Have you reached an improvement limit in your job? Or maybe you have reached a limit to what you are willing to improve, given the environment in which you work.

Steve Jones - SSC Editor

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

PASS Summit 2025 is fast approaching
 
 Featured Contents
SQLServerCentral Article

Migrate SSRS Reports to a New Server in Just a Few Clicks

Kunal Rathi from SQLServerCentral

Learn how to migrate SSRS reports to a new server using SSRS Reports Migration Wizard. Step-by-step guide to move reports, data sources, and datasets in just a few clicks.

External Article

Schema Design Basics for Power BI

Additional Articles from MSSQLTips.com

You have a Power BI project that generates real-time reports for an inventory management system that uses SQL Server. You are aware that Power BI performance is heavily influenced by how your data is structured in SQL Server but don’t have a clear understanding of how to optimize your SQL data structure for Power BI. In this article, we look at different ways to structure the data and tables to help improve Power BI query performance.

Blog Post

From the SQL Server Central Blogs - Troubleshooting TempDB Log Full Errors When SSMS Won’t Connect

gbargsley from GarryBargsley

Have you ever received the dreaded error from SQL Server that the TempDB log file is full? Only to open SSMS and be greeted with a message that prevents...

From the SQL Server Central Blogs - Accelerating AI with Confidence: Why Microsoft Purview is Key to Responsible Innovation

Chris Yates from The SQL Professor

Artificial intelligence is no longer a distant concept. It is here, embedded in the way we work, create, and make decisions. From generative assistants to predictive analytics, AI is...

Learn Microsoft Fabric: A practical guide to performing data analytics in the era of artificial intelligence

Site Owners from SQLServerCentral

A step-by-step guide to harness the power of Microsoft Fabric in developing data analytics solutions for various use cases

 

 Question of the Day

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

 

PWDCompare

What does the PWDCOMPARE function do?

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)

DBCC CHECKIDENT

What is returned as a result set when I run this command without a new seed value?

Answer: Text that contains the current identity value and current column value

Explanation: This command returns the following text (from MSLearn):

Checking identity information: current identity value '', current column value ''. DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Ref: DBCC CHECKIDENT - https://learn.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkident-transact-sql?view=sql-server-ver17

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 2019 - Administration
Compatibility levels on database changing them and impacts. - We’re running SQL Server 2019 with database compatibility level 150, and after recent tuning (RAID-10 tempdb with even files and RCSI enabled) performance is stable; however our application vendor is asking us to drop the database’s compatibility level all the way down to 110 (SQL 2012). My concern is that this would disable many 2019 […]
Timeout when expanding the table - Experts, I am hoping to get some help and feedback. I have a server with 5 instances on it. Out of 256 GB, I have allocated 36GB to this instance. This specific instance has been up and running for over a year now without issues. This instance also has 6 DBs. Yesterday I noticed when […]
SQL Server 2019 - Development
Is there a way for SP to know who called it? - Hi everyone I am writing an SP where there is logic inside the SP that depends how the SP was called.  For example, Start of SP ....code.... If SSIS called SP then do A else do B .... code .... End of SP Is there a way for SP to know who asked it to […]
SQLServerCentral.com Announcements
SSC Website Deployment 24 Sept 2025 - We are planning on a fairly big code deployment to set the stage for some upgrades later this year. Hopefully no issues, but as with any software change, please post here or in Website Issues if you see something.
Editorials
Getting More Time from AI - Comments posted to this topic are about the item Getting More Time from AI
All the Costs of Downtime - Comments posted to this topic are about the item All the Costs of Downtime
Planning for tomorrow, today - database migrations - Comments posted to this topic are about the item Planning for tomorrow, today - database migrations
Article Discussions by Author
Changing the Recovery Time - Comments posted to this topic are about the item Changing the Recovery Time
When Page Prefetching Takes a Back Seat – Exploring Trace Flag 652 in SQL Server - Comments posted to this topic are about the item When Page Prefetching Takes a Back Seat – Exploring Trace Flag 652 in SQL Server
Single User SQL Server on Linux - Comments posted to this topic are about the item Single User SQL Server on Linux
How Well Does the MSSQL Extension in VSCode Work? - Comments posted to this topic are about the item How Well Does the MSSQL Extension in VSCode Work?
The Tightly Linked View - Comments posted to this topic are about the item The Tightly Linked View
Build a Test Lab of SQL Server 2025 on Windows Server 2025 using Hyper-V Virtual Machines - Comments posted to this topic are about the item Build a Test Lab of SQL Server 2025 on Windows Server 2025 using Hyper-V Virtual Machines
SQL Server 2022 - Administration
Bottlenecks on SQL Server performance - We have a BI-application that connects to input tables on a SQL Server 2022 Standard edition. This is installed on a Windows Server 2022 in Azure with the size Standard E32s v5, having 32 vCPUs, 256 GB RAM, 32 data disks and 51200 max IOPS. The SQL Server is used for reading, updating and writing […]
SQL Server 2022 - Development
Is there some good routines for updating SQL Server database objects with GitHub - At work we've been getting better at writing what's known as GitHub Actions (workflows, YAML). I've got it deploying applications to websites, etc. It is cool. One thing users would like to have is a means of deploying updates to SQL Server database objects using GitHub Actions. I've thought about this and have come up […]
 

 

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

 

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