The SQL Twilight Zone

Question

The SQL Twilight Zone

Viewing 12 posts - 16 through 26 (of 26 total)

You must be logged in to reply to this topic. Login to reply

Dalkeith Hall of Fame Points: 3718 More actions · Answer 1

PostGres with the spatial plugin to make it PostGIS

I m merely a hobbyist compared to nearly everyone in here.

That said MS Azure now gives me access to anything I want. I spend a small amount of money every month and tinker about with SQL Server on my own projects (that said with database as a service). I concentrate on end to end applications that have small amounts of information in them compared to many. I have minimal input as a DBA at work but nonetheless anything I learn from my home work helps me in many tasks.

I would have thought the same for everyone in here anyone who has understanding of the cloud is probably more independent than ever albeit you may be less involved in configuring/backup database work.

What is nice about this is that my access to tools in some sense is very stable and independent of my employment with my knowledge slowly improving over time. I like this fact. I am considering shelling out for a PostGres database because it is strong on spatial.

cloudydatablog.net

Jeff Moden SSC Guru Points: 1004558 More actions · Answer 2

Steve Jones - SSC Editor - Friday, November 2, 2018 1:30 PM
Rod at work - Friday, November 2, 2018 8:18 AM
Steve, what do you mean by, "In today's SQL twilight zone..."?
The rest of the sentence: imagine you can't work with SQL Server any longer.

Heh... I hate it when you write such things. Do you know something the rest of us don't?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Eric M Russell SSC Guru Points: 125589 More actions · Answer 3

I know how Twilight Zone episodes work; as soon as I would learn PostgresSQL, I'd wake up again and everyone else on the planet would be a SQL Server DBA. :ermm:

But, today in reality, my title at work has changed from SQL Server DBA/Developer to Cloud Data Architect, and my new primary domain will be all things data related in Azure. In the coming years, I expect on-prem SQL Server to take a backseat to the various Azure database services. But it won't happen overnight, and it won't disappear from the landscape.

"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

DinoRS SSCrazy Points: 2683 More actions · Answer 4

I would leave SQL Server for other type of data. Most likely I would end up with Flow Simulation on Ground Vehicles. If I never started with SQL Server I'd probably be owning my own car shop / being a master mechanic (of course).

Matter of fact: I'm willing to leave IT for good after spending some time with a racing team, unfortunately I haven't come across an offer yet so you have to deal with me...

jasona.work SSC Guru Points: 50154 More actions · Answer 5

I'm probably the most boring one here...
If SQL Server vanished from the face of the earth tonight, and I had to find a new role / job tomorrow, I'd probably fall back on my previous experience as a sysadmin. I might even shoot for a *gasp* management position overseeing sysadmins, because I can at least talk some of the talk while knowing that I won't know everything about what they do.

From there, I'd probably start looking at what's left in the RDBMS world and see what I could pick up. I've maintained an Oracle database for a couple months, and while it's a great product with some great features, yeah no.

Steve Jones - SSC Editor SSC Guru Points: 737403 More actions · Answer 6

Jeff Moden - Sunday, November 4, 2018 5:28 PM
Heh... I hate it when you write such things. Do you know something the rest of us don't?

Nope , was just pondering what I'd do after talking with someone that had moved to a new phase of their career.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 7

Steve Jones - SSC Editor - Monday, November 12, 2018 10:29 AM
Nope , was just pondering what I'd do after talking with someone that had moved to a new phase of their career.

I am sort of in that position now. I can either become a tester to stay in the group I am currently in, hope they can find me a new home here still working with SQL Server, or find new employment (hopefully still working with SQL Server) somewhere else. Biggest problem, I really can't move right now with the health issues my dad id currently having. Hope there is maybe finding something that would let me work from home.

Ross McMicken SSCarpal Tunnel Points: 4449 More actions · Answer 8

I would do what I am doing now where most of my time is spent in Snowflake or SAP Hana. I do some work in legacy SQL Server systems, but mostly it's Snowflake now.

daniel.dolan SSC-Addicted Points: 437 More actions · Answer 9

As I am one of the ancient ones on here, I would probably just retire. Barring that, I would quickly change to working full time in Intersystems IRIS, specifically supporting Epic installations as I am already certified in that and it is a large part of my work now.

Jo Pattyn SSC-Dedicated Points: 32390 More actions · Answer 10

Probably switch to PostGres or start developing again

EdVassie SSC Guru Points: 60504 More actions · Answer 11

This happened to me, but in reverse.

I used to have some expertise in DB2, both on mainframe and *nix. I attended and spoke at conferences for DB2 and was very active on newsgroups (listservers back then) and user groups around DB2. I also had some experience with Oracle, IMS, and DMS1100. In 2001 I was in the professional services division of a software house that had made its name providing a toolset or DB2.

Then the CEO of the software house decided prof services was not core and closed it down overnight and I was redundant. (Four years later not only had this decision been reversed under a new CEO but professional prices had became the biggest profit centre of the whole business. Such is life.)

The company I joined next was largely a SQL server place, with a bit of DB2 looked after by a colleague. I had played with Query Analyser at the software house, but had a lot to learn about SQL Server. After 2 or 3 gears I had become a resumed my attendences at conferences, contributions to user groups and newsgroups, etc, but these were all SQL Server. DB2 had become a place of memories, not of work.

We will all face change in our lives. At work the only constant is change, and outside of work change is seldom far away. Sometimes it will be incremental, other times it will be sudden. However, the underlying skills from previous situations are likely to prove useful in the new.

Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

P Jones SSChampion Points: 12366 More actions · Answer 12

I'm one of the older ones who could retire, but this is happening in my world as our SQL Server databases are being replaced by the cloud and AWS S3 Data Lake. However it still requires Athena SQL to get anything out of it so there's no such thing as no more SQL!

And I've got MySQL websites for a hobby.

However the one thing I really miss and haven't yet found is a "SQL Server Central" for AWS - a sound knowledge source that I've relied on for the past 20 years and a community of like minded people from all over the world who can give articles from a different perspective and real answers to issues not just manufacturers' documentation that doesn't explain things.

The SQL Twilight Zone

Cookies on SQLServerCentral