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

The Problem Solver

This editorial was originally published on Aug 28, 2015. It is being re-run as Steve is traveling.

I don’t know if the urge to solve problems is learned or built in from the start, but I suspect it’s the latter. My Mom tells stories about buying me gifts as a small child, with me taking them apart to see how they worked. It was frustrating for her at first, but over time she saw that this was just who I was, and who I still am.

Those of us that are problem solvers see the world differently. Where some will find stress in having to learn something new quickly or resolve some critical problem, for a problem solver. This is the best kind of gift! From jigsaw puzzles to tuning slow queries to fixing a creaky process to be more reliable, if we can see the problem/challenge, then we’re engaged. The corollary to that is that if we don’t have problems to solve, we get bored and unhappy and soon start to think about moving on.

We problem solvers tend to see everything has a problem to solve. Work, home, life, finance, emotions, whatever. Literally correct I guess, but in practice few appreciate having their problems “solved” during a brief conversation. Better to listen and nod in most cases.

Keeping a problem solver happy requires a reasonable stream of interesting problems to solve. Part of the reason is that we crave the chemical surge of success. Part is the feeling that we need problems to exercise our skills or they will diminish. I think you might compare our desire to an athlete’s need to compete. For us problems solvers the competition is internal, perhaps making this trait more common to introverts?

However, problem solvers have to learn that not all problems need to be solved, and managers have to learn to focus the problem solvers, too. The clunky quarterly seven step process that could be automated and the query that could be tuned from 1 second to 100 milliseconds are interesting problems, but the effort may hold almost no value for the business. It’s often difficult to understand why the business doesn’t want those solved too – can’t they see the current solution is sub-optimal?

None of us are one thing, but it’s useful to understand our dominant traits and those of others. Finding the right balance of traits, well, that’s just a problem to solve!

Andy Warren

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

Redgate SQL Source Control
 
 Featured Contents

SQL-On-Hadoop: Hive - Part II

Frank Banin from SQLServerCentral.com

Running Interactive and Batch SQL Queries on Hadoop and other distributed clusters using SQL.

Dealing with Server Objects, Settings and Features when Provisioning Databases

Additional Articles from Redgate

If we want the behavior and performance of our test databases to mimic that observed in production, then we must consider not only the database but also the server. Grant Frtichey reviews the server-level objects, settings and features that we may need to consider, and then shows how to 'synchronize' the linked servers, user logins and SQL Agent jobs, as part of an automated provisioning process, using SQL Provision.

Azure Data Factory Stored Procedure Activity Transformation Activities

Additional Articles from MSSQLTips.com

In this post we will discuss Azure Data Factory transformation related pipeline activities using Stored Procedure activity.

From the SQL Server Central Blogs - Low Tech Repeating Tasks in Trello

Andy Warren from SQLAndy

I mentioned in earlier posts that I’m using Trello this year for managing SQLSaturday tasks and figured I might as well go all in and add some of the...

From the SQL Server Central Blogs - Chaos engineering for SQL Server running on AKS using KubeInvaders

dbafromthecold@gmail.com from The DBA Who Came In From The Cold

A couple of weeks ago I came across an awesome GitHub repo called KubeInvaders which is brilliant work of Eugenio Marzo (b|t) KubeInvaders allows you to play Space Invaders...

 

 Question of the Day

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

 

Resetting Status

What does sp_resetstatus 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)

Azure VM SQL Database Backups

As a contractor, I have set up a SQL Server instance inside of an Azure VM. I am a little worried about support from the organization that needs this, since they have accidental DBAs that work on the systems.

I want to make the backup process simple and easy for them, while ensuring they can have a point in time recovery to an hour. They are comfortable in the Azure Portal, and a solution that works in the Portal is preferred.

Which of these should I choose?

Answer: Use Azure Backup to the Recovery Services Vault with the workload extension

