|
how do you do foreign keys in excel
|
# ? May 17, 2016 00:15 |
|
|
# ? May 15, 2024 04:18 |
|
you know you can just save it all to csv and probably load it into an sqlite db in about 5 seconds right
|
# ? May 17, 2016 00:17 |
|
sql express is fully featured sql server w/ a 10gb/db limit. its real good for small timey personal things
|
# ? May 17, 2016 01:24 |
|
postgres
|
# ? May 17, 2016 13:52 |
|
Shaggar posted:sql express is fully featured sql server w/ a 10gb/db limit. its real good for small timey personal things sql express train directly into my ballsack
|
# ? May 17, 2016 14:06 |
|
Shaggar posted:sql express is fully featured sql server w/ a 10gb/db limit. its real good for small timey personal things but there are better dbs out there that don't have limits and run non-poo poo-tier OSes that don't require you to buy expensive licenses
|
# ? May 17, 2016 14:24 |
|
akadajet posted:but there are better dbs out there that don't have limits and run non-poo poo-tier OSes that don't require you to buy expensive licenses for example
|
# ? May 17, 2016 14:27 |
|
qhat posted:for example your mother
|
# ? May 17, 2016 14:31 |
|
i mean if you're making some awful hobbyist website then you can easily get away with mysql or even sqlite, or basically loving anything since it doesn't matter but if you care about enterprise features for example not complete dog poo poo replication and failover then you should be seriously considering investing some money into what's going to be one of the most critical technologies in your business and microsoft is putting sql server on linux soon anyway so the windows requirement won't even be a thing eventually
|
# ? May 17, 2016 14:37 |
|
akadajet posted:but there are better dbs out there that don't have limits and run non-poo poo-tier OSes that don't require you to buy expensive licenses no there aren't
|
# ? May 17, 2016 14:41 |
|
ok so he was talking about personal project things anyway but since there's no reason to use mysql in the real world then you're should probably learn how to make dbs the correct way, else you may as well just check plaintext csv files into svn because who cares
|
# ? May 17, 2016 14:43 |
|
theres also mssql embedded which is weird and doesn't have stored procs so its not very good.
|
# ? May 17, 2016 14:45 |
|
so it's at least equally as useful as mysql nice
|
# ? May 17, 2016 14:45 |
|
the other cool thing w/ sql express is once u decide to upgrade to a licensed version you just stick the license in there and it magically turns into that version.
|
# ? May 17, 2016 14:47 |
|
one thing that annoys me about sql server is SSMS 2014 is horse poo poo and doesn't save connection parameters in the dialog box so the program disconnects from the DB every 5 minutes and you have to type out the loving connection string again. SSMS 2016 fixed that though so once again SQL server is the best
|
# ? May 17, 2016 14:51 |
|
qhat posted:one thing that annoys me about sql server is SSMS 2014 is horse poo poo and doesn't save connection parameters in the dialog box so the program disconnects from the DB every 5 minutes and you have to type out the loving connection string again. .csv files don't need connection strings and as such are superior
|
# ? May 17, 2016 14:53 |
|
qhat posted:one thing that annoys me about sql server is SSMS 2014 is horse poo poo and doesn't save connection parameters in the dialog box so the program disconnects from the DB every 5 minutes and you have to type out the loving connection string again. doesn't do that on my pc.
|
# ? May 17, 2016 14:54 |
|
Shaggar posted:doesn't do that on my pc. we use multisubnetfailover and idk if you use that but apparently it's a known problem, since without that option half of the connection attempts will just fail. they should just do the logical thing and have that setting as a checkbox somewhere like in visual studio, but they don't so idk. at least the connection parameters are actually saved between connection attempts now.
|
# ? May 17, 2016 14:57 |
|
no we aren't doing multi subnet failover.
|
# ? May 17, 2016 14:59 |
|
Shaggar posted:the other cool thing w/ sql express is once u decide to upgrade to a licensed version you just stick the license in there and it magically turns into that version. lol so it's like a 200mb download with a fragile installer, instead of a tiny library like sqlite3, gg msft
|
# ? May 17, 2016 15:19 |
|
if you want an embedded db you can use sql embedded which is the equivalent of sqllite. sql express is a real db and has all the features of fully licensed sql server which is why u download everything.
|
# ? May 17, 2016 15:21 |
|
our oracle "dba" contractors are claiming you can't "trust" rman backups and that we have to also stop the db's to do a cold file capture every week. I suspect they are idiots.
|
# ? May 17, 2016 16:45 |
|
Percona-Server-server-57-5.7.11-4.1.el7.x86_64.rpm
|
# ? May 17, 2016 17:07 |
|
why can you not trust the tool that has been provided by the exact same company that creates the database apart from the fact that that company happens to be oracle
|
# ? May 17, 2016 17:17 |
|
qhat posted:why can you not trust the tool that has been provided by the exact same company that creates the database I believe this is due to: a furious waving of hands. but if anyone has info on exactly how the oracle vss writer service works and how to control it, I would appreciate it. because our DBAs don't know poo poo and the thing ends up consuming all memory until the system deadlocks
|
# ? May 17, 2016 18:16 |
|
didn't you mention shitcanning a 45k "dba" not too long ago? because i think the rest of them could use the same treatment. being able to do backups of the db you maintain is kind of a pretty basic+important skill imo
|
# ? May 17, 2016 18:58 |
|
YeOldeButchere posted:didn't you mention shitcanning a 45k "dba" not too long ago? because i think the rest of them could use the same treatment. being able to do backups of the db you maintain is kind of a pretty basic+important skill imo these are contractors but yeah, its awful and I hate everyone involved. we should be paying someone a bajillion dollars a month to host oracle db's for us because our in house people don't know what the gently caress and I'm touching the poop as little as possible
|
# ? May 17, 2016 19:08 |
|
It's cool how you can make a boatload of money while knowing next to nothing about your primary trade
|
# ? May 17, 2016 19:51 |
|
contracting sounds like an awesome racket and I should get on it for megabuxxx, yes
|
# ? May 17, 2016 20:04 |
|
we have a consultant with us right now whos contracted for 6 months cause hes actually really goddamned good. first consultant I've ever met who knew what he was doing.
|
# ? May 17, 2016 20:05 |
|
Contractors who know what they're doing are the dumb ones because it means that they weren't smart enough to get a job with free training that is just over their head enough to not get fired. I'm pretty smart, so you'll never catch me working a job where I'm totally qualified.
|
# ? May 17, 2016 20:26 |
|
I bet shaggar is good at his job lol...
|
# ? May 17, 2016 20:27 |
|
Shaggar posted:we have a consultant with us right now whos contracted for 6 months cause hes actually really goddamned good. first consultant I've ever met who knew what he was doing. this is how i imagined it should be, you pay more money and you get someone who can do the job right now. evidently not though.
|
# ? May 17, 2016 20:40 |
|
oracle dbas are garbage
|
# ? May 18, 2016 00:13 |
|
uncurable mlady posted:oracle dbas are garbage you say this while Tori is on probation? Coward. Bitch.
|
# ? May 18, 2016 00:19 |
|
zen death robot posted:a lot of them are really bad, like amazingly so Thats called The Bible.
|
# ? May 18, 2016 00:24 |
|
ive used rman before. even in the cli and not the gui one
|
# ? May 18, 2016 00:25 |
|
YOSPOS BITCH!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
|
# ? May 18, 2016 00:28 |
|
zen death robot posted:The Bible didn't tell them it was OK to set the systems max shared memory size to be absolute maximum a 64 bit OS would ever allow and go hog wild with SGA sizes and then bitch to me that the storage speeds are loving trash because they're swapping the loving DB cache out to disk constantly like a bunch of loving idiots/ Lol
|
# ? May 18, 2016 00:36 |
|
|
# ? May 15, 2024 04:18 |
|
zen death robot posted:I mentioned they could just allow orcale to automatically handle the memory management and they argued with me that there's a "bug" that wouldn't allow them to use more memory than existed on the system. Lmao
|
# ? May 18, 2016 00:38 |