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

Daily Coping Tip

Look for something positive to say to everyone you speak to

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.

The End of Year Career Evaluation

This month's T-SQL Tuesday invitation asked about end-of-year operations that you might take on your databases. I don't know how many of you follow any specific end-of-year routine, but you may.

However, that got me thinking about an end-of-year career evaluation. It's not something I've done, but I do often look back and forward and build some career goals. That has been helpful in ensuring I do some work on my career each year, even though I'm much closer to the end than the beginning.

If I were younger, I would look at my career in three ways: what I need to learn, what I want to accomplish, and how to move toward my goals. I'm actually going to tackle these three areas myself, but since we're near the end of the year, these might be things you think about as well.

Technology changes so much, and we are often challenged by new requests, requirements, or circumstances to work with new software. I think the cloud has spurred this on, and as a result, I expect most people find they need to learn things constantly. Having a plan, and keeping a list of the technology is a good way to capture the entire bundle of challenges you face. Whenever someone asks you about something new, or you hear in a review that you should improve, add those things to your list. It's likely you'll never get to them all, and certainly, you won't be an expert in them, but you can develop lots of competence and fluency in different areas.

The second thing to look at is how to take this big list of skills, languages, software, etc. and prioritize it. Cut the list down to something manageable this year. Or maybe just this quarter. Being organized can help you deal with the overwhelming number of items on your big list. In this stage, I'd order things by what's interesting to you. This might be an understanding of YAML to update pipelines as code. It might be solving some types of complex queries in SQL that you struggle with. It might be learning to better express yourself clearly and succinctly in email. List the things you need to work on.

This isn't easy, and this is really a prioritization of what is most important to you. You might talk with co-workers, your boss, or your partner to help decide what you can do. You should also think budget here, in terms of your time. Can you spend more than 8 hours a month on something? Carving out 2 hours a week is likely manageable, but more can be hard. Think hard about this, especially if your employer doesn't give you any time while at work.

The last evaluation should be easier. It's taking the things you are working on and building a plan to actually improve yourself. Do you need to draft better crafted emails and have people review them and give suggestions? Are you going to pick specific problems to solve in SQL? Maybe you want to tackle a specific Power BI report? All these are examples I've used myself, but you might have different things from your second list. This is the short-term plan you'll implement.

I wouldn't make this too detailed a plan, but I would include enough to guide you. Maybe this is actually spending a month of lunches on something? Or just two lunches a week? I wouldn't schedule them all out, but I'd have some specific things I need to tackle, in some order, which at least gives me a plan. I wouldn't include timelines here, but rather, what is the first thing to do, the second, and so on.

This sounds like work, and it is. That's how you move forward, and how you shape your career to be what you want. Be deliberate, make decisions that are best for you, and then execute on those decisions. That will help you find the best career and job for you.

Steve Jones - SSC Editor

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

 
  Featured Contents
Stairway to SQL Server Replication

Stairway to SQL Server Replication: Level 2 - The Role of the Distributor

Sebastian Meine from SQLServerCentral.com

In this Stairway, Sebastian will be covering the details of SQL Server transactional and merge replication, from understanding the basic terminology and methodology of setting up replication, to describing how it works and how the basic replication processes can be monitored.

External Article

Converting Data Across Time Zones: An In-Depth Primer

Additional Articles from SimpleTalk

This article dives into all the math required to convert historical times between time zones.

External Article

Executing Optional Code in Flyway Callbacks

Additional Articles from Redgate

This article demonstrates how we can use a Flyway placeholder as a simple on/off switch for each task, during Flyway migrations.

Blog Post

From the SQL Server Central Blogs - Clickable SVG images in Power BI using the HTML Content custom visual

Meagan Longoria from Data Savvy

People have done creative things with SVG measures in Power BI, ranging from KPI cards to infographics to fun games. For my latest Workout Wednesday challenge, I used SVG...

Blog Post

From the SQL Server Central Blogs - Recommended Approach to Encryption in SQL Server

Matthew McGiffen from Matthew McGiffen DBA

We looked earlier at the various places our data lives – on disk, in memory, in-transit across the network. A good strategy will protect all of these locations –...

 

  Question of the Day

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

 

The Invalid Synonym

Can I create a synonym for an object that doesn't exist? I have this code. Does it work?
CREATE TABLE dbo.NewTable (myid INT) GO DROP TABLE dbo.NewTable GO CREATE SYNONYM MyNewTable FOR dbo.NewTable GO 

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)

SWITCHOFFSET()

The SWITCHOFFSET function will help you change a datetimeoffset value to a new time zone with a second parameter. What does the second parameter represent?

Answer: The number of minutes to move the datetimeoffset.

