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

Degree Apprenticeships

I enjoyed my time in college, and I learned a great deal. While I do think that the time helped me grow, I also recognize that I was always a good student and the cost of my working through that degree was far below what today's degrees cost at many universities (even accounting for inflation). What's more, I worked most of the time I was at university to pay for my living expenses.

These days I am torn on the value of a degree, especially when the total cost can easily exceed USD$50,000. Even more concerning is the fact that many people have to drop out with substantial debt and no degree. That's the worst of both worlds. While it's easy to point the finger at people for not finishing or working harder, it ignores the challenges of the real world, which can throw curve balls at all of us.

For a lot of my college time, I had to work to support myself because I didn't have enough scholarship funding, and I was worried about loans. I was worried about post-college, and in the 80s, I was able to work 30+ hours a week and earn enough to pay rent and buy food. Later in my time, I was able to secure an internship that paid me, which was nice. Then I wasn't spending 80+ hours a week trying to learn and support myself.

I saw a note recently about degree apprenticeships from Purple Frog Systems. The idea is that someone is part-time in university while working for an employer. This might require more than 40 hours a week of combined work, but I like the idea of someone learning about both the academic and practical views of an industry and getting mentorship from both co-workers and academics.

While many of us who work for an organization might get tuition assistance, it's not always easy to work out school and work. Managers may or may not work with you, and there isn't really continuous support to help you complete your degree. The quality of your manager often determines if this works. However, the bigger issue is that many people struggle to find jobs in the first place and not many organizations I've worked for have any programs to find people who might be suited for an apprenticeship program.

I don't that our industry, or many industries, really need to require degrees. That being said, I do think there are things universities teach well, and they give a good perspective on a variety of topics. Employers can benefit from motivated individuals who learn their business, learn different skills in school, and bring about energy and fresh perspectives. Plus, employers learn how to train and grow new people at a lower cost. We all struggle to hire well and train people to be effective quickly. Working with interns or apprentices is a good way to embed regular mentorship and training into the culture of your company. That's something everyone can benefit from.

I hope to see more apprenticeships in the future, not just in technology (or marketing as in the post), but in a variety of industries. I don't know if we will, but I do think this might help us get better at finding and training new staff.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Batch Execution Mode on a Rowstore in SQL Server 2022

Almighty from SQLServerCentral

Batch execution mode is a new optimization feature in SQL Server. In this Article, we'll explore how Batch execution mode works and how you can use it to get faster query results on Rowstore data.

External Article

Mastering a cloud migration: 10 video tips

Additional Articles from Redgate

If you haven’t had time to catch up on our latest full-length webinar on Cloud Migration, here’s an easy way to digest the tips from our experts in less than 20 minutes!

External Article

Improve Query Performance when SQL Server Ignores Nonclustered Index

Additional Articles from MSSQLTips.com

In this article, we look at why SQL Server may not use a non-clustered index over the clustered index and what you can do to improve performance.

Blog Post

From the SQL Server Central Blogs - T-SQL Tuesday 167 – Encryption and Data Protection Roundup

Matthew McGiffen from Matthew McGiffen DBA

Huge thanks to everyone who responded to my invitation to blog on Encryption and Data Protection for this month’s T-SQL Tuesday. I got what I hoped for, which was...

Blog Post

From the SQL Server Central Blogs - Fabulous Stuff in Fabric – Part 1: Cloning Tables

Koen Verbeeck from Koen Verbeeck

A while ago I had a little blog post series about cool stuff in Snowflake. I’m starting up a similar series, but this time for Microsoft Fabric. I’m not...

Azure SQL Revealed

Azure SQL Revealed: A Guide to the Cloud for SQL Server

Site Owners from SQLServerCentral

Access detailed content and examples on Azure SQL, a set of cloud services that allows for SQL Server to be deployed in the cloud. This book teaches the fundamentals of deployment, configuration, security, performance, and availability of Azure SQL from the perspective of these same tasks and capabilities in SQL Server. This distinct approach makes this book an ideal learning platform for readers familiar with SQL Server on-premises who want to migrate their skills toward providing cloud solutions to an enterprise market that is increasingly cloud-focused.

 

 Question of the Day

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

 

Parsing Strings

What is returned by this code?
SELECT PARSENAME('a.b.c.d.e', 2)

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)

Adding a FK in a CREATE TABLE

I want to create a table with a self-referencing FK. Can I do this in one CREATE TABLE statement or do I need an ALTER TABLE to add the FK?

Answer: Yes, in all cases

Explanation: This code is valid, so you can define a self-referencing FK in the CREATE statement.

CREATE TABLE Employee
(EmpID INT NOT NULL CONSTRAINT EmployeePK PRIMARY KEY
, EmpName VARCHAR(20)
, MgrID INT,
CONSTRAINT FK_Mgr_Emp FOREIGN KEY (MgrID) REFERENCES dbo.Employee (EmpID)
)
GO

