Uncategorized Archives - Page 2 of 8 - DawaBI

Uncategorized

Colorado SQL Events : October 2013

All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend so bring a co-worker¦or two. These events provide for great learning opportunities, as well as networking with other local SQL Server professionals.


Northern Colorado SQL Server User Group Meeting

Date: Monday, October 21st

Time: 5:30 – 8:30 pm

Main Presentation: “Introduction to Graph Databases”

 

Presenter: Dave Loftis

 

Meeting Location

UNC Loveland Center at Centerra

2915 Rocky Mountain Ave.

Loveland, CO 80538

Breckenridge Conference Room 2nd Floor

 

 


View Larger Map


Colorado Springs SQL

 

Date: Wednesday, October 23rd

Time: 5:30 – 8:00 pm

Main Presentation: TBA

 

Presenter: TBA

 

Meeting Location

Hyatt Place – Colorado Springs

503 Garden of the Gods Rd W,

Colorado Springs, CO

 

 


View Larger Map


BoulderSQL

 

Date: Tuesday, October 15th

Main Presentation: OLAP in Your Organization:

Explore how OLAP can fit into your overall information delivery architecture. As business has seen repeated successes in data-based decision making and Big Data is all the buzz, there is momentum behind exposing data to the business in more inventive ways. We’ll discuss strategies for exposing information to internal clients and how BI tools have decreased the one-off report workload for Mike’s team. Then we’ll build a cube from scratch and talk about what you need to learn to make these tools work for you.

 

 

Presenter: Mike White

Mike White has been focused on database development and administration since 1992 and is a co-author of the SQL Server 2008 Bible and the SQL Server 2005 Bible. He has concentrated on Microsoft’s Business Intelligence (BI) tools and applications since 2000, and has architected and implemented several warehousing and Analysis Services applications, as well as non-traditional applications of BI tools. After many years in corporate IT and consulting, Mike currently works as a data architect for AmerisourceBergen Specialty Group. He is a strong advocate for the underused BI toolset and Microsoft SQL Server in general.

 

Meeting Agenda

5:30 6:00 Food / Socializing
6:00 6:15 User Group Business
6:15 6:45 First Presentation
6:45 8:00 Main presentation
8:00 8:30 Questions/Answers, general SQL discussions

 

Meeting Location

Confio Software in Boulder

4772 Walnut Street

Suite 100

Boulder, CO 80301

 

 


View Larger Map


DenverSQL

The Denver SQL Server User Group is organized to bring professionals of all career levels that work with Microsoft’s SQL Server, together to learn and network with others. There is no charge to attend, and you are encouraged to bring guests. Food and refreshments are provided by event sponsors.

Date: Thursday, October 24th

Time: 5:30 – 8:00 pm

Main Presentation: TBA

Presenter: Steve Jones

 

Meeting Location

Microsoft
7595 Technology Way, Suite 400
Denver, CO 80237

 

 


View Larger Map

By |October 13th, 2013|Uncategorized|

PASS SQL Saturday Events : October 2013

PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please note that in order to attend one of these event, you must register (registration links are provided for each event). Please register soon as seating is limited, and let friends and colleagues know about the event. Most events are free, however a nominal fee may be charged so that lunch may be provided (not pizza). Note that all event times are relative to venue location.


Istanbul | #258

Date: Saturday, October 5th, 2013

Time: 8:30 am – 5:30 pm

Cost: Free

Venue:
Microsoft – Bellevue Residences
Levent Mahallesi, Aydin Sokak No:7
Levent, Istanbul
Turkey

Event Details >> Register >> Schedule


El Salvador | #254

Date: Tuesday, October 5th, 2013

Time: 7:30 am – 4:00 pm

Cost: Free

Venue:
Universidad Tecnológica
Calle Arce # 1020,
San Salvador, El Salvador

Event Details >> Register >> Schedule


Milan | #260

Date: Saturday, October 8th, 2013

Time: 9:00 am – 5:00 pm

Cost: Free

Venue:
Via Lombardia, 2
Peschiera Borromeo
20068 , Italy

Event Details >> Register >> Schedule


Charleston | #227

Date: Saturday, October 12th, 2013

Time: 8:00 am – 5:30 pm (Local Time)

Cost: Free + $10 Lunch

Venue:
9200 University BLVD
North Charleston
SC, 29406

Event Details >> Register >> Schedule


Minnesota | #238

Date: Saturday, October 12th, 2013

Time: 7:30 am – 5:00 pm

Cost: Free + $10 Lunch

