|
|
 |
BI SIG Meetings
Business Intelligence Special Interest Group
Special Interest Group focusing on MS SQL ...
|
|
|
|
|
|
|
|
Studying for Certification? Why do it alone?
If you are interested in leading or attending a Certification Study Group check out our study group listing by clicking here.
|
|
|
|
Job Postings are now online. Are you seeking SQL professionals? Are you seeking a new place to ply your skills? Visit the IndyPASS Job Opportunities forum today. Members only! Please register to post or view job opportunities.
|
|
|
|
Members can download presentations on the Member Downloads page. Not a member yet? It's free and simple: Just select the Register link on the upper right corner of the page.
|
|
|
|
Consider visiting other regional user group meetings while you are out of town. Check out the regional meetings calendar for meetings occurring in other communities.
If you are a leader of a SQL Server User Group and would like to have your meetings featured on our regional meetings calendar, please contact us at indypassboard(at)indypass.org. If you have an RSS feed for your meeting announcements please provide the URL.
|
|
|
Increase Your SQL Server Value. Immediately.
Now more than ever, people and businesses need new skills and knowledge to remain competitive and thrive. Join thousands of SQL Server professionals at the Washington State Convention & Trade Center in Seattle from Nov 2-5. Return to work and do your job better, faster, easier–right away.
IndyPASS chapter members benefit from a discounted registration fee for the summit!
Please use discount code CHM3D, and identify IndyPASS as your PASS chapter to receive this discount.
Register now.
|
|
|
Go Big, Go Huge... Go Fast! Leveraging Table Partioning to Speed Performance and Ease Management of Large Tables
Presented By: Eddie Wuerch, ExactTarget
Placing a large number of rows into a table introduces many challenges to database performance. Range queries take longer, table maintenance can become cost-prohibative, and loading or deleting large chunks of data can either escalate to table locks due to too many row locks or the transaction logbloats from nibbling away in small batches to avoid the locks.
Table partitioning is one way to attack these issues, physically splitting a table into many pieces while still presenting the table as one entity to data consumers.
Introducing table partitioning to your larger tables can provide significant boosts to speed, reductions to contention, and ease data management. This demo-heavy presentation will cover partitioning and several of its practical uses.
About Eddie Wuerch
Eddie Wuerch is a DBA, developer, and trainer specializing in SQL Server for over ten of the twenty years he has spent in IT. Eddie is currently the Principal Database Architect and DBA team lead at ExactTarget, a leading SaaS ESP located in Indianapolis, Indiana. Eddie and his team manage the many multi-terabyte 24x7 SQL Server database clusters that form the foundation of the ExactTarget application. In addition to holding MCITP certifications in SQL Server 2005 and 2008 development and administration, Eddie is also a Microsoft Certified Trainer, bringing his VLDB experience to developers and DBAs, delivering courses in SQL Server high availability, development, administration, optimization, and Reporting Services.
Date: Tuesday July 21st, 2009
Location:
3500 DePauw Blvd.
Pyramid #3 - Lower Level
Indianapolis, IN 46268
Directions
Agenda:
5:30 - Professional Networking
6:00 - Announcements
6:15 - Featured Presentation
7:30 - Prize drawings
|
|
|
|
|
|
|
|
|
SQL Server 2008 Developer Training Kit
The SQL Server 2008 Developer Training Kit will help you understand how to build web applications which deeply exploit the rich data types, programming models and new development paradigms in SQL Server 2008.
SQL Server 2008 Service Pack 1 Now Available
Service Pack 1 (SP1) focuses on essential updates only, primarily roll-ups of cumulative updates 1 to 3 and fixes to issues reported through the SQL Server community. SP1 eases deployment and management of Service Packs by introducing Slipstream, Service Pack Uninstall, and Report Builder 2.0 Click Once capability.
How Do I BI
Explore data mining models in Business Intelligence Development Studio, part of Microsoft SQL Server 2008 database software, with Senior Developer Evangelist Lynn Langit. See how you can create data sources in Business Intelligence Development Studio, process Microsoft SQL Server Analysis Services (SSAS) objects, work with the Cube Editor, and more.
MSXML 4.0 SP3 now available
MSXML4 SP3 is a complete replacement of previous service packs and includes security and reliability fixes. After MSXML4.0 SP3, there are no future service packs planned and MSXML4 SP2 support will end in November 2009. MSXML4.0 customers are recommended to upgrade to MSXML6 which has new functionality, performance and security improvements.
SQL Server 2008 Service Pack 1 CTP Now Available
Service Pack 1 (SP1) focus on essential updates only, primarily a Roll-up of Cumulative Update 1 to 3 and fixes to issues reported through the SQL Server community. While keeping product changes contained, we have made significant investments to ease deployment and management of Service Packs by introducing: Slipstream, Service Pack Uninstall, and Report Builder 2.0 Click Once capability.
SQL Server 2008 Data Warehousing and Fast Track Architectures
Use the data warehousing capabilities of Microsoft SQL Server 2008 Enterprise to build faster warehouses, manage growing data volumes, integrate with Microsoft business intelligence products, and with the recent acquisition of DATAllegro, scale a warehouse to perform across hundreds of terabytes of data.
Essential Toolkit for SQL Server 2008 Migration
Locating legacy SQL Server instances for SQL Server 2008 migration projects can be time-intensive. Accelerate the process by downloading the free Microsoft Assessment and Planning (MAP) Toolkit for SQL Server 2008 and you can now get answers in just a few hours.
SQL Server 2005 Service Pack 3 Now Available
Service Pack 3 (SP3) addresses issues reported through the SQL Server community, and includes a roll-up of fixes since SP2. SP3 does not introduce major new features. Also, the Feature Pack for SP3 has been updated with this release.
Rate the New DevCenter Page Design
Tell us what you like and don't like about the new design for the Integration Services page. We plan to use this design for other component and technology pages in SQL Server 2008, but your feedback is vital. Use the Rating and Feedback control on the top right-corner of the page to let us know your thoughts about this design.
Watch New Videos from the SQL Server Documentation Team
Use SQL Server videos to learn about the product and component technologies, see how to do various tasks, and discover related help topics that help you expand your knowledge of SQL Server.
MSXML 4.0 SP3 Beta now available
Service Pack 3 (SP3) is a complete replacement of previous service packs and includes a number of security and reliability fixes as well as a more robust setup package. We want to know what you think. Please run your existing application against MSXML 4.0 SP3 Beta to ensure the new service pack is compatible with your application with no behavior change.
Get the First Cumulative Update for SQL Server 2008
Cumulative Update 1 contains hotfixes for the Microsoft SQL Server 2008 issues that have been fixed since the release of SQL Server 2008.
Hierarchy ID: Model Your Data Hierarchies With SQL Server 2008
Here we explain how the new hierarchyID data type in SQL Server 2008 helps solve some of the problems in modeling and querying hierarchical information.
SQL Server 2008: Access Your Data Any Place, Any Time
Join these webcasts, download podcasts, or take part in virtual labs to discover how you can best prepare your data for a data mining project and work with advanced features for manageability. We also examine the reporting enhancements that let you quickly and easily generate the reports your organization needs.
Connecting to SQL Server Through the Firewall on Windows Server 2008 or Windows Vista
Windows Server 2008 and Windows Vista help increase security by automatically enabling the firewall. Before you connect to an instance of SQL Server from another computer, you must configure the Windows Firewall to allow appropriate access and still continue to block inappropriate access. For more information the <a href="http://blogs.msdn.com/sqlsecurity/archive/2008/07/01/sql-server-and-the-windows-server-2008-firewall.aspx" target="_blank" >SQL Server Security team blog</a>.
Download the SQL Server 2008 Feature Pack
The Feature Pack is a collection of stand-alone install packages that provide additional value for SQL Server 2008.
SQL Server 2008 RC0 Books Online
Download the Release Candidate (RC0) version of Books Online for Microsoft SQL Server 2008, the primary documentation for SQL Server 2008.
Cumulative Update 7 for SQL Server 2005 Service Pack 2
This package contains all of the SQL Server 2005 hotfixes that have been released since the initial release of SQL Server 2005 SP2.
SQL Server 2008 CTP (February 2008) Is Now Available
Download the latest release of SQL Server 2008 Community Technology Preview (CTP) and discover new capabilities to help support your mission-critical platform. This CTP continues to improve functionality in all aspects of the product.
Download SQL Server 2008 Books Online Community Technology Preview (February 2008)
SQL Server 2008, the next release of Microsoft SQL Server, provides a comprehensive data platform. Books Online is the primary documentation for SQL Server 2008. Download a pre-release preview of Books Online for SQL Server 2008.
Get the Microsoft SQL Server 2008 Feature Pack CTP (February 2008)
Download the February 2008 Feature Pack Community Technology Preview (CTP) for Microsoft SQL Server 2008, a collection of stand-alone install packages that provide additional value for SQL Server 2008.
SQL Server 2005 Books Online (September 2007) Update
The September 2007 update for SQL Server 2005 Books Online is now available in the MSDN Library. Localized versions and a downloadable version will be released as soon as they become available.
SQL Server Compact 3.5 Beta 2 available for download
Start building a new generation of embedded database applications for desktops and mobile devices with SQL Server Compact 3.5 Beta 2. New features include LINQ to SQL support and enhanced support for T SQL statements.
Perform Database Administration Operations with SQL Server Management Objects
SQL Server Management Objects offer developers a robust toolset for backing up and restoring databases, and issuing DDL commands, as John Papa explains.
Regular Expressions Make Pattern Matching and Data Extraction Easier
Now you can perform efficient, sophisticated text analysis using regular expressions in SQL Server 2005.
|
|
|
|
|
|
|
|