SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

The Voice of the DBA

Reading Through the Logs

Have you ever tried to read a transaction log? I mean used a query against fn_dblog() to read data and try to reconstruct what happened with a transaction or a series of transactions? It's a cumbersome process and takes a lot of knowledge, practice, and most importantly, patience. It's not something I'd want to wish on anyone. There are a few products to help, but no one really does this that often, and it's almost easier to just change some data by applying your own manual fixes.

If you're in the UK, you might have heard about the TSB bank meltdown. If you're unlucky, you've been affected by the outage, which has been going on over a week as a system cutover failed. You can read some reporting about the plans, the rollout of some services, the initial problems , and the warning signs. If you go to the end of the third link, you'll find this awesome tweet. Beans and bombs, he he.

There are a lot of potential issues that we could discuss here. I've been a part of a failed rollout and I have sympathy for the IT staff dealing with this. The thing that I wonder about is the data. With the magnitude of customers (millions), the seemingly long list of places where things failed (notifications, scheduled payments, inquiries, etc.), and the rate at which people can bang on a system from their phones and various applications, how much data has been mangled and altered? 

I'd guess a lot, in which case, we aren't just talking about updating rows on the basis of someone's authority. Whoever is tracking through data needs to essentially read transaction logs, unwind the actions where data was converted incorrectly and then (potentially) subsequently changed. Then they need to work out the reversing entries. The database needs help from DBAs, developers, and probably financial staff to understand why things are in a state. Why are closed accounts are open, why payments are scheduled years in the future, where balances are, and more. With the possible cross contamination of data between accounts, this is an area where TSB needs to be thorough and careful.

Data is important in today's complex, interconnected world. There are certain areas where data problems are highly disruptive and can have lasting repercussions if mistakes are made by the data processors. The financial and medical areas certainly fit in these categories, and it's sad that people are going to go through pain and problems that may affect them for years. Hopefully TSB will get things working soon and data issues corrected. If there's one thing I learned from this is that for certain issues, I need to ensure I have my own paperwork to prove my side of the story.

Steve Jones from SQLServerCentral.com

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

The Voice of the DBA Podcast

Listen to the MP3 Audio ( 4.8MB) podcast or subscribe to the feed at iTunes and Libsyn. feed

The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music.


How to make your SQL Server development GDPR ready

Redgate’s SQL Data Privacy Suite helps you to build a data catalog of your SQL Server estate, and put in processes to protect and monitor personal information. Find out more about how our tools help with GDPR compliance

SQL Provision

NEW SQL Provision: Create, protect, & manage SQL Server database copies for compliant DevOps

Create and manage database copies effortless and keeps compliance central to the process. With SQL Provisions virtual cloning technology, databases can be created in seconds using just MB of storage, enabling business to move faster. Sensitive data can be anonymized or replaced with realistic data to ensure data is protected as it moves between environments. Download your free trial

Featured Contents


Provisioning SQL Server Instances with Docker

Additional Articles from SimpleTalk

With SQL Server 2017, Microsoft announced the exciting news that SQL Server would now run in Docker containers. Laerte Junior provides a guide to get started creating SQL Server instances in Docker. More »


SQL Server From .Net: Connecting Visual Studio Community Edition to SQ

Tim Wellman from SQLServerCentral.com

This is a short description of how to connect the free Visual Studio Community Edition to the free SQL Server Express edititon. More »


Join the leading experts in data governance and SQL Server at Redgate’s SQL Privacy Summit

The GDPR is almost here and, just one week before it’s launch, Redgate is hosting the first SQL Privacy Summit in London. The schedule of presentations, panel discussions and workshops has been created to help SQL Server professionals ensure their business meets the new data privacy and protection regulations. More »


From the SQLServerCentral Blogs - SQL and Azure Maze

Kenneth Fisher from SQLServerCentral Blogs

Something fun for the end of the month. Here are a handful of mazes for you to enjoy. I found... More »


From the SQLServerCentral Blogs - Power BI Custom Visuals Class (Module 101 – Tachometer)

Devin Knight from SQLServerCentral Blogs

In this module you will learn how to use the Tachometer. The Tachometer for communicating performance against a goal. Module 101... More »

Question of the Day

Today's Question (by Steve Jones):

