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

Daily Coping Tip

Notice when you feel judgmental and be kind instead

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.

Leading without Managing

One of the interesting things I have heard a few times during the Pluralsight Tech Skills Day was growing your career, and moving into a leadership role, but without becoming a manager. I've tried to this the last few jobs, helping others and even managers learn to be better at their job of, well, managing.

Part of that job is leading. That means inspiring employees, and helping keep them motivated and on track without penalties or pressure. Maybe the best definition I've seen in the past is that leadership is convincing people to get things done when they have no reason to do so. It's influence and inspiration.

Managing is often dealing with day to day issues. Scheduling vacation, salary reviews, tracking progress of work, dealing with HR issues, running meetings and more. Those are skills managers really need, and often aren't well trained on. Hopefully you get a manager that has spent time learning these skills.

Leadership is different, and it's something you can do in any position. You can inspire others, set an example, and believe in yourself. Those qualities often bring others along, especially when you have success. Even if you don't always succeed at your task, learning and trying new approaches can convince others that they should follow your lead.

As a manager you can force others to follow your direction, but leading them is a different skill. I've had many more managers that couldn't lead than could, but that wasn't always a problem. As long as someone is providing leadership, the team has direction and focus. If you don't have a manager that's a leader, perhaps you want to be that person. Step up, be a role model, and guide others along a path that meets the goals your organization has set.

Steve Jones - SSC Editor

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

 
 Featured Contents

High Precision Multiplication

cmartel 20772 from SQLServerCentral

Learn how to multiply large numbers while minimizing the loss of precision

How Does Microservices Architecture Change Database Deployment?

Additional Articles from Redgate

Grant Fritchey discusses the relationship between microservices architecture and database deployment and how these two important pieces of the DevOps puzzle, can work together, or against each other in the future.

How to query blob storage with SQL using Azure Synapse

Additional Articles from SimpleTalk

How do you include blob storage in reports? In this article Dennes Torres explains how to query blob storage with SQL using Azure Synapse.

From the SQL Server Central Blogs - T-SQL Tuesday #140 Wrap up: What have you been up to with containers?

aen from Anthony Nocentino's Blog

I want to start by saying thank you to all who submitted, and an amazing collection of people submitted some fantastic content. Also, thanks to Steve for asking me...

From the SQL Server Central Blogs - Building a Basic Desktop Flow with Power Automate Desktop

Devin Knight from Devin Knight

In this video Devin covers the the beginning design of a Power Automate Desktop Flow that will be used over the course of the next

 

 Question of the Day

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

 

More Python Lambdas

I have this lambda defined:
x = lambda a: a * 2
What happens with this code?
x('a')

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)

Azure Blob Store Redundancy

Which type of redundancy offers this: data is replicated synchronously across three Azure availability zones in the primary region. Each availability zone is a separate physical location.

Answer: Zone-redundant storage (ZRS)

