| The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | Hand-picked content to sharpen your professional edge |
| No Degree Needed For most of my career, I've seen many companies that hire white-collar workers, including their IT staff, require a college degree or the equivalent experience in the military. Often this has been something the Human Resources department has made a requirement in their job descriptions and requests to recruiters. This was a filter that stopped many talented people from even getting an interview. That hasn't stopped a lot of people from pursuing careers as developers or IT staffers, and I've had many friends who have had successful careers without a degree. The world has been changing, especially since the pandemic, and many companies are no longer requiring any sort of university degree for candidates. There are still a lot of job descriptions that "prefer" a degree, but even that is changing rapidly. I hope at some point that we stop looking at degrees as anything other than a bit of experience in working through a project and not as any sort of qualification for a particular job. This week there was an article about seven ways to become a software engineer without a degree. The ways are: learn to program, earn a cert, contribute to an OSS codebase, write documentation, find employers who don't care, be a freelance developer, and go to a bootcamp. Of these, a few seem redundant learning to code is probably needed to contribute to OSS or freelancing. Of these, I overall like the advice. Being self-motivated or driven is a skill that many employers appreciate. Showing that you are producing something useful in the world is a good way to create opportunities. It's also a sign that you'll work to be productive and not expect to avoid work after getting hired. I know I prefer people who go figure things out rather than those who wait for someone else to tell them what to do. I don't recommend bootcamps, however, unless you are very motivated to take whatever you learn and then expand on it with OSS contributions or other tasks that showcase and expand knowledge. Finding a job is challenging at times, and certainly impressing someone enough to hire you is a task. A degree can help, especially with those who might be prejudiced towards university experience, but more and more people recognize that college doesn't necessarily prepare you to be productive or a great employee. You can prove that to people yourself with some work, some documenting your efforts, and some good soft skills to explain what you know. Steve Jones - SSC Editor Join the debate, and respond to the editorial on the forums |
The Weekly News | All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit. |
AI/Machine Learning/Cognitive Services |
Companies must recognize AI's utility, while setti... |
Compare the best AI meeting assistants and tools make, so you can easily document everything that is said during meetings. The post 10 Best AI Meeting Assistants & Tools for... |
Administration of SQL Server |
Here are the details Comprehensive Database Perfor... |
In the context of partitioning, it's essential to understand the concepts of aligned and non-aligned indexes. Let us learn about it today. First appeared on SQL SERVER – Aligned and... |
A client asked me about SQL Server collations, and if they should consider the new UTF8 collations (new since SQL Server 2019). I tried to hide my blank stare... |
How SQL Server Indexes Store Data Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a... |
Azure Databricks, Spark and Snowflake |
With the introduction of Git Integration Repo in D... |
Reading Time: 6 minutes In this post I want to co... |
This week, I addressed a customer's request to und... |
We are very excited to announce a significant “refresh” to the current Azure SQL Database Elastic Jobs preview! This refresh brings several new capabilities that were highly requested by... |
Career, Employment, and Certifications |
Is your company hiring for a database position as ... |
Here are seven effective strategies that can lead ... |
New latency metrics on OS, data and temporary disk... |
Azure Monitor Logs extends archive retention to up... |
Computing in the Cloud (Azure, Google, AWS) |
Earlier this year, we migrated the entire Stack Ov... |
Conferences, Classes, Events, and Webinars |
Don’t worry if you missed Redgate’s live stream announcement at PASS Data Community Summit - you can join David Gummer, Chief Product Officer at Redgate, and Alex Yates, Senior Solutions Specialist at Redgate, live on the 29th of November to learn: How test data management can benefit you in your role How you can reap benefits including accelerated data provisioning, and improved quality and speed of application releases Top takeaways from the exciting launch at PASS Data Community Summit 2023 How Redgate have worked to simplify the challenges of managing and getting your hands on quality (yet compliant) test data |
PASS Data Community Summit have announced that they have handpicked 16 sessions to livestream, for free, from this year’s event. These sessions have been chosen because they represent topics of interest to the broader data community. The benefit of livestreaming a selection of sessions means that data professionals from around the world will have the opportunity to hear the latest announcements from Redgate, Microsoft, Intel, AWS and community experts. |
Appreciate everyone who has reached out asking if ... |
Edwin Sarmiento has a great First Timer Guide for the PASS Data Community Summit, which is updated for 2023. He’s been compiling this since 2016, and it’s worth reading.... The... |
Learn how to deal with string data that needs to b... |
Database Design, Theory and Development |
THE VIDEO THE SYNOPSIS In this video, explain what... |
HA/DR/Always On/Clustering |
Learn how to build a Windows Failover Cluster usin... |
The portable SSD market has seen rapid growth over... |
Hidden deep in Seagate's financial report released late last month was a brief roadmap update for the company's heat-assisted magnetic recording (HAMR) technology. As noted in the latest update,... |
The path to high-capacity RDIMMs for servers has primarily been through 3D stacking (3DS) of DRAM dies using Through-Silicon Vias (TSVs). However, this has presented significant challenges in packaging... |
This tip will provide fundamental information on R... |
Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) |
DESCRIPTION One of the key pillars of Microsoft Fabric is that it’s lake centric and open. At the core of this pillar there’s OneLake - a single, unified storage... |
Microsoft Fabric is a SaaS platform that allows users to get, create, share, and visualise data using a wide set of tools. It provides a unified solution for all our data and analytics workloads, from data ingestion and transformation to data engineering, data science, data warehouse, real-time analytics, and data visualisation. In a previous blog post, I explained the basics of the Microsoft Fabric data platform. |
Microsoft Fabric, including the Data Warehouse, evolves faster than we can analyze and write about it. Here I’m summarizing the most recent news I looked at. Clone Table We... |
Oracle/PostgreSQL/MySQL/other RDBMS |
TimescaleDB is an open-source time-series database extension for PostgreSQL. It is designed to efficiently manage and query time-series data, offering features such as automatic data partitioning, data retention policies, and specialized time-series functions. |
One of the technologies that my new job brought wi... |
Performance Tuning SQL Server |
A Big Blind Spot In SQL Server’s Missing Index R... |
Fixing Performance Problems With Key Lookups In SQ... |
Why Common Table Expressions Don’t Fix Performance Problems In SQL Server Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love... |
PowerPivot/PowerQuery/PowerBI |
Recently I was involved in an interesting discussi... |
This article describes how to use the DAX time int... |
How to use the DAX time intelligence calculations ... |
Video by: Reid HavensLearn about three primary tec... |
Product Reviews and Articles |
There was an update to Flyway Desktop which lets y... |
Consider a customer who needs to deploy sequence o... |
A database assertion test aims to check that data within a relational database conforms to specific business rules. This article demonstrates how to run these assertion tests automatically in... |
Recently a customer was looking to automate some of their SQL Compare checks, but they wanted to do this in a dynamic way, since they needed to do this... The... |
Product Upgrades and Releases |
Enable disks to tolerate zonal failures without ca... |
“Data is at the center of every application, process, and business decision,” wrote Swami Sivasubramanian, VP of Database, Analytics, and Machine Learning at AWS, and I couldn’t agree more.... |
Just in time for Microsoft Ignite and the PASS Data Community Summit, version 1.47.0 of Azure Data Studio is available with some great new features and a number of... |
there are still lesser-known reasons to prefer apply() functions over for loops, which we will explore in this post. |
In the realm of statistics, a cumulative distribution function (CDF) serves as a crucial tool for understanding the behavior of data. It provides a comprehensive picture of how a variable’s values are distributed across its range. In this blog post, we’ll embark on an exciting journey to unravel the mysteries of CDFs and explore how to effortlessly calculate and visualize them using the powerful R programming language. |
My sticky note filled up quickly after I only added setNames() on it, with related functions for dealing with object names, in base R and beyond! |
Active ransomware attacks against vulnerable Atlas... |
In a rapidly evolving cybersecurity landscape, CISOs must take proactive measures to safeguard their careers and mitigate risks associated with their roles. |
T-SQL and Query Languages |
T-SQL Code for the popular game of “Connect 4”... |
I had written about a FK in a CREATE TABLE stateme... |
This is an article on How to write efficient TSQL.... |
I recently faced a situation where I had to track down the definition of a particular SQL view for various databases. I didn’t want to click through each database... |
Learn how to unpivot data or sets of data with SQL... |
UNPIVOT works great when you're populating a single output column, but I talk about how CROSS APPLY can work better in more complex scenarios. |
The SQL NTILE() is a window function that allows you to break a table into a specified number of approximately equal groups, or . For each row in... |
Learn about working with time series data using T-SQL code and how to add additional data to the data set for more in-depth data mining. |
Tech stocks are on shaky ground. The seven biggest... |
If you are looking to set up well-orchestrated Linux environments, this guide explains the essential concepts and practices for advanced user management. |
Introduction Although residential solar photovolta... |
I wanted to write a post about going to the Pass Data Community Summit this year, and everything I started to write sounded cheesy. So I started thinking (finally),... |
Tools for Dev (SSMS, ADS, VS, etc.) |
This topic came up on Shop Talk Monday night and I figured I would write a quick blog post because it caught people there by surprise. Visual Studio Code... |
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. Note: This is not the SQLServerCentral.com daily newsletter list, and unsubscribing to this newsletter will not stop you receiving the SQL Server Central daily newsletters. If you want to be removed from that list, you can follow the instructions on the daily newsletter. |
|
|