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

Daily Coping Tip

Let go of small stuff and focus on the things that matter

I also have a thread at SQLServerCentral dealing with coping mechanisms and resources. Feel free to participate.

For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from The Action for Happiness Coping Calendar. My items will be on my blog, feel free to share yours.

Communicate Through Commit

Using Version Control is a skill, and it's one that most technical professionals should learn. Even sysadmins and infrastructure people can benefit from, especially as people use infrastructure as code and GitOps with products like Terraform.

Writing a commit message is a bit of an art, and it's a good skill to have. I saw a post on how to write one, and I like the overall advice. Talk about why you're making the change, not what you're doing.

The post has good practical advice about structuring a commit message, especially to ensure the messages are terse and easy to understand. Like much of coding, to do this well requires practice, and feedback. Ensuring your team agrees on how to do this and reviewing messages to help everyone improve will build a more cohesive team as well as reduce the amount of explicit communication you need to have.

Our time is precious as developers, but our attention is even more precious. Every interruption from Slack, a text, or any synchronous communication could break our flow. Many of us complain about meetings taking time out of our day, but the small questions and queries from others, especially at random times, can be worse than meetings.

Building standards, habits, and providing short documentation in common areas, like commit messages, can reduce the need for one developer to interrupt another. The more we work together as a team, by agreeing on and adopting standards, the better we work together as a team.

Steve Jones - SSC Editor

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

 
 Featured Contents

Basic Git for DBAs: Merging Code Between Branches

Steve Jones - SSC Editor from SQLServerCentral

This article will cover a basic set of code merges between different branches.

SQL Server MSDB Database Tutorial

Additional Articles from MSSQLTips.com

In this tutorial we will cover common questions related to the SQL Server msdb database. This is one of the standard system databases that are part of every SQL Server installation. This tutorial will give you a better idea of what the msdb database.

From the SQL Server Central Blogs - Power BI Monthly Digest – July 2020

Devin Knight from Devin Knight

In this month’s Power BI Digest Matt and I will again guide you through some of the latest and greatest Power BI updates this month.

From the SQL Server Central Blogs - Setting up a New SQL Change Automation Project

Steve Jones - SSC Editor from The Voice of the DBA

It’s been awhile since I’ve set up a new project in Redgate’s SQL Change Automation project. I’ve mostly used this in Visual Studio, but I need to demo something...

 

 Question of the Day

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

 

The Eager Writer

What does the eager writer process do in SQL Server?

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)

Removing Variables from R Studio

I am using R Studio and do this:

> customerids <- c(1,2,3)
> orderqty <- c(10, 20, 30)

I added those vectors to a data frame, but in R Studio, I see them as Values in the Global Environment pane:

variables in R Studio

I want to remove just these two variables from my environment to test something. How can I do this?

Answer: type "rm(orderqty)" and "rm(customerids)"

Explanation: The rm() function will remove an item from the R workspace session. Ref: rm() - https://www.rdocumentation.org/packages/base/versions/3.6.2/topics/remove#:~:text=remove%20and%20rm%20can%20be,active%20environment%20is%20searched%20first.

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
SQL2017 CU21 CHECKDB WITH EXTENDED_LOGICAL_CHECKS - I have a problem running CHECKDB WITH EXTENDED_LOGICAL_CHECKS using dynamic SQL since upgrading SQL2017 standard edition to CU21. The problem occurs with msdb on all seven instances and on two out of 63 user databases. The problem does not occur with CU20. If I run the following static SQL from SSMS: DBCC CHECKDB ([msdb]) WITH […]
SQL Server 2017 - Development
SQL Query Help - CHARINDEX - Need query help. create table #tblTest1 (ID int, SName varchar(50), Type varchar(10)) INSERT INTO #tblTest1 values (1,'abc/efg','OS') INSERT INTO #tblTest1 values (2,'xyz/tgf','OS') INSERT INTO #tblTest1 values (2,'tgf/xxx','OS') INSERT INTO #tblTest1 values (3,'ccc/ppp','OS') INSERT INTO #tblTest1 values (4,'ddd/tqm','OS') INSERT INTO #tblTest1 values (5,'mpg/eee','OS') create table #tblTest2 (SName varchar(50)) INSERT INTO #tblTest2 values ('efg') INSERT INTO #tblTest2 […]
Out of memory error when I try to export an SSIS project in SSMS to an ispac - Hey guys, when I go into ssms and open the integration Services Catalog folder, navigate to a project, right click it and left click on export it runs for some time but then I get an error saying out of memory. How can I correct this?
SQL Server 2016 - Administration
SCOM alert offline/recovery pending/suspect... but DBs seems fine - Hello experts, We are using SCOM to monitor SQL Server AOAG, and I am having trouble resolving this alert: Database is in offline/recovery pending/suspect/emergency state I use the alert details to check the status of the databases on each of the AOAG replicas, as well as the Always On High Availability Dashboard. The dashboard is […]
What Should be...? - Dear friends, Using Always On in our corporate site, we have 3 nodes deployed, our main database backup is based on images of that virtual  machines, but constantly I have databases requesting transaction log backups, what role should have a normal backup of transaction log files vs virtual machines images backup, our management team has […]
Cannot connect after Availability Group automatic failover - Hi We have a SQL Server setup with Availaibility Groups, in the cluster we have four nodes, two in one datacenter and two in another datacenter. There are four AGs on these cluster nodes, each primarially on one of the four nodes, with one other node in the same datacenter for syncronous HA and the […]
SQL Server 2016 - Development and T-SQL
Calculate aging between two date fields excluding weekends and holidays in SQL - Hi Friends, I have a table which has DateTime, IsWeekend, IsHoliday fields in my DB. I have another table which has the list of tickets logged with columns like Select TicketID, Status,CreatedDate,ResolvedDate, etc., From Table_A How can I calculate the aging of these tickets excluding the weekends and holidays. I have read so many posts […]
Is it possible to optimize this SQL to get rid of 2 highlighted subqueries? - Is it possible to optimize this statement to get rid of the case named [aging]? specifically, the two highlighted statements that cause 90% of all waits in the entire select statement. 4 attachments: entire SP, the CULPRIT SQL, and the full Stored Proc where it is called +screenshot that shows fully confirmed problem statements that […]
Is it possible to optimize this SQL to get rid of 2 highlighted subqueries? - Is it possible to optimize this statement to get rid of the case named [aging]? specifically, the two highlighted statements that cause 90% of all waits in the entire select statement. 4 attachments: entire SP, the CULPRIT SQL, and the full Stored Proc where it is called +screenshot that shows fully confirmed problem statements that […]
SQL Server 2012 - T-SQL
'Too many parameters..' error - Hi Friends, I am a Database-Design architect trying to write some stored procedures. I created an SP with one IN parameter and many OUT parameters....I called it from the below calling-code carefully having carefully declared the parameters but still I get this error.. Will be very thankful if somebody can point to the issue and […]
SQL Server 2019 - Development
SQL Collation to match IBMi - In SQL, these items sort this way INV175 INV190 INVB03 INVB04 On the IBM iSeries, they sort. INVB03 INVB04 INV175 INV190 Is there a SQL Collation I can use in a query to make a SQL Select ORDER BY match the IBM Sort ?   EDIT: I found this in an old post, which seems […]
Understanding the Expression Service - avoiding expression limits - Hi Sql Experts, At my company, we have authored a piece of software that allows users to examine data by viewing it in a grid, and authoring expressions against that data. Our software ultimately distills those expressions authored in the application to sql expressions used in a SELECT. These expressions are all linear (no aggregations/grouping), […]
SSDT
Use a variable for a file connection manager - How do I tell a file connection manager that the file in question is not a static name and will change daily? I have a string variable that builds the daily expected filename but can't see how to use this. SSDT wants me to enter the name of an existing file... which I can do […]
Integration Services
csv load exact format using ssis - i have one doube in ssis how to load double codes data from sql server to csv filesusing ssis pacakge . source : emp table CREATE TABLE [dbo].[empcsvfile]( [eid] [varchar](50) NULL, [empstring] [varchar](8000) NULL, [details] [varchar](500) NULL ) GO INSERT [dbo].[empcsvfile] ([eid], [empstring], [details]) VALUES (N'1', N'''1'',''yt'',''1te'',''1d''', N'{"test":"ed","eDate":"1990-01-16","isflag":null,"Type":"te","Number":null,"std":null,"mark":null,"Code":"22","cty":"r","state":"tn","country":"IN","isPermanent":null,"Lines":{"Street2":"street2","Street1":"street2","Taluka":"street2","District":"street2"},"Proof":null},{"Type":"PHONE","Date":"2017-05-28","Verified":null,"Type":"BSNSS","Code":null,"Code":null,"Number":"954457565","ette') destination : Test.csv file eid |empstring |details […]
SQLServerCentral.com Website Issues
Ask SSC TLS Error - Posted also over on AskSSC but posting here in case people can't get to the site due to this. https://ask.sqlservercentral.com/questions/156338/tls10-tls-11-error-when-browsing-from-secured-hard.html   Getting an issue when browsing ASK from a CIS hardened desktop with the latest version of Edge or Chrome. This is due to Ask using TLS1.0 or TLS.1.1 which it will not support any […]
 

 

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

 

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