Hi -

Due to the construction at the Microsoft offices, it won't be possible for us to
have meetings for the rest of the year. We are looking to have our next meeting
in January of next year. If anything changes, we will send out another email to
inform everyone.

Thanks,

Joe and Linchi

Automating Analysis of the DMVs  for Query Exec, Index Usage Stats, and Execution Plans

by Joe Chang

The DMVs introduced in SQL Server 2005 have been really helpful in identifying the top SQL queries to tune, and in identifying unused indexes. Still, it can be tedious to manually examine each XML execution plan, and to find out which execution plans reference infrequently used indexes.

This presentation will show you much of this can be automated with a free SQL Exec Stats utility, and will help you get most out of these DMVs.

Registration site: http://www.clicktoattend.com/?id=140632
Event Code: 140632

Hi All -

There's a training event that I thought would interest members of our
group. Details are available in the link below.

Joe

http://www.tallan.com/events/pages/EventDetails.aspx?eventID=76

Dear SQL Server Professional,

Ever want to implement drag-and-drop reporting in your application and stop the rampant report queue. In this session you'll get an introduction to SQL Server Analysis Services (SSAS). You'll see how to use it to give your users their own ad-hoc reporting and have better than expected performance results.  Join us at the New York SQL Server Group and learn about:

• The Benefits of SSAS 
• What are Demensions and Hierarchies 
• User interfaces for developers
• Cube Design and Measures
• Including UBO and MDX in SSAS

New York City SQL Server Group (*click to register)*must register for building security purposes

Topic:  Introduction to SSAS with Brian Knight

Thursday , July 23,  2009

 Time:  6:00 PM - 8:00 PM

Location:  Microsoft New York City Office, 1290 Ave of the Americas, Sixth Floor  New York, NY  10104
 

This FREE presentation is open to all SQL professionals in the New York City region. All attendees will have access to:

•   Q & A with Brian Knight

·         Post meeting use of the DTS Profiler tool for analyzing the scope of DTS conversion projects (available via  free download)

•  Participation in a raffle for a $50 Amazon gift certificate or a seat in our 4 day SSAS online training class  ($795 value)     

 
About the Speaker:
Brian Knight, SQL Server MVP, MCSE, MCDBA, is the co-founder of SQLServerCentral.com and JumpstartTV.com. He runs the local SQL Server users group in Jacksonville (JSSUG) and was on the Board of Directors of the Professional Association for SQL Server (PASS). Brian is a contributing columnist for SQL Server Standard and also maintains a regular column for the database website SQLServerCentral.com and does regular webcasts at Jumpstart TV. He has co-authored and authored more than 9 SQL Server books including Admin911: SQL Server (Osborne/McGraw-Hill Publishing), Professional SQL Server DTS, Expert SSIS, Professional SQL Server 2005 Administration and Professional SQL Server 2005 SSIS (Wrox Press). Brian has spoken at conferences like PASS, SQL Connections and TechEd and many Code Camps. 

SQL Server I/O Performance: Size Matter!

Disk I/O performance is always a critical aspect of a SQL Server system. In this meeting, Linchi will cover the key parameters and metrics you must evaluate when you review the SQL Server disk I/O performance. The focus, however, is on the fundamental principles underlying efficient disk I/Os, how SQL Server optimizes its disk I/Os on these principles, and how you can take advantages of them in your disk I/O performance tuning efforts. More specifically, Linchi will dive into discussions on random I/Os vs. sequential I/Os, and discuss why disk I/O size is a critical factor in all SQL Server disk I/O evaluation.

Linchi has been working with SQL Server since version 4.21a. He is most interested in automating database management in an enterprise environment, and enjoys troubleshooting performance issues. Linchi is a SQL Server MVP, and is active in various local and online SQL Server communites. He can also be found on sqlblog.com checking out SQL Server via empirical data points.

Click below to register.

 https://www.clicktoattend.com/invitation.aspx?code=139182

SQL Server I/O Performance: Size Matter!

Disk I/O performance is always a critical aspect of a SQL Server system. In this meeting, Linchi will cover the key parameters and metrics you must evaluate when you review the SQL Server disk I/O performance. The focus, however, is on the fundamental principles underlying efficient disk I/Os, how SQL Server optimizes its disk I/Os on these principles, and how you can take advantages of them in your disk I/O performance tuning efforts. More specifically, Linchi will dive into discussions on random I/Os vs. sequential I/Os, and discuss why disk I/O size is a critical factor in all SQL Server disk I/O evaluation.

Linchi has been working with SQL Server since version 4.21a. He is most interested in automating database management in an enterprise environment, and enjoys troubleshooting performance issues. Linchi is a SQL Server MVP, and is active in various local and online SQL Server communites. He can also be found on sqlblog.com checking out SQL Server via empirical data points.

Tuning Replication for High Performance.

SQL Server replication provides bullet proof solutions for distributing data, however getting optimal performance from replication topologies is difficult and frequently a moving target. In this session SQL Server MVP Hilary Cotter will explain how to maximize your replication solution for throughput and minimal latency. He will discuss how to measure throughput and latency, tips and tricks for optimal performance, optimal methods for subscription deployments, to handle large batch DML, and to deploy alerting. Please click below to register.

http://www.clicktoattend.com/?id=138760
 

User-defined functions in SQL Server 2008 by Steve Kass

User-defined functions were a new feature in SQL Server 2000, and both
major versions of SQL Server since 2000 have added enhancements and
improvements in the area of user-defined functions.

We'll look at some new features in SQL Server 2008 that enhance and
improve what user-defined functions can offer. We'll also look at some aspects
of user-defined functions (relevant to SQL Server 2000 and 2005 as
well) that deserve wider understanding, particularly with regard to how they
affect performance.

Click Here to Register 

Speaker: Steve Kass is Professor of Mathematics and Computer Science at
Drew University in Madison, NJ. He is a co-author, with Itzik Ben-Gan,
Dejan Sarka, and Lubor Kollar, of Inside SQL Server 2008: T-SQL
Querying, published last month, and he is the technical reviewer for
Inside SQL Server 2008: T-SQL Programming, to appear later this year. He
has been a Microsoft SQL Server MVP since 2002.

New Workshop: New York City April 2 & 3

SQL Server Performance: ERP & CRM

Demand was so strong for NYC last time that we sold out in a few days. So, we are booking in another workshop in early April to seat those who couldn't get in the first time.

Please register for this event soon, as it is already filling up fast.

This workshop is free of charge.

Topics Covered:

Top Reasons for SQL Server 2005/2008
Query Repro: Reproducing Problem Queries Outside of the Application and Tools to Fix Them
Performance Tuning Methodology: A Repeatable Process
Tools & Techniques
Databases & Disk Drives: Architecting a Scalable Solution
SQL Server Settings
Case Study Handouts
Architecting for RSCI
SQL Server Compression
Hyper-V and Virtualization
EIM

Location:

1290 Avenue of the Americas, Sixth Floor
New York, NY 10104
Phone: (212) 245-2100
Fax: (212) 245-3290


More information to follow soon.

Seating is limited to about 28 people.

For pre-registration, please e-mail: harvs@...

 Come Join us this Thursday evening for  a presentation from Nick Barclay (SQL Server MVP) regarding performance point.

PerformancePoint Server 2007 Monitoring and Analytics 101

Everybody wants dashboards! Come and have a look at this demo-rich session that will show the foundational components of PerformancePoint Server 2007 Monitoring and Analytics and how to easily build and deploy the dashboards that make CXOs salivate.

Click on the link below to register

https://www.clicktoattend.com/invitation.aspx?code=134823

OLAP Development Using SQL Server 2008 ->
https://www.clicktoattend.com/invitation.aspx?code=133837
February 17, 2009

