|Outside the Washington State Convention & Trade Center|
The good news is that Jason Deyalsingh, our scheduled presenter for the October SSRS session, has kindly adjusted his busy schedule so that he may present at TTSSUG's last meeting for the year 2010. If you are new to SQL Server Reporting Services and want to know how to start building a report or if you are interested in understanding how Business Intelligence Development Studio (BIDS) and Report Builder 3.0 can be used to benefit you and your organisation then I suggest you register for this event.
The TTSSUG meeting would be focusing on Microsoft SQL Server Reporting Services (SSRS), an important component of The Microsoft Business Intelligence Platform. SSRS is a server-based reporting platform that provides comprehensive reporting functionality for a variety of data sources.
The presentation will demonstrate how to build reports using Business Intelligence Development Studio (BIDS) and Report Builder 3.0. This event is recommended for Developers, Database Developers and Database Administrators. See the invite below for more details. To register click here.
The last event was special because I achieved my goal of attending all 24 sessions. This time I plan to attend all 24 sessions and the four bonus sessions. I will also be the moderator for session 20 - “Automate Your Database Maintenance Using Ola Hallengren’s Free Script” which is being presented by Brad M. McGehee. Brad is the Director of DBA Education for Red Gate Software and is an accomplished Microsoft SQL Server MVP with over 15 years SQL Server experience. He is a frequent speaker at SQL PASS, European PASS, SQL Connections, SQLTeach, devLINK, SQLBits, SQL Saturdays, TechFests, Code Camps, SQL Server user groups, and other industry seminars.
For more information about the event see my previous blog post.
For the Live Meeting link please visit the PASS SQL Azure Site.
We began with a small presentation to explain the mission and goals of TTSSUG and also to introduce the steering committee to the attendees. The presentation ended with an introduction of the main presenter, Gregory Chee. Gregory is an Application Consultant in Microsoft Business solutions department with Esprit Consultants Limited and has over 7 years of IT experience. His presentation, Lifecycle of an SSIS package: From development to production, gave a brief introduction to SSIS and helped people to understand the basic concepts of SSIS. Most of his session was focused on demonstrating how to create and deploy two SSIS packages. The first package was a basic ETL package which introduced Control Flow items such as Data Flow Task and Execute SQL Task. The package also showed the use of Data Flow sources, destinations and some basic transformations. The second package was create to combine data from multiple excel files and compare them to a database in order to produce a report. This package highlighted variables, looping, table lookup, output redirection and package logging. The presentation and the packages can be downloaded here.
I would like to thank Microsoft Trinidad and Tobago team for sponsoring this event and for assisting us with everything that contributed to the event. Also special thanks to Gregory Chee for coming to share his knowledge with the group during his vacation time. Last but most importantly, I would like to thank the people who attended the event and who were interested in attending the event. For more information about SSIS please visit SSIS homepage on MSDN.
If you are interested in local and international events and you want to know what's new going on in the 'SQL World' you can follow me on twitter. I may tweet about other tech stuff that I find cool (such as the mind scanning watch) but I won't be tweeting about things like what I had for lunch and what I am planning to have for dinner.
The TTSSUG meeting would be focusing on Microsoft SQL Server Integration Services (SSIS). SSIS is a platform for building enterprise-level data integration and data transformations solutions and is an important component of The Microsoft Business Intelligence Platform. This meeting is recommended for Developers, Database Developers and Database Administrators. See the invite below for more details.
The TTSAC launch will give insight on how this new community can facilitate the growth of the local IT ecosystem and ignite the drive for innovation. This meeting is recommended for Software and Enterprise Architects. See the invite below for more details.
I hope to see you at both events!
Scott Klein is co-founder of Blue Syntax Consulting, a company that specializes in Azure training and consulting. Scott has been working with SQL Server for nearly 20 years, working with companies large and small all over the United States, working in a wide scope of fields such as medical, finance, and retail. Scott is also a veteran author, having written a number of books including Professional SQL Server XML, Professional LINQ, Pro ADO.NET Entity Framework 4.0, and the soon to be released Pro SQL Azure. Scott is a SQL Server MVP and President of the South Florida SQL Server Users Group and the newly formed Azure PASS Virtual Chapter. He speaks frequently as SQL Saturday events and user groups, and was lucky enough to speak at the 2008 European PASS conference in 2008.
For the Live Meeting link please visit the site at: http://azure.sqlpass.org/
She interviewed me via email and recently posted it on their blog (An Interview with New Chapter Founder, Nigel Sammy). The information will be useful to anyone interested in starting a user group/chapter and it will also give some insight as to why the Trinidad and Tobago SQL Server User Group (TTSSUG) was started. Thanks Nancy and Kathi for this wonderful opportunity.
- Mitra Sinanan for taking the time to share his knowledge with the group.
- Gisselle Ramsaran and Indera Ganesh from Corbin Communications for making all the arrangements for the event.
- Neeala Maharaj-Racha, our Microsoft Liaison, for all the time and effort that she spent in order to assist the group
- Of course the other co-founders of the group, Anand Singh and Ruselle Seeboo.
- Last but most importantly, the people who attended the event and who were interested in attending the event.
This year I was able to attend all 24 sessions thanks to a few cold showers and two Red Bulls. The event was totally worth the lack of sleep; all the sessions were quite enjoyable and informative. I am now posting about the event because I was waiting for the recorded sessions to become available. While I recommend that you watch all of the sessions, the following are what I consider as 'must watch' sessions:
Session 01: Introduction to PowerPivot (Brian Knight)
Brian sells PowerPivot to you. Great presentation to get you excited about the next 23 sessions.
Session 03: What Exactly is in SQL Server 2008 R2 (Kevin Cox)
Want to know about the features available in R2 and too lazy to read my previous blog post? Then this session is for you!
Session 05: Data Tier Applications (Jacob Sebastien)
This session shows benefits for both Developers and Database Administrators. A presentation for everyone.
Session 06: What's Really Happening on Your Server? 15 Powerful SQL Server Dynamic Management Objects (Adam Machanic)
Adam delivers a well balanced presentation - great introduction and important information.
Session 11: Easier than Ever Report Authoring in SSRS 2008 R2 (Jessica M. Moss)
R2 features makes it easy to create Reports but Jessica makes it easier.
Session 13: Manage Your DBA Career, Don’t Let it Manage You (Brad McGehee)
The one and only PD session that reminds you of things that you take for granted.
Session 14: Top 10 Mistakes on SQL Server (Kevin Kline)
If you want to remain a DBA then you should learn how to avoid the mistakes shown in this session.
Session 17: SQL Tuning - Get it Right the First Time (Dean Richards)
Should Developers or Database Administrators do SQL Tuning? View this session if you want the answer.
Session 20: Advanced T-SQL Query Tuning Techniques (Rob Farley)
This was not one of the original 24 sessions but I was glad that it became one. Rob Farley came out of moderating session 19 and jumped into this session to show his approach to taming a 'wild' query.
Session 24: BLITZ! 60 Minute Server Takeovers (Brent Ozar)
Perfect Session and great presenter to end the event. Brent not only shows DBA what to do when taking over a server but his session also reminds them what should be done to all their existing servers.
Thanks to all of the presenters for sharing their knowledge with us and thanks to the PASS members for all the hard work and long hours they spent to make this event a huge success. Special thanks to PASS Board Member and 24 Hours of PASS organizer, Thomas LaRock (aka SQLRockstar).
The Trinidad and Tobago SQL Server User Group is a volunteer and independent organization providing a community for Microsoft SQL Server professionals, hobbyists and enthusiasts.
Mission and goals:
1. To develop a network of professionals with a common interest in Microsoft SQL Server.
2. To promote free and open communication among users of Microsoft SQL Server and related software products.
3. To establish channels for the education of TTSSUG members and the communication of Microsoft SQL Server related information to and from the members.
The group is an official local Chapter of the Professional Association of SQL Server (PASS).
What is PASS:
The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (Virtual Chapters) to webcasts and the annual PASS Community Summit – the largest gathering of SQL Server professionals in the world – PASS is dedicated to helping its members Connect, Share, and Learn.
Empower the global Microsoft SQL Server and Business Intelligence community to connect, share, learn and be inspired through networking, knowledge sharing, peer-based learning, and the ability to influence the direction of Microsoft SQL Server data platform.
PASS chapters exist to help facilitate education and a knowledge exchange among developers, architects, DBAs, users and managers with an interest in Microsoft SQL Server technologies.
For more information please view this PDF.
Even though this group is an official PASS chapter it is still very new and there are many things that need to be completed before it our first event. We are currently working on bylaws so that we can begin registering members and a mailing list will be available soon to communicate with people interested in future events.
If you have any questions or who are interested in information of future events, please email me: email@example.com.
Date: Wednesday 12th May, 2010
Time: 4pm – 6:30pm
Target Audience: DBA, Database Developers, SQL Server Hobbyists and Enthusiasts
Location: Microsoft, West Moorings
* Limited seats are available so please register early.
To register for this event contact:
Mr. Nigel Sammy
In a few days Microsoft will be releasing the latest iteration of its data platform, SQL Server 2008 R2. R2 will provide customers with a trusted and scalable platform that can increase IT and developer efficiency and deliver expanded reporting and analytics through self-service business intelligence. SQL Server 2008 R2 also introduces two new premium editions; Microsoft SQL Server 2008 R2 Datacenter and Microsoft SQL Server 2008 R2 Parallel Data Warehouse (formerly codenamed “Madison”).
Some of the new features of R2 are:
· PowerPivot (formerly codenamed "Gemini")
PowerPivot gives the users the power to create and manage self-service business intelligence solutions.
- PowerPivot for SharePoint adds shared services and infrastructure for loading, querying, and managing PowerPivot workbooks that you publish to a SharePoint 2010 server or farm.
- PowerPivot for Excel can be used to assemble and create relationships with data from various sources, and then use that data as the basis for PivotTables and other data visualization objects that support data analysis in Excel.
· Data -Tier Applications
A data-tier application (DAC) forms a single unit which contains the database schema and some server level objects required by the database in order to support an application. This simplifies the development, deployment, and management of the data-tier objects that support a multi-tier or client-server application
· Application and Multi-Server Administration
SQL Server 2008 R2 introduces the SQL Server Utility, which forms a central repository for centralized management and consolidation of data-tier applications and instances of SQL Server that have been enrolled in the utility.
This technology deals with complex high-scale event processing. It allows the monitoring and analyzing of data in motion that may be difficult to store for analysis due to its size and frequency.
· Master Data Services
This allows organizations to securely manage master data and maintain an auditable record of the data as it changes over time thus ensuring the integrity of the data.
SQL Server 2008 R2 also has some Database Engine and Reporting Services enhancements that increase the power and productivity of architects, developers, and administrators. It is important to remember that R2 is a minor version upgrade of SQL Server 2008, so new and enhanced features in SQL Server 2008 will still be available in R2. Customers with Software Assurance (SA) for their SQL Server 2008 license can upgrade to SQL Server 2008 R2 for free. People without SA will have to decide if the features in R2 will be worth the cost of upgrading.
For more information on R2 see the following links:
MSDN: SQL Server 2008 R2
SQL Server 2008 R2
I began the presentation with some information about myself and my employer Teleios Systems and then proceeded with an introduction to SQL Server 2008. This was then followed by a brief discussion about 'What is Business Intelligence' and a video of A.C. Milan: Milan Lab. The discussion highlighted where SQL Server 2008 lives in Microsoft's BI world and introduced the SQL Server BI stack: Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS). I briefly described each product (SSIS, SSRS and SSAS) and also highlighted SQL Server 2008 Data Warehousing enhancements before performing a SSIS demonstration. With the upcoming release of SQL Server 2008 R2, I decided to explained 'Managed Self Service BI' and ended the presentation with a PowerPivot demonstration using SQL Server 2008 R2 CTP and Excel 2010. Due to some time constraints I was unable to highlight some of the local BI work done by Reeza Ali, a Solutions Architect with Microsoft Consulting Services West Indies. He has recently published a series of videos on Designing and Planning a BI Project in the internationally recognized and very popular Architect journal.
The feedback that I received from a few people at the end of the event were very positive. They found the presentations very informative and were impressed with the products that was shown in the sessions.
For more information about Microsoft Business Intelligence please visit www.microsoft.com/BI.
- ► 2013 (24)
- ► 2012 (42)
- ► 2011 (33)
- ▼ December (3)
- ► September (3)
- ► August (4)
- ► June (2)
- ► May (2)