NJ SQL Server User Group

NJSQL March 16th Meeting - SQL 2008 Auditing Features with MAK

SQLDiva — Mon, 01 Mar 2010 22:24:00 GMT

Date: Tuesday, March 16th

Topic: SQL Server 2008 Auditing features

Presenter: Muthusamy Anantha Kumar(a.k.a. MAK)

Summary:
This session will demonstrate the various legal compliance requirements / controls such as Sarbanes Oxley, SAS 70, etc and how to make use of SQL Server 2008 Auditing features to achieve it. This includes different types Auditing - Server level, Database Level and Audit level. This demo also includes auditing steps like auditing a domain group, Auditing job changes etc.

Bio:
Muthusamy Anantha Kumar(a.k.a. MAK - http://www.mssqlengineering.com)
MAK is a Microsoft Certified IT Professional - Database Administrator ( MCITP SQL Server 2008, MCITP SQL Server 2005) . He has more than 11 years of experience in Information Technology including Database Engineering, Database Administration, System Analysis, Design, Development and Support of MS SQL Server 2008/2005/2000/7.0/6.5/6.0/4.X for production/development/testing. He is experienced in MS SQL Server Engineering, installation, configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery. He has handled VLDBs and been involved in SDLC of various data warehouse projects. Currently, MAK is Senior Database Engineer responsible for Engineering and standardizing Microsoft SQL Servers in one of the big finance companies on Wall Street. Previously, he was a Senior Database Administrator/Data Architect, responsible for development, test, DR and production servers for many finance , .com and B2B companies. He plays an active role in forums as a SQL Expert and moderator. He also teaches Database Administration at University of West Florida. He also teaches SQL Server part time in New Jersey. He published many online articles and he is a contributing columnist in DatabaseJournal.com. He is also publishing online articles in SQL-Server-Performance.com and SQLServercentral.com.

Agenda:
6:00pm - 6:30pm: Networking, Pizza & Group Discussion
6:30pm: Presentation

Refreshments: TekSystems

Sponsors: Quest (Swag)

Give-A-Ways:
Lots of Swag from Quest!!

NJSQL December 15th Meeting - Lots of Presenters, Prizes and Food!!

SQLDiva — Mon, 14 Dec 2009 17:06:00 GMT

Date: Tuesday, December 15th

Location: SetFocus (Directions)

Agenda:
6:00pm - 6:30pm: Dinner (Microsoft/ApexSQL)
6:30pm - 6:40pm: NJSQL/Community Updates
6:45pm: Red-Gate Demo - Alec Lazarescu
7:05pm: SQL Server Profiler in a production environment - Bill Foster
7:25pm: Northwind Velocity - Waseem Naik
7:45pm: Dessert (SetFocus)
7:50pm: SQL Azure - 15 questions answered - Jayaram Krishnaswamy
8:10pm: ApexSQL Demo - Michael Coles
8:30pm: Closing/Prizes

Refreshments: Not Pizza...(something a little nicer)

Sponsors: Microsoft/ApexSQL/Red-Gate

Give-A-Ways: Thumb Drives (Red-Gate), ApexSQL License (ApexSQL),
Zune, Windows 7 & Office 2007 (Microsoft)

Website: www.njsql.org

Google Group: http://groups.google.com/group/nj-sql-server-user-group

Linked In: http://www.linkedin.com/groups?gid=1964935&trk=myg_ugrp_ovr

SQLDiva

NJSQL Jobs Moved to LinkedIN

SQLDiva — Tue, 08 Dec 2009 18:10:00 GMT

Jobs will no longer be posted here!!

The "NJ SQL Server User Group" was created on LinkedIN several months ago. As you may/may not know, LinkedIn is a great way to share professional information about yourself and network with professionals in your field. There are often times that we are asked by recruiters if anyone in the User Group is looking for a job or if anyone specializes in a particular area of SQL Server. These questions are hard to answer and rather than keeping our own information about you, we would like to utilize LinkedIn.

Additionally, recruiters often contact us to post jobs that need to be posted on a timely basis. By allowing recruiters to join the LinkedIn Group (not the Google Group), they will be able to post jobs on the 'Job' tab of the LinkedIn Group as jobs become available. The job postings will remain on LinkedIn and there are no current plans to add them to njsql.org or this Google Group.

NO LinkedIn = NO Job Info

So, if you want to be privy to job information, please join LinkedIn and the "NJ SQL Server User Group" on LinkedIn.

Also, let me know if you have any comments on this!!

SQLDiva

December 15th NJSQL Meeting - NJSQL Speaker Idol (Speakers Requested)

SQLDiva — Tue, 08 Dec 2009 15:58:00 GMT

The December NJSQL User Group meeting will feature vendor presentations and a number of other presentations/discussions provided user group members and guests. We also are hoping to expand the refreshment menu for this Holiday Time Meeting.

If you are a user group member that would like to participate in this year's "NJSQL Speaker Idol", please send me an email with your name/topic by Thursday, December 10th. The number of participants is limited to 5 (1-2 spots are already filled).

"NJSQL Speaker Idol" participants with be required to provide 15 minutes of SQL Server content with/without the use of PowerPoint slides/demos. A vote will be taken at the end of the presentations and a number of prizes will be distributed which includes a Microsoft Zune. Other prizes include Office 2007, Windows 7 and More...

A full meeting agenda will be published by Friday, December 11th.

SQLDiva
Melissa@njsql.org

NJSQL UG November 17th Meeting - SQL Server Spatial Development with Michael Coles

SQLDiva — Fri, 13 Nov 2009 15:49:00 GMT

Date: Tuesday, November 17^th (Directions)

Agenda:

6:00pm - 6:30pm: Pizza and Vendor Presentation (Future IT)

6:30pm - 6:40pm: NJSQL Community Updates

6:40pm: Presentation

Refreshments: Pizza/Soda

Sponsor: Microsoft

Give-A-Ways: TBD

Presenter: Michael Coles

Topic: SQL Server Spatial Development

Topic Summary:

In this session we'll discuss how to develop for SQL Server spatial data in detail, including specifics about interfacing with third party mapping tools (i.e. Bing Maps), using the spatial data type methods to perform spatial calculations, and properly indexing spatial data.

Bio:

Michael Coles is a Microsoft MVP (SQL) with over 15 years experience designing and building SQL Server databases and SQL-centric business solutions. A prolific writer on all aspects of SQL Server, particularly on the expert use of T-SQL, he has authored dozens of published articles and several books including "Pro T-SQL 2008 Programmer's Guide", "Expert SQL Server 2008 Encryption", and "Accelerated SQL Server 2008".

SQLDiva

MS SQL Server Database Administrator - NJM (West Trenton)

SQLDiva — Mon, 09 Nov 2009 21:32:00 GMT

The NJM Insurance Group is a top-notch team of employees dedicated to providing quality service to policyholders. The Company is headquartered in West Trenton, New Jersey, and operates branch offices in Parsippany and Hammonton, New Jersey. NJM is the Garden State's largest provider of Personal Auto and Workers’ Compensation insurance, with nearly $1.5 billion in direct premiums written in 2008. NJM shares the benefits of its prudent operations in the form of dividends to policyholders.

For consideration, please email your resume, in WORD format to: resume@NJM.com Use the code: SQL DBA-ITMK in the subject line. Please indicate your salary requirements.

Description:
• The West Trenton Information Technology Department has an immediate opening for a MS SQL Server Database Administrator.
• The candidate will be responsible for the operational support of NJM's SQL Server Database environment. This advanced position plays an integral role in the maintenance and support of business critical applications. Candidates should be team players with excellent communication skills and have the ability to manage a multitude of database assignments independently.

Qualifications include:
• Expertise (6+ years) in SQL Server 2000 and 2005 required.
• Proven troubleshooting abilities a must.
• Specific SQL Server Administration experience including: Triggers, Stored Procedure Code Reviews and Development, Data Integration and Migration, Management Studio, SQL XML and Database Auditing and Controls.
• Strong understanding of Security implementation required.
• Knowledge of Windows 2000, 2003 and at least 5+ years experience with XP required.
• Must have a a strong knowledge of SQL and Stored Procedure Language and relational database concepts.
• Ability to translate Logical Data Models into physical structures required.
• Must be skilled at SQL Server performance management and tuning.
• Strong project management, planning and analysis skills required.
• Must be able to mentor/guide junior administrators.
• Prior application development experience including architectural and design skills are strongly preferred.

Responsibilities include:
• Database object review, creation, maintenance, and change control.
• Monitoring relational databases to optimize performance, resource use, and physical implementation.
• Supporting highly-available database technologies (clustering).
• Monitoring and maintaining database security in cooperation with data security administrators.
• Migrating databases between servers and various platforms.
• Server Reporting services support and implementation.
• Database back-up/recovery.
• Fault analysis and resolution.
• Implementing and maintaining disaster recovery solutions including replication and Log Shipping.
• Monitoring and managing database backups, logs, and maintenance.
• Supporting the Data Modeling unit with the design of new databases to meet application requirements.
• Supporting design and implementation of ETL processes between disparate systems.
• Assisting the DB2 DBA team with DB2 administrative duties.
• On-Call Support.

NJM provides employees with an attractive benefits package which includes an on-site cafeteria, a nonsmoking work environment, group health, disability, dental and life insurance, a retirement plan, 17 days paid time off annually, and a superior Company-matched savings fund plan.

NJM is an equal opportunity employer.

NJSQL/NYCSQL Saturday, October 24th (Registration Required)

SQLDiva — Mon, 05 Oct 2009 14:19:00 GMT

The NJ and NYC SQL Server User Groups would like to invite you to a FREE Saturday Event featuring Jacob Sebastian (India).

Date: Saturday, October 24^th

Time: 9:00am - 3:00pm (Sign-in begins at 8:15am)

Location: Microsoft Office (Iselin, NJ)

Registration Link: https://www.clicktoattend.com/invitation.aspx?code=141878

User Group Websites:

NJSQL - http://njsql.org/Default.aspx

NYC - http://nycsqlusergroup.com/

Sponsors: Red-Gate, Moore-Stephens Business Solutions, LLC, Pearl Knowledge Solutions, Inc, Apress

Swag: Books, SQLCentric License, Cool Stuff from Red-Gate

Bios/Topic Summary/More Detail:

http://njsql.org/blogs/user_group_news/pages/NJSQL_2F00_NYCSQL-Saturday-Event-_2D00_-Saturday_2C00_-October-24th-_2800_9am_2D00_3pm_2900_.aspx

Agenda:

8:15am - 9:00am: Attendee Check-In and Breakfast

9:00am - 9:15am: Welcome

9:15am - 10:45am: Presentation #1

Speaker: Michael Coles (Clifton, NJ)

Topic: "Where in the World?" -- Spatial Data in SQL Server 2008

10:45am-11:00am: Break

11:00am - 12:30pm: Presentation #2

Speaker: Robert Pearl (New York, NY - Pearl Knowledge Solutions, Inc. - www.pearlknows.com)

Topic: Who Did it and Ran?

12:30am - 1:15pm: Lunch

1:15pm - 2:45pm: Presentation #3

Speaker: Jacob Sebastian ( India - http://beyondrelational.com/blogs/jacob/ )

Topic: Best practices for exception handling and defensive programming in SQL Server

2:45pm - 3:00pm: Wrap-Up and Raffle/Swag

NJSQL October 20th Meeting - Effective Database Administration with a Central Repository with Linchi Shea

SQLDiva — Mon, 28 Sep 2009 18:52:00 GMT

Date: Tuesday, October 20th

Agenda:

6:00pm - 6:30pm: Networking & Pizza

6:30pm - 6:40pm: NJSQL Community Updates

6:40pm: Presentation

Refreshments: Pizza/Soda

Sponsor: Microsoft

Give-A-Ways: TBD

Presenter: Linchi Shea

Topic: What’s Effective Database Administration with a Central Repository

Topic Summary:

Many database administrative tasks are essentially the same across all the databases and the servers. These include monitoring, capacity planning, policy enforcement, best practice checking, and so on. Many more database administrative tasks are at an aggregate level, requiring data from individual databases across your enterprise. These include various reporting tasks, and investigative tasks that may need to check all or a subset of your databases or servers across the enterprise.

Having a central repository of your databases and servers is absolutely necessary for you to accomplish these tasks in a professional manner. This presentation discusses what you should have in such a repository, how you may pull data together into the repository and keep it up to date, and what problems and tasks you can effectively manage with such a repository.

Bio:

Linchi Shea has been working with SQL Server since version 4.21a. He works in the financial services sector in and around New York City. Linchi is passionate about creating robust and automated infrastructures for managing SQL Server in an enterprise environment, and enjoys troubleshooting performance issues. He has written many tools and utilities to simplify deploying, operating, testing, and troubleshooting SQL Server. You can find him blogging about SQL Server enterprise issues at www.sqlblog.com. Linchi is a co-founder and co-lead of the NYC SQL Server users group, and has been a Microsoft MVP since 2002.

LiveMeeting and Conference Call Info for Tuesday, September 15th NJSQL Meeting

SQLDiva — Tue, 15 Sep 2009 15:38:00 GMT

Time: 6:30PM EST
Where: Phone & Online

Attendee url: https://www.livemeeting.com/cc/questm/join?id=N2ZC8W&role=attend&pw=m%3BG%2Fjq9%25H

Toll free: +1 (888) 205-5513
Toll: +1 (719) 995-0562
Participant code: 377501

Upcoming Meetings Preview: October, 2009 to January, 2010

SQLDiva — Mon, 14 Sep 2009 13:38:00 GMT

October 20th
Presenter: Linchi Shea
Topic: SQL Server Infrastructure.
Details: Effective SQL Server management with a Central Repository
Sponsor: Needed

November 17th
Presenter: Michael Coles
Topic: Spatial features in SQL 2008 R2
Sponsor: Needed

December 15th
Presenter/s: User Group Members
Topic: This meeting will focus on User Groups members.
It would be great to have 2-4 members present on a topic for 15 minutes.
The balance of the meeting will be devoted to Q&A and Holiday Cheer!!
Sponsor: Needed

January 19th
Presenter: Kevin Goff
Topic: TBD - Reporting Services Topic
Sponsor: Needed

NJSQL September Meeting Tuesday, 9/15: What’s New in SQL Server 2008 R2

SQLDiva — Tue, 08 Sep 2009 12:48:00 GMT

Date: Tuesday,September 15^th

Agenda:

6:00pm - 6:30pm: Networking & Pizza

6:30pm - 6:40pm: NJSQL Community Updates

6:40pm: Presentation

Refreshments: Pizza/Soda

Sponsor: Quest

Give-A-Ways: 2-$25 Gift Cards / Magazines / Cube Posters

Presenter: Brent Ozar

Topic: What’s New in SQL Server 2008 R2

Topic Summary:

Come enjoy an entertaining and informative overview of the new features in SQL Server 2008 R2. Brent will be presenting via LiveMeeting. Quest has sent me 96lbs of Give-Aways!! Yes, you read that right!!

Bio:

Brent Ozar is a SQL Server Expert with Quest Software. Brent has a decade of broad IT experience, including management of multi-terabyte data warehouses, storage area networks and virtualization. In his current role, Brent specializes in performance tuning, disaster recovery and automating SQL Server management. Previously, Brent spent two years at Southern Wine & Spirits, a Miami-based wine and spirits distributor. He has experience conducting training sessions, has written several technical articles and blogs prolifically at http://www.BrentOzar.com. He is a regular speaker at PASS events and the Editor-in-Chief of SQLServerPedia.com.

His online presences include:

SQLServerPedia Profile: BrentOzar

Email: Brent.Ozar@Quest.com

Blog: http://www.brentozar.com/

Twitter: http://twitter.com/brento/

Bookmarks: http://delicious.com/brento/

NJSQL August Meeting Thursday, 8/13: SSIS Tips and Tweaks with Todd McDermid

SQLDiva — Tue, 21 Jul 2009 03:00:00 GMT

Date: Thursday, August 13^th (Yes…Thursday is correct for this month only!!!)

Agenda:
6:00pm - 6:30pm: Networking & Pizza
6:30pm - 6:40pm: NJSQL Community Updates
6:40pm: Presentation

Refreshments: Pizza/Soda

Sponsor: TBD

Give-A-Ways: TBD

Presenter: Todd McDermid

Topic: SSIS Tips and Tweaks

Topic Summary:
Loading a Data Warehouse using SSIS should be pretty easy – all the tools you’ll need are in the box. However, there are a few things you should avoid and non-obvious best practices to use to make that ETL faster and more reliable. Assuming attendees have a basic level of familiarity with Kimball Data Warehousing methodology, this talk will explain how to accomplish Kimball ETL using SQL Server Integration Services. We'll quickly review the SCD Wizard and how it works for processing your dimension tables - what it's good for, what it's not, and what alternatives you have to it. We'll also examine fact table loading using a surrogate key replacement pipeline, including use of the Lookup component for date-ranged lookups. Finally, we’ll look at specific and easy performance tweaks, techniques and best practices. Depending on time constraints,that can include reviewing which Data Flow components to avoid and how to still get your work done without them, tuning inserts and updates, or issues from the audience.

Bio:

Todd McDermid has been developing software for about two decades, and most of that software has used SQL Server for data storage. He has primarily been involved with Manufacturing and Supply Chain projects, both in ISVs and as an internal IT resource. In recent years, he’s discovered Business Intelligence and the Microsoft platform – turning him into somewhat of an evangelist for using BI to support performance management in his current organization. To assist in achieving that goal, he’s used Integration Services to populate a Data Warehouse, using standard as well as custom built SSIS components. Along the way he’s earned his MCSD.Net and MCTS (on SQL08BI). He’s currently a moderator of the MSDN SSIS forums, coordinator of two CodePlex open-source projects, and frequent blogger on SSIS topics.

SQLDiva

NJSQL July Meeting 7/21 - SQL Server Administration with Windows PowerShell with MAK and Yan

SQLDiva — Thu, 04 Jun 2009 01:55:00 GMT

Agenda:
6:00pm - 6:30pm: Networking & Pizza
6:30pm - 6:40pm: NJSQL Community Updates
6:40pm: Presentation

Refreshments: Pizza/Soda

Sponsor: Wrox

Give-A-Ways: TBD

Presenter/s: MAK and Yan

Topic: SQL Server Administration with Windows PowerShell

Topic Summary:
Windows PowerShell is an administrative scripting tool that allows you to automate many tasks you're probably currently doing by hand. Presentation includes Introduction to Windows PowerShell, SQL Server 2008 powershell providers, SQL Server administration etc.

Book(Released June, 2009): Microsoft SQL Server 2008 Administration with Windows PowerShell

Bios:

Muthusamy Anantha Kumar(a.k.a. MAK - http://www.mssqlengineering.com)

MAK is a Microsoft Certified IT Professional - Database Administrator ( MCITP SQL Server 2008, MCITP SQL Server 2005) . He has more than 11 years of experience in Information Technology including Database Engineering, Database Administration, System Analysis, Design, Development and Support of MS SQL Server 2008/2005/2000/7.0/6.5/6.0/4.X for production/development/testing. He is experienced in MS SQL Server Engineering, installation, configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery. He has handled VLDBs and been involved in SDLC of various data warehouse projects. Currently, MAK is Senior Database Engineer responsible for Engineering and standardizing Microsoft SQL Servers in one of the big finance companies on Wall Street. Previously, he was a Senior Database Administrator/Data Architect, responsible for development, test, DR and production servers for many finance , .com and B2B companies. He plays an active role in forums as a SQL Expert and moderator. He also teaches Database Administration at University of West Florida. He also teaches SQL Server part time in New Jersey. He published many online articles and he is a contributing columnist in DatabaseJournal.com. He is also publishing online articles in SQL-Server-Performance.com and SQLServercentral.com.

Yan Pan(http://www.yanpansql.com)

Yan (MCITP SQL Server 2008, MCITP SQL Server 2005, MCDBA SQL Server 2000, OCA Oracle 10g) is a Senior DBA for a leading global financial services firm, where her daily duties include administering hundreds of SQL Server and Oracle servers of every possible version, working with business units on software development, troubleshooting database issues, and tuning database performance. She is also a contributing columnist for DatabaseJournal.com. Her articles can be found at http://www.yanpansql.com/

Previously, Yan worked as a SQL Server DBA and a .NET developer at Data Based Ads, Inc., and developed two .NET Web applications. Before that, she worked at AT&T Research Labs. She designed OLAP cubes with SQL Server Analysis Services and developed PivotTable reports for regional managers. She has master’s degrees in Computer Science and Physics.

SQLDiva

Summer 2009 MSDN “Suburban” Roadshow Series - Parsippany 6/16 (Registration Required)

SQLDiva — Tue, 02 Jun 2009 15:43:00 GMT

Announcing the Summer 2009 MSDN “Suburban” Roadshow Series

Peter Laudati and I are happy to announce that we’ll be kicking off a late spring/early Summer 2009 series of the MSDN “Suburban” Roadshow! There’s a tendency for Microsoft (and other companies) to host live events in NYC as it’s the center of our area. But, as suburbanites ourselves, We know it can be a pain to take a day off of work and fight the elements to trek into Manhattan. One extra hassle can keep you from improving your skills and learning about the newest technologies. Don’t let that hold you back any longer!

Our Spring 2009 series will be making stops throughout the ‘burbs in north and central Jersey. Ironically, we also know that for urbanites in the big city, getting to the ‘burbs can be a major ordeal for you too! Many Manhattan-ites don’t own cars, and the suburbs are not mass transit friendly. So, we’ll bring the “Suburban” Roadshow back to NYC also.

We are scheduling the “Suburban” Roadshow events to occur on the same day as the local user group in all locations. So, if you take a half-day off to join us at the Roadshow, you’ll get a full day of content by sticking around for the user group sessions in the evening. The Roadshows run 1pm – 5pm, and most of the user groups will run from 6-8pm.

Here’s the Summer 2009 agenda line up:

Up, Up, and Away! Storage in the Microsoft Cloud

The Azure Services Platform provides a rich set of cloud-based storage options for building both cloud resident and hybrid cloud + on-premise applications. This session will show you how to leverage Windows Azure Blobs, Tables and Queues as well as the new fully relational SQL Data Services.

Developing on Microsoft Windows 7

Building applications that are easy to use, visually appealing, and that offer high performance is a challenge that developers face every day. Innovative applications can greatly improve the user experience, empowering companies to differentiate their services and solutions. However, developers are increasingly asked to do more in less time, while also optimizing the power and performance requirements of their applications.

The Windows 7 platform makes it easy for developers to create engaging, user-friendly applications by providing familiar tools and rich development features that allow them to take advantage of the latest PC capabilities. In this session we will explore the new Taskbar and Jump Lists, the Scenic Ribbon, file management with Libraries, and Windows Web Services among many other enhancements to the new operating system.

Using MS AJAX & jQuery with ASP.NET

As AJAX has risen in popularity over the past few years, most web developers have found themselves spending more time programming in JavaScript. This has led to a rise in JavaScript frameworks to make this style of programming easier. In 2007, Microsoft released its own AJAX library. At the same time, an open source JavaScript library called jQuery started gaining in popularity. In late 2008, Microsoft announced that it would be supporting jQuery as a part of ASP.NET going forward.

Both of these libraries work great together with ASP.NET’s WebForms and new MVC framework. In this session we’ll explore how you can use these JavaScript libraries to enhance your web applications. We’ll also look at the tools you’ll want to have in your toolbox when doing AJAX programming, as well as how to troubleshoot typical issues you’ll run into.

Here’s the schedule with registration links:

REGISTER NOW – Space is limited!

Location

Date & Time

Registration

Infragistics Headquarters

50 Millstone Rd., Building 100
East Windsor, NJ 08520

June 11, 2009

1:00 PM - 5:00 PM

Click here to Register

Or call 877.673.8368
With Event ID: 1032415493

Set Focus

4 Century Drive
Parsippany, NJ 07054

June 16, 2009

1:00 PM - 5:00 PM

Click here to Register

Or call 877.673.8368
With Event ID: 1032415492

Microsoft New York Office

1290 Avenue of the Americas, 6^th Floor
New York, NY 10104

June 24, 2009

1:00 PM - 5:00 PM

Click here to Register

Or call 877.673.8368
With Event ID: 1032415487

NJSQL June Meeting 6/16 - Bill Vaughn (SQL Server CLR Executables)

SQLDiva — Tue, 19 May 2009 18:40:00 GMT

Date: Tuesday, June 16th

Registration Required: https://www.clicktoattend.com/invitation.aspx?code=138666

Agenda:

1:00pm - 5:00pm: MSDN Suburban Road Show Series (Peter Laudati Bill Zack)

6:15pm - 6:30pm: Networking & Pizza

6:30pm - 6:40pm: NJSQL Community Updates

6:40pm: Presentation

Refreshments: Pizza/Soda

Sponsor: INETA

Give-A-Ways: Books

Presenter: Bill Vaughn

Topic: SQL Server CLR Executables

This walks you through the development process of creating each of the CLR executables. We'll talk about what kind of executables make sense and which won't. I'll show examples that have never been shown by anyone else that really push the CLR executable technology to the limits. This is a fairly advanced session, but very popular among both SQL Server developers and DBAs wondering if CLR executables are a path to better performance or just more problems.

Bio:

Bill is a developer, trainer, and author of numerous books on Visual Basic and data access programming (See Books). After 14 years with Microsoft and over 30 years working in the computer industry, Bill left Microsoft in 2000 to focus more on his own writing and training for Beta V. During his years with Microsoft, Bill held numerous roles which included working with the Windows 1.0 Developer Liaison team, Microsoft University, the Visual Basic User Education team, the Visual Studio marketing team, and finally at Microsoft Technical Education. Currently, Bill writes and travels the globe in order to guide, mentor, and train developers in his areas of expertise: Visual Basic, data architectures, ActiveX Data Objects (ADO), and the new .NET Framework. Bill is also an INETA speaker so feel free to contact INETA to get him to speak to your user group. Bill was made a Microsoft MVP in 2003 and 2004 for his contribution to the developer community. You can find him answering questions on the Microsoft public newsgroups. Visit microsoft.public.dotnet.framework.adonet.

NJSQL Performance Tuning Saturday (5/16/09) - Sponsorship Page

SQLDiva — Tue, 12 May 2009 20:23:00 GMT

Use of Microsoft Office	Microsoft - A Big Thanks goes out to Peter Laudati (local Microsoft Developer Evangelist!!!	http://blogs.msdn.com/peterlau/
Breakfast (Coffee/Donuts)	Microsoft	www.microsoft.com
Lunch (Pizza)	FalconStor & Microsoft	www.falconstor.com
Water /Soda	PASS	www.sqlpass.org
Swag	IPOD - FalconStor	www.falconstor.com
	T-Shirts - Edgewood Solutions	www.edgewoodsolutions.com www.mssqltips.com
	Books, Etc - CodeZone/User Group Support Services	www.codezone.com

NJSQL Performance Tuning Saturday (5/15/09) - Full Agenda, Abstracts and Bios

SQLDiva — Tue, 12 May 2009 19:18:00 GMT

Time	Description	Abstract	Bio
8:15am - 9:00am	Attendee Check-In and Breakfast
9:00am - 9:15am	Welcome
9:15am - 10:15am	Stress Testing SQL Server - Hilary Cotter/ MVP	How do you get the most bang for your buck from SQL Server? In this session Hilary Cotter will show you how determine what the current bottlenecks are on your SQL Server, and how to discover how your SQL Server will respond as your application scales. Take aways from this session are tools to help you with performance tuning and stress testing your SQL Server a methodology for tuning and stress testing your SQL Server workloads, and best practices for performance tuning and stress testing.	Hilary Cotter is a SQL Server MVP with over 20 years of IT experience. He is a guru in replication, full text search, and performance tuning. He has answered over 17,000 questions on the Microsoft newsgroups, some of them correctly.
10:15am - 10:30am	Break
10:30am - 11:30am	Query Plan Optimization / T-SQL Performance Tricks - Alec Lazarescu	You've methodically narrowed down your performance problems to a few particular queries, but where do you go from here? We'll dive into query plans and go over some ways to find potential trouble spots at a glance as well as use a few helper procedures to do analysis. Many T-SQL equivalent rewriting techniques will be explored that can have often surprisingly differing performance characteristics. The SQL optimizer has grown extremely complicated and is influenced by an incredible number of variables so, as always, the effectiveness of each technique will vary, but you will likely find a few techniques that will come in handy at some point. In addition you'll hopefully gain an appreciation for the value of creativity and experimentation for query optimization.	Alec has been a DBA/developer for over 12 years starting with Access 95 and moving to SQL Server 6.5 and has experienced firsthand the evolution of every SQL Server release since then. His current priority is a terabyte class clustered SQL Server 2005 database and the ASP.Net web site that drives it. He spends much of his time on performance tuning, troubleshooting, automation, best practices guidelines, and thinking about interesting discoveries that he should probably blog about, but never seems to have the time to.
11:30am - 12:15pm	Lunch, Vendor Presentation & IPOD Raffle - Duane Johnson –Storage Architect and Solutions Ambassador (FalconStor)	The talk will be focused on how to: Reduce overall storage costs for SQL, Optimize I/O Performance, Rapidly provide thin current copies to simplify and speed testing and development, Recover databases in 15 min or less no matter the size, Provide a simple way to protect from deletion and corruption, Replicate large datasets with minimal WAN bandwidth via "No-Dupe", Leverage CDP to protect every write, even when logging is disabled	Duane’s experience in the computer industry cover a multitude of areas including running his own technology company for 16 years servicing SMB and Enterprise accounts across the country. As a subject matter expert in multi-protocol switching technology and physical plant interconnections, Duane has been tasked to write a number of Professional Certification Exams for IBM and was the Chief Architect for the infrastructure used for the 1998 Nagano Olympics “Fan Mail” project which continues to be transformed every two years to cover both Summer and Winter Olympic Events. After joining FalconStor Software in 2005 , he spent two years maintaining the Enterprise Testing Labs at FalconStor HQ in Melville, LI and worked closely with Quality Assurance to establish testing process for testing of CDP, VTL and SIR, he now supports Sales in the Northeast as a trusted Storage Architect.
12:15pm - 1:15pm	Performance tuning XML and XQuery in SQL Server 2008 - Michael Coles/ MVP	Get the most out of your SQL Server XML and XQuery-based applications. Tips and tricks to speed up server-side XQuery and XML manipulation on SQL Server. Focus on XML shredding, XQuery path language, XML indexes, and converting relational data to XML.	Michael Coles is a SQL developer and database architect with 15 years experience. He works for a BI consulting firm in NYC and is the author of Pro T-SQL 2008 Programmer's Guide and Pro SQL Server 2008 XML. Michael has been recognized as a Microsoft MVP for his work on SQL Server.
1:15pm - 2:15pm	Disk I/O Related Performance Tuning -Linchi Shea/ MVP		Linchi Shea has been working with Microsoft SQL Server since version 4.2. He is currently responsible for SQL Server engineering at a major Wall Street firm in the New York City area. Linchi is passionate about creating robust and automated infrastructures for managing SQL Server in a large enterprise environment. He has written many tools and utilities to simplify deploying, operating, and testing SQL Server. You can find him blogging about SQL Server enterprise issues at www.sqlblog.com. Linchi is a co-founder and co-lead of the NY Metro SQL Server users group, and has been a Microsoft MVP since 2002.
2:30pm - 2:45pm	Wrap-Up and Raffle/Swag	Microsoft, FalconStor, Edgewood Solutions, PASS, Idera
Attendee Check-In and Breakfast
9:00am - 9:15am	Welcome
9:15am - 10:15am	Stress Testing SQL Server - Hilary Cotter/ MVP	How do you get the most bang for your buck from SQL Server? In this session Hilary Cotter will show you how determine what the current bottlenecks are on your SQL Server, and how to discover how your SQL Server will respond as your application scales. Take aways from this session are tools to help you with performance tuning and stress testing your SQL Server a methodology for tuning and stress testing your SQL Server workloads, and best practices for performance tuning and stress testing.	Hilary Cotter is a SQL Server MVP with over 20 years of IT experience. He is a guru in replication, full text search, and performance tuning. He has answered over 17,000 questions on the Microsoft newsgroups, some of them correctly.
10:15am - 10:30am	Break
10:30am - 11:30am	Query Plan Optimization / T-SQL Performance Tricks - Alec Lazarescu	You've methodically narrowed down your performance problems to a few particular queries, but where do you go from here? We'll dive into query plans and go over some ways to find potential trouble spots at a glance as well as use a few helper procedures to do analysis. Many T-SQL equivalent rewriting techniques will be explored that can have often surprisingly differing performance characteristics. The SQL optimizer has grown extremely complicated and is influenced by an incredible number of variables so, as always, the effectiveness of each technique will vary, but you will likely find a few techniques that will come in handy at some point. In addition you'll hopefully gain an appreciation for the value of creativity and experimentation for query optimization.	Alec has been a DBA/developer for over 12 years starting with Access 95 and moving to SQL Server 6.5 and has experienced firsthand the evolution of every SQL Server release since then. His current priority is a terabyte class clustered SQL Server 2005 database and the ASP.Net web site that drives it. He spends much of his time on performance tuning, troubleshooting, automation, best practices guidelines, and thinking about interesting discoveries that he should probably blog about, but never seems to have the time to.
11:30am - 12:15pm	Lunch, Vendor Presentation & IPOD Raffle - Duane Johnson –Storage Architect and Solutions Ambassador (FalconStor)	The talk will be focused on how to: Reduce overall storage costs for SQL, Optimize I/O Performance, Rapidly provide thin current copies to simplify and speed testing and development, Recover databases in 15 min or less no matter the size, Provide a simple way to protect from deletion and corruption, Replicate large datasets with minimal WAN bandwidth via "No-Dupe", Leverage CDP to protect every write, even when logging is disabled	Duane’s experience in the computer industry cover a multitude of areas including running his own technology company for 16 years servicing SMB and Enterprise accounts across the country. As a subject matter expert in multi-protocol switching technology and physical plant interconnections, Duane has been tasked to write a number of Professional Certification Exams for IBM and was the Chief Architect for the infrastructure used for the 1998 Nagano Olympics “Fan Mail” project which continues to be transformed every two years to cover both Summer and Winter Olympic Events. After joining FalconStor Software in 2005 , he spent two years maintaining the Enterprise Testing Labs at FalconStor HQ in Melville, LI and worked closely with Quality Assurance to establish testing process for testing of CDP, VTL and SIR, he now supports Sales in the Northeast as a trusted Storage Architect.
12:15pm - 1:15pm	Performance tuning XML and XQuery in SQL Server 2008 - Michael Coles/ MVP	Get the most out of your SQL Server XML and XQuery-based applications. Tips and tricks to speed up server-side XQuery and XML manipulation on SQL Server. Focus on XML shredding, XQuery path language, XML indexes, and converting relational data to XML.	Michael Coles is a SQL developer and database architect with 15 years experience. He works for a BI consulting firm in NYC and is the author of Pro T-SQL 2008 Programmer's Guide and Pro SQL Server 2008 XML. Michael has been recognized as a Microsoft MVP for his work on SQL Server.
1:15pm - 2:15pm	Disk I/O Related Performance Tuning -Linchi Shea/ MVP		Linchi Shea has been working with Microsoft SQL Server since version 4.2. He is currently responsible for SQL Server engineering at a major Wall Street firm in the New York City area. Linchi is passionate about creating robust and automated infrastructures for managing SQL Server in a large enterprise environment. He has written many tools and utilities to simplify deploying, operating, and testing SQL Server. You can find him blogging about SQL Server enterprise issues at www.sqlblog.com. Linchi is a co-founder and co-lead of the NY Metro SQL Server users group, and has been a Microsoft MVP since 2002.
2:30pm - 2:45pm	Wrap-Up and Raffle/Swag	Microsoft, FalconStor, Edgewood Solutions, PASS, Idera
Attendee Check-In and Breakfast
9:00am - 9:15am	Welcome
9:15am - 10:15am	Stress Testing SQL Server - Hilary Cotter/ MVP	How do you get the most bang for your buck from SQL Server? In this session Hilary Cotter will show you how determine what the current bottlenecks are on your SQL Server, and how to discover how your SQL Server will respond as your application scales. Take aways from this session are tools to help you with performance tuning and stress testing your SQL Server a methodology for tuning and stress testing your SQL Server workloads, and best practices for performance tuning and stress testing.	Hilary Cotter is a SQL Server MVP with over 20 years of IT experience. He is a guru in replication, full text search, and performance tuning. He has answered over 17,000 questions on the Microsoft newsgroups, some of them correctly.
10:15am - 10:30am	Break
10:30am - 11:30am	Query Plan Optimization / T-SQL Performance Tricks - Alec Lazarescu	You've methodically narrowed down your performance problems to a few particular queries, but where do you go from here? We'll dive into query plans and go over some ways to find potential trouble spots at a glance as well as use a few helper procedures to do analysis. Many T-SQL equivalent rewriting techniques will be explored that can have often surprisingly differing performance characteristics. The SQL optimizer has grown extremely complicated and is influenced by an incredible number of variables so, as always, the effectiveness of each technique will vary, but you will likely find a few techniques that will come in handy at some point. In addition you'll hopefully gain an appreciation for the value of creativity and experimentation for query optimization.	Alec has been a DBA/developer for over 12 years starting with Access 95 and moving to SQL Server 6.5 and has experienced firsthand the evolution of every SQL Server release since then. His current priority is a terabyte class clustered SQL Server 2005 database and the ASP.Net web site that drives it. He spends much of his time on performance tuning, troubleshooting, automation, best practices guidelines, and thinking about interesting discoveries that he should probably blog about, but never seems to have the time to.
11:30am - 12:15pm	Lunch, Vendor Presentation & IPOD Raffle - Duane Johnson –Storage Architect and Solutions Ambassador (FalconStor)	The talk will be focused on how to: Reduce overall storage costs for SQL, Optimize I/O Performance, Rapidly provide thin current copies to simplify and speed testing and development, Recover databases in 15 min or less no matter the size, Provide a simple way to protect from deletion and corruption, Replicate large datasets with minimal WAN bandwidth via "No-Dupe", Leverage CDP to protect every write, even when logging is disabled	Duane’s experience in the computer industry cover a multitude of areas including running his own technology company for 16 years servicing SMB and Enterprise accounts across the country. As a subject matter expert in multi-protocol switching technology and physical plant interconnections, Duane has been tasked to write a number of Professional Certification Exams for IBM and was the Chief Architect for the infrastructure used for the 1998 Nagano Olympics “Fan Mail” project which continues to be transformed every two years to cover both Summer and Winter Olympic Events. After joining FalconStor Software in 2005 , he spent two years maintaining the Enterprise Testing Labs at FalconStor HQ in Melville, LI and worked closely with Quality Assurance to establish testing process for testing of CDP, VTL and SIR, he now supports Sales in the Northeast as a trusted Storage Architect.
12:15pm - 1:15pm	Performance tuning XML and XQuery in SQL Server 2008 - Michael Coles/ MVP	Get the most out of your SQL Server XML and XQuery-based applications. Tips and tricks to speed up server-side XQuery and XML manipulation on SQL Server. Focus on XML shredding, XQuery path language, XML indexes, and converting relational data to XML.	Michael Coles is a SQL developer and database architect with 15 years experience. He works for a BI consulting firm in NYC and is the author of Pro T-SQL 2008 Programmer's Guide and Pro SQL Server 2008 XML. Michael has been recognized as a Microsoft MVP for his work on SQL Server.
1:15pm - 2:15pm	Disk I/O Related Performance Tuning -Linchi Shea/ MVP		Linchi Shea has been working with Microsoft SQL Server since version 4.2. He is currently responsible for SQL Server engineering at a major Wall Street firm in the New York City area. Linchi is passionate about creating robust and automated infrastructures for managing SQL Server in a large enterprise environment. He has written many tools and utilities to simplify deploying, operating, and testing SQL Server. You can find him blogging about SQL Server enterprise issues at www.sqlblog.com. Linchi is a co-founder and co-lead of the NY Metro SQL Server users group, and has been a Microsoft MVP since 2002.
2:30pm - 2:45pm	Wrap-Up and Raffle/Swag	Microsoft, FalconStor, Edgewood Solutions, PASS, Idera

NJSQL May Meeting 5/19 – Michael Coles (SQL 2008 Encryption)

SQLDiva — Sun, 10 May 2009 12:41:00 GMT

Date: Tuesday, May 19th

Agenda:

6:15pm - 6:15pm: Networking & Pizza

6:15pm - 6:30pm: Mike Dooley, Harvey Nash

6:30pm - 6:40pm: NJSQL Community Updates

6:40pm: Presentation

Refreshments: Pizza/Soda

Sponsor: Harvey Nash / Apress

Give-A-Ways: Swag from Apress

Presenter: Michael Coles

Topic: SQL Server 2008 Encryption - Protecting Your Data @ Rest

In 2007 the parent company of TJ Maxx stores was attacked by hackers who stole 45.7 million credit and debit card numbers stored in their databases. The attack cost the company hundreds of millions of dollars, dozens of lawsuits, and a lot of bad publicity.

SQL Server 2008 includes several features designed to help defend against these types of attacks against confidential data stored in the database. These tools include symmetric and asymmetric encryption functions, certificate and key management, hash functions, extensible key management (EKM), transparent data encryption (TDE) and even SQL CLR functionality. All of these tools will help you protect your data at rest in the database.

In this presentation you will explore these features with Michael and see several of them in action. Michael will talk about how encryption works in SQL Server 2008, how to achieve the best performance possible with encrypted data, and how to work around some of the limitations of the SQL Server encryption implementation. He'll also discuss best practices for your own SQL Server encryption implementations.

Bio:

Michael Coles is a SQL developer and database architect with 15 years experience. He works for a BI consulting firm in NYC and is the author of Pro T-SQL 2008 Programmer's Guide and Pro SQL Server 2008 XML. Michael has been recognized as a Microsoft MVP for his work on SQL Server.

Location:

SetFocus

4 Century Drive

Parsippany , NJ

SQL Database Developer Position In Northern New Jersey

SQLDiva — Tue, 21 Apr 2009 20:18:00 GMT

SQL Database Developer
Fulltime
75K – 85K

Fast paced North Jersey consumer goods Company is looking for a strong
MySql Database Developer. Experience in MySQL would be ideal but company
will also see a strong SQL developer. Must have experience with
transactional SQL databases in an enterprise environment. Will do
reporting, data pulls, and data optimization. Will develop database
Packages, Procedures, Triggers and Functions. This is an alive and
energetic environment and candidates must be able to come out of the gates
running. Experience with remote transactions, e-commerce, or direct
response is a major plus. Must be strong with MySQL OR SQL database
development. No database development experience – no interview! US
Citizens and Green Card Holders and those authorized to work in the US are
encouraged to apply. We are unable to sponsor H1b candidates at this time.
No recruiters please!

Candidates can send their resumes to me at irene@irenec.com

SQLDiva

NJ SQL Server User Group - Google Group (Don't forget to sign up!!!)

SQLDiva — Sat, 11 Apr 2009 01:47:00 GMT

If you haven't already registered for the NJSQL Google, please join.

Google Group: http://groups.google.com/group/nj-sql-server-user-group

SQLDiva

NJSQL News - 4/10/09

SQLDiva — Sat, 11 Apr 2009 01:44:00 GMT

April 21st User Group Meeting (Andrew Brust)
Registration Required: https://www.clicktoattend.com/register.aspx?eventid=137601

NJSQL Performance Tuning Saturday 5/16 ( 4 Sessions, Registration Open 4/21)

Philly Code Camp 4/18 (Registration Required http://codecamp.phillydotnet.org/2009-1/default.aspx)
2 NJSQL User Group Members Speaking at the Code Camp!!! Congratulations Paul and William!!
8:30 Paul Downing - C# 3.0 Language Enhancements (precursor to LINQ)
2:00 William Foster - Table Partitioning in SQL Server

SQLServer 2008 SP1 Released
http://blogs.technet.com/dataplatforminsider/default.aspx

Microsoft BI Conference Cancelled
http://blogs.msdn.com/bi/archive/2009/04/08/microsoft-bi-conference-update.aspx

PASS Summit Agenda (Nov. 2 - Nov. 5)
BI Tracks Expanded to two Tracks (BI Architecture, Development and Administration & BI Client Reporting and Delivery)
http://summit2009.sqlpass.org/Agenda.aspx

SQLDiva

NJSQL Performance Tuning Saturday 5/16/09 - Registration Required

SQLDiva — Mon, 09 Mar 2009 01:31:00 GMT

Do you want to learn SQL Server Performance Tuning Strategies from the Pros? Then, you have found the right event!! Come join the NJ SQL Server User group for a free Saturday event that includes 4 sessions on Performance Tuning Topics.

Date: Saturday, May 16th

Registration: Required

Registration Link: https://www.clicktoattend.com/invitation.aspx?code=137968

Location: Microsoft Office (Iselin, NJ)

Time: 8:15am - 3pm

Agenda:

8:15am - 9:00am: Attendee Check-In and Breakfast

9:00am - 9:15am: Welcome

9:15am - 10:15am: Stress Testing SQL Server (Hilary Cotter - MVP)

10:15am - 10:30am: Break

10:30am - 11:30am: Query Plan Optimization / T-SQL Performance Tricks (Alec Lazarescu)

11:30am - 12:15pm: Lunch

12:15pm - 1:15pm: Performance tuning XML and XQuery in SQL Server 2008 (Michael Coles - MVP)

1:15pm - 2:15pm: Disk I/O Related Performance Tuning (Linchi Shea - MVP)

2:30pm - 2:45pm: Wrap-Up and Raffle/Swag

Note: Agenda subject to change, please see www.njsql.org for updates.

Bios/Session Abstracts: Coming Soon!!!

Date: Saturday, May 16th

Registration: Required

Registration Link: https://www.clicktoattend.com/invitation.aspx?code=137968

Location: Microsoft Office (Iselin, NJ)

Time: 8:15am - 3pm

Agenda:

8:15am - 9:00am: Attendee Check-In and Breakfast

9:00am - 9:15am: Welcome

9:15am - 10:15am: Stress Testing SQL Server (Hilary Cotter - MVP)

10:15am - 10:30am: Break

10:30am - 11:30am: Query Plan Optimization / T-SQL Performance Tricks (Alec Lazarescu)

11:30am - 12:15pm: Lunch

12:15pm - 1:15pm: Performance tuning XML and XQuery in SQL Server 2008 (Michael Coles - MVP)

1:15pm - 2:15pm: Disk I/O Related Performance Tuning (Linchi Shea - MVP)

2:30pm - 2:45pm: Wrap-Up and Raffle/Swag

Note: Agenda subject to change, please see www.njsql.org for updates.

Bios/Session Abstracts: Coming Soon!!!

NJSQL April 21st Meeting - Ineta Speaker Andrew Brust

SQLDiva — Mon, 09 Mar 2009 01:29:00 GMT

Date: Tuesday, April 21st

Presenter: Andrew Brust (Ineta Speaker)

Topic: TBD (something BI/Analysis Services/Excel Services)

Bio: Andrew J. Brust is Chief, New Technology at Citigate Hudson, Inc., a Microsoft Gold Certified Partner specializing in Business Intelligence and custom database applications built with .NET, SQL Server, and other Microsoft technologies. Prior to joining Citigate Hudson, Andrew was the President of Progressive Systems Consulting, which he founded in 1994 and merged with Citigate Hudson in 2004. Andrew is Microsoft's Regional Director for New York and New Jersey, a contributing editor to Visual Studio Magazine, a regular speaker and Conference Chair at VSLive and a featured speaker at other conferences throughout the U.S. and internationally. Andrew has over 15 years of experience programming and consulting in the Financial, Public, Small Business, and Not-For-Profit sectors. Mr. Brust is also a Vice-Chairman of the New York Software Industry Association (NYSIA) Board of Directors.

March NJSQL Meeting 3/17 (Topics: Table Partitioning & Report Builder 2.0 Tips and Tricks)

SQLDiva — Mon, 09 Mar 2009 01:27:00 GMT

Date: Tuesday, March 17^th

Agenda:

6:00pm - 6:30pm: Networking, Pizza & Group Discussion

6:30pm: Presentations (Table partitioning 2000 and 2005 & SQL 2008 Report Builder 2.0 Tips and Tricks)

Refreshments: Pizza/Soda

Sponsor: Microsoft

Give-A-Ways: Books, ETC

Presenter: William Foster

Topic: Table partitioning 2000 and 2005

Bio: William Foster is an Application Architect currently using SQL Server 2000/2005 and Oracle 10G at TD Bank, working on warehousing projects with the merger of TD Bank North and Commerce Bank, has been working with designing and performance tuning of relational databases for 21 years.

Presenter: Jim Le

Topic: SQL 2008 Report Builder 2.0 Tips and Tricks

A flexible reporting tool for business and power users with easy to use wizards for creating table data regions and data visualizations including charts and gauges.

Bio: Jim Le is a certified MSDBA with 12 years of IT experience. He has been working with MS Sql server since version 6.5 and reporting services since its first release. He is currently working on building a data warehouse and a reporting system for Yappr.com

Location:

SetFocus

4 Century Drive

Parsippany , NJ

Reminder... NJSQL Meeting this evening (Refreshments arrive at 5:30pm)

SQLDiva — Tue, 17 Feb 2009 15:19:00 GMT

Date: Tuesday, February 17^th

Agenda:

5:30pm - 6:20pm: Networking, Pizza & Group Discussion (Time change due to MSDN “Suburban” Roadshow from 1-5:30pm)

6:20pm-6:30pm: NJSQL Community NewsVendor Presentation

6:30pm: Presentation via the GRID

Location:

SetFocus

4 Century Drive

Parsippany , NJ

Directions

Refreshments: Pizza/Soda

Sponsor: Microsoft

Give-A-Ways: Books, ETC

Topic: MDX 101

Multidimensional Expressions (MDX) is a query language for OLAP databases, much like SQL is a query language for relational databases.

Presenter: Kevin Goff

Bio: Kevin Goff is a Microsoft MVP .NET/C# (2005-2008), a columnist for CoDe Magazine(The Baker's Dozen Productivity Series), book author (Pro Visual Studio 2005 Reporting with SQL Server and Crystal Reports - Apress), Trainer/Courseware author (SetFocus Business Intelligence Masters program), a frequent speaker for MSDN CodeCamp and .NET/SQL Server User Groups with 22 years experience in software industry.

Web Site: http://www.CommonGroundSolutions.net

Blog: http://www.TheBakersDozen.net