I want to create a database and set the maximum size for a database file in SQL Server 2017. I can use the MAXSIZE parameter to do this. What can I specify for the value of the parameter? (choose 3)

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: T-SQL.

We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center.


XML and JSON Recipes for SQL Server: A Problem-Solution Approach

Quickly find solutions to dozens of common problems encountered while using XML and JSON features that are built into SQL Server. Content is presented in the popular problem-solution format. Look up the problem that you want to solve. Read the solution. Apply the solution directly in your own code. Problem solved! Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I have built an event session in Extended Events (XE) called MyEventSession. I set this to startup when the SQL Server instance starts. It's currently running with both a file and ring buffer targets. I decide to drop this session, buit don't want to lose data from the file target. What do I need to do?



Sessions do not need to be stopped to be dropped. Data in the file target will persist in the file. Data in the ring buffer target will be lost.

Ref: DROP EVENT SESSION - click here

Extended Event Sessions - 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.

SQL Server 2017 : SQL Server 2017 - Development

Normalization and Third Normal Form - Hello. I was watching a video that covered Normalization. It explained that a database is in third normal form when...

To CASCADE DELETE or not? - There is a healthy debate going on between a couple teams in my area regarding the use of the cascade...

SSIS Buffer Error - Hi, I am trying to execute a package and I am getting the following error messages: Error: A buffer failed while allocating...

Help with a simple TSQL script to open and save an Excel file. - I have an SSRS report that exports to a specific folder on a scheduled basis.  There's a problem with the...

Error Processing Cube from SSIS package run as a SQL Job - Hi, I am trying to upgrade a SQL server with Analysis Services to SQL 2017 cu5, 14.0.3023.8, (I tried CU4 before...

Removing stored procedures to move to cloud - I got an interesting email today about cutting back on the reliance of the applications on databases and plans to...

SQL Server 2016 : SQL Server 2016 - Administration

SELECT query is blocking UPDATE query in SQL Server 2016 - Hi, I'm running a data warehouse load and a select statement from table DBO"."DIM_BILL_INV_ITEM" is blocking the UPDATE query forever on the...

Restoring backup to AlwaysOn Availability Group primary server. - I'm a bit of a novice when it comes to AlwaysOn, so I was hoping some of you that have...

Transactional Replication has poor Plan - For some reason we are getting a real poor plan on our Replication server... transactional. (I have no idea why...

SQL Server 2016 : SQL Server 2016 - Development and T-SQL

Updating datetime2 column not working - Hello, Trying to update some datetime2 columns. UPDATE T_MYTABLE SET dateTransferred = '2018-03-26 05.00.00' where id = 1223 Causes an error.  So, I tried casting it. UPDATE...

Table Variable Parameters, Stored Procedures and Performance - Hi all, I have just started a new gig as a contractor, and the DB architect here insists that we...

Date Upto 28 days ahead, no weekends - Hi All, I have a statement returning data from today up to 28 days ahead, but it is including weekends. I...

Importing from XML to SQL 2014 - This is my 4th day on SQL so I am a newbie. I created a query to import from an...

SQL Server 2012 : SQL 2012 - General

Users are experiencing slow connections trying to log into the application - Dear Everyone I have a custom build application running on .Net and its trying to access the company's SQL Server...

SQL Server 2008 : SQL Server 2008 - General

Does Rownum and Rowid works in SQL Server - Hello Guys ..want to know if rowid and rounum works in sql server too ?  if not what are the equivalent...

How to find modified records in a table without using timestamp columns ? - I have an SQL server and we  needs to monitor a  specific table with 10k records for any insert update...

SQL Server 2008 : T-SQL (SS2K8)

Number of Days between two Day Names - I have a table with a Start Day and a End Day Column ID StartDay EndDay 1 Monday Friday 2 Tuesday Wednesday 3 Friday...

TSQL to check database backup status - Hello, I am trying to generate a monthly report for sql database backup job. Is there a script that I can...

SQL Server 2008 : SQL Server Newbies

Frequently used DMV's & DBCC commands..... - Hi Guys I'm looking FOR DMVs & DBCC commands that day to day DBA needs.... which are more frequently used.... Please help...

Data Warehousing : Integration Services

Power BI - can use free? - Hello.  I have two question abaout Power BI. 1. Can I use it free in work (commercial use)? 2. If commercial free use...

This email has been sent to {user_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.
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 ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com