Archive for October, 2007

SQL DownUnder CodeCamp 2007 – Introduction to Performance point 2007 (8)

Session-8 Topic: Introduction to Performance point Adam Cogan – SSW Microsoft Office Performance point Server 2007, the goal of the product is to turn the corporate  goals into Numbers. 3 building blocks of the product…Monitoring, Analytics and Planning (MAP). The product is built around Cubes, Reporting Services, Sharepoint Server,  KPI’s, Dashboards and the competitors to the […]

October 14, 2007 · Rahul Desai · No Comments
Posted in: Project Management, SharePoint, SQL Server, UserGroups and conferences

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. Technorati Tags: Ducas Francis, Readify, Sql server, SQL […]

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. Technorati Tags: Mai Low, Red Rock Consulting, Sql server, Sql DownUnder, […]

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 […]

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 Wardy It solutions 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 […]

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   Technorati Tags: Visual FoxPro, Microsoft, Milind Lele, VFP, Rahul Desai

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 […]

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….). Technorati Tags: Charles Sturt University, IT Masters, IT courses, Rahul Desai

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 […]

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 […]

October 10, 2007 · Rahul Desai · No Comments
Posted in: Project Management, Software Engineering