January 28, 2016 at 2:10 pm
Do NOT mean to bite the hand that feeds me.
Yeah But....
I was a SysAdmin (large IBM and HP UNIX severs). The DBA wanted all the disk, all the I/O threads, and all the CPU. For HIS PIDs.
If the users could not get to HIS DB. HIS DB/SQL environment was NOT the problem!
During root cause analysis HE always made it a point to say:
It was the hardware, network or operating system that were having problems.
I'm now a newbie learning about DB servers and T-SQL, for my investment purposes and having fun doing it.
The DBA had an easy job! Just reading forums with great solutions!!!!
June 21, 2024 at 7:13 pm
It appears this discussion has been dormant for about eight years, but could have some interesting perspectives. Let me hear from you.
I retired 4/30/2010 after 42 years in IT, but still use my systems every day. I'm into digitizing 100-year-old b&w photos, 35mm slides, etc, love my digital music library, and use SL Server to analyze my now-digitized 80 years of financial history. My home office shared with my wife has seven computers for various purposes.
Rick
Disaster Recovery = Backup ( Backup ( Your Backup ) )
June 21, 2024 at 7:22 pm
I'm now a newbie learning about DB servers and T-SQL, for my investment purposes and having fun doing it.
seboldj, tell me more about your use of SQL for your investment purposes. I export 38 years of files, 80 years of financial data to my custom SQL Server db - a work in progress.
Rick
Disaster Recovery = Backup ( Backup ( Your Backup ) )
June 24, 2024 at 9:30 pm
Hello!
You are way more data rich than I.
Basically I track all Vanguard lineup, S&P 100, and the Dow Jones Composite. Only on a weekly basis. Saturday is a busy day for me. I keep no more then 4 years of data.
I use sql to do momentum investing with different time frames. Calculating Z-scres, Regression, Skewness, and Relative strength, etc
I stared in 2005 and avoided the big drawdown of 2007-2008, and 2020.
I share my data analysis via excel with my children when they are interested End of Month/ Quaterly.
June 25, 2024 at 3:14 pm
Hello!
You are way more data rich than I.
Basically I track all Vanguard lineup, S&P 100, and the Dow Jones Composite. Only on a weekly basis. Saturday is a busy day for me. I keep no more then 4 years of data.
I use sql to do momentum investing with different time frames. Calculating Z-scres, Regression, Skewness, and Relative strength, etc
I stared in 2005 and avoided the big drawdown of 2007-2008, and 2020.
I share my data analysis via excel with my children when they are interested End of Month/ Quaterly.
I'm sure you are more mathematically inclined than I am. I'm not really up to date with archiving my data since my active file begins with 2010 for active cash accounts. My oldest investment records begin in 1944 when my Dad bought a life insurance policy for me with face value of $1000. But it has paid dividends and interest on deposits every year since then. Over the years with Quicken I entered all my data and got rid of all the paper. My first serious investments on my own began in 1974 when I had a profit-sharing plan at work that was the basis for my retirement savings. I have kept all my investment activity for all the years in my active file for historical reporting. Most of my SQL efforts have been to be able to query and organize data so I could clean it back in Quicken and organize it for reporting. (My early efforts were not all that good). My approach for the insurance assets has been to create three securities for each policy, those being face value, dividends and interest all with a 'share value' of $1.00 which I can then use for net worth reporting by including any or all 'securities'.
Digitizing all my data and all my wife's data from her business has resulted in a row of seven empty 4-5 drawer file cabinets in our basement that no one seems to even use any more. I offered them free on our neighborhood website and got no takers. I had to buy my second NAS device because the first 4-drive unit was too small since I failed to consider bios limitations on drive size. My laptop now has lots of mapped network drives - 8 in NAS servers, 6 in docking stations, and 4 on a USB port stick. As data ages I tend to burn it to DVD's and there are a couple hundred of those, stored next to my boxes of over 500 music CD's.
You can see how my OCD manifests itself.
Rick
Disaster Recovery = Backup ( Backup ( Your Backup ) )
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply