Loads of SQL Server tips as well as all the latest SQL Server news brought to you by Brisbane's Leading SQL Server Consultants
Newsletter Issue #23
In this issue:

WARDY IT Community Dinner
January QLD SQL Server User Group
Analyzer 2005
Exam Insurance
SQL Server 2005 Best Practices
Label Security Toolkit
SQL Server Security
PSS Blog
NZ SQL Code Camp Recordings
Online SQL Server Training

Did you know?

Peter Ward will be presenting at the inaugural   SQL Server Open World in Denmark in March 2007

 

WARDY IT Solutions is holding the course Writing Queries for SQL Server in Brisbane on Monday 26th March 2007

Thanks to everyone for the overwhelming response to the questions in last months newsletter . The winner of the Maxtor OneTouch III USB 200GB External Hard Drive was Laird Carmichael from Canberra. Keep an eye out for future editions of the WARDY IT Solutions SQL Server newsletter as we incorporate all of your valued feedback.

 

I would like to take this opportunity to thank all our newsletter subscribers for their support and feedback throughout the year and wish you and your families all the best over the festive season and the year ahead. 2007 is going to be a big year for Brisbane's Leading SQL Server Consultants WARDY IT Solutions, so keep an eye out for the announcements in January's newsletter.

 

Happy Reading

 

Peter Ward

^top

WARDY IT Community Dinner

The WARDY IT Community Dinner is a casual event for IT professionals in South East Queensland. It's a fun way to meet some new people and find out how other people are dealing with the challenges that we face every day. The January WARDY IT Community Dinner  is on Monday the 8th of January at The Breakfast Creek Hotel . Add this event to your Outlook Calendar.

^top

January QLD SQL Server User Group

At the January QLD SQL Server User GroupGeoff Orr from FrontRow Data Solutions will be demonstrating how partioned tables can be used to manage Very Large Databases (VLDB's). For more details and to register for this free event refer to here.

 

Don't forget that for every QSSUG meeting that you attend between January 2007 and June 2007 affords you an entry into the draw for free registration to the world's largest SQL Server conference the 2007 PASS Community Summit in Denver, Colorado valued at over AU$2000!

^top

Analyzer 2005

If you are looking for a Business Intelligence (BI) front-end application that supports SQL Server 2005, then Analyzer 2005 should be at the top of your list to evaluate. Not only does Analyzer 2005 support Dynamic Reporting, Ad-Hoc Queries and Predictive Analysis but it also provides all of these features using a zero footprint client. For more details refer to here.

^top

Exam Insurance

If you are thinking of sitting a Microsoft Certification Exam between now and the 31st of May 2007 then Exam Insurance might help give you the confidence to sit the exam. Basically you pay a little more when booking your exam, knowing that you can re-sit the exam for free if you fail and if you pass you receive 25% of your next exam. For a list of Exam Insurance Partners refer to here.

^top

SQL Server 2005 Best Practices

Microsoft has put together a list of best practice resources for SQL Server 2005 ranging from White Papers to scripts and benchmarking tools. The resources can be found here.

^top

Label Security Toolkit

The Label Security Toolkit for SQL server 2005 demonstrates how to combine the capabilities of SQL Server 2005 to implement a label-based row and/or cell level security framework in an application database. The toolkit can be downloaded here.

^top

SQL Server Security

David Litchfield from NGSSoftware has written an interesting article that compares the vulnerability track record of Microsoft SQL and Oracle databases over the past 6 years which has generated a lot of debate about which database is more secure, SQL Server or Oracle. The article can be downloaded here.

^top

PSS Blog

The Microsoft Product Support Service (PSS) SQL Server Engineers have started a new blog which includes some great troubleshooting tips and other resources and tools that help assist with diagnosing issues with SQL Server. The blog can be found here.

^top

NZ SQL Code Camp Recordings

Thanks to Nick Randolph the recordings of each of the sessions from the recent SQL Code Camp 'Really Down Under'  that was held in New Zealand are available for download. The sessions range from Advance Indexing strategies to ORM's and LINQ. The recordings can be downloaded here.

^top

Online SQL Server Training

If you are looking for online training for SQL Server then you can't go past JumpStartTV. JumpStartTV has a range of online training for SQL Server ranging from Writing Simple Select Statements to Clustering SQL Server 2005 . For a complete list of database topics available from JumpStartTV, refer here.

^top

WARDY IT Solutions is a highly regarded IT Solutions provider specialising in Microsoft SQL Server.  You may not be aware though that WARDY IT Solutions is also a registered Microsoft Partner and has an established relationship with numerous hardware and software vendors, enabling us to provide competitive pricing on your next hardware or software acquisition.  For more information on how WARDY IT Solutions can assist with your next acquisition email: contact@wardyit.com.