|
|
-
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!!
Posted
Monday, March 01, 2010 5:24 PM
by
SQLDiva |
-
-
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
Posted
Tuesday, December 08, 2009 10:58 AM
by
SQLDiva |
-
Date: Tuesday, November 17th (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
Posted
Friday, November 13, 2009 10:49 AM
by
SQLDiva |
-
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 24th
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
Posted
Monday, October 05, 2009 10:19 AM
by
SQLDiva |
-
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.
Posted
Monday, September 28, 2009 2:52 PM
by
SQLDiva |
-
-
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
Posted
Monday, September 14, 2009 9:38 AM
by
SQLDiva |
-
Date: Tuesday,September 15th
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/
Posted
Tuesday, September 08, 2009 8:48 AM
by
SQLDiva |
-
Date: Thursday, August 13th (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
Posted
Monday, July 20, 2009 11:00 PM
by
SQLDiva |
-
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
Posted
Wednesday, June 03, 2009 9:55 PM
by
SQLDiva |
-
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, 6th 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 |
Posted
Tuesday, June 02, 2009 11:43 AM
by
SQLDiva |
-
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.
Posted
Tuesday, May 19, 2009 2:40 PM
by
SQLDiva |
-
-
| Time | Description | Abstract | Bio | | 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
| | | |
Posted
Tuesday, May 12, 2009 3:18 PM
by
SQLDiva |
|
|
|