Explanation: While getting retained might be profitable, this isn't the easiest way to get backups in Azure for a company running SQL Server in a VM. Azure Backup can install an extension into your VM that allows for backup to the Recovery Services Vault. The policy and settings can then be managed in the Azure Portal. Ref: About SQL Server Backup in Azure VMs - https://docs.microsoft.com/en-us/azure/backup/backup-azure-sql-database

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
Hello, I'm a Seller [CVV] - Provide of CVV and Bank Logins + MSR/ATM Skimmers good prices here. - US cvv: Visa/Master: $2 - Amex Card/Discover: $4 - UK cvv: Card Random: $8, With D.O.B/With Pin: $13 - CA cvv: $10 - Paypal verified with mail and pass login: $25 ----RULE---- * Only sell, not share and I don't want to […]
SQL Server 2017 - Development
Sell cvv with good quality - Provide of CVV and Bank Logins + MSR/ATM Skimmers good prices here - US cvv: Visa/Master: $2 - Amex Card/Discover: $4 - UK cvv: Card Random: $8, With D.O.B/With Pin: $13 - CA cvv: $10 - Paypal verified with mail and pass login: $25 ----RULE---- * Only sell, not share and I don't want to […]
SQL Server 2016 - Administration
Cost Threshold For Parallelism - How do I find last update timestamp for Cost Threshold For Parallelism value? Is it logged somewhere?
Get history of blocking - Hi Is there any view that stores blocking history?   Thanks
to change the netbios name on a replication server - Hello everyone I have a server in transactional replication I have a netbios change request from this server the Publisher and Distribution Server are configured on the same server what will be the impact of this change on the good functioning of my replication must change the logical no of this server through the command […]
Software need db owner permission to master database (sql2016) - We have a manufacturer whose software requires authorization for the master database. (only db owner working) Unfortunately, the manufacturer can not tell us why this access to the master database is necessary. Without Permission the application will not start What are your opinions? Have you ever seen such software? We have 200 different applications but […]
SQL Server 2016 - Development and T-SQL
full text search - Trying to understand why when I search for numerics in full text, contains does not return, but containstable does.  It seems that in that in this instance the 0's are repeatable and not indexed, but why does one work and the other not?  Is there a way to make it work regardless? CREATE TABLE [dbo].[EquipSrch]( […]
Disable DCD on table fails - Hello everyone, I have CDC enabled on a few tables. Recently i had changed one column in 2 tables from varchar(20) to varchar(50) and then capture agent CDC job started to fail. What i found is that there is a bug in all SQL versions and no fix.  The work around i found is: Drop […]
SQL 2012 - General
New CVE-2019-1068 vulnerability - is there a patch for MSSQL 2012? - MSSQL Server 2012 Service Pack 4 is officially supported until 2022-07-12: https://support.microsoft.com/en-us/lifecycle/search?alpha=sql%20server%202012 The new vulnerability in MSSQL, published 2019-07-09: CVE-2019-1068 | Microsoft SQL Server Remote Code Execution Vulnerability https://portal.msrc.microsoft.com/en-us/security-guidance/advisory/CVE-2019-1068#ID0EMGAC mysteriously excludes MSSQL 2012. The oldest supported version in the table is MSSQL 2014 SP2. And the article states "If your SQL Server version number is […]
SQL Server 2008 - General
Cannot upgrade SQL 2008R2 DB Engine - Hi; thanks for reading the post   i have inherited a legacy SQL Farm with a couple servers running SQL2008. I am attempting a side-by-side upgrade on the servers (due to constraints out of my hands) I have successfully upgraded a number of them but have a troublesome few remaining. When I attempt an upgrade […]
SSRS 2016
PowerBI Server - Hi all, First of all forgive me if this is the wrong forum for this, I couldnt find a specific channel for PowerBi, so sorry. Anyway, I'm researching PowerBI and I've got myself a bit confused, imagine the scenario that I develop a report and then publish it to the cloud powerbi.com as I want […]
SSDT
pivot on SSDT 2017 - Good Morning everyone I have a problem with a tabular Project on SSDT 2017, I have a 1 table with columns Q1, Q2, Q3 & Q4, I need to Pivot this columns, the manual say that I used the transform Menu, but I dont Find this Menu, Could anyone help me please. I appreciate your […]
Integration Services
SSIS - I am trying to connect oracle 11.2 using Integration service Oracle Destination Editor and OLE DB Destination .Installed the Oracle database client on the SSIS server but still get the below error. There was an error trying to establish an Oracle connection with the database server. Did anyone made successful connection.Any idea or advise please? […]
SSIS Package/Agent Job Not Failing!!! - I have a package running in SQL 2016 using Project Deployment. One of the steps executes a stored procedure.  All of the tasks have their error parameters left at default so any error should cause the package to fail because the maximum error count is 1. In this particular instance the database user account used […]
SQL Server and Sharepoint
Page Output cache problem - I have several users who see old page layout rather than new one. I am not sure what is the problem. Page output Cache profile says inherit inside site content cache option. Is this causing a problem?. I tried clearing browser cookies from user PC, but same problem thanks
 

 

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

 

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