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

I Need a CS Degree. I Don't Need a CS Degree

For a long time I've felt that my recommendation for people wanting to enter technology wasn't to go to college and get a degree, but rather start to learn on your own and get an entry level job (help desk, tech support, etc.) and start to work in the industry. That's a good way to both experiment and understand what you're considering undertaking as a career, as well as limiting your investment. It's also nice to get paid to learn something.

College is great, but it's also expensive. I find that for many people, it can be hard to get a good ROI from college these days. The fast rising cost, not to mention the uncertain opportunities after college lead me not to recommend pursuing a CS degree, or really any degree, as a default view. There are exceptions, but for many people, I'd prefer to work and try to better understand where they should invest in education.

However.

Jerry Nixon has a great (long) post on Twitter on this topic, answering the question of whether someone should get a degree or not, mostly focused on developers and CS degrees. It's a very nuanced view that you both should and shouldn't get a degree. It really depends on what you want to do. There are cases where we might want someone to get a degree and deeply understand complex development. It's one thing to build internal web apps or design a database used by internal sales teams. It's quite another to design encryption for a military application or ensure a rocket can land on a floating platform.

Both things can be true together. You should get a degree to be a developer and you should not get a degree to be a developer, but the more detailed answer depends on where you want to work and what you want to achieve. A nice optimistic view from Jerry is that some people want to achieve something bigger than a paycheck, bettering the world with software, not to earn more, but to make life better in some way. I wish more people felt that way.

A great piece of advice from Jerry is to listen to those who you want to become, not the loudest people. I somewhat lament that so many of the very, very smart people I know or hear about are focused on tooling that generates revenue or income, and not necessarily pursuing improvements in the world. That's their choice, and I can't get upset about so many extremely capable technologists working in finance or FAANG rather than areas where they might change the world for the better. I can be though, and am, sad.

Read the post, and think deeply about what this means to you. And if you want to be a great software or database engineer, then do great things. Work hard at your craft and constantly sharpen your saw.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

A Guide to SQL Security in Django

omu from SQLServerCentral

If you encounter Django in your environment, are you thinking about SQL Injection and security? If not, read this article and learn how to protect your data.

External Article

Optimize SQL LIKE Wildcard Searches

Additional Articles from MSSQLTips.com

Learn about different ways to improve the performance of full wild card text searches to find strings in SQL Server tables.

Technical Article

PASS Summit Livestream and on-demand

Press Release from PASS

Unable to travel to Seattle this November? We have options for you to join in from the comfort of your own home or office, with a free livestream and on-demand access available to buy.

Blog Post

From the SQL Server Central Blogs - Should I Learn PostgreSQL

Steve Jones - SSC Editor from The Voice of the DBA

I got asked this question recently: I constantly see PostgreSQL on Microsoft slides, email, ads, etc. My MCADAA exam started with an entire section on it. I’m trying to...

Blog Post

From the SQL Server Central Blogs - Migrate to Azure PostgreSQL Flexible Server

hellosqlkitty from SQLKitty

I need to migrate from a single server to a flex server. Instead of doing a dump and restore, I’m going to try out the migration service that Azure provides. Single...

Deciphering Data Architectures

Deciphering Data Architectures

Additional Articles from SQLServerCentral

Data fabric, data lakehouse, and data mesh have recently appeared as viable alternatives to the modern data warehouse. These new architectures have solid benefits, but they're also surrounded by a lot of hyperbole and confusion. This practical book provides a guided tour of these architectures to help data professionals understand the pros and cons of each.

 

 Question of the Day

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

 

Incremental Statistics

I have run this on SQL Server 2022 for the Sales database:
ALTER DATABASE Sales SET AUTO_CREATE_STATISTICS ON (INCREMENTAL = ON)
I then run this in the Sales database:
USE Sales
GO
CREATE STATISTICS CustomerStats1 ON dbo.Customer (CustomerKey, EmailAddress) WITH INCREMENTAL = OFF
The dbo.Customer table is partitioned. How are statistics created?

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 LAGging NULL

I have this data in a SQL Server 2022 table:

player         yearid team HR
Alex Rodriguez 2012   NYY  18
Alex Rodriguez 2013   NYY  7
Alex Rodriguez 2014   NYY  NULL
Alex Rodriguez 2015   NYY  12
Alex Rodriguez 2016   NYY  9

If I run this code, what are the results returned in the hrgrowth column?

SELECT
  player
, yearid
, hr
, hr - LAG (hr, 1, 0) IGNORE NULLS OVER (ORDER BY yearid) AS hrgrowth
FROM dbo.playerstats;

Answer: 18, -11, NULL, 5, -3

