June 14, 2017 at 6:28 pm
I'm looking forward, loading the million song dataset into a Graph table in SQL Server 2017
https://github.com/arvindshmicrosoft/MillionSongDatasetinSQLServer
June 14, 2017 at 6:37 pm
Steve Jones - SSC Editor - Wednesday, June 14, 2017 6:28 PMI'm looking forward, loading the million song dataset into a Graph table in SQL Server 2017https://github.com/arvindshmicrosoft/MillionSongDatasetinSQLServer
But, why? What relationships are you thinking will be uncovered in a database of unrelated music? I assume some crossover between artists where you could see artists tied to groups maybe, but what else would you be investigating?
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
June 14, 2017 at 9:02 pm
jonathan.crawford - Wednesday, June 14, 2017 6:37 PMSteve Jones - SSC Editor - Wednesday, June 14, 2017 6:28 PMI'm looking forward, loading the million song dataset into a Graph table in SQL Server 2017https://github.com/arvindshmicrosoft/MillionSongDatasetinSQLServer
But, why? What relationships are you thinking will be uncovered in a database of unrelated music? I assume some crossover between artists where you could see artists tied to groups maybe, but what else would you be investigating?
Learning how graphs work. Using a set that's easy to understand.
June 14, 2017 at 9:37 pm
I've been away for awhile wrapping up a project with some hard deadlines but that's all done and I'm back.
-- Itzik Ben-Gan 2001
June 15, 2017 at 2:22 am
Brandie Tarvin - Friday, June 9, 2017 4:11 AMThom A - Thursday, June 8, 2017 12:14 PMI feel totally foolish for posting this, but does anyone know where the touchpad scroll settings are in Windows 10?My touchpad has suddenly decided it wants to be on a Mac, as physically scrolling upwards scrolls the page downwards. >_< Oddly, my USB mouse is working as normal, and flipping the mouse option only affects the USB mouse. It's really bugging me, as I'm not always in a place to use a mouse (like when it's on my lap, heh).
Thanks guys!
Settings -> Devices -> Mouse & Touchpad -> Additional Mouse Options -> last column on the right (on mine it says Thinkpad, for yours it'll probably be your device brand name) -> Advanced Settings -> Scrolling.
Because they really had to try hard to figure out how to hide this and complicate users' lives.
EDIT: Changed a word I mistyped
Thanks Brandie, only just seen this (all my time has literally gone out the window the last month). I had a look, but nothing there. My Mouse and touchpad menu's are actually separated, and the touchpad only has a sensitivity option. Had a good look again, but nothing.
I've "got used to it" now, so I'll live with it. No doubt it'll switch back on it's own when it becomes second nature to me. :rolleyes:
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 15, 2017 at 1:29 pm
No wonder I'm not making more money...
I'm indenting wrong:
https://arstechnica.com/information-technology/2017/06/according-to-statistics-programming-with-spaces-instead-of-tabs-makes-you-rich/
June 15, 2017 at 1:46 pm
jasona.work - Thursday, June 15, 2017 1:29 PMNo wonder I'm not making more money...
I'm indenting wrong:
https://arstechnica.com/information-technology/2017/06/according-to-statistics-programming-with-spaces-instead-of-tabs-makes-you-rich/
I wonder how does using tabs converted to spaces count.
June 15, 2017 at 4:38 pm
Huh. well, that's good, I seem to be in a good position in reference with the rest of the industry and my expectations. I use tabs, by the way, because I'm not a heathen
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
June 15, 2017 at 4:58 pm
TomThomson - Wednesday, June 14, 2017 4:05 PMHugo Kornelis - Tuesday, June 13, 2017 9:00 AMLynn Pettis - Tuesday, June 13, 2017 8:14 AMGrant Fritchey - Tuesday, June 13, 2017 5:50 AMBrandie Tarvin - Tuesday, June 13, 2017 5:01 AMAs part of my Grace Hopper SOL session, I'm committed to naming the different types of database platforms and it occurs to me that I know of a few off the top of my head: SQL Server, Oracle, NoSQL, MySQL, and DB2.Any others that I'm missing?
I only have about 10 minutes to lay out what types of DB administrators there are, mention the different platforms, and explain why databases are so important to modern life before giving 10 minutes of questions and give and take on the session (each one only lasts 20 minutes), so I have to be brief. Any thoughts you'd like me to incorporate into this?
Types of platforms I'd go different:
Relational, Object, ID/Value, Unstructured, Semi-structuredWhat you have is kind of a mix between products & platforms, NoSQL being more of a platform than the products you listed, SQL Server Oracle MySQL & DB2.
Your forgetting the old Hierarchical and Network database systems that came before the relational database systems.
Correction. I am trying to forget those. So should you.
I think that's a mistake. There are still many out there being used for large scale stuff (sometimes very large scale stuff). If you are a database specialist you may find yourself having to deal with of those databases, if only to get data out of one and into a more modern database model (and already many such transitions have had nightmare problems precisely because the perople in charge of moving the data thought underatanding the old models was beneath them). Pretending that hese thing are not a significant proportion of extant databases, with a very large data content, is just plain "if I shut my eyes it doesn't exist" crazy.
Pervasive/Btrieve
June 16, 2017 at 4:24 am
Having a bit of a brain fart this morning concerning SSIS. Need some "yes", "no", "maybe" thoughts over here if anyone has a few moments.
June 16, 2017 at 4:29 am
Hugo Kornelis - Tuesday, June 13, 2017 5:17 AMBrandie Tarvin - Tuesday, June 13, 2017 5:01 AMAs part of my Grace Hopper SOL session, I'm committed to naming the different types of database platforms and it occurs to me that I know of a few off the top of my head: SQL Server, Oracle, NoSQL, MySQL, and DB2.Any others that I'm missing?
I only have about 10 minutes to lay out what types of DB administrators there are, mention the different platforms, and explain why databases are so important to modern life before giving 10 minutes of questions and give and take on the session (each one only lasts 20 minutes), so I have to be brief. Any thoughts you'd like me to incorporate into this?
Given the limited time you have, I'd suggest starting with explaing the difference between "relational" databases (such as SQL Server, Oracle, PostgreSQL, MySQL, DB2), that have a strong schema and strong ACID guarantees; versus the so-callled "NoSQL" databases (for which I'll let someone else chime in with examples because I don't know which are big at this time) that are typically schema-free and have various degrees of looseness on the ACID properties.
Both these two types have their uses. The mistake is to try to think that one type can do the work of both. They CAN but you SHOULDN'T. (Just as you CAN clip your nails with a hedge trimmer or trim your hedge with a nailclipper, but most people would prefer to have one of each).
As to why databases are important in modern life: They are not. Data is important. How much data do we collect now as opposed to some decades ago? How is that data used to support our life (decision making, but also leasure - just think about all the statistics in sports broadcasts if you want an example from outside of the boardroom), nd how long arre we prepared to wait for that data. The database is just a tool to support this.
Thanks, Hugo. I didn't think about that. I'll see what I can work in about this.
June 16, 2017 at 4:30 am
jasona.work - Tuesday, June 13, 2017 6:23 AMI'd agree with Grant and Hugo, rather than getting down to individual RDBMS systems, think 1000ft view, especially with the limited timeframe for the presentation. Think "explaining to the CXX Executives," rather than "explaining to the techies."
I'm beginning to see I might have bitten off more then I can chew in the time allotted. You have a good point about the 1000ft view, especially as this is a student lab and probably a lot of these students haven't even heard of some of these concepts before.
June 16, 2017 at 4:36 am
Thom A - Thursday, June 15, 2017 2:22 AMBrandie Tarvin - Friday, June 9, 2017 4:11 AMThom A - Thursday, June 8, 2017 12:14 PMI feel totally foolish for posting this, but does anyone know where the touchpad scroll settings are in Windows 10?My touchpad has suddenly decided it wants to be on a Mac, as physically scrolling upwards scrolls the page downwards. >_< Oddly, my USB mouse is working as normal, and flipping the mouse option only affects the USB mouse. It's really bugging me, as I'm not always in a place to use a mouse (like when it's on my lap, heh).
Thanks guys!
Settings -> Devices -> Mouse & Touchpad -> Additional Mouse Options -> last column on the right (on mine it says Thinkpad, for yours it'll probably be your device brand name) -> Advanced Settings -> Scrolling.
Because they really had to try hard to figure out how to hide this and complicate users' lives.
EDIT: Changed a word I mistyped
Thanks Brandie, only just seen this (all my time has literally gone out the window the last month). I had a look, but nothing there. My Mouse and touchpad menu's are actually separated, and the touchpad only has a sensitivity option. Had a good look again, but nothing.
I've "got used to it" now, so I'll live with it. No doubt it'll switch back on it's own when it becomes second nature to me. :rolleyes:
What type of machine are you using? Have you checked the brand's support site for info yet?
June 16, 2017 at 4:37 am
Thanks everyone for your database platforms and brands thoughts. They help. I'm going to get to work on my presentation and let you know if I have any more questions.
Viewing 15 posts - 58,921 through 58,935 (of 66,547 total)
You must be logged in to reply to this topic. Login to reply