SQLServerCentral.com Community Update for {date}

Problems displaying this newsletter? View online.

Featured Contents

Question of the Day

The typo

The Voice of the DBA

The Crazy Times of Year

Do you have busy times of the year that recur regularly? In some positions I've held, we had certain events or processes that always caused additional stress and headaches for employees. As a bartender, certain holidays (New Years, Halloween) were extra crazy. In one company, every quarter was an adventure involving a late, or a complete, night of work. Different industries and organizations seem to have different schedules that regularly stress employees.

Are there times that are tough for you? Or maybe slow times? In a few organizations where my wife worked, the week between Christmas and New Years was always so slow that they'd actually close the office and give people the week off, without it affecting their vacation schedules. That would be a nice perk to have.

This is the busy time of year for me. Spring sometimes gets filled, but this next couple months is somewhat crazy. The first third of September I was in the UK. I returned home, and I have a week and a half off, which I need because then life gets hectic.

The weekend of the 20th, I'm heading back to upstate New York to see my daughter play in a volleyball tournament. That's exciting since I've never seen her play college competition live, and I'm looking forward to the trip. A few days after I return, however, I head to Australia for work. Just a couple days, because I can't spare the time, which is disappointing to my wife. She's like to go, but since I'm in Memphis the first weekend of October, there isn't time for a week in the beginning of Spring down under.

I am home the second week of October, but with a pre-con and SQL Saturday, it will be a busy week of prep and trying to get other things done since the third week of October my wife wants to go back to New York to see our daughter. I'm tempted, but torn since the last week of of the month I return to London before heading to Seattle the weekend after.

I still have other work to do with SQLServerCentral and Redgate in addition to these weekends, and I have the feeling I'll be ready to knock off travel and just coach kids after the PASS Summit. Right now I'm looking at being committed for part or all of every weekend except for this past weekend until Nov 9.

A tough time, but really, it's a great job I have with amazing opportunities to see friends and places all over the world. I know I'll be tired, but it will be a good tired, even with the extra time spent preparing for travel and catching up on chores when I return.

Are there any wild times in your work world? Let us know today.

Steve Jones - SSC Editor

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

Featured Contents

Managing SQL Server containers using Docker SDK for Python - Part 2

carlos10robles from SQLServerCentral

There are multiple ways to interact with the Docker daemon, as command line client API or GUI based tools like Kitematic. Docker also provides a SDK for Go and Python, this SDK can be used to create and manage Docker containers the same way it works with the Docker engine API.

A fresh new look for Redgate University

Additional Articles from Redgate

Last September Redgate University opened its doors online, since then, with their selection of getting started courses they have been helping customers get up and running with their tools. Now, along with a brand-new look, new courses have been added to help you advance your skills past the basic usage of the tools. Come and check it out and leave your suggestions for future courses.

Working with React Components

Additional Articles from SimpleTalk

The React library allows teams to work faster and with more consistency. In this article, Camilo Reyes explains how to get started using React components in a C# application

From the SQL Server Central Blogs - Whitespace, Letter Case, and Other Things That Prevent Plan Reuse

Bert Wagner from Bert Wagner

Watch this week’s episode on YouTube. Last week’s post briefly mentioned that SQL server may not reuse a query plan from cache if there is a small difference in whitespace....

From the SQL Server Central Blogs - Finding SQL Configuration Manager in Windows 10–#SQLNewBlogger

Steve Jones - SSC Editor from The Voice of the DBA

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I went to check a network protocol setting...

Question of the Day

Today's question (by Steve Jones - SSC Editor):
	The typo
I'm inserting some test data with an INSERT statement. I have a GO separator after this, but as I go to type CTRL+E to execute the query, I accidentally type a 5 in the editor and this gets executed. INSERT dbo.Claim ( PharmNo, ClaimNo, ClaimDate ) VALUES ( 'KLM', '123', GETDATE() ) GO 5 What happens?
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)

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?

Answer: Everything works and there are 6 columns in the result set from dbo.Invoice

Explanation: Everything works here. The synonym resolves to the name of the table and at the time of the query, there are 6 columns, so all are returned. Ref: Synonyms - https://docs.microsoft.com/en-us/sql/relational-databases/synonyms/synonyms-database-engine?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

SSIS - Why No Failure/Error On Truncation? - I tried Googling this but most complaints seem to be that SSIS is giving people truncation errors when they don't think they should have them. I'm having the opposite problem: my SSIS package is "successfully" loading a long string into a CHAR(6) column and SSIS/SQL Server (?) is automatically truncating it. It gives me a […]

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 […]

SQLServerCentral.com Website Issues

Search box returns error when clicked -

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.