Explanation: The results are: 18, -11, NULL, 5, -3 The LAG has a default of 0 if a null is returned, so the first value is 0. The third value is null because a NULL for 2014 subtracting anything returns NULL. The 2015 row, however, shows a 5 as the IGNORE NULLs column for LAG() ignores the NULL and goes back to the 2013 value for the LAG function. Ref: LAG - https://learn.microsoft.com/en-us/sql/t-sql/functions/lag-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 2016 - Development and T-SQL
Merge rows in SQL - I have a table like below ID Ident source val opendate closedate IsActive -------------------------------------------------------- 101 euid01 File01 x010 01-01-2023 01-01-2999 1 101 euid02 File01 x111 01-01-2023 01-01-2999 1 101 euid02 File01 x222 01-01-2023 01-10-2024 0 102 euid01 File11 x010 01-01-2023 01-01-2999 1 102 euid02 File12 x333 01-01-2023 01-01-2999 1 102 euid02 File10 x444 01-01-2023 01-10-2024 […]
Development - SQL Server 2014
How can I tell if an UPDATE command updated any rows? - I am calling an Update routine from C# and need to determine if the Update routine found a matching row to update. If it does not, I call the Insert Routine. I was hoping that if no row was updated, I would get an error which would tell me that I need to do the […]
SQL Server 2019 - Administration
It is difficult to learn Oracle. - I am a new student to learn Sql syntax. Is there any skills I need to master first?
SQL Server 2019 - Development
problem with PIVOT Table - Thanks in Advance! I'm having trouble grouping all counts and sums on one line for each county which should not look like (Code attached) Note one county is repeated and most are like that: County     MH    SA DD Cost Camden    0        0    1     152.88 Pitt      […]
Pivot Using SQL - I need some help with pivot. For the following data set:   and produce an output like this:
Iterative query to sum a colum relating to dates. - Hi, I have a simple table with 5 columns as follows with about 80,000 rows, I wish to sum the Hours for each Client at 2 week intervals. In other words starting at a particular EndDate, sum the Hours for each client for 2 week period. ID,  ClientID,  EndDate,  Hours 1 ,        […]
how to force SS to run certain SP in parallel? - hi everyone I have a SP that is run in SSIS.  That particular SP is basically running a bunch of SP.  See below for code.  SP1 and SP2 are independent of each other so they can definitely be run in parallel.  They all read data from the same table but each writes to a different […]
cannot read the next data row for dataset x - Hi, a peer asked me today to help on this ssrs error.   There is a lot going on in this report but the dataset in question uses a table meant just for ssrs and is filtered in the report by the userid of the person running the report.   When i run the query with a […]
SQL Azure - Development
Copying table data efficiently - Environment: Azure db with P15 (4000 DTU) Table 1: Having 90 coluumns of which 25 columnd encrypted , having approximately 60 million records Table 2: Exact similar structure as Table 1 with no records Requirement : Need to copy data from Table 1 to Table 2 In quicker time and least usage of DTUs. workdone: […]
Reporting Services
Report server errors - http://servername/reports/browse/ could not load folder contents http://servername/reportserver The server principal "NT SERVICE\SQLServerReportingServices" is not able to access the database "ReportServerTempDB" under the current security context. How do I fix this ? Does this have anything to do with SPNs ?https://learn.microsoft.com/en-us/sql/reporting-services/report-server/register-a-service-principal-name-spn-for-a-report-server?view=sql-server-2017
Reporting Services (2019) - Changing Service Account - This is something that happened while investigating a problem - so not impacting me any more - but I wonder what I'm missing. When trying to change the Service Account in the Reporting Services Configuration Manager from built-in to a domain account, it fails to connect to the database with the error: A connection could […]
Design Ideas and Questions
Should testing of Business Report changes be allowed in Prod? - When I arrived at the company 2.5 years ago, the environments were a mess!  Dev crap in Prod, Prod stuff in dev, many databases didn't have a Dev version, etc.  It has been a grueling marathon, but the environment is mostly stabilized.  I've even set up a PreProd environment where users can test deployments or […]
MySQL
MySQL joining - a tricky problem from a newby - Hi, I'm not even sure whether this is possible. I've three tables, one containing a location ID, and a location name. The second table is a users table, which contains the kind of information you'd expect, i.e. name address etc. The third table is a transactions table containing rows describing transactions which can be described […]
SQL Server 2022 - Administration
Blocking Connection to Server - Good Afternoon, We recently procured a service management software for our company, which uses SQL server 2019( 15.0.2125.1) as backend. The client application uses sql usernames to login into the application . I find this as a security issue, as any internal user can directly connect to the server either through ODBC or through SSMS […]
Migrating standalone database to always-on cluster. - I am planning to migrate a currently standalone database to SQL Always On. This would be an OS & SQL upgrade & migrate activity to an entire new box of servers running on latest Windows Server & SQL Server. I have never perform this configuration before and will be referring to steps which is stated […]
 

 

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

 

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