Venue:
University of Minnesota – Keller Hall
200 Union Street SE
Minneapolis, MN, 55455

Event Details >> Register >> Schedule


Charlotte BI Edition | #237

Date: Saturday, October 19th, 2013

Time: 8:00 am – 4:30 pm

Cost: Free + $10.00 for lunch

Venue:
Central Piedmont Community College ,
2800 Campus Ridge Road
Charlotte, NC, 28105

Event Details >> Register >> Schedule


Bulgaria | #199

Date: Saturday, October 26th, 2013

Time: 8:00 am – 5:30 pm

Cost: Free

Venue:
110 B, Simeonovsko Shosse Bul.
Sofia, 1700, Bulgaria

Event Details >> Register >> Schedule

By |October 2nd, 2013|Uncategorized|

PASS Virtual Chapter Events : October 2013

 

Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters (VC) are interest-based forums that unite the SQL Server community through live webcasts with top SQL Server experts, online forums and resources including an archive of past presentations, and special training events.


Business Analytics – Virtual Chapters

Date: Tuesday, October 3, 2013

Time: 10:00 am – 11:00 am (Mountain Time)

Cost: Free

Language: English

Featured Presentation: Predictive Analytics using In-Database Models

This webinar will cover: Introduction to in-database analytics, business uses cases covering segmentation and next likely purchase and a quick example of the technology that drives in-database analytics.

 

Speaker Info:

Jim Zhang Fuzzy Logix

Register


HASSUG & H-BI Monthly Meeting

Date: Tuesday, October 8, 2013

Time: 10:30 am – 1:30 pm (Mountain Time)

Cost: Free

Language: English

Schedule:

10:30-10:40 Announcements
10:40-11:45 General presentation (Topic 1)
11:45-12:15 Lunch\Networking Raffle #1
12:15-1:20 BI themed presentation (Topic 2)
1:20-1:30 Recap Announcements Raffle #2

Event Details >> Attend


Professional Development – Virtual Chapters

Date: Wednesday, October 9, 2013

Time: 11:00 am – 12:00 pm (Mountain Time)

Cost: Free

Language: English

Featured Presentation: Lead Your Team to More Creative Ways of Think

Whether you’re a current manager, aspiring to be one, or looking to lead a team of peers, you need to know how to motivate people, including yourself. In this session, we will go over some different leadership approaches. We will talk about how to inspire those around you to come up with new and creative ideas in a constructive way without dictating processes and procedures. Not only can this help make your job more enjoyable, but those that work with you and for you will enjoy their work as well!

Speaker Info:

Dave Zapcic, the Director of Enterprise Data Management at Glatfelter Insurance Group

Attend

 


PASS Big Data Virtual Chapter – Virtual Chapters

Date: Wednesday, October 9, 2013

Time: 12:00 pm – 1:00 pm (Mountain Time)

Cost: Free

Language: English

Featured Presentation: Sentiment Analysis with Big Data

People’s sentiments and opinions are written in social networks. There are tweets, Facebook posts, book reviews, forum discussions, and more. These attitudes and feelings are communicated using text, with the format depending on the social network. Twitter messages are limited to 140 characters and use hashtags, for example; Facebook messages can be longer. This session reviews the different Natural Language Processing, text mining, and data mining techniques you can use for sentiment and tone analysis. Organizations can use the extracted knowledge for brand reputation, market predictions, and automatic learning. We’ll look at, Hadoop, data mining, and Microsoft Big Data Hadoop distribution HDInsight

Speaker Info:

Paco Gonzalez, who works for SolidQ, earned his Master’s degree at the University of Murcia, Spain, and Kennesaw State University, GA. Now he combines his work at SolidQ with his PhD thesis, Analyzing Social Data. He is an MCT and MCP Certified on BizTalk Server and SQL Server and works in the integration and BI fields at SolidQ. Paco is the Pass BigData virtual chapter Leader. He is coauthor of Microsoft Training Kit 441.

Event Details

 


Business Analytics – Virtual Chapters

Date: Thursday, October 24, 2013

Time: 10:00 am – 11:00 am (Mountain Time)

Cost: Free

Language: English

Featured Presentation: Brust on Business Analytics

This interview style meeting will provide you with Andrew Brust’s insights on the current state of Business Analytics.

Speaker Info:

