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

Daily Coping Tip 

 

Get out into a green space and enjoy nature 

 

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. 

Beer Mode

David Perell has an essay on the different ways that creative people work. He calls these "beer mode" and "coffee mode". When you are in coffee mode, you are getting things done. You have a list, and you work towards accomplishing the items on your list. Lots of us spend time in this mode every day, and often our bosses expect us to spend more of the time here. This has also been described as "closed" mode.

Beer mode is different. This is an open mode, where we are not focused on solving an idea, but rather playing with something. We are thinking widely, investigating, and not necessarily planning on getting something concrete completed.

For much of my career, I was in coffee mode. I think my ability to take a list and get things done contributed to my success in various positions. I could grind through a set of tasks, even repetitive ones, and show my boss what I'd accomplished each day. Going through a list quickly, even if slightly inefficiently, was often rewarded.

These days, I spend more time in beer mode. Not actually drinking beer, but rather experimenting, playing, thinking, and trying to find new insights into the database world, into how customers might re-imagine their use of our products, and how computing and technology can inspire the world. Those are the fun times. I still get a fair amount of coffee mode in editing, scheduling, etc., but I get more playtime than I ever expected in the past.

We need both types of working. Often we do want focus and concentration. This is where we build skills, develop strong habits, and produce something valuable. This is steady growth. However, we also need creative time. This is where we expand our minds, think outside the box, and how we grow in leaps and bounds. At least, we may. We can't predict when we have a breakthrough or find an "aha" moment, but all of us have them, even when they are not life changing.

Some organizations are better than others at allowing some "beer mode" time at work. If your boss doesn't think there is a need for unstructured work, maybe send them the essay above and see what they think. There might be all sorts of reasons why this doesn't make sense every day, or every week, but I do think that having some experimental time is important for anyone doing creative work. This includes the DBAs and sysadmins trying to get your system to run better without a large budget.

Steve Jones - SSC Editor

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

 
 Featured Contents

Creating a Robust SSIS Development Environment using the SSIS Catalog

reinis from SQLServerCentral.com

Discover how to integrate features of Visual Studio and the SSIS Catalog for an efficient development and deployment environment.

The four best features to look out for in SQL Monitor

Additional Articles from Redgate

In this blog, David Yard at Kingston Technology shares his favorite SQL Monitor features and how they’re helping him to make sure their large SQL Server estate performs at its best.

Simple Talk Storage 101 by Robert Sheldon

Additional Articles from SimpleTalk

The only way to derive meaning from the massive amounts of data collected today is to develop innovative high-performing, high-capacity storage solutions. In this book, Robert Sheldon explains the many types of storage currently available and what's on the way.

From the SQL Server Central Blogs - The PASS Data Community Summit Call for Speakers

Steve Jones - SSC Editor from The Voice of the DBA

The other day I saw something that I wasn’t sure I’ve ever see again. The call for speakers for the PASS Data Community Summit went out. After the dissolution...

From the SQL Server Central Blogs - The WITDC Mental Health and Wellness day and why July 2020 really sucked for me.

Kenneth.Fisher from SQLStudies

I recently gave a presentation at the WITDC Mental Health and Wellness day. The recordings are out and here’s the ... Continue reading

 

 Question of the Day

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

 

Write-Debug

If I use the Write-Debug cmdlet, how do I get output to the console?

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)

Flatten a Multidimensional List in Python

I have this list in python:

mdlist = [[10,20,30],[40,50,60],[70,80,90]]

I want to remove the grouping and get this list:

[10, 20, 30, 40, 50, 60, 70, 80, 90]

Which of these does this and stores the result in a variable?

Answer: onelist = [x for temp in mdlist for x in temp]

