Search
Sunday, February 05, 2012 ..:: Events & Downloads ::.. Register  Login
 May 19, 2011
Minimize
Taking Your Application Design to the Next Level with Analysis Services Data Mining
 
Speaker: Peter Myers
 
PowerPoint slides from this presentation have been posted on our website.  Click Here 
 
 November 22, 2010
Minimize

PASS Summit Highlights

PASS Summit 2010 drew  2,858 delegates and 1004 pre/post-conference attendees for a total of 3,862 registrations - the largest turnout since the inception of the conference and a 26% increase in attendance over 2009.

For the first time in its history, PASS streamed the daily keynotes, thanks to our sponsor Dell, live from Seattle with thousands tuning in to watch the centre stage program. View them now:

Microsoft shared a host of announcements at PASS Summit. Find out more from PASS President, Rushabh Mehta as he interviews  Microsoft Exec Ted Kummert.

 October 20, 2010
Minimize

SQL Server 2008 R2 Migration Guidance

http://technet.microsoft.com/en-us/gg315159.aspx 

 September 27, 2010
Minimize
 July 21, 2010
Minimize

SQL Server 2008 R2 Report Builder 3.0
An intuitive report authoring environment for business and power users and supports the full capabilities of SQL Server 2008 R2 Reporting Services

 June 4, 2010
Minimize

SQL Server 2008 R2 Download is now available: http://msdn.microsoft.com/en-us/subscriptions/downloads/default.aspx 

 April 16, 2010
Minimize
This training kit is ideal for developers who want to understand how to take advantage of the key improvements introduced in SQL Server 2008 and SQL Server 2008 R2 in their applications.
 March 16, 2010
Minimize

SQLServer2008_161x33
An Introduction to SQL Server 2008 R2 Master Data Services
Available on demand starting on March 22. Master Data Services (MDS) is a new SQL 2008 R2 component that will help your organization effectively manage master data in a centralized location. In this 8-part series you will become familiar with the installation procedure and get an understanding of how to build, deploy, and manage master data within your organization. Become a Facebook Fan of msdev.

 March 7, 2010
Minimize

This training kit is ideal for developers who want to understand how to take advantage of the key improvements introduced in SQL Server 2008 and SQL Server 2008 R2 in their applications, as well as for developers who are new to SQL Server
 
 
Download the SQL Server JDBC Driver 3.0 CTP, a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces available in Java Platform, Enterprise Edition 5

 February 1, 2010
Minimize



Microsoft SQL Server Migration Assistant 2008 for MySQL v1.0 CTP1
Microsoft SQL Server Migration Assistant (SSMA) 2008 is a toolkit that dramatically cuts the effort, cost, and risk of migrating from MySQL to SQL Server 2008 and SQL Azure.
 

 January 18, 2010
Minimize

Registration is now open for Quest’s virtual SQL Server training conference. Sign up today to get free education—right from the convenience of your desk.

 
Join SQL Server experts Kevin Kline, Brent Ozar and Ariel Weil—all from Quest Software—as they present tips and tricks to help you monitor your SQL Server environment with ease. You’ll learn how to use Dynamic Management Views (DMVs) to simplify troubleshooting and significantly enhance SQL Server performance.
 
Date: Wednesday, March 3, 2010
Time: 7:45 a.m. – 5 p.m. ET
 
Don’t miss this insightful, full-day event!

P.S. - Register by January 31 and be entered to win an Amazon gift card!
 January 9, 2010
Minimize

 
This toolkit dramatically cuts the effort, cost, and risk of migrating from MySQL to SQL Server 2008 and SQL Azure
 
 
This toolkit dramatically cuts the effort, cost, and risk of migrating from MySQL to SQL Server 2005

 December 19, 2009
Minimize
SQL Server 2008 Express is a powerful and reliable data management system that delivers a rich set of features, data protection, and performance for embedded application clients, light Web applications, and local data stores
 December 5, 2009
