Click here to Skip to main content
15,885,757 members

Articles by wizardzz (Tip/Tricks: 2)

Tip/Tricks: 2

RSS Feed

Average article rating:

No articles have been posted.

Average blogs rating:

No blogs have been submitted.

Average tips rating: 4.67

Database Development
SQL Server
5 Apr 2011   Updated: 5 Apr 2011   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 5,120     Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
I would definitely include some security measures in here as they can compromise the data being stored. Though the system may remain up after a breach, it will be too late to prevent damage once it's done:16. By all means necessary, take measures against SQL injections. This is probably a...
Programming Languages
SQL
19 Apr 2011   Updated: 19 Apr 2011   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: CPOL    Views: 22,290     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
Time remaining of Database Shrink
25 Jul 2011   Updated: 1 Aug 2011   Rating: 4.33/5    Votes: 3   Popularity: 2.07
Licence: CPOL    Views: 12,411     Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
It also limits SQL's ability to find a proper index to use, hence hindering performance. I wasn't aware of this aspect until a SQL consultant made mention of it. Unfortunately we haven't adopted the policy of dropping the *.

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.
Chief Technology Officer
United States United States
What I get paid or have been paid to do:
Sports data (NBA, NCAA)
Restaurant data - menus, locations, sales history, foot traffic, dwell time.
IOT - logistics and mining
Trading software and protocols (QuickFIX, Onix, etc).
Price feed development.
Trader simulation tools.
Back office, end of day reporting, NFA compliance.
Performance testing, optimization, and analysis.
Large scale data management, analysis, and visualization.
Worked with most major banks, some electronic exchanges, many data providors, and a few counter-parties:
MISO, PJM, NYISO, NEISO, CAISO, AESO, ERCOT, BOE, CME, CBOE, Eurex, ICE, Morgan Stanley, J.P. Morgan, RBS, EBS, Credit Suisse, Nomura, Barclays, Deutsche Bank, Citibank, UBS, Goldman Sachs, Bear Stearns (defunct), Triaina, Bloomberg
Experience in FX, energies, futures.