# https://www.rodneyellis.com.au llms-full.txt ## SQL Server Consultancy Services ## About Me I've built my IT career around taking businesses away from using legacy systems based around Excel & Access and converting them into modern, professional systems based on SQL Server. **I'm also an expert at making SQL Server run faster!** Although I've worked at many large companies such as [Credit Corp Group](https://www.creditcorp.com.au/), [William Hill](https://www.williamhill.com.au/), [DeLonghi](https://www.delonghi.com/en-au) , [PricewaterhouseCoopers](https://www.pwc.com.au/) and [Harvey Norman](https://www.harveynorman.com.au/) in various DBA & Developer Roles, I don't get as much satisfaction as when I do work for the smaller business. I currently have several consultancy contracts with small businesses within Sydney. If you want me to help your business, please get in touch. The two most common roles I do in my consultancy are: - **Remote / Virtual DBA** - **Performance Tuning** See the next section below for more information. Note - I live in the Sutherland Shire in Southern Sydney, and have an office in Caringbah. So if you're local please feel free to schedule an person meeting. Otherwise, like most IT professionals in the modern era, I can connect with you via Zoom, Teams, Google Meeting, or anything else you prefer! 🤓 ## Core Services * * * ### SQL Server Database Adminstration (DBA)  Fixed Cost! If you're in charge of a "small business" or team, then you don't need to pay someone to sit in a chair to check the daily backups. Leave it with me! For small nominal monthly fee, I will: - Setup your backups and other daily/weekly/monthly tasks (eg index rebuilding and statistics maintenance) \- and actually check the backups work (most people do not do this)! - Run corruption checks - Look for unexpected table/database growth - And give other recommendations on issues I see with your SQL Server System * * * ### Legacy System → SQL Server **Excel** has its place in a Business, but it **should not run the business**! If you're using Excel to do your CRM or anything else for that matter, then contact me to upgrade it to a SQL Server based system. Additionally, I have also done several upgrades from **Microsoft Access to SQL Server** too. * * * ### Speed up your SQL Database!   13 Point Check! Is your SQL Server grinding to a halt? Give me one hour to do an extensive 13 Point Check to find out why and give you recommendations on what to do. * * * ### Speak At Your Event! There are few things I enjoy more than teaching, and I am always looking for opportunities to speak to groups. I base my speeches around these two topics: 1. Why your business needs a database (non-technical) 2. How to build/develop a database needs a database (technical) If you would like me to come to your business or group, then please [Contact Me](https://stingrae.com.au/contact) ## My Formal Qualifications ![project name](https://rodneyellis.com.au/assets/images/mcse.png) * * * ![project name](https://rodneyellis.com.au/assets/images/mcsa.png) ## Work Experience ### Co-Founder & Lead Developer - [Startup Hub](https://rodneyellis.com.au/\#)(2020 - Present) Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a, tellus. Phasellus viverra nulla ut metus varius laoreet. Donec vitae sapien ut libero venenatis faucibus. Nullam quis ante. Etiam sit amet orci eget eros faucibus tincidunt. ### Software Engineer - [Google](https://rodneyellis.com.au/\#)(2019 - 2020) Vivamus a tortor eu turpis pharetra consequat quis non metus. Aliquam aliquam, orci eu suscipit pellentesque, mauris dui tincidunt enim. Sed fringilla mauris sit amet nibh. Donec sodales sagittis magna. ### Software Engineer - [eBay](https://rodneyellis.com.au/\#)(2018 - 2019) Maecenas tempus, tellus eget condimentum rhoncus, sem quam semper libero, sit amet adipiscing sem neque sed ipsum. ## My GitHub You can also embed your GitHub activities using Casey Scarborough's [GitHub Activity Stream](https://github.com/caseyscarborough/github-activity) widget. [Mark Otto](https://github.com/mdo) [mdo](https://github.com/mdo) [![](https://avatars.githubusercontent.com/u/98681?v=4)](https://github.com/mdo) 1 day ago [mdo](https://github.com/mdo) commented on pull request [twbs/bootstrap#41488](https://github.com/twbs/bootstrap/pull/41488) ![](https://avatars.githubusercontent.com/u/98681?) Agreed with Patrick, going to close out for now. 1 day ago [mdo](https://github.com/mdo) closed pull request [twbs/bootstrap#41488](https://github.com/twbs/bootstrap/pull/41488) ![](https://avatars.githubusercontent.com/u/98681?) Form Validation: Increase \`$form-feedback-font-size\` to make \`.invalid-feedback\` larger 2 days ago [mdo](https://github.com/mdo) commented on issue [twbs/bootstrap#41495](https://github.com/twbs/bootstrap/issues/41495) ![](https://avatars.githubusercontent.com/u/98681?) Very strange bug. Your fix doesn't work anymore because the selector is not specific enough. Smack an \`!important\` on there, or use \`.list-group-item... 4 days ago [mdo](https://github.com/mdo) closed pull request [twbs/bootstrap#41492](https://github.com/twbs/bootstrap/pull/41492) ![](https://avatars.githubusercontent.com/u/98681?) Add section to Download page for IntelliSense extension 4 days ago [mdo](https://github.com/mdo) created branch [intellisense-ext](https://github.com/twbs/bootstrap/tree/intellisense-ext) at [twbs/bootstrap](https://github.com/twbs/bootstrap) 4 days ago [mdo](https://github.com/mdo) closed pull request [twbs/bootstrap#41491](https://github.com/twbs/bootstrap/pull/41491) ![](https://avatars.githubusercontent.com/u/98681?) Add text-wrap balance and pretty to complement existing white-space utils 4 days ago [mdo](https://github.com/mdo) closed pull request [twbs/bootstrap#41490](https://github.com/twbs/bootstrap/pull/41490) ![](https://avatars.githubusercontent.com/u/98681?) Replace white-space utilities with text-wrap utilities, add new ones 4 days ago [mdo](https://github.com/mdo) created branch [v5/text-wrap-utils](https://github.com/twbs/bootstrap/tree/v5/text-wrap-utils) at [twbs/bootstrap](https://github.com/twbs/bootstrap) 4 days ago [mdo](https://github.com/mdo) created branch [v6/text-utils](https://github.com/twbs/bootstrap/tree/v6/text-utils) at [twbs/bootstrap](https://github.com/twbs/bootstrap) 5 days ago [mdo](https://github.com/mdo) commented on pull request [twbs/bootstrap#39099](https://github.com/twbs/bootstrap/pull/39099) ![](https://avatars.githubusercontent.com/u/98681?) This incorrectly changes the hover color of outline buttons, so we can't merge that at the moment. 8 days ago [mdo](https://github.com/mdo) commented on issue [twbs/bootstrap#41453](https://github.com/twbs/bootstrap/issues/41453) ![](https://avatars.githubusercontent.com/u/98681?) Search should be a bit better after today! We'll keep looking at things to see if there are alternatives or more improvements to be made here. 8 days ago [mdo](https://github.com/mdo) closed issue [twbs/bootstrap#41453](https://github.com/twbs/bootstrap/issues/41453) ![](https://avatars.githubusercontent.com/u/98681?) Bootstrap site search 8 days ago [mdo](https://github.com/mdo) commented on issue [twbs/bootstrap#41457](https://github.com/twbs/bootstrap/issues/41457) ![](https://avatars.githubusercontent.com/u/98681?) Never used SonarQube, but we have CVE analysis and security coverage as appropriate. Everything else is just opinions. 8 days ago [mdo](https://github.com/mdo) closed issue [twbs/bootstrap#41457](https://github.com/twbs/bootstrap/issues/41457) ![](https://avatars.githubusercontent.com/u/98681?) SonarQube Security Hotspots Identified in Bootstrap 5.3.5 - Potential Vulnerabilities 8 days ago [mdo](https://github.com/mdo) commented on issue [twbs/bootstrap#41476](https://github.com/twbs/bootstrap/issues/41476) ![](https://avatars.githubusercontent.com/u/98681?) https://getbootstrap.com/docs/5.3/examples/footers/ loads fine for me, if this is what you mean. 8 days ago [mdo](https://github.com/mdo) closed issue [twbs/bootstrap#41476](https://github.com/twbs/bootstrap/issues/41476) ![](https://avatars.githubusercontent.com/u/98681?) Footer link not working 8 days ago [mdo](https://github.com/mdo) deleted branch main-jd-enhance-box-shadow-mixin at [twbs/bootstrap](https://github.com/twbs/bootstrap) 8 days ago [mdo](https://github.com/mdo) pushed to [main](https://github.com/twbs/bootstrap/tree/main) at [twbs/bootstrap](https://github.com/twbs/bootstrap) - ![](https://gravatar.com/avatar/ec7db895ee3e4a17222533986d966543)[7f946d](https://github.com/twbs/bootstrap/commit/7f946d4241ef2b889428e576dc819b98fc8e69b6) Consolidate multiple 'none' values in \`box-shadow\` Sass mixin (#41... 8 days ago [mdo](https://github.com/mdo) closed issue [twbs/bootstrap#41381](https://github.com/twbs/bootstrap/issues/41381) ![](https://avatars.githubusercontent.com/u/98681?) When setting both $input-focus-box-shadow and $input-box-shadow to \`none\`, Bootstrap generates invalid CSS. 8 days ago [mdo](https://github.com/mdo) merged pull request [twbs/bootstrap#41469](https://github.com/twbs/bootstrap/pull/41469) ![](https://avatars.githubusercontent.com/u/98681?) Consolidate multiple 'none' values in \`box-shadow\` Sass mixin 1 commit with 199 additions and 5 deletions 8 days ago [mdo](https://github.com/mdo) closed pull request [twbs/bootstrap#41469](https://github.com/twbs/bootstrap/pull/41469). ![](https://avatars.githubusercontent.com/u/98681?) 8 days ago [mdo](https://github.com/mdo) commented on issue [twbs/bootstrap#41417](https://github.com/twbs/bootstrap/issues/41417) ![](https://avatars.githubusercontent.com/u/98681?) Closing for now, we can revisit in v6 if we want. 8 days ago [mdo](https://github.com/mdo) closed issue [twbs/bootstrap#41417](https://github.com/twbs/bootstrap/issues/41417) ![](https://avatars.githubusercontent.com/u/98681?) Increase size of h6 class to more clearly be a heading 8 days ago [mdo](https://github.com/mdo) deleted branch main-jd-fix-zip-examples-html-files at [twbs/bootstrap](https://github.com/twbs/bootstrap) 8 days ago [mdo](https://github.com/mdo) pushed to [main](https://github.com/twbs/bootstrap/tree/main) at [twbs/bootstrap](https://github.com/twbs/bootstrap) - ![](https://gravatar.com/avatar/ec7db895ee3e4a17222533986d966543)[e5b9f3](https://github.com/twbs/bootstrap/commit/e5b9f3714923c1848c2e8f1f3a296b04f1fad8e5) Fix HTML head content built from 'Download examples' button (#4146... 8 days ago [mdo](https://github.com/mdo) merged pull request [twbs/bootstrap#41468](https://github.com/twbs/bootstrap/pull/41468) ![](https://avatars.githubusercontent.com/u/98681?) Fix HTML \`\` content built from 'Download examples' button 1 commit with 3 additions and 3 deletions 8 days ago [mdo](https://github.com/mdo) commented on pull request [twbs/bootstrap#41468](https://github.com/twbs/bootstrap/pull/41468) ![](https://avatars.githubusercontent.com/u/98681?) Tested, looks great! 8 days ago [mdo](https://github.com/mdo) commented on issue [twbs/bootstrap#41453](https://github.com/twbs/bootstrap/issues/41453) ![](https://avatars.githubusercontent.com/u/98681?) We're still looking into this. For some reason, Docsearch is ignoring over a hundred URLs, most of the utilities pages. Nothing in the configuration h... 17 days ago [mdo](https://github.com/mdo) commented on issue [twbs/bootstrap#41453](https://github.com/twbs/bootstrap/issues/41453) ![](https://avatars.githubusercontent.com/u/98681?) I do feel like it's gotten worse. I'll have to look at the config for docsearch and see if we can improve. 18 days ago [mdo](https://github.com/mdo) deleted branch icons-112-113 at [twbs/blog](https://github.com/twbs/blog) Public Activity [GitHub Activity Stream](https://github.com/caseyscarborough/github-activity)