SQL Server is now in its second decade as a leading OLAP database and
development platform. Beginning with SQL Server 7's OLAP Services
product and continuing today with SQL Server 2008 Analysis Services,
Microsoft has steadily grown its market share and built up its full
Business Intelligence stack with SQL Server OLAP as the foundation.

While SQL Server 2005 Analysis Services represented a complete re-
write of the SQL Server 2000 version, SQL Server 2008 has added more
subtle, yet important, improvements to its predecessor. These include
dynamic Best Practice Alerts, streamlined wizards, a new designer for
dimensional attribute relationships and the ability to design
aggregations or modify those generated by Analysis Services' wizards.

In this Webcast, Andrew Brust – twentysix New York's chief of new
technology and a lead author of the Microsoft Press
book, "Programming Microsoft SQL Server 2008" – will discuss these
new features and show several of them in action. He'll also review
some of the underlying features first introduced in SQL Server
Analysis Services 2005. And to show true end-to-end scenarios, we'll
see how to query cubes from Excel 2007. Whether you're new to OLAP or
a seasoned pro, this Webcast will get you ready to build, refine and
query Analysis Services cubes in SQL Server 2008.

*           *           *

Using Reporting Services in SQL Server 2008 ->
https://www.clicktoattend.com/invitation.aspx?code=133838
March 17, 2009

Elsie Pan - a twentysix New York Business Intelligence Architect and
contributor to the Microsoft Press book, "Programming Microsoft SQL
Server 2008" - will demonstrate the report design capabilities in
Reporting Services 2008.

We'll review the updated Report Designer in Visual Studio 2008 with a
focus on the new tablix data region and charting capabilities of
Reporting Services 2008. We will also demonstrate how to create a
report using an Analysis Services data source.

Join us and learn how to effectively take advantage of Reporting
Services in SQL Server 2008 to deliver the reports that your users
are demanding!

SQL Server 2008 T-SQL Enhancements

With each version of SQL Server, Microsoft continues to improve the functionality of T-SQL. The latest version is no exception with both new data types and commands for developers and DBAs. Joe Lax from DB Directions will demonstrate several of the most important  enhancements to the language  in the newly released SQL Server 2008.

As usual, we will be meeting at the Microsoft Offices at 1290 6th Avenue at 6:00 PM.

Pizza and refreshments will be supplied and raffles and giveaways will be offered to the audience. 

To register, please click   http://www.clicktoattend.com/?id=132768

Thanks,

Linchi and Joe

NY Metro SQL Server Users Group

The September 25th Meeting
 

One of the most significant new features in SQL Server 2008 is data compression, which has been long sought after by the SQL Server community. Now that it's here, the question becomes: how is it, and how can you effectively use it in managing your databases? In this session, Linchi Shea gives an independent assessment of SQL Server 2008 data compression that is supported with solid empirical results, and looks at what types of data may be good/bad for data compression, and what workloads may benefit from data compression. The focus is on the performance and space implications. To help appreciate the feature in a bigger context, the session will also include a competitive analysis of data compression across the major DBMS products.

Use the following site to register:

Registration site: http://www.clicktoattend.com/?id=131991
Event Code: 131991

Note that if you want to receive future meeting announcements via your email, you need to subscribe to the Yahoo group named nycsqlusergroup. The subscription instructions are on the homepage of our new website. Alternatively, you can just send a blank email to nycsqlusergroup-subscribe@yahoogroups.com.

Pizza and refreshment will be served at the meeting, and there will be a drawing for several giveaways.

Thanks,

Joe Lax and Linchi Shea

NY Metro SQL Server Users Group

The August 28th Meeting
 

Microsoft SQL Server 2008 offers an extensive list of new features. Among the new features for enterprises is the Enterprise Policy Management f (EPM) framework.

Tom Davidson of Microsoft will dive into this new feature, and show us how the SQL Server 2008 EPM framework will allow policy reporting across the SQL Server enterprise including down-level SQL Server 2000 and 2005 versions.

Use the following site to register:

Registration site: http://www.clicktoattend.com/?id=130951
Event Code: 130951

