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

What's a forgivable mistake?

Most of us try our best to do the best job they can each day at work. We never try to make mistakes. We might be lazy at times, or avoid some work, but we don't try to do anything incorrectly. We might shortcut something, hoping a partial completion or quick patch is enough to satisfy a requirement, but we don't actively do things incorrectly.

At least I hope that's the case for all of you. I assume there are some BOFH people out there, but they are few and far between.

That being said, we're human. We will have accidents, we'll do something without thinking, or we'll click (or type) the wrong item. Sometimes these errors go unnoticed until we can correct them. Perhaps they go unnoticed for years, and we completely forget about them.

Other little "whoops" mistakes have widespread consequences. I've seen incorrect firewall rules deployed that took down entire swaths of a business. There are incorrect deployments by developers, putting out old, or even future, code that breaks things down. DBAs might change, or even truncate, the wrong data at times. That's something I've certainly been guilty of in the past.

In your job, are there mistakes you make that are forgivable? I'd hope that most are, and you don't worry about certain tasks affecting your employment status. I'm sure there are potential mistakes that might require termination, but I'd hope these are repeated mistakes and not one time events.

Let us know today what mistakes might be forgivable in your organization. These might not be something you've done, but perhaps something you've witnessed. How much mercy does your management have for the humans trying to manage their database systems?

Steve Jones - SSC Editor

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

Redgate Data Masker
 
  Featured Contents

Performance Tuning Using Extended Events: Part 1

bdavey from SQLServerCentral.com

In this article, learn how to identify performance tuning opportunities using Extended Events.

Understanding Azure Storage Options

Additional Articles from SimpleTalk

The choices found when provisioning storage in Azure can be overwhelming. In this article, Monica Rathbun explains the options to help your organization research which storage might be right for your solution.

From Source Control to Database using SQL Compare Command Line

Additional Articles from Redgate

Giorgi Abashidze explains how his team use SQL Compare Command line to automate database deployments for their customers, without having access to the real staging or production databases, merely by using our development database contained under TFS Source Control.

From the SQL Server Central Blogs - #PowershellBasics: Working with arrays

Kenneth.Fisher from SQLStudies

I mentioned arrays in a previous post so I figured I should talk about what they are and how to ... Continue reading

From the SQL Server Central Blogs - Cleaning up the [NOT] NULL for Columns with SQL Prompt 10

Steve Jones - SSC Editor from The Voice of the DBA

SQL Prompt 10 is out and there are a few interesting things that have changed in the product. One of these is the Quick Fixes, inspired by some other...

 

  Question of the Day

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

 

The Schema Name

I gave this code to a junior DBA to create a new user:
CREATE USER SSISProcess WITH DEFAULT_SCHEMA = etl
We have some objects in the [etl] schema, but some of our code doesn't seem to create new objects in this schema correctly. We want to verify that the user can correctly see the schema. Someone logs in as the user, SSISProcess, and they want to check the default schema. What should they run to get this?  

Think you know the answer? Click here, and find out if you are right.

 

 

  Yesterday's Question of the Day (by sergey.gigoyan)

Database Backup Types

Which statements are correct about the SQL Server database backup types?

  1. A Transaction Log backup contains all changes made after the previous transaction log backup.
  2. Each differential backup contains only the changes made after the previous differential backup.
  3. Each differential backup contains all changes made after the previous full backup.
  4. A copy-only full backup can be a base for differential backups.
  5. Each full backup contains only the changes made after the previous full backup.

Answer: 1, 3

Explanation: The transaction log backups contain only the changes made since the last log backup. Differential backups consist of changes since the last full backup, not differential. A copy only backup does not affect the differential bitmap. Ref:

http://dbprofi.com/sql-server-backup-types-vs-oracle-backup-types/  

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
Weird network issue - Hi, I have an ssis package, that when I run it from the virtual server (the package is deployed on the catalog) and I use a job to run the package it takes 18 hours. I have set up another server (very small one called TEMP), is also a virtual server and deployed the same […]
SQL Server 2017 - Development
Parse character string into multiple fields - I need to parse a VARCHAR(255) field into four fields, three VARCHAR(5) and one VARCHAR(255). The VARCHAR field to be parsed is a variable length for example: 122 667|6 71|77|120 71|77|219|427|122|670|120|10 The characters before the first | go into field 1 The characters after the first | but before the second | go into field […]
SQL Server 2016 - Development and T-SQL
Find rows older than 60 days with Epoch time format - Hi, I'm trying to purge this table for any rows older than 60 days but the LogTime column is in Epoch format.  I've read articles on how to convert it to human readable format and i just can't get it to work.  Here is the table data. LogLevel LogTime INFO 1574434804509 INFO 1574434804509 INFO 1574434804509 […]
Need to use Remain value in calculation - Hello community, I need to performe a calculation by Row using remain values for the same Receipt_nr --This is a Temp table for test purpose CREATE TABLE #temptab (docdata DATE, Invoice VARCHAR(29), nrInvoice INT, totalinvoice NUMERIC(14,2), totalreceived NUMERIC(14,2), Receipt_nr INT, TotalPaymetforInvoice NUMERIC(14,2), remain NUMERIC(14,2) ) INSERT INTO #temptab (docdata, Invoice, nrInvoice, totalinvoice, totalreceived, Receipt_nr, TotalPaymetforInvoice, […]
Administration - SQL Server 2014
Slow deletes - Hi All, I have table with 1574963 rows and grown up to 1.21 Tera Bytes. Table has a clustered idx and additional nonclustered idx is created. App team is trying delete/archive some data in small chunks. CREATE TABLE [dbo].[LogData]( [c1] [bigint] NOT NULL, [c2] [int] NOT NULL, [c3] [int] NOT NULL, [c4] [ntext] NOT NULL, […]
Development - SQL Server 2014
EXECUTE sp_executesql - Cordial Saludo. tengo el siguiente script DECLARE @SqlString NVARCHAR(500) DECLARE @ParmDefinition NVARCHAR(500) DECLARE @Valor_Tmp Numeric(12,2) SET @SqlString=LTRIM(RTRIM(@ValorFrm)) SET @ParmDefinition = N'@Valor_OUT Numeric(12,2) OUTPUT' EXECUTE sp_executesql @SqlString,@ParmDefinition,@Valor_OUT=@Valor_Tmp OUTPUT SET @Valor=@Valor_Tmp la variable @ValorFrm='SET @Valor_OUT=983,5-2(15.3)-1' Esta variable es una construccion similar a a+2(b)-1 construida por programa. El problema es que en el SSMS funciona y ejecuta bien […]
A cursor with the name already exists - Hi, I have this code in a job that needs to run every 5 minutes. It works most of the time without issue. But 4-5 times a day I get the "a cursor with the name already exists" error. I added the LOCAL to the cursor declaration, but still get the error. I checked for […]
SQL 2012 - General
Place data on another drive - Hi all! I have had to  change from my good old dependable server to a local laptop. That gives some big challenges...   One of my databases is app. 2GB, and that just cannot be on a laptop harddisk - At least not mine. In comes my Synology drives, 2 X 8 TB   But […]
How to understand the SQL Server Statistics information and Query Cost of Execut - In figure 1, there are SQL statements , these 2 sql statments join 2 tables, one is on current database server, the other is on another database server. the first SQL statement runs by SQL Server linker server to join; the second SQL statement uses openquery and linked server to get same data. and in […]
Find how many week day crossed in a given date - Team I have a scenario in SQL Query. If I Give a day, The output should say which day and how many days crossed in a given month For Ex If I give 04th Dec 2019 as input > It should say, It is Tuesday and this date is first tuesday If the Input is […]
Reporting Services
Drillthrough Reports - I have created a report (report1) that I can then drill into report2 (Action > Go to Report) - On report1, I specify name of report2 and give it the parameter report2 needs. Test this out and all works fine - I can click on my "hyperlink" on report1 and it will take me to […]
Strategies and Ideas
Programmatically determine intersection of flight paths and countries - A friend of mine asked me an interesting question... Given a flight path (a linestring of sorts), can one determine which countries the flight overflew? My guess was to define the path as a linestring (maybe with a width, if that's possible), and then use STIntersect to determine the countries overflown. Is there an example […]
Integration Services
How to achieve parallelism in BULK INSERT with OLE DB source and target objects - Hi all! I need help to get the performance up on my ETL. My data flow task is very simple in nature: OLE DB source (MS SQL Server table) points to OLE DB target (MS SQL Server table) with TABLOCK hint The target table is uncompressed, has no indices or other constraints (PKs, Uniques) -> […]
Administering
Log Shipping Agent Error Message - Hi all, I am trying to configure log shipping and getting following error in agent job history.(SQL Server 2019) There was no problem with sql server 2017 and 2016 in same configuration. The backup file was created normally but error message is logged. ---------------------------------------------------------------------------------------------------------------- 2019-12-04 11:16:50.90 Starting transaction log backup. ID: '26c94b60-7380-4ddd-8dc7-ae2ae70630c7' 2019-12-04 11:16:50.90 *** […]
SQL Server 2005 Strategies
Datatype coversion error - Hi, In my application I am fetching data from a View which internally having multiple select qurries combined using Union.  It's near about 500 lines of query. When i fire Select on view it takes some time and then throws Datatype coversion error. To find the source of the error I execute available queries on […]
 

 

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

 

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