Services Offered:
|
|
• Analyze Current Database(s)
|
|
• identify performance issues
|
|
• identify problems or inconsistencies
|
|
• provide recommendations for improvements
|
|
• Refactor Current Database(s)
|
|
• standard transactional database
|
|
• operational data store (data lake)
|
|
• dimensional model data warehouse
|
|
• Design and Develop New Database(s)
|
|
• standard transactional database
|
|
• operational data store (data lake)
|
|
• dimensional model data warehouse
|
|
• Train SQL Server Professionals
|
|
• SQL Server database architecture
|
|
• T-SQL coding using standard material
|
|
• T-SQL coding using objects from database(s)
|
|
• Monitor SQL Server Instances
|
Areas of Specialty:
|
|
• Performance Tuning
|
|
• efficient, effective indexing
|
|
• efficient, flexible, and robust T-SQL code
|
|
• efficient, flexible, and compact data structures
|
|
• Database Architecture
|
|
• data modeling and data types
|
|
• primary keys and foreign keys
|
|
• database normalization (OLTP)
|
|
• T-SQL Coding
|
|
• stored procedures
|
|
• functions and views
|
|
• triggers and other objects
|
|
• Automation
|
|
• business data processing
|
|
• server/database monitoring
|
|
• server/database maintenance
|
