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

Daily Coping Tip

Challenge negative thoughts. Find an alternative interpretation

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.

Share Your Mistakes

I wrote the other day about a culture of allowing mistakes. We know they are going to happen, so we ought to accept them. Even stupid ones. I make them at times, my wife does, my kid does, so I have been working to not get upset and emotional about them. Instead, hold someone accountable, let them fix things, and try to do better in the future. It's what I'd want, and what I am trying to do with my family, friends, kids I coach, and others.

Many of us share knowledge and information. One of the reasons I love events like SQL Saturday is that others share their knowledge. I especially appreciate is when someone shares a solution and how or why they build it. Hearing their stories, the reasons for their decisions, and what works well is great. I learn in a similar way from blogs, which is why we syndicate blogs at SQL Server Central and include them in the newsletter.

By the way, if you have a blog and want to syndicate it (full feeds, please), contact the webmaster or submit an article.

We want to share knowledge, but we should also remember to share mistakes. We make wrong turns, and sometimes others might not take our advice because we recommend them. Instead, they might go down the same wrong path as we did previously. They might make the same mistake we did. Sharing and showing how a decision didn't work well can be a powerful and valuable story. We all respond well when we empathize, and most of us can empathize with a mistake.

Almost every interview I've been in has asked me about a mistake, misstep, or other error that I've corrected or learned from. Usually, there is some variation on "tell me about a difficult situation" that you need a story about. In a technical interview, this might be based on a programming or database administration problem. In other interviews, this might require you to think about interactions with others.

In any case, I encourage you to keep stories handy for interviews or reviews. I'd certainly also suggest that you blog about them. Writing is a valuable communication skill we all need, especially in these days of mostly remote interactions. Practice, get better at presenting your thoughts, and learn to share stories that will help others in their journey to be a better professional.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Establishing a Connection to PostgreSQL with GoLang

sabyda from SQLServerCentral

Learn how to use golang to connect to a PostgreSQL database.

External Article

Power BI - How to Download and Get Started

Additional Articles from MSSQLTips.com

In this article learn how to download, install and get started building your first Power BI report using SQL Server data.

Technical Article

Columnstore Indexes are Finally Sorted in SQL Server 2022

Additional Articles from SQLServerCentral

There’s a widespread misconception that SQL Server’s columnstore indexes are like an index on every column.

Blog Post

From the SQL Server Central Blogs - Register as a Pre-Con Speaker

Steve Jones - SSC Editor from The Voice of the DBA

I’ve been debating how we better organize speaker resources and one of the things I proposed was a pre-con registry of speakers. I did so at the sqlsaturday blog....

Blog Post

From the SQL Server Central Blogs - SQLServerCarpenter Tools

Brahmanand Shukla from SQL Server Carpenter

Over the past couple of years, I’ve developed several tools that I’ve been using during my Performance Tuning and other related assignments. I thought to share it with the...

 

 Question of the Day

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

 

Quantums

The time a worker can remain active in a scheduler is called the OS quantum. What is the maximum length of time for a quantum?

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)

Restoring a Certificate

I use the BACKUP CERTIFICATE command to back up a certificate from my SQL Server 2019 instance to a file. I want to restore this on another instance. What command do I use?

Answer: CREATE CERTIFICATE, LOAD CERTIFCIATE