Explanation: The second parameter is the number of minutes to move. Ref: SWITCHOFFSET - https://learn.microsoft.com/en-us/sql/t-sql/functions/switchoffset-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 - Administration
SQL Server database monitoring tool. - Hi Expertise, Kindly suggest  SQL Server database Centralize monitoring tools with historical reports for all target DB Servers ON-Prime and CLOUD based setup. Thanks  
Why are the logical reads appearing in IO STATISTICS even after cleaning Cache - Hello, I am trying to understand the output of IO STATISTICS . I run some queries like as bellow : DBCC FREEPROCCACHE DBCC DROPCLEANBUFFERS SET STATISTICS TIME ON SET STATISTICS IO ON SELECT * FROM [HumanResources].[Employee] SET STATISTICS TIME OFF SET STATISTICS IO OFF The output is SQL Server Execution Times: CPU time = 0 […]
SQL Server 2017 - Development
A question about unique keys - I've been away from SQL Server for a number of years. Years ago what I am asking could not be done.  I assume that it still can't be done, but rather than make an assumption I thought that I should ask. Below is a completely fictitious example, but it illustrates my question. Supposing that I […]
SQL Server 2016 - Development and T-SQL
For Each Loop Query (SSIS) -   In above screenshot can anyone tell me how can I enter value of "Files" field as expression?
calculate 12 months of data from a given date from a user - I have a query that it seems to be off dont know what wrong but I need to show last 12 months of data based off a user input for a date. my query is this. My results show different in SSRS. /*Declare @Date as Date = '11/1/2022' Declare @prop as int = 8000 --*/SELECT […]
calculate 12 months of data from a given date from a user - I have a query that it seems to be off dont know what wrong but I need to show last 12 months of data based off a user input for a date. my query is this. My results show different in SSRS. /*Declare @Date as Date = '11/1/2022' Declare @prop as int = 8000 --*/ […]
Administration - SQL Server 2014
Parallel Execution Plan - Or not. - Hello. SQL Server 2014 - 3 Numa Nodes - 6 processors in each Numa Node (not that is not the issue) - MAXDOP = 6. I have been running some testing with Substring Queries (LIKE) vs FTS Catalog (CONTAINS) Search and experimenting with CHARINDEX and COLLATION (Binary). As part of the testing with CHARINDEX and […]
Error on File - Hi Experts, I have a database with multiple files on multiple drives and one of the drive is restricted to a defined size. Now because the index maintenance job is failing with below error. How can I rectify this without increase the disk space.   Could not allocate space for object 'dbo.Table1'.'PK_Table1_ID' in database 'DB1' […]
how to check the table is being used(selecting/inserting/updating/deleting/locki - how to check the table is being used(selecting/inserting/updating/deleting/locking) by some sql statement? many thanks!
SQL Azure - Development
Azure DevOps and branches - Hi all   Firstly, full disclosure, we're only getting started with this so late to the party (and complete novices).   Tools we're using (not just for DevOps):- SQL Clone SQL Compare SQL Prompt SSMS (V18)   We're just getting started with Clone and found it to be very useful. The bit that's not so […]
Azure Data Factory
Please help , how to write data in data lake ? - I want to read data from json file and write in a data lake by azure data factory, so can anyone tell me the procedure I am new to data engg field, Thanks in advance
Upskill Azure Data Factory knowledge - Hey guys, I'm a DE with of 2 experience and I've been working with Azure Data Factory as the main ETL tool for 6 months now. However, I feel I need to gather more knowledge and assume more responsibilities inside my team but most of the senior professionals don't have much time to teach me. […]
SQL Server 2022 - Development
Using SQL - Convert column to rows - not a straight forward pivot - Hello All, I have below sample table. Code is also included. create table Trade_test (portfoliocode nvarchar(10), tradedate varchar(10), tradeamount varchar(10) ); insert into Trade_test values('A','01012021','100') insert into Trade_test values('A','01012022','1000') insert into Trade_test values('B','01012018','100') insert into Trade_test values('C','01012019','100') I need to pivot the data to have below output. I have tried few things but not getting […]
What's the logic of the NOT IN clause? - I thought I understood the "NOT IN" logic very well until I run into a case where the presence of NULL values affects the result in a way I was not expecting. The setup is super simple: CREATE TABLE A1(ID1 INT); CREATE TABLE A2(ID2 INT); INSERT INTO A1(ID1) VALUES (1), (2), (NULL); INSERT INTO A2(ID2) […]
Struggle Bus - Varbinary(max) Performance Suggestions? - I have a very large table I am dealing with that has a varbinary(max) column.  I have a Order By that is extremely slow on this field and also I have a Convert as well to a NVARCHAR(MAX) but even without the convert it is slow.  How can I somehow increase the performance on this […]
 

 

RSS FeedTwitter

This email has been sent to newsletter@newslettercollector.com. 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

 

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