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

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 month180
Total points6,456,705
Questions: 6
Solutions: 3900
Articles: 11
Videos:
Tutorials:
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 message me using the EE system.

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 :
https://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/A_653-Dynamic-Pivot-Procedure-for-SQL-Server.html
https://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) :
https://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/A_657-Managing-the-Transaction-Log-for-the-Accidental-DBA.html
https://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/A_691-Managing-Fragmentation-for-the-Accidental-DBA.html

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

Consulting :
https://www.experts-exchange.com/ITPro/Consulting/A_3217-The-importance-of-Value-in-Business.html
https://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 41,295 points to level up.
LVL 57
  • Overall
    56
  • Microsoft SQL Server
    41
  • Microsoft SQL Server 2005
    34
  • SQL
    32
  • Microsoft SQL Server 2008
    31
  • Databases
    20
  • Microsoft Access
    12
  • MySQL Server
    10
  • .NET Programming
    10
  • Consulting
    8
  • Microsoft Development
    7
  • SSRS
    7
  • Visual Basic.NET
    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
  • Project Management
    3
  • Miscellaneous
    3
  • Enterprise Software
    3
  • Software
    3
  • Editors IDEs
    3
  • Web Languages and Standards
    3
  • Windows OS
    3
  • Server Hardware
    3
  • Big Data
    3
  • Microsoft Server Apps
    3
  • SBS
    3
  • Microsoft SharePoint
    3
  • Storage
    3
  • Microsoft Visual Studio
    3
  • Delphi
    3
  • Analytics
    3
  • Sybase Database
    3
  • Windows Networking
    3
  • Programming Languages-Other
    3
  • Web Applications
    3
  • JavaScript
    2
  • Microsoft Office
    2
  • Outlook
    2
  • Active Directory
    2
  • IT Administration
    2
  • DB2
    2
  • PostgreSQL
    2
  • Programming Theory
    2
  • ColdFusion Language
    2
  • Storage Hardware
    2
  • Scripting Languages
    2
  • Microsoft IIS Web Server
    2
  • Windows Batch
    2
  • VBA
    2
  • Office Suites-Other
    2
  • Azure
    2
  • Powershell
    2
  • Exchange
    2
  • VMware
    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
  • Remote Access
    1
  • jQuery
    1
  • Unix OS
    1
  • AWS
    1
  • Windows Server 2012
    1
  • Virtualization
    1
  • Microsoft Legacy OS
    1
  • COBOL
    1
  • .NET App Servers
    1
  • Power BI
    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
  • LINQ Query
    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
  • Encryption
    1
  • ACT
    1
  • Email Clients
    1
  • AWS RDS
    1
  • Microsoft Visio
    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