SQL Server Development

SQL Server Services are offered in the areas of designing, developing and maintaining a database.  Also in integrating the database into other reporting and development platforms.

Database Development is something that I have spent a long time doing professionally.  I have worked on databases from 1MB to 30TB in size, so have a wide range of experience.

In brief I have listed a few areas that maybe of interest, however if there is something that is not listed please contact me and I can discuss it further.

Database Design - Creating Normalisation Documentation and creating database designs

Creating Database Objects and Stored Procedures - From the design database objects can be created and any views, functions and stored procedures to help with integration into reports and other applications.

Creating CLR Store Procedures - Sometimes not all functionality can be served efficiently from a standard stored procedure. 

Creating Data Access Layers - Development of Data Access Classes to integrate into a .NET development, including all functions to call any stored procedures and modify data.

SQL Server Administration - Sometimes the area that is forgotten about.  SQL databases need to be backed-up, reindexed, consistency checked + more.  

SQL Server Sizing - When implementing a new database, we need to ensure that the SQL server hardware is going to be able to cope with the CPU load as well as memory.  Additionally how much space is required?

 


These services complement these areas: