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
 

Is Rolling Back The Same as Failing?

Today we have a guest editorial from Andy Warren as Steve is on holiday. This editorial was originally published on Mar 4, 2014.

Recently I was part of a team that was doing a medium size/complexity migration. We came up with a plan, met to review it, and then after the appropriate communication to all involved, went forward with the implementation. It was only at the end that we realized that although we had executed the plan well, we had missed something. It as disappointing and disheartening to be sure. We spent an excited five minutes discussing ways to fix the problem and then decided that while we thought we could fix it, the right thing to do was rollback. It was not production, we had the luxury of time, and we needed a fully vetted process before we did the same in production.

The rollback went fine, as expected and planned. But it didn’t feel good. In part because we weren’t “done” and in larger part because we had missed something that in the glaring light of hindsight should not have been missed. Making it work would have felt better. It would have been a chance to be heroic.  Maybe it would have been cathartic too, working off some guilt by doing some frantic work to make it all go. Everyone was a bit down the rest of the day, me included.

Rollbacks aren’t failures (though I’ll grant a failed rollback is a whole different thing). That’s why we plan for things to go wrong, why we keep the rollback plan as simple as possible, and why we double check that we can execute it if needed – no shortcuts. I k now this, yet I still felt bad about it.

It’s a great topic to talk about before it happens. It will reinforce the need for planning for success and failure, and it will help the team key their eyes focused on the real win – winding up in a sustainable place.

How would you feel? How would your manager (and their manager) react to a rollback? Assuming it’s not an all the time thing is a rollback an acceptable outcome, or is anything less than getting it done treated as a failure?

Andy Warren

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

Ad for State of Database Landscape survey
 
 Featured Contents
Technical Article

Stairway to Azure SQL Hyperscale – Level 3: RBPEX Caching Layer Internals

Chandan Shukla from SQLServerCentral

In this level of the Stairway to Azure SQL Hyperscale we learn about the read-only layer that speeds up queries.

External Article

Use SQL to Find a String in Database Tables, Stored Procedures, and User Defined Functions

Additional Articles from MSSQLTips.com

Searching for a string in database tables has been discussed over the years. There are several approaches to the problem (see References at the end of the article). See how to use SQL to find a string in different types of SQL Server objects and data.

Blog Post

From the SQL Server Central Blogs - SQL Server Is Slow (part 1 of 4)

Kevin3NF from Dallas DBAs

How should you respond when you get the dreaded Email/Slack/Text/DriveBy from someone yelling at you that SQL Server is slow?   Stop. Don’t Open SSMS Yet. You’ve heard it...

From the SQL Server Central Blogs - From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures

Chris Yates from The SQL Professor

In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly efficient, OLTP systems were the workhorses of enterprise data. They handled the daily grind: purchases,...

Big Data Analytics cover

Big Data Analytics with Spark: A Practitioner's Guide to Using Spark for Large Scale Data Analysis

Site Owners from SQLServerCentral

Big Data Analytics with Spark is a step-by-step guide for learning Spark, which is an open-source fast and general-purpose cluster computing framework for large-scale data analysis. You will learn how to use Spark for different types of big data analytics projects, including batch, interactive, graph, and stream data analysis as well as machine learning. In addition, this book will help you become a much sought-after Spark expert.

 

 Question of the Day

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

 

Vector Datatype Dimensions

The new vector datatype in SQL Server 2025 requires a number dimension parameter. What is the maximum number of dimensions supported?

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)

Who am I?

If I want to track which login called a stored procedure and use the value in an audit, what function can I use to replace the xxx below?

create procedure AddNewCustomer
  @customername varchar(200)
AS
BEGIN
    DECLARE @added VARCHAR(100)
    SELECT @added = xxx

    IF @customername IS NOT NULL
      INSERT dbo.Customer
      (
          CustomerName,
          AddedBy 
      )
      VALUES
      (@customername, @added)
END

Answer: system_user

Explanation: SYSTEM_USER returns the login. CURRENT_USER returns the user mapping. Ref: SYSTEM_USER - https://learn.microsoft.com/en-us/sql/t-sql/functions/system-user-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

 

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