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

Daily Coping Tip

Make time to run, walk, bike, swim, dance, cycle, stretch, or some other activity

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.

Office FOMO

There are plenty of companies that are starting to consider bringing people to the office. A few are tentatively making plans, Microsoft has opened campus with the option of 50% time at home. Google is aiming for Sept 1 and requires you to request remote work for more than 14 days a year. A few other friends are starting to go back 1-2 days a week at their companies, with the idea that this may increase over time.

Redgate has still extended full time remote to the end of 2021, and I have no idea what things will look like after that. I'm curious, and anxious, as I want to go back to the office. Like mentioned in this piece, I am missing others, the interactions and the chance meetings. Grant wrote about things we miss recently, and that was my response. Not necessarily the office, but just missing the chance to interact with adults and talk tech.

The bigger issue that I see, is that many of us may feel forced back into the office to take advantage of opportunities. The chance to get visibility with people outside our team, especially those that might be in management positions and can impact our careers. The face time, especially casual encounters outside of meetings, are a chance to impress others and give us an advantage over others.

To me, this is the challenge of remote work when not everyone is remote. Out of sight, out of mind is an apt expression. While you might constantly contact those that you work with, who are the people that may give you a raise, a promotion, or a spot on a project that everyone wants to work on? If these are people you contact often, great. If not, and in my experience, I don't often get the chance to sell myself to them unless I'm in the office.

These days I'm not as ambitious in my career, so I worry less about impressing others. I do want to see people, and that is what I miss the most during this pandemic. I do hope I can go back to the Redgate office and see people this fall, and I am hoping some events start to take place in person, perhaps with limited audiences, but in some way that allows us to have those chance, serendipitous interactions.

Steve Jones - SSC Editor

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

 
 Featured Contents

Soft Skills: Controlling your career

David.Poole from SQLServerCentral

Technical skills come and go while soft skills will serve you throughout your life. They will have the greatest influence over your career, job and role.  For some people soft skills come naturally.  As an Aspergers person (Aspie) I have to practice my soft skills at every opportunity. Pure techies need not lose hope. Soft […]

Learn basics of Data Wrangling in SQL Server to handle Invalid Values

Additional Articles from MSSQLTips.com

In this article we cover the topic of data wrangling which is steps you can take to cleanup and validate data prior to data analysis.

From the SQL Server Central Blogs - Changing MaxDop For Resumable Index Create Operations

John Morehouse from John Morehouse | Sqlrus.com

I’ll admit it, sometimes I’m wrong. Recently I blogged about the usefulness of a newer feature that was enhanced with the release of SQL Server 2019.  Resumable Indexes operations...

From the SQL Server Central Blogs - When the DBA is Deadlocked

Pam Mooney from The Non-Cluttered Index

When I launched The Noncluttered Index last year, it was with the intention of writing at least twice a week. For a while, that was very doable.  Then, work...

 

 Question of the Day

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

 

Parquet

What is the Parquet format for data files?

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)

Comparing Execution Plans

I am trying to work on tuning a query. I want to look at the two execution plans for the two versions and compare them. What should I do in SSMS v18.6?

Answer: Run one query and save the execution plan. Then run the second query and right click in the execution plan area and select "compare showplan"

Explanation: You need to save at least one of the execution plans. Then when you have a second one in the window, you can right click and select "Compare Showplan" to look at two at once. Ref:

Discuss this question and answer on the forums

 

Featured Script

Space allocated to the databases by disk letters

Evgeny Garaev from SQLServerCentral

Found this useful for database migrations. This helps to identify how much space will need to be allocated for a new server and how a SQL Sever instance is using discs currently. Note. This won't show correct information on Linux instances and if you use mounting points in Windows.

SELECT SUBSTRING(physical_name, 1, 3) DiskDrive, (8.0*sum(size))/1024/1024 GB
FROM sys.master_files
GROUP BY SUBSTRING(physical_name, 1, 3);