Minimize

This add-in allows you to take advantage of new SQL Server 2008 R2 Reporting Services report processing and management capabilities in SharePoint integrated mode
 
 
Get groundbreaking technology, such as fast manipulation on large data sets, streamlined integration of data, and the ability to effortlessly share your analysis through Microsoft SharePoint 2010

 November 21-22, 2009
Minimize

So Cal Los Angeles Code Camp - November 21st and 22nd at USC
This will be the best Code Camp ever!

Don't miss it!!  Check out these links for details: http://www.lacodecamp.com/ or http://www.socalcodecamp.com/

 November 19, 2009
Minimize

SQL Server Integration Services (SSIS) 2008: Shoot From The Hip

Presented by: Ron Landers
 
 
This discussion will focus on a plethora of SSIS 2008 topics. Some of the topics I will be discussing include (but not be limited to) efficient package development, configuration, deployment, logging, new and enhanced transforms, constraints and controlling workflows, and variables and expressions.
During the session we will build and review various packages to illustrate the concepts presented, as well as discuss the application of the various topics to a production runtime environment. After all, what good would attending this session be without the ability to directly apply what we discuss in your existing environment?
This will be a dynamic interactive meeting and all relevant questions and discussion topics are welcome. Please bring your questions and your experiences to this meeting so we all can learn and benefit!
 

Attached are 2 zip files. One is the solution and one is the folder sturcture template I discussed.

SQLLA_Solution.zip SQLLA_DirStructure.zip
 
Here is the link to the article from Jamie Thompson on naming standards:
 
http://consultingblogs.emc.com/jamiethomson/archive/2006/01/05/SSIS_3A00_-Suggested-Best-Practices-and-naming-conventions.aspx
 

 November 14, 2009
Minimize

 
Download the a community technology preview release of the documentation and tutorials for Microsoft SQL Server 2008 R2

 October 26, 2009
Minimize
This on-demand series will walk through the new features of SQL Server 2008 R2. Topics include Report Builder 3.0, building your ISV ETL application, ISV operational application, looking at which R2 edition is right for you, and more.
 October 17, 2009
Minimize

 
This add-in allows you to take advantage of SQL Server 2005 Service Pack 2 report processing and management capabilities within Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server 2007.

 October 9, 2009
Minimize

 
The SQL Server Driver for PHP is a PHP 5 extension that allows for the reading and writing of SQL Server data from within PHP scripts.

 September 19, 2009
Minimize

IIS Database Manager allows you to easily manage your local and remote databases from within IIS Manager
 
 
IIS Database Manager allows you to easily manage your local and remote databases from within IIS Manager

 September 15, 2009
Minimize

 
Available on demand starting September 21, this series of short how-to videos will touch on SQL Server Express 2008 features such as how to back up and restore a SQL Express database, how to back up a remote SQL Express database, how to update SQL Server Express 2005 to SQL Server Express 2008, and more.
 
 
Explore how you can build offline smart client applications in a RAD way that synchronizes a back-end database with a local instance of Microsoft SQL Server Compact 3.5.
 
 
This lab provides an introduction to the development of a Windows Presentation Foundation (WPF) client with Visual Studio 2008.

 September 12, 2009
Minimize
A platform for the continuous and incremental processing of unending sequences of events (event streams) from multiple sources with near-zero latency
 September 4, 2009
Minimize
The SQL Server 2008 R2 August Community Technology Preview (CTP) rollout continues. Download the SQL Server 2008 R2 August CTP today and register for the free SQL Azure August CTP.
 September 2, 2009
Minimize

24 Hours of FREE, Nonstop SQL Server Training from PASS

Join Us for 24 Hours of Nonstop SQL Server Training

 
Stock up on the caffeine! The FREE 24 Hours of PASS event is bringing an exceptional lineup of SQL Server and BI experts to your computer starting at 00:00 GMT (UTC) on September 2, 2009.
 
24hrs button 
 July 8, 2009
Minimize
 July 5, 2009
Minimize

 
Binary code analysis tool that helps identify common variants of certain prevailing vulnerabilities that can give rise to common attack vectors such as Cross-Site Scripting, SQL Injection, and XPath Injection
 
 
Binary code analysis tool that helps identify common variants of certain prevailing vulnerabilities that can give rise to common attack vectors such as Cross-Site Scripting, SQL Injection, and XPath Injection

 June 25, 2009
Minimize
 

SQL Server Videos

  Strategy Companion – BI Tools for SQL Server   
10 minutes, 10 seconds
In this Channel 9 video, Suresh Sreedharan, ISV Architect Evangelist, sits down with Bob Abernethy, SVP at Startegy Companion, to talk about their BI offering.
 
  How Do I: Profile Data with the Data Profiling Task and Viewer   
14 minutes 15 seconds
Data quality is important to every business. Using the SQL Server 2008 Data Profiling Task computes statistics about the data in a database to spot incorrect values. The Data Profiling Viewer allows you to view the generated statistics. In this video Scott Golightly shows how to create the data profile and how to review the results.
 
  How Do I: Import Text Files with SQL Server Integration Services?   
9 minutes 48 seconds
Many programs produce logs as plain text files. Sometimes these log files need to be imported into SQL Server to allow further analysis of the data. In this video Scott Golightly shows how to use SQL Server Integration Services to import text files into SQL Server.

 June 23, 2009
Minimize

SQL Server 2008 R2 CTP Is Coming Soon
During the summer of 2009, Microsoft will offer a community technology preview (CTP) of SQL Server 2008 R2. Sign up now to receive an e-mail notification of the availability of the CTP.

 May 29, 2009
Minimize

 
Visit this site to learn more about how SQL Server 2008 can help reduce costs and do more.
 
 
Use this easy ROI calculator to estimate your savings, or download the Full SQL Server Value Calculator for a more accurate assessment.
 
 
To better understand and communicate a business case for upgrading to SQL Server 2008, check out this study, which provides a framework for evaluating the potential financial impact to the organization of upgrading from a previous version of SQL Server to SQL Server 2008.
 

More on the Benefits of SQL Server 2008

 
Microsoft SQL Server 2008 Upgrade Advisor analyzes instances of SQL Server 2000 and SQL Server 2005 in preparation for upgrading to SQL Server 2008. It identifies feature and configuration changes that might affect your upgrade, and provides links to documentation that describes each identified issue and how to resolve it.

 May 15, 2009
Minimize
Download the SQL Server 2008 Developer Training Kit to understand how to build Web applications that deeply exploit the rich data types, programming models, and new development paradigms in SQL Server 2008.
 May 8, 2009
Minimize

Find Visual Studio products and extensions   
Find products, extensions, and add-ins that work with Visual Studio.
 
 
Use this SQL adapter, which is also a part of the BizTalk Adapter Pack 2.0, to connect BizTalk applications to SQL Server.

 May 4, 2009
Minimize

This afternoon, Ben Aminnia spoke at the Los Angeles .NET Developers Group www.ladotnet.org about the architecture of www.vipletters.com – a web-based system for composition, archival, and retrieval of MS Word documents on a SQL Server database without using Office Automation.

 April 30, 2009
Minimize

 
Download the SQL Server Driver for PHP Version 1.0 Cumulative Update - April 2009.
 

 April 14, 2009
Minimize

Office SharePoint Designer 2007 provides the tools you need to deliver compelling and attractive SharePoint sites and quickly build workflow-enabled applications and reporting tools on the SharePoint platform.
 
 
SQL Server 2008 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.

 April 11, 2009
Minimize

Use these free report packs to simplify your report tasks, improve your business visibility, and speed your decision making.
 
 
Download the SQL Server JDBC Driver 2.0, a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces available in Java Platform, Enterprise Edition 5.

 March 12, 2009
