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

Staying Focused

Most of us know when we've been working in the flow. Time ceases to exist, and often seems to have flown by when we stop working. We may not eat or take a break, just focusing on a problem and tackling it in a very single minded fashion. Whether this is a development task or some infrastructure effort, we can achieve flow.

At the same time, many of us struggle to find the flow in a busy workday of meetings, interruptions, music, slack messages, and more. Attention is a commodity, and one that many of us struggle to focus on a single task. We may find that if we do achieve flow and something interrupts us, then we struggle to get focused again.

When I give presentations and talk about remembering what code we wrote or changes we made last week, plenty of people will chuckle along with me. It's a challenge to remember what we were last doing, especially when we move to more DevOps style work with small chunks of tasks being completed. Even coming back to work the next day, after an evening of family or hobby time, can be distracting.

How do you get back into the flow quicker? There are lots of books and advice around, but I thought this programmer's look at how to keep himself organized around a busy life was interesting. He uses some tools, primarily based around software coding, to help remind himself quickly of not only what tasks need to be tackled, but where he was in the flow of the work. In some sense, this reminds me a bit of Andy Warren's efforts at keeping SQL Saturday organized.

Flow is hard to come by. To me, this is one reason why more workers ought to have private offices and less meetings. A developer or DBA in the middle of the zone, working in the flow, needs to be left alone. That's the most productive time for them, when they are most efficient and valuable. More organizations ought to try and foster this, not inhibit it.

Steve Jones - SSC Editor

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

Redgate SQL Provision
 
 Featured Contents

Azure DWH part 19: Backup and Restore SSAS

Daniel Calbimonte from SQLServerCentral.com

In the part 18, we created a Cube based on the Azure Data Warehouse. In this new chapter, we will work with the cube, create backups and show some tips to restore.

Monitoring TempDB Contention using Extended Events and SQL Monitor

Additional Articles from Redgate

Sometimes, a database will slow down exponentially when it is working hard, with many concurrent users. Well, to be more accurate, all the databases on the instance will slow down.

Research Paper Week: Plan Stitch: Harnessing the Best of Many Plans

Additional Articles from Brent Ozar Unlimited Blog

In his latest blog posts Brent shares his favourite research papers, explaining why he found them interesting and why you might too. STarting off with the Microsoft Research paper Plan Stitch: Harnessing the Best of Many Plans by Bailu Ding, Sudipto Das, Wentao Wu, Surajit Chaudhuri, and Vivek Narasayya (2018)

From the SQL Server Central Blogs - Quick Blog: Clone Power BI Workspace Permissions

Aaron Nelson from SQLvariant

However, one detail they left out of that post is how to clone the users & groups, and their respective permissions from one Workspace to another. It's a pretty...

From the SQL Server Central Blogs - Moving to Azure SQL Database Serverless

John Morehouse from John Morehouse | Sqlrus.com

In a previous post, I discussed the public preview of Azure SQL Database Serverless.  This is a newer product released from Microsoft for the Azure ecosystem.  Moving to this...

 

 Question of the Day

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

 

Changing Synonyms

I run this code in my SQL Server 2017 database during development:
CREATE TABLE SalesHeader
(   OrderKey INT IDENTITY(1,1),
    CustomerID int,
    OrderDate DATETIME2(3),
    StatusKey INT );
GO
CREATE SYNONYM Invoice FOR SalesHeader
GO
I now realize that I didn't do a good job with the SalesHeader table, and decide to do this:
DROP TABLE dbo.SalesHeader
GO
CREATE TABLE SalesHeader
(   OrderKey   INT IDENTITY(1, 1),
    CustomerID INT,
    ShipTo     VARCHAR(100),
    OrderDate  DATETIME2(3),
    OrderTotal NUMERIC(8, 3),
    StatusKey  INT);
GO
I then run this:
SELECT * FROM dbo.Invoice
What happens during this process?

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)

Configure Polybase

I want to enable my SQL Server instance to use the Polybase connection to Hadoop. What option needs to be configured?

 

Answer: sp_configure @configname = 'hadoop connectivity'

Explanation: The option for Polybase to use Hadoop is the "hadoop connectivity" option. Ref: Configure PolyBase to access external data in Hadoop - https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-configure-hadoop?view=sql-server-2017

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
Cannot generate sspi context (sql server) - Hi,   Can't login to this SQL Server using Management Studio remotely - but can when RDPed to the server itself?
SQL Server 2017 - Development
Azcopy usinf sql sp - Hello Experts, I am working on SP that sends my csv file from on prem machine to Azure blob container. I am using lastest Azcopy v10. DECLARE @Program varchar(200) = '"C:\AzCopy.exe"' DECLARE @Source varchar(max) = 'E:\Backup\abc.txt' DECLARE @Destination varchar(max) = 'https://myaccount.blob.core.windows.net/' DECLARE @DestKey varchar(max) = 'secret key' DECLARE @Options varchar(max) = '/S /XO /XN /Y […]
SQL Server 2016 - Administration
SQL Server Agent stops unexpectedly - Buffer Overflow - Our SQL Agent has been randomly crashing for the last month and a half. The last time it crashed we had procmon running on the server monitoring SQLAGENT.EXE and prior to it shutting down there was a bunch of Buffer Overflow events, see screen shot attached. There was a probably a 1000 of these all […]
Performance related question - This (performance) is the area time to time I struggle with. Couple of days ago, we had an issue where all of a sudden, an application started running slow. I was told to look into it from a SQL Server side and I couldn't find anything (atleast from what I know) because all the available […]
Basic Avaialbility without active Directory - Hi , I am trying to configure Basic Allwayson in SQL 2016 Standard edition using the below ebsite https://www.sqlpassion.at/archive/2016/01/11/how-to-create-a-sql-server-availability-group-without-an-active-directory-domain/ I did below things. Firewalls off in both nodes SQL-1 & Sql-2 I created DNS Suffix in both servers as Testing.com Remote registry and Remote administration is enabled in both nodes. i enabled Failover clustering In powershell […]
issue with sql connectivity - Hi Experts, This is more of a generic question on sql connectivity. Under what circumstances, users will not be able to connect to sql server instance. The services are up and running though. Firewall is open. TELNET is working and still users are complaining that there app's are unable to connect to sql server. What […]
SQL Server 2016 - Development and T-SQL
SQL Lite Data Types VS T-SQL Data Types - I am having trouble running this SQL Lite on my T-SQL. I changed the NUMBER to NUMERIC n Decimal in SQL Server. Still i am getting this error. What would be the equivalent data type in SQL Server. All of the other SQL Lite code are running on my SQL Server Express, except this: DROP […]
SQL Server 2012 - T-SQL
Trying to insert from table 1 with missing index to table 2 with index - Table 1 is missing an index that was supposed to be in place when the table was created that is set to unique. The table has an identity column. I have created the table 2 new with the index in place and is empty. (Table 1 and 2 are the same structure except table 1 […]
Insert into Select with Conditions - Hello, I think my requirement is fairly straight forward, but cant seem to get the syntax right or find a solution. Im, trying to do a Insert into Select , that will allow duplicates only if a field value in a row is null. hope that makes sense. - thanks Greg
SQL Server 2008 - General
Relations of system tables, Sys.dm_exec_connections?sys.dm_exec_sessions and ... - What are the relations among Sys.dm_exec_connections? sys.dm_exec_sessions and sys.dm_exec_requests and what are the relations among Sys.dm_exec_connections? sys.dm_exec_sessions ?sys.dm_exec_requests and sys.sysprocesses ? I check it on MSDN,but not clear the explanation yet, could you please help me to make a detailed explanation ? thanks
SQL Server 2008 Performance Tuning
Huge speed difference with clause "If exists" - I have a fairly simple stored procedure that checks to see if a value is present in a view. It's horribly slow when it's executed one way, and reasonably quick another way. i don't understand why there is such a difference. Here they are: Slow: if exists (select 1 From BotCBO.vwClovekStrings_PrZk Where ClovekString = '[gmelin]') […]
Data Transformation Services (DTS)
dtexec delay validation true - I have a SSIS package that loads a flat file.  It runs fine on my laptop but on my virtual machine I have to set DelayValidation to true otherwise it looks like it loads the data then removes it from the final table.  On the virtual machine if I run the package from the Visual […]
Integration Services
Package complete but a task is still running, not getting all of the data - Ok, so using SSIS (Visual Studio 2015) and running a single package from the IDE. Now there is no event logging etc. The message come up at the bottom of the screen to say its completed.  Everything looks complete. I open up the data flow task and strange things appear. As in the picture below […]
Possible double hop issue - SSIS Package / SSIS Catalogue - Wanted to check if anyone else was able to resolve this and how they did it. In a nutshell we have a package stored in SSIS catalogue on Server – S1 which reads files from Server – S2 ( NAS share) and then the  package stored in SSIS catalogue is executed via a C# app […]
SQLServerCentral.com Website Issues
Search box returns error when clicked -
 

 

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

 

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