SQL DownUnder CodeCamp 2007 – Loop containers in SSIS (7)
Session-7
Topic: Loop Containers in SSIS
Ducas Francis, Senior developer – Readify
2 ways to add iteration to SSIS, the demo was quiet comprehensive, Hope the presentation in full is available.
Blog: Ducas Francis – Blog
Yet another good session from a new speaker, Thanks Ducas Francis.
October 14, 2007
· 
Rahul Desai · 
One Comment
Posted in: SQL Server, UserGroups and conferences
SQL DownUnder CodeCamp 2007 – Moving SQL server system Databases (6)
Session-6
Topic: Moving SQL Server system Databases 2000 and 2005
MAI Low – Red Rock consulting
The session covered do’s and don’ts, step by step procedure on moving the database. from one version to another.
Another good session from a new speaker, Thanks Mai Low.
October 14, 2007
· Rahul Desai · No Comments
Posted in: SQL Server, UserGroups and conferences
SQL DownUnder CodeCamp 2007 – Reporting Services Tips and Tricks (5)
Session-5
Topic: Reporting services Tips and Tricks
Mahesh Krishnan – Senior consultant, Readify
Covered the following tips on reporting services:
1. Create report templates that can be re-used in your reporting application.
2. Create your own style theme that will show up in the report wizard.
3. Customize the way the Report Manager and HTML viewer looks.
4. Call custom code (written in your favourite .NET language) from your reports.
5. Call the Reporting Service Web service from your application.
6. Monitor your reports via the Executionlog table and performance counters.
7. Navigate a report’s “DOM” using the Document outline view.
8. Consider performance.
9. Consider user experience.
10. Consider maintainability.
Links to speaker:
Blog: Mahesh Krishnan-Blog
Excellent session from a new speaker, thanks Mahesh Krishnan.
October 14, 2007
· Rahul Desai · No Comments
Posted in: SQL Server, Tools, Tips & Utilities, UserGroups and conferences
SQL DownUnder CodeCamp 2007 – If only they taught SQL server at kindergarten (4)
Session-4
Topic: If only they taught SQL server at Kindergarten
Peter Ward peter@wardyit.com and www.wardyit.com and www.wardyit.com/blog
Some of the good practices covered…..Return only what is required, Avoid LOOPS and use data sets, Handling NULL’s, Avoid co-related Sub-queries (replace with JOINs and CASE statements), Implicit Insert column list (target column list be explicitly specified), TOP without an order by should be avoided, Temporary tables, Other common bad practices and connecting to SQL server (specify application name in the connection string)….
Presentation should be available at the SQL DownUnder web site.
Good session again. Thanks Peter Ward.
Some links from the session:
Australian SQL server user group: www.sqlserver.org.au
Ask a SQL Guru : www.askasqlguru.com
October 14, 2007
· Rahul Desai · No Comments
Posted in: SQL Server, Tools, Tips & Utilities, UserGroups and conferences
Latest News from the Visual FoxPro Team…..
Service Pack 2 (SP2) for Visual FoxPro 9.0 is now available for download.
Read the full release details from Milind Lele – Program Manager for Visual FoxPro and Visual Basic at the following link:
http://msdn2.microsoft.com/en-us/vfoxpro/bb264582.aspx
October 14, 2007
· Rahul Desai · No Comments
Posted in: Visual Foxpro
SQL DownUnder CodeCamp 2007 – Bare Metal tuning of SQL server (3)
Session-3
Topic: Bare Metal Tuning of SQL server
Kelvin Kline
Is a Technical Strategy Manager, SQL server solutions and a SQL server MVP working with Quest Software. He is also the President of PASS.
Major presentation was revolving around Methodology, CPU’s, Memory, Workload profile consideration, Disk I/O, virtualization, ….on how they can be used better, Pros and Cons of each category, bench marking tests on each of the category and up to what extent it can be beneficiary…over all an interesting session, specially for DBA’s.
For virtualization, suggested, avoid MS Virtual server and lower versions of VMWare, suggested VMWare ESX for virtualization as is low overhead as far as memory and overall performance is concerned.
Some valuable links from the session www.sqlblog.com ……
Benchmarking tool at www.quest.com/bench,ark_factory/index.asp (!free) and www.microsoft.com/technet/community/en-us/sql/webcsts.mspx
Kevin can be reached on Kevin.kline@quest.com
Over all an informative session, thanks Kelvin Kline.
October 13, 2007
· Rahul Desai · No Comments
Posted in: SQL Server, Tools, Tips & Utilities, Training, UserGroups and conferences
SQL DownUnder CodeCamp 2007 – Charles Sturt University and IT Masters….(2)
Session-2
Topic: Charles Sturt University and the IT masters courses
Covered information related to the IT courses supported by both the educational institutes. Good to know the student base is growing (I am one of them….).
October 13, 2007
· Rahul Desai · No Comments
Posted in: General, SQL Server, Training, UserGroups and conferences
SQL DownUnder CodeCamp 2007 – SQL server 2008 – Enhancements and new features (1)
Session-1
Topic: SQL server 2008 – enhancements and new features
Dr. Greg Low – Consultant – Readify
The new data types (specially the Date and time) are really impressive along with the whole list of other changes (power point slide should be available on the SQL down under web site). Lack of support for Visual Studio 2005 at launch date was identified as one of the main concerns.
October 13, 2007
· Rahul Desai · No Comments
Posted in: SQL Server, Training, UserGroups and conferences, Visual Studio
SDLC, Phases and task ownership – Inception / Initiation Phase (2)
Continuing from the previous article, we move on to the Inception phase, this phase starts after the Inquiry phase completes. During this phase, the development manager or Project Manager creates the Engineering Requirement Specification (ERS), which describes all technical requirements of the project. This phase ends if the ERS is signed as complete and is informative so that it enables engineers and testers to create the software that can fulfil the customer?s need.
Step:1 Define Customer Requirement
Write the Customer Requirement Document (CRD), a non-technical document which describes the project mostly as use cases
Ownership / Responsibility: Project Manager / Customer / Pre-Sale
Step:2 Customer Acceptance
Review and get acceptance from customer
Ownership / Responsibility: Project Manager / Development Manager /Customer
Step:3 Define Technical Requirement
Write the ERS with all detail about the technical requirements of the project
Ownership / Responsibility: Project Manager / Development Manager
Step:4 Review
Review with the team for clearness / Perhaps discussion with customer for unclear issues
Ownership / Responsibility: Project Manager / Development Manager / Software Engineer / Software Tester
Step:5 Customer Acceptance
Review and get acceptance from customer
Ownership / Responsibility: Project Manager / Development Manager / Customer
Step:6 Update plan
Correct the draft project plan created in previous phase with updated estimation / Inform customer and team / Get customer acceptance
Ownership / Responsibility: Project Manager / Development Manager / Customer
The documents to be produced at the end of this phase are Engineering requirements specifications (ERS), Project Plan.
More in next blog entry…..
October 10, 2007
· Rahul Desai · No Comments
Posted in: Project Management, Software Engineering
Launching the task manager…..the third way….
Everyone knows that the task manager can be launched by the following two methods:
First Method:
Press CTRL + ALT + DELETE and click on the ‘Task Manager…’ button on the Windows Security dialog.
Second Method:
Right click on the Windows Taskbar and chose ‘Task Manager…’
but very few know (I was one of them till I found out) the third and the easiest method (no right clicks, no dialog, no security…..) which is:
Press CTRL + SHIFT + ESC and the Task Manager will be launched instantly.
And guess what…it works on Vista as well….
October 8, 2007
· Rahul Desai · No Comments
Posted in: Tools, Tips & Utilities