Ref: FK Contstraints - https://learn.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql?view=sql-server-ver16#foreign-key-constraints

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
Can’t return role based on employee no from three columns? - I need to write a SQL Server query return only one role from table dbo.F6000059 based on employee no, but I face issue I don't know how to return the correct role. I will return only one role from table dbo.F6000059 if "employee no" exists in columns REAN82 or REAN83 or REAN84. And role name will return will be only one roles from below […]
SQL Server 2016 - Development and T-SQL
Delete large number of rows help - I have a batch process where i have to delete around 75 MIL rows out of 1.3 Billion rows table.  And then insert the new rows back. I have been told that there is no way to do incremental load on these. I believe the DELETE operation is taking very long (2-3 hours). Database is […]
SQL 2012 - General
how to calculate the RAM used while running a query - how to calculate the RAM used while running a query
SQL Server 2012 - T-SQL
Adding records between records - Hi, Trying to figure out how to approach this... I will have data where these is an ID and a date. I want to add  records  between the two dates Max up to 6 days between the actual dates. example DATA: ID, SomeDate, Flag 3642570, 2023-09-01 00:00:00.000, X 3642570, 2023-09-06 00:00:00.000, X 3642570, 2023-09-13 00:00:00.000, […]
SQL Server 2019 - Administration
How to enable Always Encryption in SQL Server Agent Jobs - I am trying to run a SQL Agent job to select an encrypted column, but it's still shows as encrypted. How can I run SQL agent job to run with Always Encryption enabled.
SQL SSIS job failing with out of memory error - Hi All, Most of the time SQL SSIS job failing with out of memory error. The package are hosted in SSIS catalog. My question is - Will SSIS & SSAS use memory within SQL max and min memory (or) out of SQL server? I have SQL SSIS, SSAS & two instance of DB engine. I […]
Ola IndexOptimize - USER_DATABASES failed - EXECUTE [dbo].[IndexOptimize] @Databases = 'USER_DATABASES', @LogToTable = 'Y' Job Name                            IndexOptimize - USER_DATABASES Step Name                          IndexOptimize - USER_DATABASES Duration                              01:00:14 Sql Severity        16 Sql Message ID  50000 Operator Emailed Operator Net sent Operator Paged Retries Attempted          0   Message Executed as user: NT SERVICE\SQLSERVERAGENT. ...0)  Server: SERVER1 [SQLSTATE 01000] (Message 50000)  Version: 15.0.4316.3 [SQLSTATE 01000] […]
Ola IndexOptimize - USER_DATABASES failed - EXECUTE [dbo].[IndexOptimize] @Databases = 'USER_DATABASES', @LogToTable = 'Y' Job Name                            IndexOptimize - USER_DATABASES Step Name                          IndexOptimize - USER_DATABASES Duration                              01:00:14 Sql Severity        16 Sql Message ID  50000 Operator Emailed Operator Net sent Operator Paged Retries Attempted          0   Message Executed as user: NT SERVICE\SQLSERVERAGENT. ...0)  Server: SERVERABC [SQLSTATE 01000] (Message 50000)  Version: 15.0.4316.3 [SQLSTATE 01000] […]
Expand disk size for SQL 2019 High Avalability Group - Hi, Due to the data growth, we have to increase the disk size where the data files resides. Our SQL 2019 high availability group is running in VMWare v.7. 2 nodes. Do I right click the VM, Edit Settings, then increase the disk size, then expand it in disk manager? I assume I have to […]
KB5029375 - SQL Server 2017 GDR - I have been trying, on and off, to install the latest CU/GDRs on test servers since Friday by obtaining the updates from: Latest updates and version history for SQL Server - SQL Server | Microsoft Learn I have had no problem with SQL2019 CU23 or the SQL2016 GDR. I cannot get the SQL2017 GDR to […]
SQL Server 2008 - General
MSSqlServer 10.50.6000.34 Event-ID 18456 LoginError - Hi Experts, how can I fix this error NT-AUTHORITY\SYSTEM Cause: Error opening the explicitly specified database. [CLIENT: ] Thank  you, Stephan
MSSqlServer 10.50.6000.34 Event-ID 18456 LoginError - Dear Experts, Nothing special, just an annoying returning entry in Windows-Event- Protocol. => SQL Server 2008 However, the Event viewer is throwing permanently an error: Error logging in for the user 'NT-AUTHORITY\SYSTEM'. Cause: Error opening the explicitly specified database. [CLIENT: ] - System - Provider [ Name] MSSQLSERVER - EventID 18456 [ Qualifiers] 49152 […]
SSRS 2016
100% stack bar chart with periods and time axis - Hello, I am trying to develop a report that would display periods of time (segments) on time axis and grouped by equipment, like below: Colored bars are segments (Duration in seconds). On X-Axis i would like to display time. But as long as i am using X-Axis as a default 1-100 i can see segments, […]
Integration Services
Trouble Upgrading SSIS Project and Packages from Targeting SQL 2014 to 2022 - Taking an existing Visual Studio SSIS Project that targets SQL Server 2014 to now target SQL Server 2022 through the suggested course of the "Upgrade All Packages" has been unsuccessful. The reason being was we were trying to avoid having to recreate the project and packages from scratch. We are using Visual Studio 2019 version […]
SQL Server 2022 - Development
Extract file in zip format - Good afternoon, Devs. My name is André, and I'm new here. I'd like to ask for your assistance with a problem I'm currently facing. I've taken over the migration of an application where the database is in SQL Server, and there's a table containing files stored in a column of type "ntext." According to the […]
 

 

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

 

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