| A community of more than 1,600,000 database professionals and growing |
| | | Is Rolling Back The Same as Failing? Today we have a guest editorial from Andy Warren as Steve is traveling. 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 from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| | ADVERTISEMENT | | | | Don’t just fix SQL Server problems, prevent them from happening SQL Monitor helps teams looking after SQL Server be more proactive. Not only does SQL Monitor alert you to current issues, it gives you the information you need to stop them happening in the future. Download SQL Monitor now and get a 14 day free trial |
| | | | Could your SQL coding be more efficient? Data Platform MVPs and SQL Server experts share their tips on how to standardize formatting whilst stripping out the repetition of coding with SQL Prompt. Over these 20 short videos we will help you write better, shareable SQL faster. Check out the tips |
|
|
|
| | | | | Sadan Kumar Budde from SQLServerCentral.com We as DBAs, changing or migrating databases to a new path is important part of admin’s world. This article helps you with the steps involved to move the Critical 'master' database. More » |
| | GDPR is introducing new rights at the same time that the threats to data are the biggest they’ve ever been. The more leaks and breaches there are, the more your customers will learn that GDPR grants them six specific rights, and the louder they’ll ask how you’re meeting those obligations. More » |
| | Additional Articles from SimpleTalk The General Data Protection Regulation (GDPR) will affect organisations in countries around the world, not just those in Europe. The GDPR regulates how personal data is stored, moved, handled, and destroyed. Not following the regulation will lead to dire consequences for your organisation. As a data professional or developer, you may have many questions and might be wondering how it will affect the way you will do your job. William Brewer answers common questions about the GDPR that you were too shy to ask. More » |
| | Arun Sirpal from SQLServerCentral Blogs I was doing some normal activities on one of my Azure SQL Databases, I went to make a cup of... More » |
| | Matthew McGiffen from SQLServerCentral Blogs More and more people are considering some level of encryption against their data stored in SQL Server. In many cases... More » |
|
|
| | | Today's Question (by Steve Jones): I have a table with data that looks like this: OwedTo OwedBy Beer Steve Ally 2 Steve Tugberk 1 Steve Dave 1 Steve Grant 4 Grant Ally 4 Grant Dave 2 Grant Steve 1 Ally Grant 2 Ally Dave 3 Ally Steve 4 I decide to write an aggregate like this: SELECT bt.OwedTo , SUM(bt.Beer) FROM dbo.BeerTally AS bt GROUP BY bt.OwedTo WITH ; |rollup> Which operator in the WITH clause results in more rows in the results? |
Think you know the answer? Click here, and find out if you are right. We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: Aggregates. We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
| ADVERTISEMENT | | Protect your data from attack by using SQL Server technologies to implement a defense-in-depth strategy, performing threat analysis, and encrypting sensitive data as a last line of defense against compromise. The multi-layered approach in this book helps ensure that a single breach doesn't lead to loss or compromise of your data that is confidential and important to the business. Get your copy from Amazon today. | |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I want to create a function in R that will return the next number of a Fibonacci sequence if I pass in the current 2. How should I write this code?
Answer: nextfib <- function(x, y) {return(x+y)} Explanation: The function() function is used to define a function. It takes parameters in brackets and the code in braces. The return() function is recommended, but not required. Ref: function() - click here » 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. Which OS for SQL Server 2017 Standard? (new data warehouse) - My company will be setting up a new data warehouse server using SQL Server 2017 Standard. We're a mixed shop,... SQL Restore takes long time - how do I clear committed transactions from log ? - Hi everyone, There is so many blog posts and articles out there about this case and I have been reading, but... How do I log into SSMS v17 on a home network? - I've got SSMS v17 installed on a new laptop. And I've got SQL Server 2016 Developer Edition on a desktop... Backing up multiple SQL instance and databases using 3rd party software - Any recommendations - Hello, We are looking to have a centralized software management tool for backing up SQL Server databases that can also provide... INDEX MATCH IN SQL.... IS IT POSSIBLE?? - Mail – [email protected] & Reorganise indexes - HI, I got this from the ola.hallengren web site and when I run it, it doesn't appear to do anything, but if... SQL Server 2016 Mirroring - Hi, Can someone please confirm that SQL Server 2016 SP1 does or doesn't do mirroring, Failover Cluster Installation Error - I'm attempting to install a failover cluster (using 2014 Standard), and I'm having a problem. The installer requires a SQL... Bulk insert into table from csv - Hi, i have table in CSV: As you can see there are a lot of columns. My source table data types fields are: SpinLocks - Hello, Does anyone know what the following Spinlocks stand for? name collisions spins spins_per_collision sleep_time backoffs ALLOC_CACHES_HASH 426181802 324947377588 762.4619 25544 154546374 SOS_CACHESTORE_CLOCK 13071 5429436964 415380.4 0 17156 SOS_OBJECT_STORE 6559674 ... Help getting list of tabs (Tables) in Excel. sp_tables_ex returning no results. - Below is what I have run. I can query the workbook if I already know the sheet name. And insert... ALIGNMENT - Hello all, I have the quest to make Procedure again. But this time I have the syntax, but I dont know how... Group by Date, Then take 1st row of each id - Hi All, I think this might be complicated. New to this forum, but okay at SQL. I'm starting to delve into... PRIME NUMBERS - Dear all, I have SP : CREATE proc . (@opt tinyint, @ResultCount int) as set ROWCOUNT @ResultCount declare @NextInt int--This is the next number... query help - IF OBJECT_ID('Tempdb..#tStudents') IS NOT NULL DROP TABLE #tStudents CREATE TABLE #tStudents( (6) NOT NULL , (50) NOT NULL, (MAX) NULL, ... Can we restore copy-only full backup and regular tlog backup? - Good Morning Experts Can we restore copy-only full backup and regular tlog backup? Date showing instead of blank result - Hi I am getting a date show in one of my fields and I know this box is blank on the... How to Automate the closing of a window? - What is the best way to automate the clearing out of an error message that pops up a few times... Design Input for ETL of OLTP Database - Hello All - I wasn't sure exactly where my question fit, so thought i'd put it here first. I just started... Tempdb - |
|
| This email has been sent to [email protected]. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the [email protected]. | This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here. | This transmission is ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: [email protected] |
|
|
