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

Daily Coping Tip

Bring to mind people you care about and send love to them

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.

Imposter or Student

If you're moving forward in your career, you're a bit of an imposter. Actually, according to David Perell, everyone is an impostor. Many of the very successful people in technology built things that they knew nothing about. They learned technology, business, sales, and more on their way to success.

I posted a note about the video above, and someone suggested that we are students instead. The negative connotation of an impostor, someone that deliberately fakes their knowledge is something that bothers many. I get that, and I do understand the desire to disclose what you know and what you don't.

We need to be lifelong students in the technology business, and maybe even in many other fields. The platforms on which we work, the tools we use, they do change. More importantly, the underlying technology we use might suddenly change as our employers shift directions or management moves in a new direction.

While it's useful to adopt the mindset of being a student, there are plenty of times when we are asked to work with something we don't understand. Others may assume we know something and look to us to lead the way or solve problems. While we may protest or let them know that we are learning, we are still expected to produce some results.

When I coach kids, we often tell them to "fake it until they make it." They are learning new skills and sometimes don't do well, but it is important to project an air of confidence, to believe that you will soon learn the skill. That mental projection of your future is important, and it instills confidence. I wouldn't underestimate the importance of believing in yourself, even when you lack some ability.

When you tackle something new, do you consider yourself an impostor or student? Either way, I hope you dive into the tasks with enthusiasm and confidence.

Steve Jones - SSC Editor

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

 
 Featured Contents

Keep Column Headers Visible in SSRS

Ginger Keys Daniel from SQLServerCentral.com

Keep column headers visible while scrolling down the page of SSRS reports.

Recruiting DBAs for DevOps

Additional Articles from SimpleTalk

DBAs are in great demand, but what if you are recruiting a DBA for DevOps? Mike Cuppett explains how to hire and train the right DBA for the job.

From the SQL Server Central Blogs - Azure SQL Database – Contained user Model

BLOB EATER from All About SQL

I always follow a contained user model when setting up users within my Azure SQL Database. I do this so the user in question has access to only specific...

From the SQL Server Central Blogs - Logging Messages with Raiserror – #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. I recently ran across some people discussing how...

 

 Question of the Day

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

 

The Git Default Branch

How can I set the default branch for my local git (v2.28) software to main?

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)

Getting the SQL Connections

I want to get a count of the connections to my SQL Server 2019 instance in T-SQL. Which of these work?

Answer: Querying sys.dm_os_performance_counters or sys.dm_exec_connections

Explanation: You have a number of options, but both sys.dm_exec_connections and sys.dm_os_performance_counters can get you a count. 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 - Administration
Stopping the SQL Server Agent before a datacenter shutdown - I have read different opinions on whether to manually shut off the SQL Agent service before shutting down a SQL instance for 2 days; some believe the server being off is perfectly fine, and others have said to manually stop the Agent and manually start when the server/instance is turned back on. To me the […]
SQL Server 2017 Dev Certificate error - Error Message attempting to download data from my SQL Server 2017 dev edition. 0 - The certificate chain was issued by an authority that is not trusted. I've tried so many suggestions and it's probably because I'm not a certificate expert. So. Two questions. As a person with limited DBA experience with advanced settings, how […]
SQL Server 2016 - Administration
Removing Stopped Databases - Greetings all,  first post.... In doing backups with our Cohesity system it reports errors with a few databases which lead me to investigate the cause.  Basically these are stopped databases on the Microsoft Server 2016 / MSSQL 2016 server systems.  The SQL Configuration Managers shows them as stopped.  These particular databases were moved to other […]
SSRS - Object reference not set to an instance of an object -     Hi All SQL Server version: 2016 SP2 CU13 I have one particular report that keeps giving me the error below....All other reports work just fine. An unexpected error occurred in Report Processing. (rsInternalError) Object reference not set to an instance of an object. According to the Execution log, the report ran last a […]
SQL Server 2016 - Development and T-SQL
Empty Index Statistics object - This is a new thread but relates directly to Index statistic is empty - how is this possible? My post in that thread and for background " I too am on SQL2016 CU15 , db in Compatibility mode 2012.  In the past four months we have had three occurrences of this problem. We are truncating […]
Transactions - Hi, Can you please let me know what is the benefit of using the 'SET IMPLICIT_TRANSACTIONS ON' in the below code when we already have 'BEGIN TRAIN' which can be used to rollback if any error occurs? So, I see IMPLICIT is also being used sometimes, not sure what is the benefit when we already […]
Development - SQL Server 2014
Index on View - Dear Group: I was going to create an index on a view we have, but I am getting the following error:  "Cannot create index on view '' because the view is not schema bound." I Googled this and found that the issue is that we need to create the view using SchemaBinding like the following:  […]
Calling a Function to Update Temp Table - Hello, I have created a function that will determine the Distance between 2 sets of Lat and Log Coordinates.  The function is working as desired.  As a next step, what I would like to do next is record the difference in miles into my temp table. I am attempting is to call the Function within […]
SQL 2012 - General
How to get PartId from table #trades that have wrong Code ON Code Value To when - How to get PartId from table #trades that have wrong Code ON Code Value To when code type from and code value from Exist ? How to get PartId from table #trades that have wrong Code ON Code Value To when code type from and code value from Exist ? I work on SQL server […]
SQL Server 2019 - Administration
SSRS report download fails - Hi. I am trying to download a report from SSRS 2019 in word format and fails with error as below: An error occurred during rendering of the report. (rrRenderingError) The type initializer for 'MS.Utility.EventTrace' threw an exception. Requested registry access is not allowed. Same case with Excel. Only PDF works. The cases when I am […]
Importing text file issue - Hi, I am trying to import the attached REF_RF1MAS.txt file but am getting numerous bulk load errors. I was given the attached A_spec that is supposedly the import specs but it does not seem correct. I tried the code below.  Any ideas on what the issue is? Thanks.   Msg 4863, Level 16, State 1, […]
SQL Server 2019 - Development
Wait for query to finish before returning results - When I do "select * from ... " from a large table, the result starts to "stream" before the query is completely done. Is there a way to prevent this? Some kind of oppositve of the "FAST" queryhint?
Many executionplans for one query, why? - I've yet to find an answer for this. I've found a few queries that have a few executionplans. Why is that? For example, I've seen queries (in QueryStore) that has executionplans A and B (and more)... For a few days the query uses A and then goes back to B, and then back to A […]
Reporting Services
SSRS Dynamic columns for different Year groups - Hi,   I have sample data, please can someone help me create the output based on the following data? So asically in SSRS when year 6 is selected it should populate the output below for Year 6, Year 7 populate the output for Year 7.   CREATE TABLE Data ( StudentId int, intYear int, ,subject […]
History Snapshots - Bulk create for many reports - Hi guys, just found the History Snapshot Option within SSRS. Do you know if there is a way to create a schedule that will be used by every report. E.G. I want to take a history snapshot of every report with a retention of 24 hours. Then the snapshot should be deleted. Maybe you can […]
 

 

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

 

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