Mark Wills
Topic Advisor
  • Australia
Member Since: 2008/03/25
Industry: Consulting
Top Skills:
Tech Certifications:
View All
Prodigy
Volunteer
Connect on Live
Hire

Love to Help

More bio
Activity
Points this month363
Total points5,264,734
Questions: 6
Solutions: 3380
Articles: 10
Videos:
Courses:
Posts:
Group Discussions: 32
Professional Background
No Professional Background shown
More
Education
UNSW
BSC
Science
MCAE
BMath
Industrial Mathematics
TAFE
Diploma
Commerce
TAFE
Diploma
Business
CDI
Diploma
Operations and Programming
More
Full Biography

Have survived close to 4 decades (give or take a couple of years) in the computer industry.

I am interested in helping pure and simple, and appreciate the acknowledgements of a heartfelt "Thank you" (though do get a smile when points come this way). I can assure you that I will try my upmost to assist, but it does require your input, and sometimes ask seemingly obscure questions to get to the bottom of things.

Please be interactive with your postings, give feedback, provide direction, give examples where possible. Wherever possible, I will recreate and test the answer before posting, hence the slight (?) delays. So, please help me to help you, if I do provide an answer, or if I do raise a question, give it some consideration before moving on to another post.


For EE specific contact please use <myusername> @ e-e.com

Humbled and privileged by being awarded Microsoft SQL Server MVP.

Articles I have written (would love you to read, and vote "yes", and leave comments) :

Pivot :
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/A_653-Dynamic-Pivot-Procedure-for-SQL-Server.html
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/A_4256-Dynamic-Pivot-Procedure-without-the-Pivot-function.html

Structure (and not just for the accidental DBA) :
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/A_657-Managing-the-Transaction-Log-for-the-Accidental-DBA.html
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/A_691-Managing-Fragmentation-for-the-Accidental-DBA.html

Other SQL :
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/A_651-Making-Sense-of-Index-DMV's-in-SQL-Server.html
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/A_1221-Fun-with-MS-SQL-spt-values-for-delimited-strings-and-virtual-calendars.html
http://www.experts-exchange.com/Database/Miscellaneous/A_12816-What-is-Big-Data.html
http://www.experts-exchange.com/articles/20059/T-SQL-formatting-Dates-and-Times-using-FORMAT.html

Consulting :
http://www.experts-exchange.com/ITPro/Consulting/A_3217-The-importance-of-Value-in-Business.html
http://www.experts-exchange.com/ITPro/Consulting/A_3220-Negotiating-Loss-for-a-Win-Win.html

More
Languages
Australian
Native or Bilingual Proficiency

Level Progress

Current: Level 51
Mark needs 143,266 points to level up.
LVL 52
  • Overall
    51
  • Microsoft SQL Server
    34
  • Microsoft SQL Server 2005
    33
  • Microsoft SQL Server 2008
    29
  • Query Syntax
    24
  • Databases
    17
  • Microsoft Access
    11
  • .NET Programming
    9
  • MySQL Server
    9
  • Consulting
    8
  • SQL
    8
  • Microsoft Development
    7
  • DB Reporting Tools
    7
  • Visual Basic.NET
    6
  • ASP.NET
    6
  • XML
    6
  • SSRS
    6
  • Oracle Database
    5
  • Windows Server 2008
    5
  • Windows Server 2003
    5
  • Microsoft Excel
    5
  • Visual Basic Classic
    4
  • C#
    4
  • Crystal Reports
    4
  • ASP
    4
  • SSAS
    4
  • Microsoft Server OS
    4
  • Microsoft Applications
    4
  • Web Development
    3
  • VB Script
    3
  • Miscellaneous
    3
  • Programming
    3
  • Enterprise Software
    3
  • Storage Software
    3
  • Project Management
    3
  • Web Languages and Standards
    3
  • SSIS
    3
  • PHP
    3
  • Server Hardware
    3
  • Software-Other
    3
  • Editors IDEs
    3
  • Microsoft Server Apps
    3
  • SBS
    3
  • Microsoft SharePoint
    3
  • Storage
    3
  • Programming Languages-Other
    3
  • Sybase Database
    3
  • Web Applications
    2
  • Delphi
    2
  • Big Data
    2
  • Windows OS
    2
  • Windows Networking
    2
  • Outlook
    2
  • Analytics
    2
  • Active Directory
    2
  • JavaScript
    2
  • Programming Theory
    2
  • DB2
    2
  • Storage Hardware
    2
  • Microsoft IIS Web Server
    2
  • ColdFusion Language
    2
  • Office Suites-Other
    2
  • IT Administration
    2
  • Networking
    2
  • Web Browsers
    2
  • Exchange
    1
  • Smartphone Programming
    1
  • Windows Batch
    1
  • Windows Vista
    1
  • Disaster Recovery
    1
  • E-Commerce
    1
  • Microsoft Dynamics
    1
  • Visual C++.NET
    1
  • Hardware
    1
  • PostgreSQL
    1
  • Office / Productivity
    1
  • Cloud Computing
    1
  • GIS/GPS Programming
    1
  • Anti-Virus Apps
    1
  • VBA
    1
  • OS Security
    1
  • Acronis
    1
  • Proofreading
    1
  • Network Management
    1
  • Web Servers
    1
  • System Utilities
    1
  • Security
    1
  • VMware
    1
  • Powershell
    1
  • Microsoft Legacy OS
    1
  • Microsoft Office
    1
  • .NET App Servers
    1
  • Server Software
    1
  • Windows 2000
    1
  • SSL / HTTPS
    1
  • AntiSpam
    1
  • WCF
    1
  • Internet Protocols
    1
  • Windows XP
    1
  • Java
    1
  • Scripting Languages
    1
  • IBM System i
    1
  • Web Development Software
    1
  • HTML
    1
  • DB Dev Tools
    1
  • Microsoft DOS
    1
  • Microsoft Forefront ISA Server
    1
  • Tax / Financial Software
    1
  • Components
    1
  • ACT
    1
  • Email Clients
    1
  • Microsoft Visio
    1
  • Encryption
    1
  • VPN
    1
  • Windows Live Mail
    1
  • Adobe Dreamweaver
    1
  • Linux
    1
  • Microsoft Visual Studio
    1
  • Operating Systems
    1
  • Perl
    1
  • Search Engine Optimization (SEO)
    1
  • Regular Expressions
    1
  • Internet Marketing
    1
  • Network Security
    1
  • Wireless Networking
    1
  • Broadband
    1
  • Laptops Notebooks
    1
  • Microsoft Hardware
    1
  • Productivity Apps
    1
  • Web-Based CMS
    1
  • Networking Hardware-Other
    1
  • System Programming
    1
  • Document Management
    1
  • Dell
    1
  • Internet / Email Software
    1
  • Project Management Software
    1
  • Chat / IM
    1
  • AWS
    1
  • C++
    1
  • CSS
    1
  • Document Imaging
    1
  • Technical Writing
    1
  • Unix OS
    1

Profile Validation

Email Verified
Expert Level Achieved
PayPal Connected