|
|
|
|
|
|
WiSSUG
Wisconsin SQL Server User’s Group
|
 |
July WiSSUG Meeting
| Date: |
7/13/2010 |
| Time: |
4:30 PM |
| Location: |
Microsoft Office in Waukesha, Wisconsin (Map). Phone: (262) 446-5200 |
| |
Address: N19 W24133 Riverwood Dr., Suite 150, Waukesha, WI 53188 |
Where has the summer gone? We are nearly at the half-way point for this meeting. This month Farouq, one of our members is bringing a presentation to us. He is well-versed in teaching Microsoft topics and it should be a very informative meeting. I’m very interested to listen to Farouq’s message about data visualization.
We are in need of a member to take over the task of getting sponsors for our meetings.
Our Meeting lineup:
August Brian Knight – Pragmatics Works
September TBD
Please come out to our meeting this month to interact with your peers in the SQL Server community.
Agenda
* Networking with your peers: Take advantage of this time to ask questions of your peers. You may be able to get the answer that has been eluding you thus far. At the very least you will gain a different perspective on your problem.
* WiSSUG Business: WiSSUG Opportunities, Education, PASS news
*Presentation by Farouq Abukhamireh. Data Visualization
Presentation Preview
Presentation: Data Visualization
Turn database tables into interactive data visualizations and dashboards.
Farouq Abukhamireh is a Senior Business Intelligence Architect and a Microsoft Certified Trainer (MCT) who is focused on Microsoft’s Business Intelligence (BI) stack (SSAS, SSIS, SSRS, MDX, Performance Point, Excel Services, and SharePoint). Farouq is a seasoned Information Technology professional with 15 years of experience developing innovative solutions using Microsoft technologies. Farouq works as an independent consultant; he is also the founder of Rubix Consulting, LLC. More information about Farouq can be found at his LinkedIn profile http://www.linkedin.com/in/farouq
Live Meeting information
Join the meeting.
Audio Information
Computer Audio
To use computer audio, you need speakers and microphone, or a headset.
First Time Users:
To save time before the meeting, check your system to make sure it is ready to use Microsoft Office Live Meeting.
Troubleshooting
Unable to join the meeting? Follow these steps:
1. Copy this address and paste it into your web browser:
https://www.livemeeting.com/cc/usergroups/join
2. Copy and paste the required information:
Meeting ID: CSH37N
Location: https://www.livemeeting.com/cc/usergroups
If you still cannot enter the meeting, contact support
Notice
Microsoft Office Live Meeting can be used to record meetings. By participating in this meeting, you agree that your communications may be monitored or recorded at any time during the meeting.
Sponsors for the March Meeting:
Microsoft: Pizza and Soda
WiSSUG Sponsors Are the Best
Please support our sponsors with your patronage
John E. Allman
June WiSSUG Meeting
| Date: |
6/08/2010 |
| Time: |
4:30 PM |
| Location: |
Microsoft Office in Waukesha, Wisconsin (Map). Phone: (262) 446-5200 |
| |
Address: N19 W24133 Riverwood Dr., Suite 150, Waukesha, WI 53188 |
Welcome to the WiSSUG SQL2008 R2 launch event. We have Dave Paulson, a great speaker lined up to take us through what’s new in SQL Server 2008 R2 today. Yes it is a “BI release” but it is more than that. Do you wonder what’s in SQL Server 2008 R2 for you? Well then join us on June 8th at 4:30 PM for our WiSSUG launch event. If time permits we will also have a demonstration of Report Builder 3.0.
If you haven’t noticed we are back on our normal 2nd Tuesday schedule this month.
Our Meeting lineup:
July TBD
August Brian Knight – Pragmatics Works
September TBD
Please come out on June 8th to interact with your peers in the SQL Server community.
Agenda
* Networking with your peers: Take advantage of this time to ask questions of your peers. You may be able to get the answer that has been eluding you thus far. At the very least you will gain a different perspective on your problem.
* WiSSUG Business: Volunteer Opportunities, Education
*Presentation by Dave Paulson. What’s New in SQL Server 2008 R2
Presentation Preview
Presentation: What’s New in SQL Server 2008 R2
The SQL Server 2008 R2 release is best known for it’s BI offerings. Even if you aren’t thinking of exploring the BI capabilities of R2, there is still a wealth of capability for you. Dave will show you all the ways that SQL Server 2008 R2 will help you in your shop.
Dave Paulson is a Microsoft SQL Server Data Platform Specialist covering Wisconsin, Illinois and Indiana. As a SQL Server DPS, Dave is focused on The SQL Server database, High Availability, Scalability/Performance, etc. Prior to working for Microsoft, Dave worked for the past 11 years in a technical sales role at Oracle Corporation.
Live Meeting information
Join the meeting.
Audio Information
Computer Audio
To use computer audio, you need speakers and microphone, or a headset.
First Time Users:
To save time before the meeting, check your system to make sure it is ready to use Microsoft Office Live Meeting.
Troubleshooting
Unable to join the meeting? Follow these steps:
1. Copy this address and paste it into your web browser:
https://www.livemeeting.com/cc/usergroups/join
2. Copy and paste the required information:
Meeting ID: 4SC6QW
Location: https://www.livemeeting.com/cc/usergroups
If you still cannot enter the meeting, contact support
WiVSSUG Lunch & Learn
May Lunch & Learn
Date: 5/28/2010
Time: 11:30 AM
Location: On Line
Dave Paulson is speaking to us this month. He is always able to help us understand the various nuances of SQL Server while being able to contrast those to other DBMS he has knowledge of as well. He brings a unique view to our meetings.
In order to “attend” this meeting you will need speakers (or a headset), and a microphone for any questions. Don’t worry if you don’t have a microphone though as you will be able to send your questions in via the question pane.
Please RSVP to sqldba@new.rr.com if you plan to attend this meeting so we can have an idea how many folks plan to attend.
I hope to “see” you at the meeting Friday at 11:30AM.
Our Meeting lineup:
June Steven Murawski – Deeper dive into PowerShell V2.
July TBA
August TBA
Please connect with us on May 29th. You will miss a great free educational opportunity if you don’t attend.
Presentation:
“A Practical Use of SQL Server 2008 Policy-Based Management”
I will discuss and demonstrate the use of SQL Server 2008 Policy-Based Management to enforce Best Practice recommendations that were given to one of my customers as a result of a SQLRAP review. (SQLRAP stands for “SQL Server Risk Assessment Program”). The presentation will be based on the use of standard best practice policies provided with SQL Server 2008, as well as some custom developed policies, to enforce recommendations identified in the SQLRAP review. This presentation will illustrate a real-world use of Policy-Based Management, and would be of interest to anyone who is interested in an effective way to enforce SQL Server Best Practices in an efficient and automated fashion.
Dave Paulson is a Data Platform Specialist with Microsoft, covering Wisconsin, Illinois and Indiana. As a SQL Server Data Platform Specialist, Dave is focused on The SQL Server database, High Availability, Scalability/Performance, etc. Prior to working for Microsoft, Dave worked for the past 11 years in a technical sales role at Oracle Corporation.
Live Meeting Information
Notice
Microsoft Office Live Meeting can be used to record meetings. By participating in this meeting, you agree that your communications may be monitored or recorded at any time during the meeting.
John Allman
May WiSSUG Meeting
| Date: |
5/13/2010 |
| Time: |
2:30 PM |
| Location: |
Microsoft Office in Waukesha, Wisconsin (Map). Phone: (262) 446-5200 |
| |
Address: N19 W24133 Riverwood Dr., Suite 150, Waukesha, WI 53188 |
Normally I have difficulty getting one presenter each month. This month I goofed and had two. I hope Dave Paulson will accept my apology for that indiscretion. I am getting older you knowL
This month Tom is going to continue a topic he started last month at the WiVSSUG meeting. In the event you weren’t able to attend that meeting, I’ll have a recording available on the web site shortly. I’m excited about hearing the remainder of Tom’s topic as the beginning was very interesting as well as useful.
I hope all of you folks are planning on attending the SQL Server 2008 R2 launch event tomorrow. Following that meeting Pragmatic Work’s Brian Knight will be answering questions in a forum he calls Stump the Chump. I don’t know about you, but I’ve never been able to ask Brian a question that he didn’t have a good answer for,
Our meeting will follow that session.
We hope to have a good attendance for our meeting, and just think, you can get all your BI (and many others) questions answered by an internationally known authority.
Next month our meeting will be back on the 2nd Tuesday of the month. I hope to see you at the meeting this month.
Our Meeting lineup:
June Dave Paulson – SQL Server 2008 Topic
July TBD
August TBD
September PowerShell Infrastructure for the DBA
Please come out on May 13th to interact with your peers in the SQL Server community.
Agenda
* Networking with your peers: Take advantage of this time to ask questions of your peers. You may be able to get the answer that has been eluding you thus far. At the very least you will gain a different perspective on your problem.
* WiSSUG Business: Volunteer Opportunities, Education
*Presentation by Dr. Tom Lane. Managing the Database Life Cycle Using Visual Studio Data Dude Part II
Presentation Preview
Presentation: Managing the Database Life Cycle Using Visual Studio Data Dude, Part II
In 2006 Microsoft released Visual Studio® Team Edition for Database Professionals and with it provided a tool that truly enabled schema versioning and deployment in the database development life cycle. After a few of iterations (DBPro, GDR, GDR R2 and now VS 2010) together with source control (Team Systems) database architects, developers, administrators and other database professionals can now employ integrated change-management functionality to streamline changes to their databases and reduce the risk of catastrophic failure related to the alteration of database schemas. This talk will walk through the process of building and maintaining a complete database project. It will address database creation and change scripts as well as the use SQLCMD, variables and addition files to build complete agile database development environment. This talk will include a recap of the previous meeting on the subject and extend into more examples and more in depth discussion.
Dr. Thomas Lane: Currently Tom is a Sr. DBA at Wonderbox Technologies in Mequon, WI. Wonderbox Technologies provides web based solutions built on SQL Server utilized by Healthcare companies to manage over 13 million lives. Tom received a Ph.D. in Chemistry, did his post-doctoral study at Marquette University, taught programming and database classes at Marquette University, worked as an instructor for a private teaching firm, worked as a developer, and a DBA. His interesting and extensive background, as well as his passion for SQL Server makes him a dynamic and interesting speaker.
Live Meeting information
Join the meeting.
Audio Information
Computer Audio
To use computer audio, you need speakers and microphone, or a headset.
First Time Users:
To save time before the meeting, check your system to make sure it is ready to use Microsoft Office Live Meeting.
Troubleshooting
Unable to join the meeting? Follow these steps:
1. Copy this address and paste it into your web browser:
https://www.livemeeting.com/cc/usergroups/join
2. Copy and paste the required information:
Meeting ID: 5BNDZ8
Location: https://www.livemeeting.com/cc/usergroups
If you still cannot enter the meeting, contact support
Notice
Microsoft Office Live Meeting can be used to record meetings. By participating in this meeting, you agree that your communications may be monitored or recorded at any time during the meeting.
WiVSSUG Lunch & Learn
April Lunch & Learn
Date: 4/30/2010
ime: 11:30 AM
Location: On Line
Chuck Heinzelman is our speaker on deck this month. He always excites us with the technical depth of his presentations and his easy manner of bringing forth his message. I’m looking forward to this presentation. If you are looking forward to using UCP in SQL Server 2008 R2 or have a need to roll your own data collectors for MDW, then this presentation is a “must attend” for you.
In order to “attend” this meeting you will need speakers (or a headset), and a microphone for any questions. Don’t worry if you don’t have a microphone though as you will be able to send your questions in via the question pane.
Please RSVP to sqldba@new.rr.com if you plan to attend this meeting so we can have an idea how many folks plan to attend.
I hope to “see” you at the meeting Friday at 11:30AM.
Our Meeting lineup:
May TBD
June Steven Murawski – Deeper dive into PowerShell V2.
Please connect with us on April 30th. You will miss a great free educational opportunity if you don’t attend.
Presentation:
Multi-Server Management with UCP, MDW, and PBM
Many of us are managing multiple servers, with multiple instances and many databases. SQL Server provides some great tools for dealing with your installations, but much of the data that is generated is still distributed across your servers. If you have problems getting a comprehensive snapshot of your environment, this session is for you. Come see how to use system data collectors and user-defined data collectors to centralize all of that data onto your Utility Control Point and use that data to build dashboards.
Chuck Heinzelman is a Senior Database Administrator with Big Hammer Data, a division of Edgenet, Inc. At Big Hammer, Chuck’s primary role is database design and development, with the occasional sidestep into server configuration and administration. He holds a BS degree in Management Computer Systems from the University of Wisconsin – Whitewater and is currently working on his MBA from the University of Wisconsin – Milwaukee. He has been working with SQL Server since 1998 and also has experience developing Windows and Web applications using Visual Basic and C#.
Chuck has been involved with PASS since 2000, serving in many capacities, including author, editor, and past member of the Board of Directors. He is a SQL Server MVP and a charter member of the Wisconsin SQL Server User Group.
Live Meeting Information
Join the meeting.
Audio Information
Computer Audio
To use computer audio, you need speakers and microphone, or a headset.
First Time Users:
To save time before the meeting, check your system to make sure it is ready to use Microsoft Office Live Meeting.
Troubleshooting
Unable to join the meeting? Follow these steps:
2. Copy and paste the required information:
Meeting ID: CJQR44
Notice
Microsoft Office Live Meeting can be used to record meetings. By participating in this meeting, you agree that your communications may be monitored or recorded at any time during the meeting.
John Allman
John Allman | Sr. DBA. | Office: (920-661-6924) Cell: (920-737-1755 | jallman@jallman.com
April WiSSUG Meeting
| Date: |
4/13/2010 |
| Time: |
4:30 PM |
| Location: |
Microsoft Office in Waukesha, Wisconsin (Map). Phone: (262) 446-5200 |
| |
Address: N19 W24133 Riverwood Dr., Suite 150, Waukesha, WI 53188 |
This month we are going to delve into SQL Server 2008 R2 again with Chuck Heinzelman. I’m excited about some of the new features in R2, but I haven’t had time to play with them at any length yet. Chuck will generate interest I’m sure and I will get moving.
This month I received a white paper from our friend Bill at Diskeeper. I’ve attached it for your reading pleasure. Some of you folks have been recipients of Diskeeper 2010 through Bill’s sponsorship of our club. I hope you’ve installed it and been as impressed as I have been with the fragmentation prevention made possible with Diskeeper 2010.
Microsoft is providing pizza and soda for our meeting again this month. I’d like to thank Microsoft for their continual support of WiSSUG.
This month we will have a couple if items for our business meeting. I have conjured up a couple opportunities for anyone who would like to step up and become more involved in WiSSUG.
Next month our meeting will be on the 2nd Thursday rather than the 2nd Tuesday of the month. This is being done to make our meeting the same day as the SQL Server R2 launch event in Waukesha. I need to know your opinion on having the meeting start earlier so we can go from the launch event into our meeting with just a short break. I’ll take a poll at the meeting Tuesday.
I hope to see you at the meeting tomorrow.
Our Meeting lineup:
May Dave Paulson – SQL Server 2008 R2
Agenda
|
* Networking with your peers:
|
Take advantage of this time to ask questions of your peers. You may be able to get the answer that has been eluding you thus far. At the very least you will gain a different perspective on your problem.
|
|
* WiSSUG Business
|
Volunteer Opportunities, Education
|
|
* Presentation by John Allman
|
Self-service Business Intelligence and SQL Server 2008 R2
|
Presentation Preview
Presentation SQL Server 2008 R2
Chuck will dig deeper into SQL Server 2008 R2 during this presentation. Prepare to be enlightened and amazed.
Chuck Heinzelman is a long-time member of WiSSUG and a SQL Server MVP. In his spare time, he works as a Senior DBA for big hammer data. He has been in the IT field for over 10 years, working primarily with SQL Server and Microsoft development technologies.
Live Meeting information
Join the meeting.
Audio Information
Computer Audio
To use computer audio, you need speakers and microphone, or a headset.
First Time Users:
To save time before the meeting, check your system to make sure it is ready to use Microsoft Office Live Meeting.
Troubleshooting
Unable to join the meeting? Follow these steps:
Notice
Microsoft Office Live Meeting can be used to record meetings. By participating in this meeting, you agree that your communications may be monitored or recorded at any time during the meeting.
WiVSSUG Lunch & Learn
March Lunch & Learn
Date: 3/26/2010
Time: 11:30 AM
Location: On Line
Spring has sprung and the flowers are already starting to bloom. Time to get on to some more SQL Server 2008 R2 related educational activitiesJ
This month one of our own members, Dr. Tom Lane will help you understand how to harness some of the power of SQL Server 2008 R2 by utilizing the power of Visual Studio 2010. Do you use source control for your SQL Server objects? If not you should definitely join us for this presentation.
I think you will find this interesting for both DBAs and Developers, and even more so if you happen to wear both hats. I’m very excited about what VS2010 and SQL Server 2008 R2. Hopefully after this meeting you will be too.
In order to “attend” this meeting you will need speakers (or a headset), and a microphone for any questions. Don’t worry if you don’t have a microphone though as you will be able to send your questions in via the question pane.
Please RSVP to sqldba@new.rr.com if you plan to attend this meeting so we can have an idea how many folks plan to attend.
I hope to “see” you at the meeting Friday at 11:30AM.
Our Meeting lineup:
April Chuck Heinzelman – SQL Server 2008 R2
May TBD
June Steven Murawski – Deeper dive into PowerShell V2.
Please connect with us on March 26th. You will miss a great free educational opportunity if you don’t attend.
Presentation:
Managing the Database Life Cycle Using Visual Studio Data Dude
In 2006 Microsoft releasedVisual Studio® Team Edition for Database Professionals and with it provided a tool that truly enabled schema versioning and deployment in the database development life cycle. After a few of iterations (DBPro, GDR, GDR R2 and now VS 2010) together with source control (Team Systems) database architects, developers, administrators and other database professionals can now employ integrated change-management functionality to streamline changes to their databases and reduce the risk of catastrophic failure related to the alteration of database schemas. This talk will walk through the process of building and maintaining a complete database project. It will address database creation and change scripts as well as the use SQLCMD, variables and additional files to build a complete agile database development environment.
Dr. Thomas Lane: Currently Tom is Sr. DBA at Wonderbox Technologies in Mequon, WI. Wonderbox Technologies provides web based solutions built on SQL Server utilized by Healthcare companies to manage over 13 million lives. Tom received a Ph.D. in Chemistry, did his post-doctoral study at Marquette University, taught programming and database classes at Marquette University, worked as an instructor for a private teaching firm, worked as a developer, and a DBA. His interesting and extensive background, as well as his passion for SQL Server makes him a dynamic and interesting speaker.
March WiSSUG Meeting
| Date: |
2/09/2010 |
| Time: |
4:30 PM |
| Location: |
Microsoft Office in Waukesha, Wisconsin (Map). Phone: (262) 446-5200 |
| |
Address: N19 W24133 Riverwood Dr., Suite 150, Waukesha, WI 53188 |
Spring is sprung. It’s time to get out of the house and attend the March WiSSUG meeting. Have you notice that we haven’t had an opportunity to hear Jay Lisota in quite some time? Well bunky this is your lucky month. Jay is our presenter for this month’s meeting
Did you notice that Red Gate now has a version control interface package that will interface between your favorite SQL tools and Visual Studio Team Foundation? I’m Road-testing the early release. More to come next month.
Microsoft is providing pizza and soda for our meeting again this month. Please give a big thank you to Microsoft for their continual support.
Are you feeling left out in our organization? You would like to do something in support of your user group, but can’t figure out what there is to do? Well just stop and talk to me at the meeting tomorrow. We have many fun activities that eagerly await someone with just your expertise.
I hope to see you at the meeting this month.
Our Meeting lineup:
March Jay Lisota – Self-service Business Intelligence and SQL Server 2008 R2
April Chuck Heinzelman – SQL Server 2008 R2
Please come out on January 12th to interact with your peers in the SQL Server community.
Agenda
|
* Networking with your peers:
|
Take advantage of this time to ask questions of your peers. You may be able to get the answer that has been eluding you thus far. At the very least you will gain a different perspective on your problem.
|
|
* WiSSUG Business
|
Volunteer Opportunities, Education
|
|
* Presentation by John Allman
|
Self-service Business Intelligence and SQL Server 2008 R2
|
Presentation Preview
Presentation: Self-Service Business Intelligence and SQL Server 2008 R2
Get a sneak peak at the up and coming Business Intelligence capabilities available with SQL Server 2008 R2, SharePoint 2010 and Office 2010. You may have heard about PowerPivot, well now you’ll get to see it in action from building the workbooks using Excel, to deploying, managing, and interacting with the newly created workbooks in SharePoint. In addition, check out the new Report Visualizations in Reporting Services such as geographic maps, sparklines, etc. Not to mention the all new Report Part Gallery. There are a lot of new and exciting features to simplify the burden of reporting on IT, and empower business users.
Jay Lisota is a SQL Server Technical Specialist for Microsoft in Chicago supporting pre-sales activities for the Microsoft Midwest District. Jay’s focus with regard to the Microsoft Data Platform has been the Business Intelligence capabilities, such as ETL through Integration Services, OLAP and Analytics using Analysis Services, and Enterprise Reporting utilizing Reporting Services. Prior to Microsoft Jay managed a global data operations center in the financial services sector. He has been with Microsoft in his current role since July of 2006.
Live Meeting information
Join the meeting.
Audio Information
Computer Audio
To use computer audio, you need speakers and microphone, or a headset.
First Time Users:
To save time before the meeting, check your system to make sure it is ready to use Microsoft Office Live Meeting.
Troubleshooting
Unable to join the meeting? Follow these steps:
Notice
Microsoft Office Live Meeting can be used to record meetings. By participating in this meeting, you agree that your communications may be monitored or recorded at any time during the meeting.
|
 |
|
|
|
|
|
|
|
|
|
| DotNetNuke® is copyright 2002-2010 by DotNetNuke Corporation |
|