Note that if you want to receive future meeting announcements via your email, you need to subscribe to the Yahoo group named nycsqlusergroup. The subscription instructions are on the homepage of our new website. Alternatively, you can just send a blank email to nycsqlusergroup-subscribe@yahoogroups.com.

Pizza and refreshment will be served at the meeting, and there will be a drawing for several giveaways.

Thanks,

Joe Lax and Linchi Shea

The user group will be meeting this Thursday at the Microsoft Offices at 1290 6th Avenue at 6:00 PM. As usual, there will be pizza galore and giveaway. The topic is below

Sentrigo, an innovative software company focusing on database security, will present on types and techniques of SQL Injection attacks on both RDBMS-based web applications and built-in database stored program units, and show how simple SQL Injection can be used to own the database server through the means of privilege escalation. It will also list ways of preventing SQL Injection attacks - ranging from secure coding practices to various external tools that will alert and prevent SQL Injection attempts, and demonstrate how hacker techniques of evasion can be used to subvert them and, finally, will introduce new deep inspection tools for Microsoft SQL Server that can prevent SQL injection, even in zero-day scenarios.

Click here to register  http://www.clicktoattend.com/?id=130122

Title: 101 Things not to do on a SQL Server

During this session Bryan Oliver, SQL Server Domain Expert, will cover mistakes that are frequently made by DBAs, Developers and System Administrators.  

Learn how to keep your boss happy by avoiding commonly occurring issues!

Bryan will discuss:

Ø  Improving SQL Server configuration

Ø  Managing other applications running along side SQL Server

Ø  Indexing and coding for performance

Ø  Anti virus software: The Do's and Don'ts

Ø  Monitoring to identify bottlenecks

Ø  Backing up for recovery purposes.

To register, click on the link below.

 https://www.clicktoattend.com/invitation.aspx?code=129597

Hi Everyone -

First of all, for those of you watching our web site, you might have
noticed a bit of confusion as to when we are meeting this month. This
was due to a scheduling conflict at the Microsoft Offices. However,
our very own Microsoft rep Mike McGeehan came through for us again
and reserved us a room for our usual day. So we will be meeting after
all this coming week on the 22nd.

The presentation will be from a new member of our group (Yes! Finally
one of you guys decided to speak up.) The details are below.

"Adventures in SQL Integration Services"
"Steve Gharibian will host an interactive demonstration where
together we will discover all the power within SQL Integration
Services ("SSIS") by working together to build a small datawarehouse.
Introduced with SQL Server 2005, and enhanced for 2008, SSIS is a
high-performance enterprise-class "Extract-Transform-Load" system
which puts this capability within reach of all SQL developers and
DBAs. See why it is an ideal platform for simply moving data up to
and including consolidating data for reporting, analysis and data-
mining.
"The audience will be involved to ensure an appropriate depth of
knowledge is kept. The resulting design from our work will touch on
ETL theory and SSIS design approaches that can work at many scales.
"Steve is one of the few MCITP's for BI on SQL 2005 and an MCSE since
1998.  Currently he is a Business Intelligence designer for
Information Technology and Corporate Service users at a major
financial services firm here in NYC."

To register use the link below.

https://www.clicktoattend.com/invitation.aspx?code=127219

Joe

Come hear Stephen Forte present on  Database Design Patterns this
Thursday at 6:00PM at the Microsoft offices at 1290 6th Avenue, 6th
floor. If you plan on attending, please register using the link below.

Joe



https://www.clicktoattend.com/invitation.aspx?code=127218

Mark your calendar for these upcoming meetings:

March 27, 2008
A Look at Some SQL Server 2008 Key Features by Amjad Khan

April 24, 2008
Database Design Patterns by Stephen Forte

May 22, 2008
(Topic TBA)

All meetings are held at the NYC Microsoft Office at 6:00 pm and there
is no charge to attend.

You can register to attend meetings here: http://nycsqlusergroup.com


- Joe Lax
Chapter Leader