What is new in SQL Server 2008 that makes it worth seriously considering? What is the difference between Web, Standard and Enterprise? All these things are covered in this introduction to SQL Server 2008. This is a 200 level session intended to give you a overview of what the new capabilities and tools are in the product and where they will be useful to you.
There are many new changes in SQL Server 2008, particularly when upgrading from SQL Server 2000. Is it worth migrating? If so, where do you start? How can you approach this? What about DTS to SSIS migrations? This session will give you some considerations and approaches to take away with you to help you make the right decisions and the migration to SQL 2008 whether it be from SQL 2000 or SQL 2005.
Architecture is about ensuring that solutions are available and scalable. This includes thinking through how to allow other stakeholders get the most from the solution. This session will explore how much developers can do with SQL Server 2008 and how DBA’s should architect their implementation to provide the key features developers will build into their applications without compromising the service the database server provides. We will also look at and discuss the various architectures that you can consider when using SQL Server 2008 technologies.
Mirroring, clustering and replication have come a long way in SQL Server 2008. In addition there are new features such as the Resource Governor that will ensure that your mission critical applications never suffer from contention with other applications. This session will give you a solid understanding of these technologies and when to use them.
Managing SQL Server 2008 servers is easier than ever before. Check out how policy based management in SQL Server 2008 will reduce risks, how configuration servers allow you to group servers together for easier management and get an introduction into SQL PowerShell to really jump start your management framework.
The event itself is free to attend and is on in WLG, AKL and CHC. For more details on the registration or to sign up - you can follow these links:
Tuesday, November 4 - Wellington - The Brewery Bar (upstairs conference room) (Register) Wednesday, November 5 - Auckland - The Duxton Hotel (Register) Thursday, November 6 - Christchurch - Christchurch Convention Centre (Register)
Looking forward to seeing you all there :)
Hot on the heels of our very popular WPF Property Grid, we have followed up with a line of business focused control suite for WPF which we feel provides the "essential" controls for anyone developing line of business applications.
We have called this new offering WPF Elements and it includes the following controls:
Wellington SQL Server Meeting Notice
Our next meeting will be:-
13 March 2008 6pm
IntergenL7 Plunket House126 Lambton Quay(Lifts lock at 17:30. If you're late and there's nobody around to swipe you up, contact Adrian on 027 435 4050)
Peter Ward is visiting us from Australia and will make 2 presentations, with refreshments in between.
Peter Ward is WARDY IT Solutions Chief Technical Architect. Peter is an active member in the Australian SQL Server community and President of the Queensland SQL Server User Group. Peter is a highly regarded speaker at SQL Server events throughout Australia and is a sought after SQL Server consultant and trainer, providing solutions for some of the largest SQL Server sites in Australia. Peter is a regular author for several SQL Server websites and has published numerous articles in the monthly SQL Server newsletter that he produces along with the highly acclaimed WARDY IT Solutions SQL Server Blog. In 2007 Peter was selected as a speaker for Tech-Ed Australia, SQL Server Open World in Denmark and as a Spotlight speaker for the 2007 SQL Pass Community Summit, the largest SQL Server event in the world. Peter has also recently been awarded as a Microsoft Most Valuable Professional for his technical excellence and commitment to the SQL Server Community.
The topics of the presentations are:-
"SQL Server 2008 - What's new, and the business value it brings"
If only they taught SQL Server in Kindergarten… Bon Jovi had a hit song in the 90's with a chorus that I believe went something along the lines of 'The server is running slow, and your to blame, You give SQL Server a bad name'. If you look at most Information Technology courses today this parody often rings true. There are all sorts of exciting (and 'sexier') subjects such as Object Oriented Programming and Programming Abstraction but somehow the subject 'SQL Server 101' has been overlooked. As a result there are set of common mistakes that are made time and time again by developers that cause an application to negatively affect the performance of SQL Server. Peter Ward from WARDY IT Solutions (www.wardyit.com) will walk through some of the common Gotcha's when developing an application that accesses SQL Server and how to identify possible performance issues prior to deployment.
"Index, What Index? SQL Server Index Tuning"Unfortunately SQL Server does not ship with the 'Make SQL Server Go Faster' configuration option. Despite what appears to be an obvious lack of functionality, SQL Server does ship with a feature that is often misunderstood called an index. When an index is used correctly it can be the answer to the missing 'Go Faster' configuration option. New hardware and configuration changes can improve the performance of SQL Server by small percentages; however a simple CREATE INDEX statement can improve performance by large orders of magnitude. In this session, Peter Ward from WARDY IT Solutions (www.wardyit.com) will explain the basics of indexing in SQL Server and the strategies that you can employ to improve query tuning by understating how to identify and create effective indexes.
"You could just look at the BackgroundMotion project which used LINQ-2-SQL and used a Repository pattern (with UoW, InMemoryDB testing etc etc). "