Saturday, 21 October 2017
Task Pane 
Login
username:
password:
Remember Me
|Signup
Our Sponsors
Current Poll
SQL Server 2008
Are you ready for the upcoming SQL Server 2008 release?







[show results]
Category Information
Meeting Collateral - Sydney
PPTs etc from Sydney Presentations
Jump to:

Resources
28/01/2005 3:47:54 PM Author: Rowan
Sydney - Jan 2005 - SQL 2005 VLDB Support - Rowan Burke
Here are the slides from the second session
22/02/2005 10:15:07 PM Author: ace
Sydney - Feb 2005 - SQL 2000 Security - Victor Isakov
Hello again,

Thanks again for your patronage. Hopefully the session provided some insights into SQL Server's security architecture, attack vectors and what to defend / watch out for.

If anyone has any suggestions, information, feedback, etc I would appreciate it.

Otherwise: I might have a number of projects coming up this year requiring SQL, DTS, Reporting Services, IIS/Sharepoint/ASP/BIP/BSC, etc skills. So if you're interested in contract work, please contact me.

Regards,

Victor
mailto:sql@informare.com.au
25/02/2005 4:56:31 PM Author: ace
Sydney - Oct 2004 - Stored Procedure Architecture & Performance - Victor Isakov
Hi everyone,

Hopefully we've shed some light on what happens in the background with SQL Server's Stored Procedures.

Please be aware that there are a lot more undocumented Procs in SQL, just execute a SELECT name FROM [master]..[sysobjects] WHERE type IN ('p','x') and compare the list to BOL ;o)


Kind Regards,

Victor
25/02/2005 5:31:17 PM Author: ace
Sydney - Aug 2004 - SQL 2000 Best Practices - Victor Isakov
Hi,

Thanx you very much for you interest and feeback on the SQL Server 2000 Best Practices Session. Hopefully you found it of interest and relevance!

Otherwise I would recommend keeping an eye on the 64-Bit space and what AMD in particular will be doing with the Opteron (x64) and the HyperTransport Architecture!

If anyone has any question, please feel free to email me at mailto:sql@informare.com.au.

Kind Regards,

Victor
25/02/2005 5:36:10 PM Author: ace
Sydney - Jan 2005 - SQL 2000 VLDB Support - Victor Isakov
Welcome back!

Hopefully everyone had a great New Year and a relaxing break over Xmas.

Promises to be an interesting year with the release of SQL 2005... Finally! Although I wouldn't be holding my breath...

I've posted the PPT Slides from last night here.

Enjoy!

Victor
25/02/2005 5:41:58 PM Author: ace
Sydney - Feb 2005 - SQL 2000 Security Architecture - Victor Isakov
Hello again,

Thanks again for your patronage. Hopefully the session provided some insights into SQL Server's security architecture, attack vectors and what to defend / watch out for.

If anyone has any suggestions, information, feedback, etc I would appreciate it.

Otherwise: I might have a number of projects coming up this year requiring SQL, DTS, Reporting Services, IIS/Sharepoint/ASP/BIP/BSC, etc skills. So if you're interested in contract work, please contact me.

Regards,

Victor
mailto:sql@informare.com.au
29/04/2005 12:55:35 PM Author: ace
Sydney - Apr 2005 - SQL 2000 Optimiser, Execution Plans and Indexes Revisited - Victor Isakov
Hello everyone,
 
Thanks for what was a very good turnout (especially considering it was after the Anzac Day Public Holiday). The interest and participation certainly made it more of the one more “successful” sessions we've had.

Thank you in particular for your positive feedback via emails, that's much appreciated.
 
Feel free to email me with further questions, as always!

Don't forget the SQL Server Technical Mailing List! I've posted the latest "Session - 003" up in the news section, so have a read. I'm sure you'll find it most useful!
 
Kind Regards,
 
Victor
mailto:sql@informare.com.au
1/09/2005 1:41:36 PM Author: angrykoala
Sydney - Aug 2005 - Neil Jacobson - Scripting with Metadata in SQL 2000
Scripting with Metadata for Common Tasks
Putting Information_schema views and system tables to work.

©2005 Neil Jacobson

This script is supplied as is. No warranty is applicable or implied.

Any use of this script must include this header / copyright information intact.

It is recommended that all code be thoroughly tested to ensure suitability and must not be used in a
Production environment without following your organisation's change control and testing procedures.

This script was designed to run on a SQL Server 2000 environment using sort order 52.
The script may not necessarily produce the expected results if object names contain non alphanumeric characters e.g. spaces or '-'

When using SQL Server Query Analyser the results should be set to text output with 8000 characters per column.

Updated 10 Nov 2005 to include new 2005 features.


29/09/2005 11:04:59 AM Author: Rowan
Sydney - Sept 2005 - Nick Barclay & Rowan Burke - Getting Ready for SQL Server 2005
Here is Nick Barclay's BI Demo of Demo's presentation
29/09/2005 11:17:49 AM Author: Rowan
Sydney - Sept 2005 - Nick Barclay & Rowan Burke - Getting Ready for SQL Server 2005
Here is Rowan's presentation on Upgrading to SQL server 2005
11/10/2005 11:03:46 PM Author: angrykoala
Sydney - Oct 2005(special) - Itzik Ben-Gan - Row Numbers
Here is presentation and TSQL from Itzik Ben-Gan's amazing presentation. I have also included his previous session TSQL on "SQL and Logic".

