|
|
-
Date: Tuesday, August 17th Topic: Transactional Replication Performance Tuning Presenter: Hilary Cotter Summary:
In this session, SQL Server MVP, Hilary Cotter, covers how to squeeze
the best performance out of your transactional replication topology.
This session covers SQL 2005, and SQL 2008, and focuses on
architecture/topology, improving log reader agent performance,
improving distribution agent performance, as well as monitoring your
replication topology. Bio:
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. Agenda:
6:00pm - 6:30pm: Networking, Pizza & Group Discussion
6:30pm: Presentation Location:
SetFocus
4 Century Drive
Parsippany , NJ Refreshments: Pizza/Soda Sponsors: SetFocus Give-A-Ways:
Books, Etc...
Posted
Tuesday, August 10, 2010 5:06 PM
by
SQLDiva |
-
Date: Tuesday, July 20th Topic: Change Data Capture in SQL 2008 Presenter: Kevin Goff (via the LiveMeeting) Attendee link: https://www.livemeeting.com/cc/usergroups/join?id=GBW4QZ&role=attend Summary:
- Basics of CDC - Understanding CDC terminology - How to read CDC log tables - CDC code samples - CDC and SQL Server Agent jobs - CDC versus database triggers (and where triggers are still needed) - How to deal with schema changes - Performance tuning - Using CDC in an ETL (Extract-Transform-Load) environment with SQL Server Integration Services Bio:
Developer/Trainer/Speaker/Author
Microsoft SQL Server MVP
SetFocus Trainer/Courseware author Agenda:
6:00pm - 6:30pm: Networking, Pizza & Group Discussion 6:30pm: Presentation Location:
SetFocus
4 Century Drive
Parsippany , NJ Refreshments: Pizza/Soda Sponsors: NJSQL
Posted
Tuesday, July 20, 2010 11:47 AM
by
SQLDiva |
-
Date: Tuesday, June 15th Topic: Waiting for What? Using Wait Statistics and other Techniques to Tune Your System Presenter: Joe Lax Summary:
With every version of SQL Server, Microsoft continues to provide additional
diagnostic tools to better manage performance. But it isn't easy to understand all the options and when best to utilize each one. In this presentation, Joe Lax will discuss the various choices available for performance tuning such as performance counters, SQL Server traces, data management views, and wait statistics and demonstrate why they each have a place in a DBA's toolbox. Bio:
Joe Lax is the President of DB Directions which provides its customers with stable, secure, effective, worry-free computer systems. DB Directions services include remote database administration, database architecture and design services, software development, and customized training. As the co-founder of the NYC Metro SQL Server User group, Joe is happy to share the solutions that he has found with others. Joe can be contacted via his DB Directions contact page. Agenda:
6:00pm - 6:30pm: Networking, Pizza & Group Discussion 6:30pm: Presentation Location:
SetFocus
4 Century Drive
Parsippany , NJ Refreshments: Pizza/Soda Sponsors: TBD Give-A-Ways:
Books, Etc, and Lots of Swag from Quest!!
Posted
Friday, June 04, 2010 4:43 PM
by
SQLDiva |
-
Are you doing spring cleaning and want to get rid of some SQL Server 2005 Books? Please bring in your 'lightly' to 'moderately' used SQL Server 2005 or 2008 books to future NJ SQL Server User Group Meetings.
Other User Group members could benefit from your book donation!! Please note that if your book is not selected at the meeting, you will be responsible for bringing your book away from the meeting. PS. SQLDiva has enough in her garage!! SQLDiva
Posted
Thursday, May 13, 2010 5:09 PM
by
SQLDiva |
-
Date: Tuesday, May 18th Agenda:
6:00pm - 6:30pm: Networking, Pizza & Group Discussion
6:30pm: Presentation Topic: Extreme Performance Warehousing Presenter: Robert J. Abate, CBIP, CDMP Summary:
In this presentation, attendees will take a look into the future of high-performance, 100+ TB data warehousing using the latest tools and techniques. We will examine reference configurations and data integration strategies for these huge volume warehouses and examine architectural approaches of design for these types of solutions including: Appliances, Partitioning, Parallel Processing, Data Mining and Distributed Designs. Bio:
A hands-on, accomplished, Information Technology leader offering more than 27 years technology experience in enterprise-wide rchitecture, Applications, Business Intelligence, Infrastructure Operations [ITIL], Outsourcing and IT Strategy / Management. Credited as one of the first to publish on Services Oriented Architecture (1996), he is a respected IT thought leader within the field. Mr. Abate is a featured expert on Data Management Radio and blogs on a variety of IT topics on www.information-management.com. Location:
SetFocus
4 Century Drive
Parsippany , NJ Refreshments: Pizza/Soda Sponsors: Edifice Information Management (www.EdificeInfo.com) Give-A-Ways:
Books, Xbox Games, etc...
Posted
Thursday, May 13, 2010 5:02 PM
by
SQLDiva |
-
-
-
| Date | Speaker | Topic | | May 18th, 2010 | Robert J. Abate, CBIP, CDMP | Extreme Performance Warehousing | | June 15th, 2010 | Joe Lax, DBDirections | Using Wait Statistics and Other Techniques to Tune Your System | | July 20th, 2010 | TBD | TBD | | August 18th, 2010 | Hilary Cotter, MVP | High Performance Replication |
Posted
Thursday, May 06, 2010 3:33 PM
by
SQLDiva |
-
Date: Tuesday, April 20th Time: 6pm - ? Location: SetFocus The NJ SQL Server User Group will be preparing for the upcoming SQL Saturday #39 events scheduled for Saturday, April 24th. We are very excited about the event. 400 people have registered so far and we have 100+ on waiting list. We have lots of stuff to do on this evening and would love to gets as many 'hands' as possible as we have 300+ vendor bags to fill.
Needed: Your hands to help us!!
Food: Pizza/Soda (SetFocus)
If you plan on attending the meeting, please email Melissa[at]njsql.org by Monday, April 19th.
Thanks for your Support, Team NJSQL
Posted
Monday, April 12, 2010 6:08 PM
by
SQLDiva |
-
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 - 6:45pm: SQL Saturday #39 Update (4/24) 6:45pm: 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 |
|
|
|