Out of interest, I'm 5 years into my DBA career ish - have other DBAs here ventured into the dev world successfully? I'm looking at it and can't really see any reason I can't dev and DBA - the skill sets overlap massively.
@George.Palacios Decent database devs aren't thick on the ground. If you've got a background in data warehousing that will be a bonus. However, a lot of shops still have a 'data monkey' mentality so you will get a preponderance of jobs offering below-market salaries.
@ConcernedOfTunbridgeWells That may be where I fit in that case. I agree on this sentiment - I've come across so, so many that lack what I consider to be the essential skills
@George.Palacios You will find me almost everywhere, my relationship with SharePoint ended though, it might spark again but Machine Learning and AI is the next thing I am most interested in now ;)
This is a very frustrating situation as the last employer continues to pay me despite my multiple calls to their helpline to rectify the situation. I've called the HR and Payroll department multiple times and filed reports.
When they ask for money back, it will cost me a lot of time and effort t...
Time line of events :
December : Joined A startup as a team lead.
January : Got paid late for December month salary at 10th January instead of last payment date 15th. Got paid in half and another half was paid at ~15th of January.
February : Got paid late (in half salary) for January month a...
A company I was interested in just flew me out for an interview. It was on the other side of the country so they paid for my flight and hotel. Unfortunately, the interview went disastrously. I blew every question and I could tell that they didn't like me personally.
When I got to the airport ...
haha, fortunately for me when i took that job i was in a "previous employer continues to pay me" situation as well. you win some, you lose some i guess
@PeterVandivier well, I got once one month extra because I was sorta fired last minute (no idea what you can safely do to a systems administrator, and there were no hard feelings on either side, for the records). After that I went to the military, and at the end of it I got 6 months of employment (paid, of course), for doing absolutely nothing. They even demolished the building I worked in before. The flip side was that I lost my access to tanks @ConcernedOfTunbridgeWells
In russian class I sat next to a guy who had dibs on a couple of miles of tee-seventy-somethings lined up in a forest somewhere. Not sure I still have his number, though.
similar to Sean's comments in the VIP room, I didn't want to imply more weight to that link than there is (i'm not an MS employee, and the MS employee does in fact indicate that voting on that doesn't have a bearing on the internal work item)
but his answer seemed like the appropriate place for that link
EDIT and UPDATE are rarely needed, nor helpful.
For future readers, posts need to be standalone, without any history. These sites are not forums, but:
We build libraries of high-quality questions and answers, focused on each community's area of expertise.
Future readers are not helped by ...
@ShadowWizard not yet; ultimately, Amazon oneboxing isn't top of our P1/P0 list, and we've been busy trying to launch "teams" :) — Marc Gravell ♦Apr 8 '18 at 9:43
Hey everyone! Quick question: is there a conventional column name for the sort order field? Similar to how 'id' is almost always used for the primary key. I guess 'order' may be a reserved word, so it's out. 'Sort'? What do you use?
@aexl For what it's worth, we have a user-populated sorting column in some cases that we predominantly call Sort. In the table it's always an int and is 1000 or 10,000 times the value displayed in the app.
@dezso Not many fellow Hungarians among your co-workers, I presume
I'm studying for a test tomorrow and trying to figure out the important concepts - https://trello.com/b/VfvcW983/database-design
Rn, only thing I've done is watch a 51 video playlist from Caleb Curry and try to go through some material on KhanAcademy. O
I've been studying DBMS for 10 years now starting from middle school, and KA has me here: https://www.khanacademy.org/computing/computer-programming/sql/sql/hour-of-sql/pt/querying-the-table
@AndriyM I know, I know. I have over 2000 pages sitting as two fat textbooks infront of me, I just wanted to share my pain. I felt this was the most relevant place. It's ok if you can't help.
@Nick That's a lot of theory for me, some of the topics I've only heard the names of. Hard to decide which should be considered more important than others. Most of what I've learnt is by self-teaching and "following examples", so I guess my choice of important-ish would be heavily influenced by what I do
I'm a developer with interest in knowing a little more about how databases work, so SQL (the more the better), basic idea about normalisation, indices, transactions, storage would be my choice
@yper-crazyhat-cubeᵀᴹ People like to make things harder
Why not just directly WHERE Number LIKE '20%'? and since you filter the result set you don't need for CASE expression, just 'X' AS Operation — Sami24 mins ago
Setup
I've set up an example on rextester and dbfiddle.
Scenario
Price list: Its the products price list, one Products can have more than one active price, even a future price.
+---------+-------+------------+--------+--------+
| product | price | date_price | base | active |
+---------+--...
My company produces small pieces, sometimes the unit price = 0.0006 €, instead of negotiate a price per unit they establish a price x 1000 units or price x 'Base' units
A company I was interested in just flew me out for an interview. It was on the other side of the country so they paid for my flight and hotel. Unfortunately, the interview went disastrously. I blew every question and I could tell that they didn't like me personally.
When I got to the airport ...
EDIT and UPDATE are rarely needed, nor helpful.
For future readers, posts need to be standalone, without any history. These sites are not forums, but:
We build libraries of high-quality questions and answers, focused on each community's area of expertise.
Future readers are not helped by ...
Setup
I've set up an example on rextester and dbfiddle.
Scenario
Price list: Its the products price list, one Products can have more than one active price, even a future price.
+---------+-------+------------+--------+--------+
| product | price | date_price | base | active |
+---------+--...
