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

The Learning Plan for 2025

I saw a post from Brent Ozar a couple of months ago promoting his Black Friday sale, which is really a Month-of-November-Training-Sale. I like that he does this, as I know it can take time to get purchases approved and not many techies want to spend a few thousand USD in hopes their company will reimburse them. Redgate likely would for me, but I don't know many other employers that would reimburse the expense without prior approval.

In the post, Brent outlines how you might spend your year working through his courses, learning more about various aspects of SQL Server. He plans out 11 months (Dec-Oct), and it's a good flow going from understanding how things work to more advanced work in different areas. I've been in a few of his classes and I honestly think you might easily need a month if not 2-3 months to get through the various modules, practice using them, and cement in a few skills along the way.

That's around the rest of the things in your life. You do need to live your life, right? It's not just work and training for work?

I used to make a plan every Dec/Jan for the year, with some goals for learning and growing. I gave up a few years ago because I found the nature of my job meant my plan was likely not appropriate after March. Even going to quarterly goals was hard, as travel became a bit chaotic for me.

As much as I like to set an example, for someone in their 50s with a busy job, the reality is I don't know where my job takes me year to year, so planning is really hard. Plus, I find myself focusing on different aspects of technology or software sales as challenges arise. While I'm trying to work on my career, it's more tactical in the sense that I worry about new things in Redgate month to month that can help me in my position.

However, for many of you, you have a job that you know the parameters of, you know what types of things you'll be asked to do, and more importantly, you know which of those things you were asked to do in the past, but struggled to get done at an expert level.

In that case, have you made a learning plan? Are you setting aside time most (or every) week to further your career? If you're young and single or married without kids, you definitely should spend time every week on your career. Doctors, lawyers, CPAs, and engineers have dedicated education requirements in their jobs, and they spend time on their careers. You ought to aim for at least a 3-4 hour a week commitment to yourself.

If you have young kids, time is precious. While you might take a few years off, my view was that when my kids were 4-5, I could take some time to grow my career. In the those toddler/young schoolage years, this might only be an hour or two a week, but it should be something. As your kids grow, you can spend a bit more time.

If you've got older kids, now is the time when you can prove you're worth a higher salary. Dive deep into tech and show that you're an expert. If your current employer doesn't want to pay you, I'm sure someone will. While there are lots of people looking for jobs, and lots of unfilled positions, employers aren't just hiring unless they are convinced someone really adds value. Learn to do this and you'll have a fun, enjoyable twilight to your career.

Think about your learning plan for 2025 and if you want to share, we'd love to hear it.

Steve Jones - SSC Editor

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

 
 
 Featured Contents
SQLServerCentral Article

Leveraging the “STUFF” Function for Enhanced Data Representation and String Manipulation 

Ganesh Gopal Masti Jayaram from SQLServerCentral

Learn the basics of the T-SQL STUFF command.

Technical Article

Improved RCSI Ghost Cleanup in SQL Server 2022

Additional Articles from SQLServerCentral

An example of poor update performance under RCSI as compared with locking read committed. Details of an improvement in SQL Server 2022 that can help avoid the worst effects.

Blog Post

From the SQL Server Central Blogs - Database Build Error – Incorrect syntax near DISTINCT

Koen Verbeeck from Koen Verbeeck

I wrote a piece of SQL that had some new T-SQL syntax in it: IS DISTINCT FROM. This predicate checks if two expressions are equal taking NULL into account....

Blog Post

From the SQL Server Central Blogs - Introduction to OpenAI and LLMs – Part 2

James Serra from James Serra's Blog

My previous blog post on this topic was Introduction to OpenAI and LLMs, the “what” part (what is OpenAI and LLM), and this blog post will talk about the...

The Phoenix Project

The Phoenix Project: A Graphic Novel about IT, DevOps, and Helping Your Business Win

Site Owners from SQLServerCentral

Adapted from the acclaimed bestselling book, The Phoenix Project Graphic Novel Volume 1 introduces readers to a stalwart cast of characters as they are challenged by the four types of work that impact complex workflows.

 

 Question of the Day

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

 

Quiesce

What does it mean to quiesce a system?

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)

The Oldest Article

What's the oldest article on SQL Server Central (take a guess)?

Answer: It's a tie, there are 3 articles from Apr 18, 2001

