Mark Wills
Topic Advisor
  • Sydney,
  • New South Wales,
  • Australia
Member Since: 2008/03/25
Industry: Consulting
Top Skills:
Tech Certifications:
View All
  • Topic Advisor
Connect on Live

Love to Help
Give a man a fish and you've fed him for a day; Teach a man to fish and you've fed him for the rest of his life. Be the teacher

More bio
Activity
Points this month577
Total points6,277,745
Questions: 6
Solutions: 3865
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 56
Mark needs 220,255 points to level up.
LVL 57
  • Overall
    56
  • Microsoft SQL Server
    40
  • Microsoft SQL Server 2005
    34
  • Microsoft SQL Server 2008
    31
  • Query Syntax
    30
  • SQL
    20
  • Databases
    20
  • Microsoft Access
    12
  • MySQL Server
    9
  • .NET Programming
    9
  • Consulting
    8
  • Microsoft Development
    7
  • Visual Basic.NET
    7
  • SSRS
    7
  • DB Reporting Tools
    7
  • XML
    6
  • ASP.NET
    6
  • Oracle Database
    6
  • Microsoft Excel
    5
  • Windows Server 2008
    5
  • Windows Server 2003
    5
  • Microsoft Server OS
    5
  • PHP
    4
  • Visual Basic Classic
    4
  • C#
    4
  • SSAS
    4
  • ASP
    4
  • Crystal Reports
    4
  • SSIS
    4
  • Microsoft Applications
    4
  • Web Development
    4
  • Storage Software
    3
  • VB Script
    3
  • Programming
    3
  • Miscellaneous
    3
  • Enterprise Software
    3
  • Project Management
    3
  • Editors IDEs
    3
  • Web Languages and Standards
    3
  • Software
    3
  • Server Hardware
    3
  • Windows OS
    3
  • Microsoft Server Apps
    3
  • SBS
    3
  • Microsoft SharePoint
    3
  • Storage
    3
  • Microsoft Visual Studio
    3
  • Delphi
    3
  • Sybase Database
    3
  • Windows Networking
    3
  • Programming Languages-Other
    3
  • Web Applications
    2
  • JavaScript
    2
  • Big Data
    2
  • Analytics
    2
  • Outlook
    2
  • Microsoft Office
    2
  • Active Directory
    2
  • IT Administration
    2
  • DB2
    2
  • Programming Theory
    2
  • ColdFusion Language
    2
  • Storage Hardware
    2
  • Microsoft IIS Web Server
    2
  • Scripting Languages
    2
  • Windows Batch
    2
  • VBA
    2
  • Office Suites-Other
    2
  • PostgreSQL
    2
  • Azure
    2
  • Powershell
    2
  • Exchange
    2
  • Networking
    2
  • WordPress
    2
  • Web Browsers
    2
  • Smartphone Programming
    1
  • Windows Vista
    1
  • Disaster Recovery
    1
  • E-Commerce
    1
  • Microsoft Dynamics
    1
  • Visual C++.NET
    1
  • Hardware
    1
  • Office Productivity
    1
  • Cloud Computing
    1
  • GIS/GPS Programming
    1
  • Anti-Virus Apps
    1
  • Operating Systems
    1
  • OS Security
    1
  • Acronis
    1
  • Proofreading
    1
  • Business Management
    1
  • Network Management
    1
  • Web Servers
    1
  • System Utilities
    1
  • Security
    1
  • VMware
    1
  • Remote Access
    1
  • jQuery
    1
  • AWS
    1
  • Windows Server 2012
    1
  • Microsoft Legacy OS
    1
  • .NET App Servers
    1
  • Server Software
    1
  • Windows 2000
    1
  • SSL / HTTPS
    1
  • AntiSpam
    1
  • WCF
    1
  • Regular Expressions
    1
  • Internet Protocols
    1
  • Windows XP
    1
  • Java
    1
  • IBM System i
    1
  • Web Development Software
    1
  • HTML
    1
  • Network Analysis
    1
  • Network Operations
    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
  • Internet Explorer (IE)
    1
  • Linux
    1
  • Perl
    1
  • Search Engine Optimization (SEO)
    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
  • RAID
    1
  • System Programming
    1
  • Document Management
    1
  • Dell
    1
  • Internet / Email Software
    1
  • Project Management Software
    1
  • Chat / IM
    1
  • Robotics
    1
  • C++
    1
  • CSS
    1
  • Citrix
    1
  • Document Imaging
    1
  • REST
    1
  • Technical Writing
    1
  • Unix OS
    1

Profile Validation

Email Verified
Expert Level Achieved
PayPal Connected