Click here to Skip to main content
15,072,134 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
Posted: 5 Apr 2011   Updated: 5 Apr 2011   Views: 4,630   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      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
Posted: 19 Apr 2011   Updated: 19 Apr 2011   Views: 21,150   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
Time remaining of Database Shrink
Posted: 25 Jul 2011   Updated: 1 Aug 2011   Views: 10,370   Rating: 4.33/5    Votes: 3   Popularity: 2.07
Licence: The Code Project Open License (CPOL)      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.

wizardzz
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.