ms sql
Pacific Fox™ has worked with Microsoft SQL Database Server on many occasions, and still recommends MS SQL Server for large application with high traffic that require high availability. Following are some short case studies providing a little more insight into where we implemented MS SQL solutions;
-
Tourism Queensland
At Tourism Queensland we created a Contacts Database that holds more than 100,000 records and gets searched on a very frequent basis. All the data was previously stored in Excel spreadsheets at different departments and locations, which caused a management nightmare, we consolidated all spreadsheets into one MS SQL database, cleansed the data, made it more manageable by putting an admin interface infront of it, made the data accessible over the intranet and published it as a web service with some data being directly published as XML from MS SQL.We utilised DTS to run the imports of the Excel files and transform the data.
-
Suncorp
At Suncorp we created a MS SQL Database that allowed the company to restructure departments, by importing employee data into one central location, we massaged the data and put an admin interface infront of it that allowed further changes to the data. -
In Spain we created a large banking application that at one stage was holding more than 1,000,000 records in the MS SQL Database, the database was storing customer and transaction details. Security and high availability was of high importance, thus we created a database cluster.