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

Daily Coping Tip

Get a long hug from someone that is important to you.

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.

Finding Separation During WFH

Work life isn't the same for all of us. In fact, as I read through this HN thread, I find that work is more varied than I often consider. I haven't worked for any of the big tech firms (FAANG or MSFT), but I have worked for companies that had a variety of perks, including food, gyms, childcare, and more. I've taken advantage of, and not been interested in these, at different times in my life.

Many of us are working from home (WFH) for the first time in an extended fashion. I've been quite fascinated in the differences amongst my co-workers. Most of them love this and are looking forward to the remainder of the year at home. Some don't like it, and feel trapped. I've been WFH for nearly 20 years, but I've often been able to change my environment through travel or working in public spaces, which aren't really a good idea right now, even if possible.

Now that we're four months in for most of us, I wonder how many people are coping, and maybe more importantly, how are you achieving separation from work in your life? Are you setting work hours or shutting down your work communications? Perhaps you have some other technique?

I have tended to pop into my office often in the past, most every day, even weekends. The flip side if I often pop out of the office during the week for the gym or to do some personal task. I've also started to avoid even going into my office on the weekends, using my laptop if I need to browse the Internet for some knowledge, without opening Slack/Outlook/Twitter/etc. Trying to completely disconnect on the weekends.

If you are coping, or perhaps not coping, feel free to drop a note in the discussion, give a tip, ask for advice, or just let us know what you like or don't like about your environment.

Steve Jones - SSC Editor

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

 
 Featured Contents

Visualise SQL Server IO Stats

Philip Robinson NWDBA from SQLServerCentral.com

Visualise and compare the output of set statistics io on with Power BI to assist with performance tuning.

Gathering SQL Server Performance Counters for Multiple Servers

Additional Articles from Redgate

SQL Multi Script can easily be persuaded to run queries at the server level rather than the database level. It is also able to combine results from many databases even if the results aren't identical but have some different columns. Phil Factor demonstrates how this works, when collecting a set of performance counters from all databases on a distribution list of servers.

Getting Started with Azure DevOps

Additional Articles from SimpleTalk

Microsoft provides Azure DevOps for hosting your repos, setting up pipelines and more. In this article, Diogo Souza shows you how to get started using Azure DevOps.

From the SQL Server Central Blogs - Adding a FK to a Table–#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. One thing that helps ensure your data is...

From the SQL Server Central Blogs - Transforming JSON data with the help of Azure Data Factory - Part 5 - Comparing it with Databricks

Rayis Imayev from Data Adventures

(2020-July-29) There is a well known and broadly advertised message from Microsoft that Azure Data Factory (ADF) is a code-free environment to help you to create ...

 

 Question of the Day

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

 

BDC Storage

A SQL Server BDC (Big Data Cluster) includes a scalable storage pool. How is this set up?

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)

Writing Dirty Pages

How are dirty pages written to disk in SQL Server?

Answer: With the lazy writer, eager writer, or checkpoint

Explanation: A dirty page is written to disk in one of three ways: the Lazy writer, the Eager writer, or a checkpoint. Ref: Writing Pages - https://docs.microsoft.com/en-us/sql/relational-databases/writing-pages?view=sql-server-ver15

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
Solutions for real-time replication of data from one SQL instance to another - Hi, I'm hoping for some opinions on the best options for how to replicate, in real time, data from a production SQL Server database onto another SQL instance. This second instance would be for vendors who need to access some of the tables from the production database, but we would prefer that they not directly […]
Faster Integrity check - We are upgrading from SQL 2014 to SQL 2017. Noticed that integrity checks are running 6 times faster than SQL 2014. Is that a big enhancement in SQL 2017? Do you agree with me?
SQL Server 2017 - Development
Insert missing records for each month/year with the previous month's value - I have a sample data, see below. Sample data The base rules are If the same CustomerID and Account# for the month that don't exist based on the previous month, then insert it; If the same CustomerID and Account# for the month that do exist based on the previous month, then keep it. For example, […]
SQL Server 2016 - Administration
Import Extended Events XEL File ? - I have a 300 Meg .XEL file from an Entended Event session that I used recently. I stopped the session, and want to query the data. What's the best way to get the file into a SQL table ? In general, what's the best way to read the data, and look for stored procedure calls […]
Insert all columns except for Identity ID - Two tables A and B have the same structure and the same number of columns. First column in both tables is IDENTITY ID. The script below cause an error because ID. INSERT INTO B SELECT *  FROM A How to use "Except" to not select column "ID" from table A?
SQL Server 2016 - Development and T-SQL
Retrieve a row with non-unique cluster keys - I noticed that for those tables with non-unique cluster key columns, SQL adds an internal unique identifier. Is there a way to retrieve a single row using this internal unique identifier which seems to be an Int32 number.
SQL Server 2012 - T-SQL
Entered by mistake - Entered by mistake
File import - Hi, I first have to say that I am not that knowledgeable on file imports, but this is really beyond me. My manager has a file that has adnominal spaces in it, I think some are tabbed and some just space, but my manager wants me to import the file into a table and keep […]
SQL Server 2019 - Administration
Application SP Response time differs on user login - I have multiple parameterized SP for our Application. When I Executes those SP individual it will returns output within 1 Sec. But when we are running Test Load with multiple user around 100 or 200 users same time , Same SP Response Time is Over 3-4 Sec. If i Execute same SP with same Parameter […]
SQL Server 2019 - Development
How to Identify Slow Code - In a specific Query, how can you easily identify how long each piece of code is taking? My query is taking over 20 minutes so I can't just comment out each line and see what improves it, so I need a better method.
For XML Clause is slow - Hello everyone, I am finding issue while running this query . WITH XMLNAMESPACES (DEFAULT 'http://example.Schema.Example.data') Select(Select * from [dbo].[udfReturnexampleRecords] () for xml path('Test'),root('example') ) as XMLTEXT   Here udfReturnexampleRecords is a table valued function and while running complete query , it runs very slow for 20 lakh records. Any advice please . Thank you
Reporting Services
Moving sub-columns in a tablix - I have a report which looks like this: These are all grouped by manager, with each of the center cells displaying the value for the particular manager and then the picture at the top and at the bottom right the sales and profit for each year. This repeats for each manager. I want to move […]
Integration Services
Ignore failure works in Visual Studio but not in Integration Catalog - Hi   I have a control package which calls a number of packges as part of an ETL process. In the RAW layer (from source to DB) I have a file which has failed due to a metadata change. This caused the whole ETL to blow up. I modified the control package by updating the […]
.dtsx packages disappearing!!! - SQL Server Data Tools 15.1.62002.01090 Microsoft Visual Studio Community 2017 Version 15.9.21 I am loosing dtsx packages!  It happens sometimes when i am closing a solution and sometimes when i build the project.  The packages are actually deleted from file and are no longer avaialble.   They are just deleted.   What is happening?  Has anyone else […]
General
Joining 2 Tables (Sales with current stock on hand) displayed - Dear all, I am trying to join 2 tables (Dailysale table and Storerng table) Dailysale contains daily sales transaction while Storerng contains the stock on hand I am using the below query select DS.DTMTRADEDATE as [DATE], DS.INTSALEID as RECEIPT, IT.STRXREFCODE as ARTICLE, (sum(case when strsaletype='I' then convert (decimal(5,0),ds.DBLQTYSOLD) else null end)) as [QTY SOLD], (sum(case […]
 

 

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

 

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