Re: [NF] How cheap is it to get SQL Server Developer? VERY
+1. Well done! John Weller 01380 723235 079763 93631 Sent from my iPad > On 11 Mar 2015, at 23:17, Virgil Bierschwale wrote: > > congrats > > -Original Message- > From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Kurt @ VR-FX > Sent: Wednesday, March 11, 2015 6:16 PM > To: profox@leafe.com > Subject: Re: [NF] How cheap is it to get SQL Server Developer? VERY > > Thank you to EVERYONE for their input in this Thread. > > FYI - I got the job offer today - and will be starting the new job in a > little over 2 weeks! > > :-) > - ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/e380a3c1-68d2-4f97-82d4-669d2653f...@jbweller.force9.co.uk ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Index Corruption / SMB
We have now applied the Enterprise Rollup and enabled SMB2 again, so I will see how it goes. Thanks Chris. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke Sent: 11 March 2015 09:51 To: profoxt...@leafe.com Subject: Re: Index Corruption / SMB I have never needed to go near any disk write caching settings since Windows 95/98 days. YMMV. There is also file lock caching to do with SMB. -- Alan Bourke alanpbourke (at) fastmail (dot) fm On Wed, 11 Mar 2015, at 09:11 AM, Allen wrote: > Does this mean that write ahead cache on the disk drive can be safely > left on? And is this win 7 and 8 or just servers? > Al > > -Original Message- > From: Dave Crozier > Sent: Wednesday, March 11, 2015 9:20 AM > To: profoxt...@leafe.com > Subject: RE: Index Corruption / SMB > > +1 for Alan's comment. SMB3 seems to have cured all the cache problems > inherent with SMB1/SMB2 > > Dave > > -Original Message- > From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Alan > Bourke > Sent: 10 March 2015 14:52 > To: profox@leafe.com; profoxt...@leafe.com > Subject: Re: Index Corruption / SMB > > > On Tue, 10 Mar 2015, at 02:32 PM, Man-wai Chang wrote: > > In addition to un-necessary caching, you also need to disable > > opportunistic locking (oplocks) in Samba. > > > No, you don't. Leave the caching alone. it's there for a reason. If > you're having to mess with caching on a regular basis, you need to be > looking at your program code. > > You *can't* turn off OpLocks under SMB2 and SMB3. You have to knock > everything back to SMB1 and then turn off OpLocks which to me is both > unnecessary and a bad idea. > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50b267080b15c148a824de4785a7451e83a3e...@dc4hs14exmbx06.os.local ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] How cheap is it to get SQL Server Developer? VERY
and me. good to hear good news for a change Al -Original Message- From: John Weller Sent: Thursday, March 12, 2015 9:19 AM To: profoxt...@leafe.com Subject: Re: [NF] How cheap is it to get SQL Server Developer? VERY +1. Well done! John Weller 01380 723235 079763 93631 Sent from my iPad On 11 Mar 2015, at 23:17, Virgil Bierschwale wrote: congrats -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Kurt @ VR-FX Sent: Wednesday, March 11, 2015 6:16 PM To: profox@leafe.com Subject: Re: [NF] How cheap is it to get SQL Server Developer? VERY Thank you to EVERYONE for their input in this Thread. FYI - I got the job offer today - and will be starting the new job in a little over 2 weeks! :-) - [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/47A300EF6053458689912C1498BC4EEC@GSL.local ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] How cheap is it to get SQL Server Developer? VERY
This is ONLY for your work and not at all for customers to use. It is FULL bore SQL server with all the bells and whistles in it allowing you to sell better versions of SQL to your clients. You get full BI, SSRS, SSIS, SSAS to learn how to work with all the no cost add-ons to paid for Sql Server. http://goo.gl/r8m0CG We use this on our TEST server because license is nothing compared to Enterprise license fees. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajidmy+8bocmyksdkmg6p2djcnhwxenkg_qw+e_ebtdhbh8...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Password managers - worth it? Anyone using in combination with a 2-factor authentication service?
In the case of 2-factor authentication, if someone stole your private key, you would have the same problem as a simple password. That's why some private key supports a password. The master password for tools like KeePass or LastPass is just an added fence. On Thu, Mar 12, 2015 at 5:26 AM, Malcolm Greene wrote: > 1. The use of a single master password scares me. If this password gets >discovered (key logger?) then all my passwords are exposed. -- .~. Might, Courage, Vision. SINCERITY! / v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3) /( _ )\ http://sites.google.com/site/changmw ^ ^ May the Force and farces be with you! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAGv=mjcc0umqqaenmvqnpcvv1jeidb9qy4h4s+b+wj5ht2s...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] How cheap is it to get SQL Server Developer? VERY
+1 from here as well Kurt! Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of John Weller Sent: 12 March 2015 08:20 To: profox@leafe.com Subject: Re: [NF] How cheap is it to get SQL Server Developer? VERY +1. Well done! John Weller 01380 723235 079763 93631 Sent from my iPad > On 11 Mar 2015, at 23:17, Virgil Bierschwale wrote: > > congrats > > -Original Message- > From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Kurt @ > VR-FX > Sent: Wednesday, March 11, 2015 6:16 PM > To: profox@leafe.com > Subject: Re: [NF] How cheap is it to get SQL Server Developer? VERY > > Thank you to EVERYONE for their input in this Thread. > > FYI - I got the job offer today - and will be starting the new job in > a little over 2 weeks! > > :-) > - [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/18725b8cd2d5d247873a2baf401d4ab2468c9...@ex2010-a-fpl.fpl.LOCAL ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Password managers - worth it? Anyone using in combination with a 2-factor authentication service?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 03/11/2015 04:26 PM, Malcolm Greene wrote: > I've seen posts on this forum extolling the virtues of password managers > like 1Password and LastPassword. Wondering if anyone has used one of > these type of products and gone back to self managing their passwords > and if so, why? Any enthusiastic users with a recommendation on a > specific product? I'm also curious if anyone is using Apple's Keychain > as their primary password manager. I've been using LastPass for about 4 years now, and wouldn't ever go back to anything else. It makes using reasonably secure passwords a no-brainer. > I've been using a XKCD-type method for generating easy to remember > passwords that are hard to break [1] and adding a non-obvious domain > name derived suffix to my base complex password for each login site. So you have to do mental gymnastics every time you go to a site in order to remember your password? The older I get, the less appealing that is to me. Also, the model proposed by XKCD is not always considered very good: https://diogomonica.com/posts/password-security-why-the-horse-battery-staple-is-not-correct/ ( -or- http://bit.ly/1AhyXjn ) > 1. The use of a single master password scares me. If this password gets >discovered (key logger?) then all my passwords are exposed. Well, that pretty much goes for any approach. If I keylogged your computer, I'd quickly learn your password scheme, and could probably figure out your domain-name trick. Once your physical machine is compromised, you're hosed. Don't count on any technique to keep you safe in that event. > 2. I work in very locked down environments that don't allow the >installation of password manager applications, browser extensions or >even access to their websites. Trying to copy a giant randomly >generated password from a password manager on my mobile phone sounds >like a logistical nightmare. LastPass for iOS makes this super-easy. I use it all the time. > 3. What happens if I don't have access to a personal device with a >password manager and I need to sign into a site with a huge randomly >generated password? Sounds like I would be SOL? Yeah, pretty much. If you have your phone, you could look it up and type the big-ass password manually, but that isn't fun. It boils down to how much convenience you are willing to trade for security. - -- Ed Leafe -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.14 (GNU/Linux) iQIcBAEBAgAGBQJVAZXkAAoJEKMgtcocwZqLXe0P/2Vm4WVbgz223EkeM7zLH5ho fIUJ9qHeWM6do/itoytGv6AW5cZCfF/QOhLISxred9ZWNLLBuOnMfM9sIKVawiMU oCa4MXfBDfpIvpyHH4wz/r+16e83vtyc2u+Zx+2RKP2yXRf3nPXJzJYNbk9+YOZf wR2lGbNsE84nLHkgznXNj7d6oUfnwMoTcckZaz+jZeWLh3fOptC5k7P0y5qtuOqR egbjtT3DupRimoLjaJtkTakBDt868ZOMEEcf4X+7KcJw9fQ+fwefKgmoSRs2PgFB K+UfYCfOaIa5I0w7l9FWGoSCrbZ1qT1oX7280ui0bIKZLOnI9wmCU8dtR21c/YsZ JX0kbdKEEeeTbfvR7h/y9KMP3jDL4qj4PjQ60ACeFQgWGkueOnnGvmUt6sZafnHD S/uXeOfImf8Kg7RR0tCrx/laBYU7lX3Tq7/cB3WnnXJMhfmkanzKLgrcRMJLjTad kxkrsVUPQsL0epg6QAq/rlZ2KmlF8rtw8NJXTSLr/D2UFqjrB5wWLpnEw0hShVKB JdoMXR0IBKd+J5P0IlzEfJmGf1B6nfPJ9/mIhPCuAoX6uacQ9XZbYTiIvCmn89xc 3vQIUemU5w3d8sOkzc7rGgU+5d3KBC7kXDTdRG+M1+SO5mTw6wczGQC+IX1o+0Oj ia3OXcEsnxCWR+G9c910 =wYoW -END PGP SIGNATURE- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/550195e4.3000...@leafe.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: RE: [NF] How cheap is it to get SQL Server Developer? VERY
Thanks Virgil! - Original Message - From: Virgil Bierschwale Date: Wednesday, March 11, 2015 7:17 pm Subject: RE: [NF] How cheap is it to get SQL Server Developer? VERY To: profoxt...@leafe.com > congrats > > -Original Message- > From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Kurt > @ VR-FX > Sent: Wednesday, March 11, 2015 6:16 PM > To: profox@leafe.com > Subject: Re: [NF] How cheap is it to get SQL Server Developer? VERY > > Thank you to EVERYONE for their input in this Thread. > > FYI - I got the job offer today - and will be starting the new > job in a > little over 2 weeks! > > :-) > -K- > > On 3/11/2015 5:27 PM, Stephen Russell wrote: > > On Wed, Mar 11, 2015 at 4:10 PM, Ted Roche > wrote: > > > >> On Wed, Mar 11, 2015 at 3:13 PM, Richard Kaye > >> wrote: > >>> Good to know, Vince, and I gladly stand corrected. MS was > not so > >> generous with the tools in the past. > >> > >> Wonder why that it. > >> > >> That's sure going to be a tough price for PostgreSQL to match :) > >> > >> > >> > > It is when you get out of the core database that you start to > pay for > > "tools" such as BI that power end users to real developers can > easily > > put out content from dashboards to graphs to output in excel > as well > > as those good ole 1000 page EOY reports. > > > > It is repeated over and over that what you don't pay for in > licenses > > you seem to pay for in extra development time. > > > > Not knocking the product at all. Just bringing to light that > > resources to work with that fantastic free product do have a > heavy cost > over time. > > > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/e7bacf452e67.55019...@optonline.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] How cheap is it to get SQL Server Developer? VERY
Agreed! Thanks! -K- - Original Message - From: Allen Date: Thursday, March 12, 2015 4:28 am Subject: Re: [NF] How cheap is it to get SQL Server Developer? VERY To: profoxt...@leafe.com > and me. good to hear good news for a change > Al > > -Original Message- > From: John Weller > Sent: Thursday, March 12, 2015 9:19 AM > To: profoxt...@leafe.com > Subject: Re: [NF] How cheap is it to get SQL Server Developer? VERY > > +1. Well done! > > John Weller > 01380 723235 > 079763 93631 > Sent from my iPad > > > On 11 Mar 2015, at 23:17, Virgil Bierschwale > wrote: > > > > congrats > > > > -Original Message- > > From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of > Kurt @ VR-FX > > Sent: Wednesday, March 11, 2015 6:16 PM > > To: profox@leafe.com > > Subject: Re: [NF] How cheap is it to get SQL Server Developer? VERY > > > > Thank you to EVERYONE for their input in this Thread. > > > > FYI - I got the job offer today - and will be starting the new > job in a > > little over 2 weeks! > > > > :-) > > - > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/e669ce724fae.55019...@optonline.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] How cheap is it to get SQL Server Developer? VERY
Thanks John! :-) -K- - Original Message - From: John Weller Date: Thursday, March 12, 2015 4:19 am Subject: Re: [NF] How cheap is it to get SQL Server Developer? VERY To: profoxt...@leafe.com > +1. Well done! > > John Weller > 01380 723235 > 079763 93631 > Sent from my iPad > > > On 11 Mar 2015, at 23:17, Virgil Bierschwale > wrote: > > > > congrats > > > > -Original Message- > > From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of > Kurt @ VR-FX > > Sent: Wednesday, March 11, 2015 6:16 PM > > To: profox@leafe.com > > Subject: Re: [NF] How cheap is it to get SQL Server Developer? VERY > > > > Thank you to EVERYONE for their input in this Thread. > > > > FYI - I got the job offer today - and will be starting the new > job in a > > little over 2 weeks! > > > > :-) > > - > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/e669d28224d4.55019...@optonline.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] How cheap is it to get SQL Server Developer? VERY
On Thu, Mar 12, 2015 at 12:57 AM, Christof Wollenhaupt < christof.wollenha...@foxpert.com> wrote: > On Wed, Mar 11, 2015 at 8:15 PM, Stephen Russell > wrote: > > > 10 gigs just gets you more time till you > > start to run out of space so learn how to shrink logs. > > > > There should never be the need to shrink logs. Growing logs are a sign of a > misconfigured or misused system: > > - The recovery model isn't set according to the database's role > - No backup strategy exists > - Temporary data is written into the production database > - DML commands are used thoughtlessly like updating the same values or > using DELETE/INSERT instead of UPDATE. > -- > Translates to the fact that this is a whole lot bigger scope than just a dbf experience. Knowing about a backup and how to restore from one is very important. Knowing how to take a db off line and why is as well. Any RDBMS, no VFP is not in this list, has ways to help protect itself but few users have a clue as to how to use them when you use Express. ?? Temp data is written into the database? I think you mean Transactions are written to the .log of the database unless you override that. DML or CRUD is how you get Transactions for that log. We had a process that digested deposit ACH details to determine which care facilities were going to receive their payment(s). Average intake of case 600,000 USD and we could divide it 70% of funds knew who were getting paid because they used IDs in depost data, 20% we had a real good guess the $$$ amounts tied to outstanding claims, and 10% we had no clue so that money went into a slush fund used to pay of every claim at it's drop dead time frame. That process would generate about 2 gig of transaction log bloat a day. When I got to the company the db was 15 gig and the log was 400+ gig. Cleaned that up and set up transaction log shipping to our secondary data center. Knowing what logs are are pretty important. Delete * from ... make log trash where truncate table ... keeps it real clean. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajidmy+r0j6j8rfpn2u7bqw4dj2a5ybukewvf7fvqhxmtl2...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] How cheap is it to get SQL Server Developer? VERY
On Wed, Mar 11, 2015 at 7:15 PM, Kurt @ VR-FX wrote: > Thank you to EVERYONE for their input in this Thread. > > FYI - I got the job offer today - and will be starting the new job in a > little over 2 weeks! Great news! Best of luck with the new job! -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cacw6n4ssisproyeqz1rhe2nfkwfifrpflr+bivve0ved75o...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] How cheap is it to get SQL Server Developer? VERY
Thanks Ted! - Original Message - From: Ted Roche Date: Thursday, March 12, 2015 9:55 am Subject: Re: [NF] How cheap is it to get SQL Server Developer? VERY To: profoxt...@leafe.com > On Wed, Mar 11, 2015 at 7:15 PM, Kurt @ VR-FX > wrote: > > Thank you to EVERYONE for their input in this Thread. > > > > FYI - I got the job offer today - and will be starting the new > job in a > > little over 2 weeks! > > Great news! Best of luck with the new job! > > -- > Ted Roche > Ted Roche & Associates, LLC > http://www.tedroche.com > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/e7c3d7753bd7.5501a...@optonline.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] How cheap is it to get SQL Server Developer? VERY
On 3/11/2015 5:27 PM, Stephen Russell wrote: On Wed, Mar 11, 2015 at 4:10 PM, Ted Roche wrote: On Wed, Mar 11, 2015 at 3:13 PM, Richard Kaye wrote: Good to know, Vince, and I gladly stand corrected. MS was not so generous with the tools in the past. Wonder why that it. That's sure going to be a tough price for PostgreSQL to match :) It is when you get out of the core database that you start to pay for Of course, and the most expensive is M$. Interestingly I did have a recent success last year: I got a couple folks fired for recommending MS SQL-Server - got 0 results for costs expended, And they hadn't even suggested using an Open Source DB as a starting point for their proof of concept. Good riddance, the company wins, the company's customers win. Need to weed out more "so-called experts" in the same way. But I digress... Not knocking the product at all. Just bringing to light that resources to Of course, you're trying to knock the product, you're an MS-head. I myself was going to ask if Ken knew for sure that the job used only MS-SQL. If they're not committed, or at least open-minded, he might make a good name for himself by suggesting investigating PostgreSQL. As M$ spirals down into death, a lot of companies are looking for alternatives. It'd be good to be ahead of that curve. But it is very true that database design is about the biggest determining factor of a "good" application. I've seen the most horrible designs created by MS-certified/Oracle-certified folks (in MS-SQL and Oracle). Recently I gen'd up a VFP app for team in a few days, using VFP dbfs, and they were stunned (software dev is not the role I'm currently filling). Showed them good uses of relational integrity, triggers, stored procedures, blah blah blah. Incredible, just incredible, the level of stupidity in the computer industry today. But at least they know MS-SQL server! ROFLMAO. -Charlie ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5501ae25.50...@verizon.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] How cheap is it to get SQL Server Developer? VERY
On Thu, Mar 12, 2015 at 2:54 PM, Stephen Russell wrote: > When I got to the company the db was 15 gig and the log was 400+ gig. > -- > Stephen Russell > > ROFL A+ jml --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/capqlobxbasafm2gkmybuphn9ptsgi+wrakgb60lsnnpxkwb...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] How cheap is it to get SQL Server Developer? VERY
On Thu, Mar 12, 2015 at 10:27 AM, Jean Laeremans < laeremans.jeanma...@gmail.com> wrote: > On Thu, Mar 12, 2015 at 2:54 PM, Stephen Russell > wrote: > > > When I got to the company the db was 15 gig and the log was 400+ gig. > > -- > > Stephen Russell > > > > > ROFL > - They thought that they had so much data! There was 200 gig free on the drive so they were not concerned as of yet. hahahahaha -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJidMYJDreK69r0WeV5CSp=o7treoyd_yo+vis+qwhpfvpq...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] How cheap is it to get SQL Server Developer? VERY
In the 70ties all properties, owners etc. of Belgium was contained in a 30 Gb hierarchical db which at the time was considered to be rather big A+ jml --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/capqlobzqm9hufysbud+yewpzpo_88_ncktu199oo2vv0pdj...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] Is your SQL Server a clown car?
http://www.brentozar.com/archive/2015/03/ten-ways-tell-sql-server-clown-car/ -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajidmyj-xwjk7t-h2tovbsrgxiabsmouukexi2qtawfgk4s...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] How cheap is it to get SQL Server Developer? VERY
> > Temp data is written into the database? I think you mean Transactions are written to the .log of the database unless you override that. What I mean is data temporarily being loaded into the database. I've often seen import processes implemented by loading data into a processing table in the main database, then have some process go through this data to integrate this into the actual tables. The proper way to handle this would be to load that raw input data into a separate database that uses simple recovery. Then process the table and only update those records in the main database that need to be updated. The biggest problem of MS SQL server is that it's so easy to use, but so hard to use correctly. MS made SQL server so accessible to developers and users that hardly anyone operating an MS SQL server has any clue what they are doing. -- Christof --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAL4QJhgJ=T0jm-82BWRX_5Pb_3w20g+sRvYSzFR=ke755cj...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] How cheap is it to get SQL Server Developer? VERY
On Thu, Mar 12, 2015 at 12:11 PM, Christof Wollenhaupt < christof.wollenha...@foxpert.com> wrote: > > > > Temp data is written into the database? I think you mean Transactions > > are written to the .log of the database unless you override that. > > > What I mean is data temporarily being loaded into the database. I've often > seen import processes implemented by loading data into a processing table > in the main database, then have some process go through this data to > integrate this into the actual tables. > > The proper way to handle this would be to load that raw input data into a > separate database that uses simple recovery. Then process the table and > only update those records in the main database that need to be updated. > > The biggest problem of MS SQL server is that it's so easy to use, but so > hard to use correctly. MS made SQL server so accessible to developers and > users that hardly anyone operating an MS SQL server has any clue what they > are doing. > -- Now I see your point. I call that a staging system where you bring every type of system's data into the mash pit and determine what needs to be updated in the Data Warehouse. 100% agree on simple recovery here. Use correctly? Wide range of correct answers there. Our ERP system considers the database to be just a data store with no intelligence associated with it. Everyone of our secondary apps for the business have their own db and use sprocs for all interaction with the api. The DW is only a staging but we advertise that in the db's name so we are not killing ourselves. We also have numerous cubes depending on the business type. Knowing how to allocate tempdb(s) is a nightmare across 5 instances of a prod server and I think I know what I am doing. Tweaking 3 different SSRS memory environments for 3 different major systems / instances is another joy. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajidmyj40yz-xqxe0maqwq5xpuo63gqmmoely7wsx1rqrr2...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] How cheap is it to get SQL Server Developer? VERY
>> FYI - I got the job offer today - and will be starting the new job >> in a little over 2 weeks! > > Great news! Best of luck with the new job! +1. -Jerry ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5501dcc1.28290.1c5...@jwolper.swanzoco.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] How cheap is it to get SQL Server Developer? VERY
Thanks Jerry!! -K- On 3/12/2015 6:36 PM, Jerry Wolper wrote: FYI - I got the job offer today - and will be starting the new job in a little over 2 weeks! Great news! Best of luck with the new job! +1. -Jerry [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/55023107.10...@optonline.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.