Explanation: The CREATE CERTIFICTE command is used to restore a certificate from a file onto an instance. Ref: CREATE CERTIFICATE - https://docs.microsoft.com/en-us/sql/t-sql/statements/create-certificate-transact-sql?view=sql-server-ver16

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
Left Join with reference data. - Records Refrenace | DataMaster DataKey 1 A | A 22 2 B | B 33 3 C | C 44 4 E | 5 F | 6 G | 7 H | 8 D | 9 R | For the Above which is not in the Master data I need to set it as 'Unknown' […]
SQL Server 2016 - Development and T-SQL
Left JOIN Works Appears to Only Work with Certain Table - Hello Community, If I execute the following query on table name optionsettransposedall_copy: SELECT C1.Id ,C1.SinkCreatedOn ,C1.SinkModifiedOn ,C1.statecode ,C1.statuscode, CASE WHEN ISNULL(CAST(C1.prioritycode AS VARCHAR(50)),'') <> ISNULL(CAST(C2.prioritycode AS VARCHAR(50)),'') THEN CAST(C2.prioritycode AS VARCHAR(50)) ELSE CAST(C1.prioritycode AS VARCHAR(50)) END AS prioritycode FROM ( SELECT *,ROW_NUMBER()OVER(ORDER BY prioritycode)RowNum FROM appointment )C1 LEFT JOIN ( SELECT *,ROW_NUMBER()OVER(ORDER BY prioritycode)RowNum FROM […]
Administration - SQL Server 2014
Sudden rise in memory - Hi How i can check which process was run that Sql memory suddenly increased. Thanks
Development - SQL Server 2014
SSRS Rendering format Excel Change ? - I was wondering if anyone knew how I can change the Excel rendering format in the reportserverconfig file so the default cell format is text and not General. If not, is there any way to format my fields in the stored procedure so when I download to Excel it formats as text? Thanks
SQL 2012 - General
Urgent help needed. MS SQL Server 2012 - Hi, I've just got a call (6pm on a Friday!) from a customer who has had his line-of-business application provider sell him a solution which required SQL Server 2012 Standard, yet the supplier (joyfully) installed the evaluation version of SQL Server 2012 Enterprise. This has now ticked over and expired. My problem is that (a) […]
Merge Replication or Back up and Restore - Hello I have a database copied on two servers. Same name. I have tried a merge replication but it keeps failing on various objects. I have removed objects one by one and left with the bare minimum tables and still won't work. Users won't mind using one database as master and do all the updates […]
SQL Server 2019 - Administration
Extending High Availability Group into Azure - Hi  I've been asked to extend a HAG which is currently on premise to include an azure vm sql instance. currently i have a 3 node cluster, two nodes in on city with synchronous connect and auto  failover  and one in another city with asynchronous connect and manual failover. I want to add an azure […]
Intermittent Witness Failures - Hi guys, Any one experienced in working in GCP with SQL Clusters? My File Share Witness intermittently failing but I cannot work would why. It will be in failed state and then I'll bring it online and its fine for a while before going off again. Below the the only error I can fine. I […]
SQL Server 2019 - Development
Return data from a calendar table with associated active events - Hello, Thanks if you can help. I am trying to build a view that returns all calendar data for a date range and any associated events if the event is active on that day. I am getting error "An aggregate cannot appear in an ON clause unless it is in a subquery contained in a […]
Calendar table in SQL - Hi guys Could you please help me to build a calendar in SQL, with the normal holidays from Portugal. Is this possible? Or....is there any chance of getting the holidays from Portugal for a specific year (2019-2022). I looked everywhere but i must be looking the wrong places.... Thank you all very much for helping […]
Amazon AWS and other cloud vendors
Possible to use SCP’s to enforce readonly console access? - We wanna foster a culture where all changes and deployments happen through CICD, hence we dont want to allow our users to have any write permissions when using the console. Alternatively we could probably enforce it using permission boundaries on all users/roles, but SCPs would be so much easier to manage. Anyone who have done […]
General Cloud Computing Questions
Could an API reduce latency vs a Direct Cloud Database Connection? - Recently, a potential client at work has requested that we provide an API in the cloud as opposed to a direct database connection for a cloud database. The application we’re developing is a Desktop application that will require a significant number of queries throughout the day. In the past, when clients have tried to move […]
Reporting Services
Can I filter a table based on parameter IIF statement, otherwise no filter? - Hello! I have a dataset that has daily stats with days specified as Weekend/Weekday, and I have a parameter ("@Daygroup") to represent this. I'd like the report users to be able to filter the data by this field, but also have the option of viewing everything/both.  Currently, it's inside a table in which I've only […]
Integration Services
Replace function in SSIS Expression - hi, I have files that are coming in .txt files. Example  MA.textfile1.txt ,MA.textfile2.TXT . I need to replace the file name after i process these files. I have a foreach loop to get the file names , and file system task to rename files. However i have set up variables within file system task, if […]
Anything that is NOT about SQL!
Web site font colour/background colour and readability - Hi everyone I'm just interested in getting peoples about the readability of many web sites as far as the general words in sentences (not headings). Maybe it's my imagination, but it seems to me that there seems to be a tendency for there to be a lack of contrast these days between the font colour […]
 

 

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

 

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