Enjoy

- Grant
27/11/2005 10:32:32 PM Author: angrykoala
Sydney - Nov 2005 - Analysis Server Cube Design in 2005 - Richard Lees
Powerpoint presentation from Richard Lees presentation on 22nd Nov 2005, New Functionality and Performance opportunities with SQL 2005 Analysis Services.
31/01/2006 9:29:47 PM Author: angrykoala
Sydney - Aug 2005 - Peter Myers - Integration Services in SQL 2005
DEVELOPING, DEPLOYING AND MANAGING A SQL SERVER INTEGRATION SERVICES IMPLEMENTATION

Slide deck from Peter Myers presentation in Sydney on the 24th Jan 2006.

Bumper crowd of over 60 members enjoyed Peter's jam packed information session...

- Grant


10/04/2007 11:42:15 AM Author: angrykoala
Sydney - Feb 2007 - Dimensional Modelling Basics - Warren Thornwaite
Dimensional Modelling Basics slide deck

Warren Thornthwaite, from the Kimball Group, http://www.kimballgroup.com has been building decision support and data warehousing systems since 1980. Warren worked at Metaphor for eight years, where he managed the consulting organization and implemented many major data warehouse systems. After Metaphor, Warren managed the enterprise-wide data warehouse development at Stanford University. He then co-founded InfoDynamics LLC, a data warehouse consulting firm. Warren joined up with WebTV to help build a world class, multi-terabyte customer focused data warehouse before returning to consulting.
10/04/2007 11:59:36 AM Author: angrykoala
Sydney - Mar 2007 - DB301 Analysis Server Implementation Best Practices - Nicholas Dritsas
DB301 Analysis Server Implementation Best Practices

Nicholas Dritsas from the SQL Server Development Customer Advisory Team

These are the guys from Microsoft that work on the biggest badest customer sites in the world - they know their stuff.


CAT Blog site:
http://blogs.msdn.com/sqlcat

Best Practices: http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/default.mspx

SQL Server 2005 SP2 Feature pack:
(it includes Performance Dashboard plus a number of utilities and add-ins to SQL Server SP2).
http://www.microsoft.com/downloads/details.aspx?familyid=50b97994-8453-4998-8226-fa42ec403d17&displaylang=en

SQL Server 2005 Best Practice Analyzer Beta:
http://www.microsoft.com/downloads/details.aspx?FamilyId=DA0531E4-E94C-4991-82FA-F0E3FBD05E63&displaylang=en
20/05/2007 9:53:08 AM Author: angrykoala
Sydney - May 2007 - SQL 2005 Service Broker - Glyn Llewellyn
This is the scripts that were demostrated as part of Glyn's May 2007 presentation on Service Broker.

They are gleaned from his hands on experience.
13/06/2007 11:38:59 PM Author: angrykoala
Sydney - Jun 2007 - Secrets of Fast Detection and Recovery from Database Corruptions - Paul Randal (Microsoft)
Here is the presentation and code presented in Paul's terrifice presentation given on the 13 Jun 2007.

After all he *did* write much of the code for DBCC! He definately knows what he is talking about.

Paul Randal,
Principal Lead Program Manager, Microsoft Sql Server Core Storage Engine
http://blogs.msdn.com/sqlserverstorageengine/default.aspx
23/07/2007 7:34:34 AM Author: EasternMining1
Using SQL Server OLAP to manage an Oracle RAC cluster
This is the slide deck that Richard used to give the presentation (Nov 2006) on how OLAP could be used to help monitor and manage a very large OLTP database on Oracle 10g. This is a good example of OLAP to SQL professionals, but it is also interesting to an Oracle DBA interested in 10g performance. To download, goto http://EasternMining.com.au/Home_files/Downloads.htm For more information about Richard Lees or EasternMining goto http://EasternMining.com.au
12/08/2008 9:34:56 PM Author: angrykoala
May 2008 - XML in SQL Server- What you need to know as a DBA
Greg Low's PowerPoint Presentation for May 2008
15/04/2009 2:10:35 PM Author: angrykoala
May 2009, SQL Server 2008 Security Deep Dive - Peter Ward - Peter Ward
Here is the collateral for Peters Security session:
http://www.sqlserver.org.au/events/ViewEvent.aspx?EventId=375

SQL Server 2008 Security Enhancements.zip
Includes Scripts:
* _Principals & Securables.sql
* 1_Audting.sql
* 2_Transparent Data Encription.sql

And the slide deck:
* SQL Server 2008 Security Enhancements.pdf

Highly recommended
2/09/2014 2:33:27 PM Author: angrykoala
Sydney - Aug 2014 - Common TSQL Mistakes session materials
Here is the material presented by Kevin Boles at our (early) August Sydney SQL Server Usergroup meeting
17/12/2014 8:04:33 PM Author: angrykoala
Dec 2014 Christmas Party - Paul presentation and scripts
Presentations and scripts from Paul and Kimberly's Christmas Party presentation.
Paul - Wait statistics for performance tuning
17/12/2014 8:06:07 PM Author: angrykoala
Dec 2014 Christmas Party - Kimberly Tripp presentation and scripts
Presentations and scripts from Paul and Kimberly's Christmas Party presentation.
Kimberly - impact on caching / performance of different methods of statement execution
9/03/2015 2:05:43 PM Author: angrykoala
Feb 2015 | Extended Events | Erin Stellato
Here is the slide deck from Erin Stellato's presentation on Extended events