|
i like the sql server tool that lets you draw tables and keys and so on; it's pleasant to use and helpful for understanding things
|
# ? Mar 8, 2016 10:16 |
|
|
# ? May 22, 2024 04:33 |
|
Phoenixan posted:they bought minecraft to eventually deliver it the fate it deserves No no no no no that cant be right, that would be a good and noble thing. MS cant do that.
|
# ? Mar 8, 2016 10:44 |
|
prefect posted:i like the sql server tool that lets you draw tables and keys and so on; it's pleasant to use and helpful for understanding things Every office in the world comes with that tool, a piece of paper and a pencil
|
# ? Mar 8, 2016 14:14 |
|
Citizen Tayne posted:Every office in the world comes with that tool, a piece of paper and a pencil but the tool actually creates the tables and relationships when you save the diagram
|
# ? Mar 8, 2016 14:18 |
|
shitface posted:if you want a bi buy Microstrategy and then run it against a real database, Oracle. saying Microsoft has bi is like saying access is a database. it's only fishmech true "you got me" *dramatically clasps hand over heart and slowly falls to the ground*
|
# ? Mar 8, 2016 14:19 |
|
prefect posted:but the tool actually creates the tables and relationships when you save the diagram Hmm.
|
# ? Mar 8, 2016 14:20 |
|
did ms buy share point from someone else, I'm trying to think if they've ever developed anything decent inhouse
|
# ? Mar 8, 2016 14:34 |
|
not that share point is decent mind you, but it seems so bad that it must have been made inhouse
|
# ? Mar 8, 2016 14:35 |
|
it was made in house lol
|
# ? Mar 8, 2016 14:41 |
|
Maximum Leader posted:it was made in house lol the theory fits
|
# ? Mar 8, 2016 15:27 |
|
I ordered my XPS 15 with 1tb SSD, and I think it comes with w10 pro instead of home
|
# ? Mar 8, 2016 20:16 |
|
Maximum Leader posted:it was made in house lol 2013 or 15 or whatever we have is so fuckin retarded. like yeah sure ms the most important thing I care about when clicking the first three dots menu is how many goddamn people I'm sharing this thing with
|
# ? Mar 8, 2016 23:33 |
|
sharepoint is total loving poo poo
|
# ? Mar 8, 2016 23:45 |
|
Chris Knight posted:2013 or 15 or whatever we have is so fuckin retarded. like yeah sure ms the most important thing I care about when clicking the first three dots menu is how many goddamn people I'm sharing this thing with I'm the submenu of a submenu you have to dig through to actually download a copy of a doc instead of opening it read only or checking it out, as well as the important Dept critical form with a modified date of today and a random clients personal info filled in
|
# ? Mar 9, 2016 00:21 |
|
Thanks Ants posted:sharepoint is total loving poo poo at least it's not Drupal
|
# ? Mar 9, 2016 01:46 |
|
theultimo posted:at least it's not Drupal let's not say things we can't take back
|
# ? Mar 9, 2016 04:14 |
|
shitface posted:what are the chances of the mssql port being even vaguely on par in performance and features to the Windows version in even the next 10 years? it will probably be faster than windows on day one. the linux kernel is just that much easier to work with. most particularly, you don't have to deal with the performance deficits associated with ntfs. shitface posted:I presume all the clr stuff will be backed by mono why? microsoft's own .net runs natively on linux.
|
# ? Mar 9, 2016 04:20 |
|
Shaggar posted:i didn't see anything in there about it. It will be nice for enterprises still trapped on Linux to finally get a good db server. now microsoft sql has a future just think, shaggar: all your t-sql skills won't be obsolete just because windows is disappearing
|
# ? Mar 9, 2016 04:22 |
|
Notorious b.s.d. posted:now microsoft sql has a future t-sql is so loving bad compared to pl/sql. christ
|
# ? Mar 9, 2016 04:28 |
|
Citizen Tayne posted:t-sql is so loving bad compared to pl/sql. christ pl/sql is an abomination. oracle tried to turn sql into an imperative language for scripting. they really shouldn't have tried. t-sql is just a bunch of extensions to sql, still as a query language. a small number of them are even useful. it doesn't really make sense to compare them
|
# ? Mar 9, 2016 04:32 |
|
Notorious b.s.d. posted:pl/sql is an abomination. oracle tried to turn sql into an imperative language for scripting. they really shouldn't have tried. You can write useful applications with PL/SQL. You can't with T-SQL. At the end of the day, that's the only metric that matters.
|
# ? Mar 9, 2016 04:34 |
|
Citizen Tayne posted:You can write useful applications with PL/SQL. You can't with T-SQL. pls don't write applications in pl/sql
|
# ? Mar 9, 2016 04:37 |
|
oracle db is really cool and good pl/sql, not so much
|
# ? Mar 9, 2016 04:38 |
|
Notorious b.s.d. posted:pl/sql is an abomination. oracle tried to turn sql into an imperative language for scripting. they really shouldn't have tried. pl/sql is powerful in that it enables you to accomplish lots of things, even though it sucks. but most database people, and most people who like imperative scripting languages, have no idea that it's possible to distinguish between "powerful" and "good"
|
# ? Mar 9, 2016 04:39 |
|
Notorious b.s.d. posted:pls don't write applications in pl/sql The application I work on/maintain has all the user interface poo poo in Java and the backend poo poo in PL/SQL. It works, and you can say whatever you want about the right way to do things, but it bills $14b a year and I have a lifetime job chaperoning it if I want one.
|
# ? Mar 9, 2016 04:42 |
|
Also at this point in time the PL/SQL way of doing things has been way less lovely than the Java way of doing things.
|
# ? Mar 9, 2016 04:43 |
|
that is a reasonable way to do things in an environment where you need to strictly control any modifications to the database. i.e., you (the java dev) don't make any, you call stored procedures, they make any changes necessary
|
# ? Mar 9, 2016 04:48 |
|
Notorious b.s.d. posted:pls don't write applications in pl/sql If you can propose a better way to pull in, process, and bill a bunch of static data every week, please let me know so that I can do better in the future.
|
# ? Mar 9, 2016 04:48 |
|
JewKiller 3000 posted:that is a reasonable way to do things in an environment where you need to strictly control any modifications to the database. i.e., you (the java dev) don't make any, you call stored procedures, they make any changes necessary That's what we do, we have a bunch of data that comes in on very specific criteria from a system of record, we store it in Oracle, all the data manipulation code lives in Oracle and the user front end stuff that defines how that data manipulation code is defined lives in Java, the rules are defined that way and communicated to Oracle via JDBC calls and validated internally. All data processing happens in PL/SQL, all user interface stuff is in Java.
|
# ? Mar 9, 2016 04:50 |
|
the main reason most developers hate stored procedures is that the dba won't grant them the necessary permissions for the cowboy coding they want to do in the database
|
# ? Mar 9, 2016 04:51 |
|
JewKiller 3000 posted:the main reason most developers hate stored procedures is that the dba won't grant them the necessary permissions for the cowboy coding they want to do in the database My main job is a DB dev and I ran into this recently, I found a hosed up piece of code from 2002 that was assigning date boundaries improperly and when I proposed that I wanted to change it UI people poo poo their pants. Turned out that instead of requesting that the DB code be fixed, they had been writing garbage poo poo workarounds in JDBC for six years.
|
# ? Mar 9, 2016 04:53 |
|
lmao yep sounds about right
|
# ? Mar 9, 2016 04:54 |
|
you are not obligated to write SPs in pl/sql oracle supports good languages, too
|
# ? Mar 9, 2016 05:00 |
|
JewKiller 3000 posted:lmao yep sounds about right I had to set a root cause analysis meeting where I pointed out that the problem (which resulted in losing billing for certain periods) was related to the original PL/SQL code and that there was no point in writing Java workarounds when the originating code could be fixed relatively easily. That's really frustrating when you're talking to people who already know what they want and aren't interested in your solution.
|
# ? Mar 9, 2016 05:00 |
|
Citizen Tayne posted:If you can propose a better way to pull in, process, and bill a bunch of static data every week, please let me know so that I can do better in the future. rpg II was good enough for your dad
|
# ? Mar 9, 2016 05:00 |
|
Notorious b.s.d. posted:rpg II was good enough for your dad This isn't an answer to my question. COBOL was good enough for my dad and is still in use for many of my current processes, too. Can you tell me why I shouldn't use PL/SQL for processing my data, or are you just spewing a bunch of poo poo?
|
# ? Mar 9, 2016 05:02 |
|
Citizen Tayne posted:I had to set a root cause analysis meeting where I pointed out that the problem (which resulted in losing billing for certain periods) was related to the original PL/SQL code and that there was no point in writing Java workarounds when the originating code could be fixed relatively easily. That's really frustrating when you're talking to people who already know what they want and aren't interested in your solution. as long as you didn't succumb to "ok ok fine how about this, i'll fix it in the database, and create a view for you guys that keeps doing it in the old broken way, so you don't have to do your jobs at all"
|
# ? Mar 9, 2016 05:05 |
|
JewKiller 3000 posted:as long as you didn't succumb to "ok ok fine how about this, i'll fix it in the database, and create a view for you guys that keeps doing it in the old broken way, so you don't have to do your jobs at all" That approach is exactly why I had to have the meeting to begin with This is not a racist statement, but our Java app team is entirely on-site Indian dudes who are incredibly insular and don't take well to interference or criticism, so when I said "You have to quit making gently caress-arounds in JDBC and account for a fix in the base system" I had an ungodly amount of push-back to work against.
|
# ? Mar 9, 2016 05:07 |
|
Citizen Tayne posted:That approach is exactly why I had to have the meeting to begin with This, btw, is what real software development work that solves actual problems is about.
|
# ? Mar 9, 2016 05:09 |
|
|
# ? May 22, 2024 04:33 |
|
we just roll our eyes and talk poo poo about managers and sales people most of the timeCitizen Tayne posted:This, btw, is what real software development work
|
# ? Mar 9, 2016 06:49 |