Explanation: The nested iterators in this comprehension will flatten the list. Ref: Data Structures - https://docs.python.org/3/tutorial/datastructures.html

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
Huge Table archive from One server to Another server - Hi All, I have a huge table of DataSpace 200 GB data and 450 GB of Index Space, Compression type is ColumnStore. Currently, I am using a power shell script with SqlbulkCopy Object to copy the data with a batch size of 10000. As the destination table size grows the copy is becoming slower and […]
SQL Server 2017 - Development
Insert data using view - Hello! I have to create a view called Customer_Age. I need to pick distinct birth year values from Customer table. Then using that I need to calculate Age as per today. And based on Age, I need to calculate Age group, Group Name etc. The data should look like:   How do I create a […]
SQL Server 2016 - Administration
reconfiguring tempdb - hi folks i have a sql server that has 15 tempdb files split over 2 drives, and autogrowth of 10mb or 64 mb depending on location the server has only access to 8 cpu's. i want to reduce the files to 8, size them up equally with plenty of space and put them all onto […]
Trans Log backups not running - I set up 2 servers with AG and a secondary is readonly.  SQLSERVER 2016 on Windows 2016 Everything is up, AG is synced up and data comes back. The odd part is the databases in the AG won't take a trans log backup? I can run the statement, but nothing happens. It doesn't come up […]
SQL Server 2016 - Development and T-SQL
How to Query Arrays with T-SQL - Hello Community, Can someone let me know how to query Array with T-SQL? For example, for the sample table below I would like to query the field 'ce_data' to find the following: where applicationSubmittedData = 2021-05-17 and applicationType = personal and deceasedDiedEngOrWales = No The sample data is as follows: CREATE TABLE #tmpTable ( ce_data […]
Recursive query problem - find ALL related records for a given record - I'm stumped but confident that there's a solution.  I'm hoping someone can help. I need a way to find all of the related records in a set of relationships given any record ID in the set.  The nature of the relationships is variable.  The 'happy path' is that the relationships represent a simple 'daisy-chain' where […]
SQL 2012 - General
How to update generated number field with number to every group from 1 to 4 ? - I work on SQL server 2012 I face issue I need to update Generated Number on table test to get UNIQUE number to every group id from 1 to 4 so first group from groupid 1 to 4 will be as 1000 so second group from groupid 1 to 4 will be as 1001 so […]
SQL Server 2019 - Administration
log shipping LSAlert showing false error - We updated our production servers from SQL 2016 to SQL 2019 over the weekend, and we setup log shipping between our main SQL Server instance and our BI server...  log shipping seems to be working as expected - logs are getting backed up on the primary and restored on the secondary, no errors, and I've […]
SQL Server 2019 - Development
SQL If not null then insert N - Is there a way to write a line into a SQL so that the column only shows a N if there is something in the field it is reading from? i.e. PERSON.TERMINATION_DATE, Only want this column to show an N if there is a termination date.
XML Parsing - Unable to switch encodiing using utf-8 when casting from NVARCHAR - Hi there I have a piece of code which takes an input parameter of NVARCHAR(Max) and then attempts to cast it to XML as follows declare @DataSheetXML NVARCHAR(max) declare @DataSheetXML2 xml set @DataSheetXML = N' ' set @DataSheetXML2= CONVERT(XML,CONVERT(NVARCHAR(MAX),@DataSheetXML)) This fails because I get the following error message: Msg 9402, […]
SQL Server 2008 - General
Help with SUBSTRING CHARINDEX - I have a field that coonsistently has data in this style: (b) Joe Brown -12563, (a) Mary Edwards -15425 I need to pull out only the name. I have the below which will pull out the name but it won't trim the space, hyphen, and number off. Any ideas? SUBSTRING([AGENT],CHARINDEX(')', [AGENT])+1, LEN([AGENT])-CHARINDEX(')', [AGENT])) name
Lock table for Insert/Update/delete - I am using SQL Sever 2008. I want to lock the whole table for insert/delete/update operation,but should allow other users to read. can anyone please suggest How to lock SQL table from insert/delete/update, but allow read , until certain operation is completed on that table ?
SSRS 2012
SSRS required services - Good day to all. I would like to know what are the ff. required services on SSRS2012? My acquired service unit has a pre-installed MSSQL 2012 from the previous developer. Is there a testing port after activating/installing the report service. Appreciate your kind help.
Powershell
Can't reach site to install MS Reporting Services Tools - Hello experts, I found what seems like the perfect set of tools that I need to migrate reports from one SSRS instance to another. The info I used is here: https://www.mssqltips.com/sqlservertip/4738/powershell-commands-for-sql-server-reporting-services/ The first step is to install the tools using this command in PowerShell: Install-Module -Name ReportingServicesTools However, I get this message when I try […]
Integration Services
SSIS executing older child package - Dear all, I have a weird problem. Our client has in the MS SQL Server Integration Services Catalog, a parent Package deployed. That package calls some child packages using the Execute Package Task and calls the child ssis from the filesystem. I changed the child package, but it seems the parent package executes the previous […]
 

 

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

 

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