Andrew: Andrew J. Brust is founder and CEO of Blue Badge Insights and writes a blog for ZDNet called “Big on Data (http://www.zdnet.com/blog/big-data). Blue Badge Insights provides strategy and advisory services to Microsoft customers and partners. The company grew out of Andrew’s background in application software development, dating back to 1985, and his industry expertise in Microsoft technologies including .NET, SQL Server, and Analysis Services. Andrew, who serves as a Microsoft Regional Director and MVP, is co-author of “Programming Microsoft SQL Server 2012” (Microsoft Press), is conference co-chair of Visual Studio Live!, and writes Visual Studio Magazine’s “Redmond Review” column. He is also an advisor to NYTECH, the New York Technology Council.

Attend

 

By |October 2nd, 2013|Uncategorized|

Colorado SQL Events : September 2013

 

All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend so bring a co-worker¦or two. These events provide for great learning opportunities, as well as networking with other local SQL Server professionals.


Northern Colorado SQL Server User Group Meeting

Date: Monday, September 16th

Time: 5:30 – 8:30 pm

Main Presentation: TBA

 

Presenter: TBA

 

Meeting Location

UNC Loveland Center at Centerra

2915 Rocky Mountain Ave.

Loveland, CO 80538

Breckenridge Conference Room 2nd Floor

 

 


View Larger Map


Colorado Springs SQL

 

Date: Wednesday, September 18th

Time: 5:30 – 8:00 pm

Main Presentation: TBA

 

Presenter: TBA

 

Meeting Location

Hyatt Place – Colorado Springs

503 Garden of the Gods Rd W,

Colorado Springs, CO

 

 


View Larger Map


BoulderSQL

 

Date: Tuesday, September 24th (4th Tuesday)

Main Presentation: Introduction to Extended Events

 

Come find out about extended events, the future successor to Profiler. We’ll dig into what extended events are and how to use them in real-world scenarios to see what’s going on inside of SQL Server. We’ll compare and contrast extended events with Profiler and see why you will want to add them to your collection of SQL tools.

 

Presenter: Eric Peterson

Eric Peterson has been designing databases, architecting solutions and generally involved with SQL Server since its release. He works as a consultant, focusing on SQL Server and also teaches SQL classes for a major tech education company.

 

Meeting Agenda

5:30 6:00 Food / Socializing
6:00 6:15 User Group Business
6:15 6:45 First Presentation
6:45 8:00 Main presentation
8:00 8:30 Questions/Answers, general SQL discussions

 

Meeting Location

Confio Software in Boulder

4772 Walnut Street

Suite 100

Boulder, CO 80301

 

 


View Larger Map


DenverSQL

The Denver SQL Server User Group is organized to bring professionals of all career levels that work with Microsoft’s SQL Server, together to learn and network with others. There is no charge to attend, and you are encouraged to bring guests. Food and refreshments are provided by event sponsors.

Date: Thursday, September 19th

Time: 5:30 – 8:00 pm

Main Presentation: What Are We Waiting For?

Presenter: Kimberly Hathaway

 

Meeting Location

Microsoft
7595 Technology Way, Suite 400
Denver, CO 80237

 

 


View Larger Map

By |September 12th, 2013|Uncategorized|

PASS Virtual Chapter Events : September 2013

 

Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters (VC) are interest-based forums that unite the SQL Server community through live webcasts with top SQL Server experts, online forums and resources including an archive of past presentations, and special training events.


Business Intelligence – Virtual Chapters

Date: Tuesday, September 3, 2013

Time: 4:00 am – 5:00 am (Mountain Time)

Cost: Free

Language: English

Featured Presentation: From Data Source to Secret Sauce: Hive for BI Pros

Big Data is not so much about storing massive amounts of data in a common database. It is also a force of change for the organisation, and it means that we have to consider the collective capabilities of the platform to serve the business: from data source to secret sauce that will help the business to make data-driven decisions to drive the enterprise forward.

How can you get your organisation’s secret sauce? Big Data allows us to conduct better analyses because research has shown that simple algorithms with a lot of data can produce better results than complex algorithms that do not have a data-rich set to work on. Data scientists need a way of combining the scalability of Big Data with the ability to conduct extensive data analysis.

Big Data can look like a minefield: what is Map Reduce? Do I have to know Java? In this session, you will be introduced to Hive, which is comfortingly similar to SQL and translates your SQL queries into Map Reduce behind the scenes for you. It’s an essential tool so please join us to learn more about it.

 

Speaker Info:

Jen is a SQL Server MVP who is best-known for her work in Business Intelligence and Data Visualisation. She is the current holder of the SQLPassion Award, presented by PASS at Summit 2012, for her work in organising Women in Technology events across Europe and the UK for the European SQL Server community. Jen has presented at TechEd North America, TechEd Europe, SQLPass and SQLBIts, along with SQLSaturday events throughout Europe. Jen is the main organiser for SQLSaturday Edinburgh, and runs the Hertfordshire User Group for SQL Server (HUGGS). Jen is joint owner of Copper Blue Consulting, architecting and delivering enterprise-critical solutions that add business value in addition to provisioning technical integrity. You can follow Jen on Twitter at @JenStirrup

Register


Business Analytics VC

Date: Thursday, September 5, 2013

Time: 8:00 am – 9:00 am (Mountain Time)

Cost: Free

Language: English

Featured Presentation: Microsoft Power BI in Office 365: Your first Road

The learning curve with a new technology is always a mixture of excitement and challenge. Seeing the great new features in a product often generates some inspiration to implement new solutions for clients. On the other hand, the process of learning about the depth of the functionality and the scope (and even limits) of features is also critical in assessing the value of a tool.

This webcast has two objectives: first, to provide a demonstration of a solution using Power BI for Office 365, and second, to walk through the primary components of Power BI, their specifications and integration points, and any limitations. The attendee will get a chance to see a live demo of Power BI in Office 365 in action, and also gain understanding of all the pieces of Power BI. The webcast will not cover the steps to create the demo, nor spend a great deal of time on any one feature The goal is to demonstrate the type of content you can create, and what tools exist under the hood.

Speaker Info:

Kevin S. Goff (http://www.kevinsgoff.net) is a Microsoft SQL Server MVP Database architect/developer/speaker/author Regular columnist for CoDe Magazine on .NET, SQL Server, and Business Intelligence topics Frequent speaker at community events in the Mid-Atlantic region. Host of BDBI Radio (http://www.bdbiradio.com), a weekly webcast on SQL/BI topics

Event Details >> Register


HASSUG & H-BI Monthly Meeting

Date: Tuesday, September 10, 2013

Time: 8:30 am – 11:30 pm (Mountain Time)

Cost: Free

Language: English

Schedule:

8:30-8:40 Announcements
8:40-9:45 General presentation (Topic 1)
9:45-10:15 Lunch\Networking Raffle #1
10:15-11:20 BI themed presentation (Topic 2)
11:20-11:30 Recap Announcements Raffle #2

Event Details >> Register


Professional Development – Virtual Chapters

Date: Wednesday, September 11, 2013

Time: 9:00 am – 10:00 pm (Mountain Time)

Cost: Free

Language: English

Featured Presentation: SQL Licensing – What Managers Need to Know

Speaker Info:

Joseph D’Antonio

Event Details

 


Data Architecture – Virtual Chapters

Date: Thursday, September 12, 2013

Time: 9:00 am – 10:00 am (Mountain Time)

Cost: Free

Language: English

Featured Presentation: How Recognize Relational Database is “Good Enough”

In a computer project, no phrase irks me more than “better is the enemy of good enough.” It is true of course, but you have to carefully guard the meaning of “good enough” or you will have a mess on your hands. What makes a great database? When queried, most database professionals would mention normalized as one of the most important characteristics that tell the difference between a good and bad database design. I won’t disagree in the least, but there is so much more to be considered. Even if you did a great job of normalization, poor naming, poorly implemented keys, too many or too few indexes, and so on can derail your design. In this session I will present seven primary characteristics of a design that differentiates between an ugly design that will have your colleagues nitpicking you to death and one that will have them singing your praises. Characteristics such as comprehendible, documented, secure, well performing, and normalized (naturally) will be covered.

Speaker Info:

Louis Davidson has worked in the IT industry for over 15 years as a corporate database developer and architect. He has been a Microsoft SQL Server MVP for 8 years and has written five books on database design. Louis is currently the data architect for the Christian Broadcasting Network, supporting offices in Virginia Beach, VA, and Nashville, TN. He has a bachelor’s degree in Computer Science from the University of Tennessee at Chattanooga. You can read more about Louis at http://drsql.org.

Event Details >> Register >> Meeting URL

 

By |August 30th, 2013|Uncategorized|

PASS SQL Saturday Events : September 2013

PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please note that in order to attend one of these event, you must register (registration links are provided for each event). Please register soon as seating is limited, and let friends and colleagues know about the event. Most events are free, however a nominal fee may be charged so that lunch may be provided (not pizza). Note that all event times are relative to venue location.


Cape Town | #243

Date: Saturday, September 7th, 2013

Time: 10:15 am – 3:15 pm

Cost: Free

Venue:
Sanlam Head Office
2 Strand Rd.
Bellville, Cape Town, Western Cape
South Africa

Event Details >> Register >> Schedule


Salt Lake City, UT | #246

Date: Saturday, September 7th, 2013

Time: 8:30 am – 5:30 pm

Cost: Free

Venue:
3900 Adobe Way
Salt Lake City, UT
84043

Event Details >> Register >> Schedule


Paris, France | #251

Date: Saturday, September 14th, 2013

Time: 10:00 am – 5:30 pm

Cost: Free + meal

Venue:
Campus EPITA/EPITECH
24 rue Pasteur
Le Kremlin-Bicetre
94270, France

Event Details >> Register >> Schedule


Johannesburg, South Africa | #244

Date: Saturday, September 14th, 2013

Time: 8:30 am – 6:00 pm (Local Time)

Cost: Free, including lunch

Venue:
Microsoft
William Nicol Drive
Bryanston, Johannesburg
South Africa.

Event Details >> Register >> Schedule


Bogotá, Colombia | #247

Date: Saturday, September 14th, 2013

Time: 8:30 am – 6:00 pm

Cost: Free

Venue:
Branch of Microsoft Colombia Inc.
Carrera 7 No. 71-21, Torre B, Piso 15, Edificio Bancafe
Bogotá DC
Colombia

Event Details >> Register >> Schedule


Orlando, FL | #232

Date: Saturday, September 14th, 2013

Time: 7:30 am – 6:00 pm

Cost: Free + $10.00 for lunch

Venue:
Seminole State College
100 Weldon Blvd
Sanford, FL 32773

Twitter Hashtag:
#SQLsatOrlando

Event Details >> Register >> Schedule


Pittsburgh | #250

Date: Saturday, September 14th, 2013

Time: 7:15 am – 5:30 pm

Cost: Free + $10 for lunch

Venue:
ITT Technical Institute
5460 Campbells Run Road
Pittsburgh, PA, 15205

Event Details >> Register >> Schedule


Kansas City | #191

Date: Saturday, September 14th, 2013

Time: 8:15 am – 5:00 pm

Cost: Free + $10.00 for lunch

Venue:
Cerner Corporation’s Riverport Campus
6711 NE Birmingham Rd
Kansas City, MO, 64117

Event Details >> Register >> Schedule


Providence, RI | #213

Date: Saturday, September 21st, 2013

Time: 9:15 am – 6:00 pm

Cost: Free + $10.00 for lunch

Venue:
New England Tech East Greenwich Campus
1408 Division Rd.
East Greenwich, RI, 02818

Event Details >> Register >> Schedule


San Diego, CA | #249

Date: Saturday, September 21st, 2013

Time: Not listed

Cost: Free

Venue:
UCSD Extension – University City Center
6256 Greenwich Dr.
San Diego, CA, 92122

Event Details >> Register >> Schedule


Cambridge, UK | #228

Date: Saturday, September 28, 2013

Time: 8:00 am – 5:00 pm

Cost: Free

Venue:
Queens College Cambridge
Cambridgeshire, CB3 9ET
United Kingdom

Event Details >> Register >> Schedule


Brasilla, BR | #253

Date: Saturday, September 28th, 2013

Time: Not Listed

Cost: Free

Venue:
A.E.n.5 e 6 Setor C Norte
Faculdade Projeção
Brasilia, Brazil

Event Details >> Register >> Schedule


Denver, CO | #190

Date: Saturday, September 28th, 2013

Time: 9:00 am – 5:00 pm

Cost: Free + $10.00 for lunch

Venue:
Cherry Creek Presbyterian Church – Community Life Center
10150 E. Belleview Avenue
Englewood, CO, 80111

SQL Saturday #190 Pre-Cons
This year we are offering 3 different all-day pre-cons on Friday, September 27th from 9am – 5pm. These pre-cons are not included in your SQLSaturday #190 registration and do require you to pay a separate fee to attend. The fee will include access to the pre-con you have registered for along with a continental breakfast, lunch and snacks. This is a great opportunity to get some in-depth training from great SQL speakers at a fraction of the cost of most other all day training events. Use the buttons below to get details on each session and register for the pre-con that you are interested in. Fee for pre-cons will be only $99 until 8/31, on 9/1 the price for the pre-cons will go up to $125 so get your spot early!

 

Eventbrite - SQL Saturday #190 Pre-Con w/Tim Mitchell

Eventbrite - SQL Saturday #190 Pre-Con w/Dmitri Korotkevitch

Eventbrite - SQL Saturday #190 Pre-Con w/Carlos Bossy

Denver SQLUG Social Media
LinkedIn
Facebook
Twitter.

Event Details >> Register >> Schedule

By |August 30th, 2013|Uncategorized|

Colorado SQL Events : August 2013

 

All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend so bring a co-worker¦or two. These events provide for great learning opportunities, as well as networking with other local SQL Server professionals.


Northern Colorado SQL Server User Group Meeting

Date: Wednesday, August 19th

Time: 5:30 – 8:30 pm

Main Presentation: What Every DBA Should Know About NoSQL

 

NoSQL is one of the buzzwords you hear going around in the developer world lately. As Database Professionals inevitably someone will come to us for help, advice, or possibly choosing a NoSQL solution. This session aims to give you a basic understanding in order to best answer those questions for your organization.

 

Presenter: Kelly Martinez

Kelly is a Application Developer and Database Administrator currently working in municipal government. With over 15 years of I.T. experience he has previously worked as a Web Developer in the Open Source space and as a System Administrator on both *nix and Windows. He holds a bachelors in Interactive Multimedia & Programming from Columbia College in Chicago. Additionally he is a certified Unix System Administrator, MCDBA/MCITP in SQL Server, and Xamarin Mobile Developer. When not thinking about databases and code he enjoys spending time with his family, traveling, working on the board of the Colorado chapter of GiveCamp (coding for charity), and reading a good fantasy novel.

 

Meeting Location

UNC Loveland Center at Centerra

2915 Rocky Mountain Ave.

Loveland, CO 80538

Breckenridge Conference Room 2nd Floor

 

 


View Larger Map


Colorado Springs SQL

 

Date: Wednesday, August 21st

Time: 5:30 – 8:00 pm

Main Presentation: Policy Based Management

 

Policy Based Management, what is this? What can it do for me? Do I really need it? How do I install and configure it? How can it help me to pass audits? You mean each server can really be configured the same. Let’s explore Policy Based Management and what it has to offer us in better management of our Sql Servers.

 

Presenter: Tom Norman

Tom Norman, Database Architect / DBA, KPA. In 1998, Tom changed his career focus to begin working with Sql Server. He has worked in all aspects of Sql Server including Administration, Database Development, BI and Reporting Services. He has worked in the Finance and Car Dealership industry. His experience has included International deployments. Tom is the co-leader of the PASS Virtualization chapter and the past President of the Denver Sql Server User Group.

 

Meeting Location

Hyatt Place – Colorado Springs

503 Garden of the Gods Rd W,

Colorado Springs, CO

 

 


View Larger Map


BoulderSQL

 

Date: Tuesday, August 20th

Main Presentation: Data Vault

 

Data vault is a compelling architecture for an enterprise data warehouse using SQL Server 2012. A well designed data vault data warehouse facilitates fast, efficient and maintainable data integration across business systems. In this session Jeff will review the basics about enterprise data warehouse design, introduce you to the data vault architecture and discuss how you can leverage new features of SQL Server 2012 to help make your data warehouse solution provide maximum value to your users.

 

Presenter: Jeff Renz

Jeff Renz has been working in the IT industry for 14 years, the last 10 of which has been focused on designing and implementing data collection and reporting solutions.  Jeff is certified by the Genesee Academy as a Certified Data Vault Data Modeler.  He is currently working as a consultant for Revgen Partners in the Business Intelligence Solutions team.

 

Meeting Agenda

5:30 6:00 Food / Socializing
6:00 6:15 User Group Business
6:15 6:45 First Presentation
6:45 8:00 Main presentation
8:00 8:30 Questions/Answers, general SQL discussions

 

Meeting Location

Confio Software in Boulder

4772 Walnut Street

Suite 100

Boulder, CO 80301

 

 


View Larger Map


DenverSQL

The Denver SQL Server User Group is organized to bring professionals of all career levels that work with Microsoft’s SQL Server, together to learn and network with others. There is no charge to attend, and you are encouraged to bring guests. Food and refreshments are provided by event sponsors.

Date: Thursday, August 15th

Time: 5:30 – 8:00 pm

Main Presentation: How Flash Storage Modernizes Databases

Presenter: Matt Henderson

Highly accomplished business intelligence (BI) professional with practical experience in both development and management roles. Skilled in performing technical BI design and development activities including the implementation of database solutions, extraction transformation load (ETL) systems, reporting systems and data collection interfaces. Leadership experience in managing both technical projects and programs. Knowledge in establishing organizational structure, standards and best practices across reporting organizations.

 

Meeting Location

Microsoft
7595 Technology Way, Suite 400
Denver, CO 80237

 

 


View Larger Map

 

By |August 10th, 2013|Uncategorized|

PASS Virtual Chapter Events : August 2013

 

Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters (VC) are interest-based forums that unite the SQL Server community through live webcasts with top SQL Server experts, online forums and resources including an archive of past presentations, and special training events.


SQL Horizons Online – Europe/Middle East/Africa

Date: Thursday, August 1, 2013

Time: 2:00 pm – 3:00 pm (Mountain Time)

Cost: Free

Language: English

Featured Presentation: Dive into the Query Optimizer – Undocumented Insight

This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization. I will use these undocumented features to explain what the query optimizer does from the moment a query is submitted to SQL Server until an execution plan is generated including operations like parsing, binding, simplification, trivial plan, and full optimization. Concepts like transformation rules, the memo structure, how the query optimizer generates possible alternative execution plans, and how the best alternative is chosen based on those costs will be explained as well.

Speaker Info:

Benjamin Nevarez is a database professional based in Los Angeles, California and author of Inside the SQL Server Query Optimizer, published by Red Gate books. He has more than 15 years of experience with relational databases and has been working with SQL Server since version 6.5. Benjamin holds a Master’s Degree in Computer Science and has been a speaker at several technology conferences, including the PASS Summit and SQL Server Connections. He blogs at http://www.benjaminnevarez.com and can be reached by e-mail at admin at benjaminnevarez dot com or on twitter at @BenjaminNevarez.

Event Details


BAVC Virtual Chapter Meeting

Date: Thursday, August 8, 2013

Time: 9:00 am – 10:00 am (Mountain Time)

Cost: Free

Language: English

Featured Presentation: Drab to Dynamite! Managed Self-Service BI Using Real-World Data

Not every business has perfectly structured data. But with managed self-service business intelligence, you can now create rich, powerful analytics solutions that let you glean and share business insights from that data. This walk-through session will begin with actual small business data in Excel format and add data from Windows Azure to expand your analytics possibilities and show how to integrate data from SQL or other sources. PowerPivot will take the stage next, joining the data and enhancing it with calculated fields and KPIs. We’ll step through Power View to produce beautiful visualizations and deep exploration functionality. We’ll finish by sharing our solution, publishing it to SharePoint (using both PowerPivot Gallery and Excel Web Services) and via PowerPoint. Whether you’re an IT pro or business user and whatever your data’s structure, after this session, you’ll have the start-to-finish instruction manual to take any data set from drab to DYNAMITE!

Speaker Info:

Sandy Rivas is a Program Manager for Power View in the SQL Server Business Intelligence / Visual Analytics team at Microsoft. A 14+ year Microsoft veteran, Sandy has helped to ship 6 versions of Microsoft Office, working closely with a wide variety of Office products such as Access, Excel and SharePoint to name a few. Her primary focus was on driving globalization and world-readiness into the Office products. Her real-world use of Excel, PowerPivot and Power View for reporting product statistics division wide, is what fueled her passion for business intelligence and data visualization, driving her to become a Program Manager for Power View.

Event Details >> Register


HASSUG & H-BI Monthly Meeting

Date: Thursday, August 13, 2013

Time: 10:30 am – 1:30 pm (Mountain Time)

Cost: Free

Language: English

Schedule:

11:30-11:40 Announcements
11:40-12:45 General presentation (Topic 1)
12:45-1:15 Lunch\Networking Raffle #1
1:15-2:20 BI themed presentation (Topic 2)
2:20-2:30 Recap Announcements Raffle #2

Event Details >> Register


Nashville SQL Server User Group (NashSQL)

Date: Thursday, August 23, 2013

Time: 10:30 am – 12:00 pm (Mountain Time)

Cost: Free

Language: English

Featured Presentation: Big Data || Hadoop

Speaker Info:

Aaron Crouch is the Business Intelligence Practice Lead for Aptera. Upon graduating from Purdue University, Aaron immediately began working on Data Warehouses and Business Intelligence (BI) implementations. Throughout his career, Aaron has strategically planned, designed, and developed BI solutions for multiple Fortune 500 companies both in the United States and abroad. His work spans the fields of retail, education, healthcare, and automotive vertical markets, and he has also acquired multiple Microsoft certifications. With over 10 years of experience, Aaron is proficient with both Microsoft as well as LINUX, UNIX, and Oracle tool sets.

Event Details >> Register

 


By |July 31st, 2013|Uncategorized|

PASS SQL Saturday Events : August 2013

PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please note that in order to attend one of these event, you must register (registration links are provided for each event). Please register soon as seating is limited, and let friends and colleagues know about the event. Most events are free, however a nominal fee may be charged so that lunch may be provided (not pizza).


Baton Rouge | #234

Date: Saturday, August 3rd, 2013

Time: 8:00 am – 4:00 pm (Central Time)

Cost: Free + $10 for lunch

Venue:
Louisiana State University
Business Education Complex
Nicholson Drive Extension
Baton Rouge, La. 70803

Twitter Info: 
The event hash tag is #sqlsatbr. Follow the official SQL Saturday Baton Rouge twitter account at @SQLSatBR!
The Baton Rouge Chapter of PASS tweets at @BRSSUG.

Event Details >> Register >> Schedule


St. Louis, MO | #236

Date: Saturday, August 3rd, 2013

Time: 8:45 am – 4:30 pm (Central Time)

Cost: Free + $10 for lunch

Venue:
Saint Louis University
Center for Workforce & Organizational Development (The Wool Center)
3545 Lindell Blvd.
St. Louis, MO 63103

Event Details >> Register >> Schedule


Indianapolis | #242

Date: Saturday, August 10th, 2013

Time: 8:30 am – 5:15 pm (Central Time)

Cost: Free + $10 for lunch

Venue:
Indiana Wesleyan University North
3777 Priority Way South Drive
Indianapolis, IN 46240
Located in the Precedent Office Park off of 96th Street (Keystone exit off 465 on north side)

Event Details >> Register >> Schedule


Christchurch, NZ | #252

Date: Saturday, August 10th, 2013

Time: 9:15 am – 5:00 pm (Local Time)

Cost: Free, including lunch

Venue:
Christchurch Polytechnic Institute of Technology (CPIT)
Madras Street, Christchurch
Canterbury, 8011, New Zealand.

Event Details >> Register >> Schedule


New York | #235

Date: Saturday, August 17th, 2013

Time: 8:30 am – 6:00 pm (Eastern Time)

Cost: Free

Venue:
Microsoft Office
1290 Avenue of the Americas, 6th Floor
New York, NY 10104

Event Details >> Register >> Schedule


Curacao | #240

Date: Saturday, August 17th, 2013

Time: 8:30 am – 5:30 pm (AST)

Cost: Free

Venue:
University of Netherlands Antilles
Sta Maria, Willeamstad
Curacao, AN5999
Netherlands Antilles

Event Details >> Register >> Schedule


Oklahoma City | #223

Date: Saturday, August 24th, 2013

Time: 8:30 am – 5:30 pm (Central Time)

Cost: Free + $10 for lunch (optional)

Venue:
Sheraton Reed Conference Center
5800 Will Rogers Road
Midwest City, OK 73110

Event Details >> Register >> Schedule


Rio de Janeiro | #245

Date: Saturday, August 31, 2013

Time: 8:30 am – 6:00 pm (Local Time)

Cost: Free

Venue:
Rua Ibituruna 108
Tijuca, Rio de Janeiro
20271-020, Brazil

Event Details >> Register >> Schedule

By |July 30th, 2013|Uncategorized|

PASS SQL Saturday Events : July 2013

 

 


#239 / East Iowa : Iowa City, IA

Date: Saturday, July 27, 2013

Time: Saturday 8:30 am – 5:30 pm

Cost: Saturday Free + $5.00 For lunch

Venue: University Capitol Centre, University of Iowa, 201 S Clinton St, Room 2520, Iowa City, IA 52240

Event details >> Register >> Schedule


#231 / Cocoa Beach – Cocoa Beach, FL

Location: 1550 N Atlantic Ave, Cocoa Beach, FL 32931

Date: Saturday, July 27, 2013

Time: 7:30 am – 5:30 pm

Cost: Free + $10.00 for lunch

Event details >> Register >> Schedule


#222 / Sacramento – Sacramento, CA

Location:
Patrick Hays Learning Center
2700 Gateway Oaks Drive, Suite 2600
Sacramento, CA 95833

Date: Saturday, July 27, 2013

Time: 7:30 am – 5:30 pm

Cost: Free + $8.00 for lunch

Event details >> Register >> Schedule

By |July 14th, 2013|Uncategorized|