Explanation: When you want to ensure you have replication across Azure availability zones in one region, you can use ZRS. Ref:

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 - Development
Find gaps in string values within a table - I have a table with ~500K rows in it. Here's a sample of the data BegVal EndVal Volume Prefix Padding begnum endnum ABC000063738 ABC000063738 VOL001 ABC 9 000063738 000063738 ABC000063739 ABC000063740 VOL001 ABC 9 000063739 000063740 ABC000063744 ABC000063746 VOL001 ABC 9 000063744 000063746 DEF00000009 DEF00000011 VOL002 DEF 8 00000009 00000011 DEF00000012 DEF00000014 VOL002 DEF 8 […]
SQL Server 2016 - Administration
Suspect database on Secondary due to Log Redo issue - I have sqlserver 2016 in an AG with 2 secondary's for readonly and have recent cu. I have had multiple times in last 2 months where one of the secondary databases goes into suspect mode. Could not redo log record and suspend from redo are what I keep seeing Also, it's the same database every […]
SQL Server 2016 - Development and T-SQL
SSRS cascading parameter doesn't change value when upstream parameters change - My report has a title that is based on the values in a couple of parameters. I'd like to add a feature to the report where the user can overtype the value for that title when the logic that sets it doesn't give quite the result they'd like. I tried adding a parameter for that […]
Insert into Table Not Working - supplied values does not match - Hello Community, I watched demonstration which showed how to insert values into a table with a view to adding a row to an existing table with new values. The following is an image showing that the 'Insert' working and add an entityID of 207 When I run the same code on my SQL server (with […]
Automate SQL query to send excel spreadsheet via email - I have this SQL query that runs perfect. I now would like to automate it as a stored procedure that emails the results in an Excel spreadsheet. Any pointer? Thanks for any help you can provide. Here is the query: select SiteID, case when SiteID = '001' then 'Omaha Terminal' else 'Geneva Terminal' end as […]
update target table when there is any changes in source table columns - Good Morning, I have a question regarding Update statement between two tables (stage_Table, Final_Table). Here Stage_Table is daily refreshes (truncate and load from feed) Fianl_table contains full data that includes everyday new records and changes over time here in final_table we have two columns that are part of Primary key (Col1, Col2) in the both […]
Development - SQL Server 2014
Dashes in uniqueidentifier - Are the dashes in the UniqueIdentifier always in the same index position? I have an Asp.Net mvc application where I pass a uniqueidentifer in the querystring as one of the parameters.  Normally this is not an issue to have the dashes in it.  However, In one solitary instance where I am creating a Pdf document, […]
Works fine in SSMS - Zero records in agent job - xp_dirtree - Hi, If I run this in SSMS it returns 7000 file names (works great): -- ############################################################################## -- BEGIN - Dump entire file tree of the documents folder into a SQL table -- ############################################################################## IF OBJECT_ID(N'tempdb..#dirs') IS NOT NULL BEGIN DROP TABLE #dirs; END; IF OBJECT_ID(N'tempdb..#directoryTree') IS NOT NULL BEGIN DROP TABLE #directoryTree; END; DECLARE @BasePath […]
Sudden Duplicate rows - Hello My query has been running for ages without a hitch but yesterday ,  Some totals  on one of the customers  exactly doubled in value   , I noticed that the rows had doubled in the query  instead of 22 rows there were 44.  but when I stripped out the query , I got 22 rows […]
SQL 2012 - General
Creating a table using an existing partition scheme - I have a partition scheme created and just need to create a table using it, but i need to use syntax for adding the indexing and primary key at the same time if possible. Can this be done? "PS_Year_Partition" is my partition scheme name: CREATE TABLE [dbo].[CallLogCommonPartitioned]( [CALL_ID] [varchar](255) NOT NULL, [DATE] [date] NOT NULL, […]
SQL Server 2019 - Administration
SQL Server Availability Group Database Backup - When performing Full Backup and Log Backup of an Availability Group database. How is the log chain not broken when the Availability Group fails over to the Secondary node in a two node Cluster? As I see it we have a 2 node cluster with Full Backup and Log Backup running on Node A. Then […]
SQL Server 2019 - Development
Extracting out elements from XML String based on condition in tag - Hi there i want to extract data from XML string based on certain criteria My xml is as follows: declare @DataSheetXML xml = ' RadioStats_00 16 0 false 0 th 11 ad779x_5 ad779x_5 16 0 sixteen_bit_raw false 0 Temperature instrumentation decode_thermistor_V1 temperature Degrees […]
SQL Azure - Administration
Copy database from another with Managed Instance - Hi I have the need to programmatically create a new database as a copy of an existing one, within the same Azure Managed Instance.  I have searched for hours and cannot find a way to do it!  This need will arise frequently, hence the need to do it programmatically. I presume it has to be […]
Reporting Services
I need help with the NuGet package Microsoft.SqlServer.Types - The NuGet package Microsoft.SqlServer.Types and the Microsoft.SqlServer.Types.dll are the bane of my existence at my current job. I have struggled with them both, for at least 3 years. I've tried to contact the owners of the NuGet package on and off over the last 3 years. It has never worked; they have never replied. So, […]
General
The Best of SQLServerCentral.com ebook broken links - Hi all, the links to the aforementioned ebook seems to be broken:( I would appreciate if anyone could help me on my way to finding these awesome resources - any of them, particularly the earlier ones, as I am new!
 

 

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

 

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