Illuminerdy IT
Information Technology & Services - Florence, Kentucky, United States
Illuminerdy IT Employees
Illuminerdy IT Details
I can share the tips and tricks I have seen over my 25+ years of working with SQL server and other database engines…Where I can help?• Intermediate to Advance T-SQL Training – Do you have a process or query that you believe can run faster than it should? Have you increased the available hardware resources and the problem still exists? Added all the missing indexes you were advised to add, and maybe a few more and that barely made a dent in execution time? The issue might be how the query was written. How your query is written can determine if you get your results in hours, minutes, or seconds. I can share my process and what I look for when writing a query for performance.• Process Optimization – Do you have an existing process that you suspect takes longer to run than it should? Have me take a look at the process to see if steps can be optimized or consolidated for a quicker run.• Table object metric auditing – Have a mature environment that has seen numerous changes over the years. Did you make a change, but left an index that is no longer needed "just incase" then forgot about it? I can help you clean up old indexes and make sure your current indexes and stats are current.• ETL – Do you have data that needs to be brought in or sent out of your environment? I can help!• Data Modeling/Architecture – Starting from scratch or updating what you already have, I can help plan out the schema for your data environment.I can help with this and more. Have a project you want to take a look at. Reach out to me with details of what is expected in your project.
Illuminerdy IT Technologies
Load Balancers
Apache
CMS
WordPress.org
Fonts
Google Font API
Other
Mobile Friendly
CSS and JavaScript Libraries
Bootstrap Framework