Minimize
Download the Microsoft Assessment and Planning (MAP) Toolkit and bypass the labor-intensive task of locating and discovering SQL instances. Migration to SQL Server 2008 is faster and easier when you use the MAP Toolkit for your assessment and planning needs.
 March 4, 2009
Minimize

This afternoon, Ben Aminnia spoke at the Southern California .NET Developers Group www.socaldotnet.org about the architecture of www.vipletters.com – a web-based system for composition, archival, and retrieval of MS Word documents on a SQL Server database without using Office Automation.

The title of this presentation was: Using ASP.NET, XSLT, and XML to Take SQL Server to a New Height
 
A copy of Ben's PowerPoint presentation can be downloaded via this link.
 March 3, 2009
Minimize

Free Seminar on Friday, March 13, 2009

Seminar: A Day with the SQL Server Experts
Location:
 Quest Software Headquarters
Address: 5 Polaris Way, Aliso Viejo, CA 92656 - BLDG 5
Date: Friday, March 13, 2009
Time:  9:00 a.m. - 4:00 p.m. Pacific Time
Breakfast, lunch and refreshments provided.

http://www.quest.com/ecard/26289/3780/ 

 February 28, 2009
Minimize
Microsoft SQL Server 2008 Management Studio Express is a free, integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server.
 

Note:

Connecting to Visual Studio 2005 requires downloading and installing Visual Studio 2005 Support for SQL Server 2008, Community Technology Preview.

Please read important information in the
Release Notes before installing SQL Server 2008 with Visual Studio 2008.

To learn more about what is required to run SQL Server 2008 Management Studio Express, see the
system requirements page.

 February 21, 2009
Minimize
Microsoft SQL Server 2008 Express with Tools is a free, easy-to use version of SQL Server Express that includes more features and makes it easier than ever to start developing powerful data-driven applications for the Web or local desktop.
 January 31, 2009
Minimize

Microsoft SQL Server 2008 Books Online (January 2009)

Download the documentation and tutorials for Microsoft SQL Server 2008.
 January 17, 2009
Minimize
This download includes two add-ins for Microsoft Office Excel 2007 (Table Analysis Tools and Data Mining Client) and one add-in for Microsoft Office Visio 2007 (Data Mining Templates).
 November 24, 2008
Minimize

Try a Virtual Lab:

After completing this lab, you will be better able to understand appropriate uses for the Resource Governor, create resource pools, create workload groups and also monitor resource usage.
 
Download SQL Server 2008 180-day Trial Software for IT Professionals. Microsoft SQL Server 2008 is a database platform for large-scale online transaction processing (OLTP), data warehousing, and e-commerce applications; it is also a business intelligence platform for data analysis and reporting solutions.
 
Download SQL Server 2008 180-day Trial Software for Developers. Microsoft SQL Server 2008 is a database platform for large-scale online transaction processing (OLTP), data warehousing, and e-commerce applications; it is also a business intelligence platform for data analysis and reporting solutions.

 
 October 6, 2008
Minimize

A Decision Maker's Overview of Business Intelligence in SQL Server 2005 - Ben Aminnia

Here's the opportunity to wear both an architect's and a developer's hat at the same time.  Click here

SQL Server Upgrade Advisor analyzes instances of SQL Server 2000 and SQL Server 2005 to help prepare for upgrades to SQL Server 2008.
 
This download includes two add-ins for Microsoft Office Excel 2007 (Table Analysis Tools and Data Mining Client) and one add-in for Microsoft Office Visio 2007 (Data Mining Templates).
 
This feature pack is a collection of standalone install packages that provide additional value for SQL Server 2008.
 
This add-in for Microsoft SharePoint Technologies provides features for running a report server within a larger deployment of Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server 2007.
 
Copyright 2004-2012 by Los Angeles SQL Server Professionals Group, Inc.   Terms Of Use  Privacy Statement
DotNetNuke® is copyright 2002-2012 by DotNetNuke Corporation