Explanation: It's actually a tie. I'm sure the first articles were actually published in Mar 2001, but we ported over some articles from a previous site where Andy, Brian, Steve, and the other co-founders had written and published their works. Ref: Oldest articles - https://www.sqlservercentral.com/articles/page/1434

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 2016 - Administration
Backup issues - I''m running a stripped backup (2 files) to a Network share. It's a 32gig machine in which 10gig free and has 4 cpu's .. Cpu % around 50%. I'm using compression and it's creating those 2 files 340gig each runs for about 10 minutes then fails. I have plenty of space on the network share. […]
Tempdb is filling due to background process. - I have it narrowed down to which session id is causing the issue, but that session is a background session with a command of "DB Startup"... I just cycled the instance less than a week ago due to the same issue, and I don't want to do it again without understanding why. DB is part […]
Development - SQL Server 2014
How can I tell which action happened from the UPDATE or INSERT in my SP? - I have the following Stored Procedure that attempts to UPDATE a table, and if there is no corresponding record INSERTS one. How do I indicate which case happened? GO /****** Object:  StoredProcedure [dbo].[insupd_tblMRBHistory]    Script Date: 2024-12-17 9:27:52 AM ******/SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[insupd_tblMRBHistory] (@BusinessUnit char(30) ,@PartNum char(25) ,@Description […]
SQL Server 2019 - Administration
Moving DB to new drive - Hi everyone I am planning on buying a new SSD to store my SS DB.  I plan to leave the actual SS on the old drive and just move the DB to the new drive.  I found the steps to do this online: https://learn.microsoft.com/en-us/sql/relational-databases/databases/move-user-databases?view=sql-server-ver16 I have a few questions: Should I move the SS to […]
Filter a SQL Server Audit with a predicate - Hi Gents, Silly question, but it's been a long time since I've done this. I need an audit of all successful and failed login attempts, so I created an Audit, but I don't want to log everything, so I added a filter: WHERE ([action_id]=(538990668)) based on https://techcommunity.microsoft.com/blog/sqlserver/filter-sql-server-audit-on-action-id--class-type-predicate/384140 SELECT [class_type] FROM sys.dm_audit_class_type_map WHERE [class_type_desc] = 'LOGIN'; SELECT […]
Copy a large table from one table to another - Hi, I have large table with 75 columns and 1.1 billion rows. Want to know the fastest way to copy from one table(non partitioned) to another(partitioned) table. Did anyone tried this. If yes, how long it took to load the data. I tried SSIS package with multiple threads, select- insert in batches and OPTION MAXDOP. […]
SQL Server 2019 - Development
New SSIS Package fails in Sql Agent when it includes a script component - I'm creating a new SSIS package using VS2022 to target Sql Server 2019 server. I have ended up with a new, very basic package that contains a script component to use C# only. This simple package will execute in VS2022 without errors. I have made no changes to the script and no code. When I […]
Aggregate Data to New Table - Hi , I am using webedition of 2019 MSSQL on AWS. I don't have SSAS or other license . I have a big table that is growing and part of active read and DML operations. I have a stored proc that is applying SUM and count on few columns. as this table has data for […]
how to generalize the LAG function so it keeps looking until a value is found? - Hi everyone There are situations where a value for a particular day is NULL so I use the previous day's value hoping it isn't NULL.  I use LAG for this.  The problem is that sometimes even the previous value is NULL so I have to use LAG(2) to get the 2nd previous value.  This approach […]
How to speed up this query? - Hi everyone I have a query that is taking a real long time.  It takes close to 30 minutes to process about 14 million records.  Is there any way to speed it up? Query: DROP TABLE IF EXISTS #TestTable DROP TABLE IF EXISTS #TEMP1 CREATE TABLE #TestTable ( [UNIT] [nvarchar](10) NOT NULL, [PURCHASE_DATE] [date] NOT […]
Azure Data Factory
Need ADF pipeline suggestion to copy 1 million files - I have an ADF pipeline that copies Files from source to destination. Both Source and destinations are different folders within adls only. My pipeline design is as follows   1.) Lookup activity-  A sql server Stored procedure that returns sourcepath and the destination path. This is connected to a Foreachloop 2.) Foreachloop activity - Has […]
Testing
Understanding allowed topics for testing - Hi, I am a first time writer looking to author some content here. I am in the software testing industry. Are we allowed to submit content that is not related to SQL or databases or should they all be related to databases?   Thanks, Arun
Analysis Services
Issue with IIF - I am creating a new measure in an SSAS cube and encountering an issue. The result is being displayed in an Excel pivot table sourced from the cube. Here’s the code I’m working with: MDX CREATE MEMBER CURRENTCUBE.[Measures].[New Column] AS IIF( [Date].[Month Of Year].[1] OR [Date].[Month Of Year].[2] OR [Date].[Month Of Year].[3], -- Logical condition […]
SQLServerCentral.com Website Issues
Topic marked as spam - by mistake? - I received the following notification a few hours ago. It seems legit but has been marked as spam – should it be resurrected? harrylune wrote: Do you have any advice on how to set up git repositories for the things indicated in the title? I'm particularly interested in hearing from anyone who have experience with […]
PostgreSQL
Permission issue in updating cron.job table in postgresql - I am using postgreSQL database for azure flexible server. I have enabled pg_cron extension on azure portal and created pg_cron extension on the database. I am able to see all the required tables/functions on the cron schema of postgres database. I am able to insert a cron job using cron.schedule function, since this inserts by […]
 

 

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

 

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