Jeff Prom's SQL Server Blog

Sharing knowledge and tips on SQL Server, Business Intelligence and Data Management.

Archive for the ‘Events’ Category

SQLSaturday #291 – Chicago 2014

Posted by jeffprom on March 19, 2014

I am happy to announce that I was selected to speak at SQLSaturday Chicago! This event will be held April, 26 2014 at 1221 N Swift Road, Addison, IL 60101. I will be presenting on Master Data Services.

Master Data Services
Does your company have similar data in multiple locations? Not really sure which set of data is accurate? With MDS, Microsoft gives you the ability to have one accurate source of non-transactional data to use with your applications or send to other databases and ETL processes. Leverage data stewards to help manage the data repository to ensure it is up-to-date and accurate. In this session we will cover MDS from start to finish including installation, creating models/entities, working with data, using the Excel add-in, security, hierarchies, views, versions, and business rules. After this session, you should have a good understanding of what MDS does, how to use it, and how to get started with your own MDS project.

Additional information can be found here:
http://sqlsaturday.com/291/eventhome.aspx

Be sure to register for this event today!

Advertisements

Posted in Events, MDS | 2 Comments »

SQL Saturday #238 – Minneapolis, MN

Posted by jeffprom on September 19, 2013

SQL Saturday #238

I’m happy to announce that I was selected to speak at the SQL Saturday #238, Minnesota event! This year I thought I would try something different. I recently changed jobs and am working with Ross McNeely. Ross mentioned that he once presented on F# which got me thinking… I know a bit about using PHP with SQL Server. So that is my session this year: ‘When scripting worlds collide: PHP + SQL Server’. This should be a fun presentation. I’ve actually used PHP longer than I have SQL Server. Somewhere in the neighborhood of 12 years. It wasn’t until just a few years ago that PHP was able to connect with SQL Server, and it makes for a very powerful combination!

Abstract:
PHP is a popular, and free, scripting language. It can be used to create websites, or simply perform a variety of tasks when run from a command prompt. Combine PHP with SQL Server and you have a powerful way to create data driven websites. In this session learn how to install, configure, and use PHP with SQL Server. Learn the basics of connecting to databases, writing queries, and using data to create dynamic, data driven websites.

I look forward to seeing everyone at the event.
http://sqlsaturday.com/238/eventhome.aspx

Posted in Events | Leave a Comment »

MN BI User Group – September 10th, 2013

Posted by jeffprom on August 21, 2013

MN BI User Group

On Tuesday, September 10th I will be speaking at the Minnesota BI User Group. The topic will be ‘Master Data Management and Microsoft Master Data Services.’ There will also be a 2nd presentation on ‘Recognizing The Parallel Data Warehouse (PDW) Workload’ presented by Jason Strate and Sanjay Kaul.

The event will be at the Microsoft office:
3601 76th Street West
Suite 600
Edina, MN 55435

For more info, visit the website at http://www.msbiusergroupmn.org

Register today!

Posted in Events, MDS | Leave a Comment »

SQL Saturday #175 Fargo – Recap

Posted by jeffprom on April 29, 2013

Last Saturday was the very first SQL Saturday event in Fargo, ND. It was a great success with about 125 attendees. Thanks to everyone who helped organize the event, the speakers, and to everyone who attended. Also a big thanks to everyone who attended my session. The board room style was a first for me but was kind of cool! I felt like an executive running a meeting. 🙂

This was also a SQL Saturday first because we had a special guest appearance by the man himself, Mr. Bill Gates!!

Bill Gates

Well in all honesty, he was actually in the same building to talk to the Microsoft employees. However, they were kind enough to let us hear him speak. How cool is that?!

The event was held at the Microsoft Executive Briefing Center which was extremely nice. The Microsoft employees onsite, such as Kelly Obach, who helped with the event were also super awesome.

Microsoft Executive Briefing Center Fargo, ND

All in all, a fantastic time. There was talk of having it again next year so hopefully I will be back again soon.

Posted in Events | Leave a Comment »

SQL Saturday #189 Costa Rica – Recap

Posted by jeffprom on April 20, 2013

Last Saturday was the SQL Saturday #189 Costa Rica event and what an awesome event! Thanks to everyone who helped make this such a great event; the organizers, the sponsors, the attendees and the speakers. Being well into April, it was quite a shock to come back to Minnesota and receive another 9 inches of snow. I should have stayed in Costa Rica a bit longer. 😀

Friday night the group went out to a restaurant called Mirador Tiquicia in Escazu. It was a bit of a drive and up a very steep hill, but it was worth it! At the top it had an amazing view of the entire city of San Jose. Here is a glimpse of the view with my wife and I.

city lights of san jose

For dinner we had a delicious buffet of traditaional Costa Rican food. Then, traditional Costa Rican dancers performed in the middle of the restaurant. What a great night!

Costa Rican dancers

On Saturday, it was time for the big event. There were 320 registered, and 257 who attended. The conference took place at the Aurola Holiday Inn in San Jose. Here you can see Eduardo Castro making the welcome announcements. In this picture he’s introducing the speakers for the day. I’m on the bottom of this slide.

sql saturday costa rica welcome

My 2 sessions were in the afternoon so I mingled and attended the morning sessions. Then it was off to lunch which was on an upper floor of the hotel. Again, we were treated to a nice view of San Jose and a great lunch. Here are some pictures of San Jose from the dinning area.

San Jose

San Jose

After a short break, it was then time to get to work. Here is me getting ready for my first session.

Getting ready for my sessions

I first presented on Master Data Services, and then on Data Quality Services. Thank you to everyone who attended my sessions and for being such a great crowd. The questions were good and hopefully everyone left knowing a bit more about MDS and DQS.

presenting on master data services

I had such a great time and met so many fun people; Eduardo Castro, Kenneth Ureña (Thanks for the coffee it was awesome!), Joaquin Zuñiga, Kevin Boles, Luis Carlos Diaz, Alex Vargas, Jesus Gil, Russell Fustino, and many others! Latin America has a great SQL Server community. Thank you for letting me be a part of this event. Hopefully I’ll be able to attend again next year!

Posted in Events | Tagged: , | 1 Comment »

SQL Saturday #175 – Fargo, North Dakota

Posted by jeffprom on March 15, 2013

SQL Saturday #175

Saturday, April 27th I will be presenting at SQL Saturday #175 in Fargo, North Dakota. This event will be held at the Microsoft Executive Briefing Center at 4550 42nd Street South, Fargo ND, 58104.
I will be speaking on the following topic:

Data Quality Services
As the old adage goes, ‘Garbage in, garbage out.’ Stop spending hours manually cleansing your data, and start using DQS! DQS is the new data quality tool provided with SQL Server 2012. By leveraging knowledge bases, you can correct invalid data and improve the quality of your data.

In this session we will cover creating a knowledge base, data cleansing, data matching, and using 3rd party knowledge bases (Reference Data). We will talk about installation, show how to use the DQS tool, and how to integrate DQS into your SSIS packages. After this session you should have a good understanding of what DQS is, how to use it, and how to get started with your own Data Quality initiative.

Check out the SQL Saturday #175 page for more information.

See you at the event!

Posted in DQS, Events | Tagged: , , | Leave a Comment »

Bienvenidos al SQL Saturday #189 – Costa Rica

Posted by jeffprom on February 20, 2013

SQL Saturday #189

I’m excited to announce that I will be speaking at SQL Saturday #189 in beautiful Costa Rica! This event will be held on April 13th, 2013 at the Aurola Hotel Holiday Inn San Jose Downtown.
I will be presenting on the following two topics:

Master Data Services
Does your company have similar data in multiple locations? Not really sure which set of data is accurate? With MDS, Microsoft gives you the ability to have one accurate source of non-transactional data to use with your applications or send to other databases and ETL processes. Leverage data stewards to help manage the data repository to ensure it is up-to-date and accurate. In this session we will cover MDS from start to finish including installation, creating models/entities, working with data, using the Excel add-in, security, hierarchies, views, versions, and business rules. After this session, you should have a good understanding of what MDS does, how to use it, and how to get started with your own MDS project.

Data Quality Services
As the old adage goes, ‘Garbage in, garbage out.’ Stop spending hours manually cleansing your data, and start using DQS! DQS is the new data quality tool provided with SQL Server 2012. By leveraging knowledge bases, you can correct invalid data and improve the quality of your data.

In this session we will cover creating a knowledge base, data cleansing, data matching, and using 3rd party knowledge bases (Reference Data). We will talk about installation, show how to use the DQS tool, and how to integrate DQS into your SSIS packages. After this session you should have a good understanding of what DQS is, how to use it, and how to get started with your own Data Quality initiative.
………………………………….
Last November I was fortunate enough to meet several chapter members at the PASS Summit event in Seattle. I look forward to the opportunity to meet again in San Jose this April.

Check out the SQL Saturday #189 for more information.

Posted in Events, SSAS, SSRS | Tagged: , | Leave a Comment »

SQL Saturday #206 – Madison, Wisconsin

Posted by jeffprom on February 18, 2013

SQL Saturday #206

Saturday, April 6th I will be presenting at SQL Saturday #206 in Madison, Wisconsin. This event will be held at Madison Area Technical College – Truax Campus, 3550 Anderson St, Madison, WI 53704.
I will be speaking on the following topic:

Master Data Services
Does your company have similar data in multiple locations? Not really sure which set of data is accurate? With MDS, Microsoft gives you the ability to have one accurate source of non-transactional data to use with your applications or send to other databases and ETL processes. Leverage data stewards to help manage the data repository to ensure it is up-to-date and accurate. In this session we will cover MDS from start to finish including installation, creating models/entities, working with data, using the Excel add-in, security, hierarchies, views, versions, and business rules. After this session, you should have a good understanding of what MDS does, how to use it, and how to get started with your own MDS project.

Check out the SQL Saturday #206 page for more information.

Hope to see you there!

Posted in Events, MDS | Tagged: , , | Leave a Comment »

Modern Apps Live! Conference

Posted by jeffprom on February 14, 2013

ModernAppsLive!

While I won’t be speaking at this new conference I wanted to post about the event and mention what a great opportunity it is for app developers.

Modern Apps Live! is an innovative new type of conference, unlike anything you’ve attended before. This conference consists of a single track containing sessions that provide you with an end-to-end narrative covering all aspects of building modern apps using today’s technologies. All the speakers have worked together as a team to bring you the highest quality content such that each session builds on those that have gone before.

Check out the website for more details:
ModernAppsLive!

Be sure to use promo code MAGENIC1 when you register to receive a discount!

Posted in Events | 1 Comment »

Minnesota PASS User Group – 1/15/2013

Posted by jeffprom on January 11, 2013

pass
Next Tuesday I will be presenting on using Proactive Caching in SSAS at the Minnesota User Group. The meeting runs from 4-6pm at the Microsoft Technology Center. For more info you can check their website here: http://minnesota.sqlpass.org/ Hope to see you there. 🙂

Advanced Cube Design – Part 1: Proactive Caching
In this first session of a multi-part series on advanced cube design techniques we will explore using proactive caching. Proactive caching gives you the ability to roll data into your cube automatically as it becomes available while still maintaining MOLAP level performance. We will cover what proactive caching is, when to use it, and how to implement it.

Posted in Events, SSAS | Leave a Comment »