Glasgow: 14th November: SQL Server Evening

Introduction of Reporting services and it fits into your organisation and setup of backend reporting databases. Also a tour of getting started with reporting services with a look at best practices. Practical examples covering the how develop different types of reports. Briefly touches on integrating Reporting Services with .NET applications.

 

Frank Kerrigan has been in development and support of large enterprise systems for 15 years. He is currently lead developer for UK PLC Insurance Company; running a development team developing C# and SQL Server. First got the programming bug programming 6502 assembly while doing electrical engineering at College in the 1980s and moved quickly into IT. He has extensive experience in manufacturing, software development, consultancy and IT management as PKI security which he has written a few patents for two fledgling start-ups. He can be found hanging round Code Project and Scottish Developer community sites and has written a few articles in SQL Server, ASP.NET and Reporting Services.

 

Although SMO was available for SQL Server 2000, in SQL Server 2005 the object model has vastly improved with just about every conceivable SQL Server object represented as a managed object. We take a look at a practical example of SMO as we build an MSI installer for a database.

 

Steve Phillips has been in development for 22 years with a short break to concentrate on network systems gaining an MCSE into the bargain. He is currently the development manager for a UK PLC Insurance Company; managing a development team developing in C# and SQL server for the .NET 3.0 development platform. Whilst at Southampton University in the early eighties he worked on a practical implementation of the B+ tree indexing model from a theoretical paper. Steve chose to write the indexing system in C, newly imported direct from Bell Labs USA. This indexing system formed the basis of the Sybase database management system later, under license from Sybase, to become SQL Server. His most significant achievement was, as part of the Human Genome Project, to project manage, and support, the building of a Windows network to connect the GlaxoWellcome (now GSK) project team to the data centre in Wisconsin, Canada for the recording and publishing of GSK’s part of the Human Genome. His most dramatic blooper was to turn down an offer from a tiny book publisher to assist them with putting their books onto CD. The publisher came to be known as Dorling Kindersley (doh!).