More »

 

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
Delete data - Just to get some thoughts. I am looking to delete data from a large table in  SQL Server database that is part of availability group with 4 additional secondary replica's in Async mode. Other than performing delete in batches what other care should be taken. I am running against test databases and noticed the deletes […]
SQL Server 2017 - Development
MySQL To TSQL - Please assist in transforming this mysql code to tsq please?   SELECT date(o.created_datetime) as Date, od.product_uid as 'Product UID', p.manufacturer Manufacturer, p.bmc BMC, p.brand Brand, od.label as SKUs, p.selling_unit as 'Unit of Measure', ROUND(if(od.amended_quantity is not null, od.amended_quantity, od.quantity)) as 'Units Sold', ROUND((if(od.amended_quantity IS NOT NULL, od.amended_quantity, od.quantity))*p.content,2) as 'Sales Volume', ROUND((if(od.amended_quantity is not null, […]
SQL Server 2016 - Administration
Profiler Trace - Hi, I am aware of capturing the trace for a single user database by adding the DB name in the column filters. If I have to filter the trace only for 2 user databases, how can I add one more database name in the column filter which says LIKE 'TESTDB' ( example) ? or just […]
Help with detecting and sending alerts for lengthy blocking - Over the weekend we had 2 ETL jobs that were causing unresolved blocking with each other. One reading data the other inserting and updating. The jobs had been running for 45 hours in the blocked state. This was only resolved after one of the processes was killed. I'm looking for some help with the best […]
Sp_server_diagnostics for WorkerThread - Hi there, I am seeing excessively high number of worker threads when running Sp_server_diagnostics. My question is around the 3 figures: "queryProcessing maxWorkers="704" workersCreated="756" workersIdle="206""and how to interpret them. As you can see from the above we are certainly exceeding the maxWorkers  but I'm trying to understand if workerIdle comes into play here. Does this […]
Database going to Recovery, while accessible. - one of the 3rd Party DB's is going to recovery state. Whithout any reason I could find. The log shows one DBCC CHECKDB after another is running on that database. Strange, I can access and query the db in ssms. I did repair_rebuild and it is working again, but after some time the problem arises […]
SSIS package cant open and find - Hello when I log in get this error: What is another way find and open ssis package?
SQL Server 2016 - Development and T-SQL
Buy oxycontin 80m,xanax,Oxycodone,Ritalin,Diazepam etc WhatsApp:+1(312) 379-9621 - We are most reliable and efficient suppliers/distributor of all kinds of commonly used pain killers,anxiety meds,depression meds,sleeping/sex aid pills,Steroids such as Hgh,Injectable steroids and Orals with safe and quick delivery to any part of the world without any custom issues..We do worldwide shipping to any clear address. Customer satisfaction is our greatest concern Shipping is […]
ExecutionLogStorage Returns No Records - SSRS - Hello, I am trying query the log for SSRS. I queried ExecutionLog3 table but did not get any records. Logging is enabled and retention period is 60 days. The ExecutionLog3 / ExecutionLogStorage is expected to have the data logged into it. What could be the reason for it to return 0 records? Can it be […]
Development - SQL Server 2014
how checksum works? - Could you please me how checksum work in the SQL statement ? below is an example. SELECT * FROM Tablename1 WHERE CHECKSUM(*) NOT IN (SELECT CHECKSUM(*) FROM TableName2) 2. and there is page checksum and database backup checksum, and what does it do while page checksum and database backup checksum? thanks!  
SQL 2012 - General
How to make group to data on pivot sql server ? - I work on SQL server 2012 i need to make group by to pivot data repeated inside pivot so i need to make group by TO FINAL RESULT PIVOT this is my sql script meaning i need to group by to data result from excute @sqldata so How to do that please DECLARE @result NVARCHAR(MAX) […]
SQL Server 2019 - Administration
upgrade path to SQL 2019 - I read the upgrade path for standard edition to SQL server 2019, the oldest version is SQL server 2012 SP4.  If earlier than 2012 it may need a version of middle to upgrade first, then to 2019. If this is s side by side installation and upgrade, like to a new server with SQL sever […]
SQL Server 2019 - Development
Archiving data to a read only file - Hi there I have a table for which archiving functionality is required. Now I have thought of writing sonmething in t-sql to use BCP to write to csv or caret delimited file There is a requirement that this file be made tamper proof and read only. Apart from setting the file attribute to read only, […]
Filtering a hierarchy-related query - I've got a table with LOTS of data. It's a tree-structure (using hierarcyId datatype) and I want a query to get all of them UNLESS they have a parent that's flagged as "Inactive" in the database, then I want to skip everything that's inactive and below. I hope you get it. If possible I want […]
Issue connecting to sql server 2019 - Hi All have been having issues connecting to Sql 2019 server this morning. Please see message I'm getting below. Any help would be greatly appreciated
 

 

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

 

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