I will take on your sql, sql server and database projects
Über diesen Service
I'm Cory, a software developer with 8+ years of experience in SQL Server (MSSQL) and T-SQL. If your project involves a SQL database, send it my way.
Pick a package for queries:
- Query Fix: fix one broken T-SQL query and I'll explain what was wrong
- Query Tune Up: debug, analyze and optimize up to 2 queries
- Query Package: up to 4 queries, plus setting them up to run on a schedule
Need more than queries? Message me first and I can quote it as a custom offer:
- Data cleaning, validation and bulk corrections on large tables
- Data imports and automated pipelines (ETL)
- Migrating older databases, such as Access, to SQL Server
- Table design and schema reviews
- SQL Server backup, storage and cost reviews
- Connecting your database to other systems and APIs
Results from my own work: a property tax report cut from 20+ minutes to under 2, a 10M+ record data correction I led, delivered overnight with zero downtime, and a review I led of about 10 SQL Server instances that cut backup spend by about $800K a year.
I mainly work in SQL Server and T-SQL, and I also work with PostgreSQL. I hold a Certificate in Advanced SQL Programming.
Datenbanktyp:
Relationale Datenbank
Plattform:
SQL Server
Expertise:
SQL
•
Performance
•
Abfragenoptimierung
FAQ
What counts as one query?
One SQL statement counts as one query. A SELECT with CTEs and subqueries is still one query, however long it is. Two separate statements, such as two SELECTs, count as two. Scripts or stored procedures with many statements can be quoted as a custom offer, so message me first.
What do you need from me to get started?
The query, table structures, a few sample rows, what you expect back, and any error message. For slow queries, also the actual execution plan (.sqlplan) and row counts. Please use dummy data and do not send real personal data.
Which databases do you work with?
Mainly SQL Server and T-SQL. I also work with PostgreSQL. Tell me your database and version when you order.
Can you work on my live production database?
I'd rather work from the query text and table structures, or from a copy of the data, and agree on a plan with you before any change to live data.
Do you offer revisions?
Each package includes 1 revision for the same query. A new or different query is a new order.
What if my project doesn't fit a package?
Message me before ordering with a short description. I'll tell you whether I can help and send a custom offer.
