DawaBI Blog | DawaBI - Page 5 of 10

Blog

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|

Colorado SQL Events : July 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

No meeting for July


Colorado Springs SQL

 

Date: Wednesday, July 17th

Time: 5:30 – 8:00 pm

Main Presentation: Data Vault Data Warehouse Architecture

 

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 I 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 help make your data warehouse solution provide maximum value to your users.

 

Presenter: Jeff Renz and Leslie Weed

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.

 

Leslie Weed is currently a Consultant with RevGen Partners in Denver, CO. She has been working with SQL Server for over 13 years in various industries including manufacturing, finance and retail. Leslie strongly believes the best SQL goes hand in hand with a good cup o’ joe.

 

Meeting Location

Hyatt Place – Colorado Springs

503 Garden of the Gods Rd W,

Colorado Springs, CO


View Larger Map


BoulderSQL

 

Date: Tuesday, July 16th

Main Presentation:

Understanding SQL Server In-memory technologies in SQL Server 14 (Hekaton)

Microsoft’s SQL Server 14 will include a new memory optimization feature code-named Hekaton, with the potential for huge performance gains provided your data fits in RAM.

 

Presenter: Mike Wilmot, Microsoft

is a SQL Server MVP, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection, full text search, and SQL Azure.  He is also an Adjunct Faculty member at University College – University of Denver, where has been teaching since 2000. He recently completed the Master Teacher Program at Denver University – University College. He is the author of two chapters in the book SQL Server MVP Deep Dives, and blogs regularly at http://sqlserverperformance.wordpress.com.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 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, July 18th

Time: 5:30 – 8:00 pm

Main Presentation: Real-Time Data Warehouse and Reporting Solutions

Presenter: Carlos Bossy, MCTS SQL Server

Carlos Bossy is a MCTS SQL Server 2008 BI Consultant and Certified Business Intelligence Professional (CBIP) with 25 years of experience in software and database development. Carlos is an independent consultant and focuses on developing Business Intelligence solutions including data warehouses, predictive analytics, data integration and reporting. He has been working with SQL Server for 10 years and is very enthusiastic about its powerful features. Carlos has developed warehouses and BI solutions for a variety of industries and state agencies.

 

Meeting Location

Microsoft
7595 Technology Way, Suite 400
Denver, CO 80237


View Larger Map

 

By |July 14th, 2013|Uncategorized|

PASS Virtual Chapter Events : July 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.


Creating HTML reports with PowerShell – June 17, 2013
Online Event

Language: English

Date: Tuesday, June 11, 2013

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

Cost: Free

Featured Presentation

Creating HTML reports with PowerShell

Speaker: Jeff Hicks, PowerShell MVP, author and trainer JDH IT Solutions

Summary: Creating HTML reports on one hand is almost brain-dead easy in PowerShell. But using it with style takes a little more work. Wouldn’t you like to add a little pizzazz to your HTML reports that you create in PowerShell. In this session I’ll offer some tips and tricks for creating great looking, or at least better looking, HTML reports including stylized alternate rows and embedded graphics.

About Jeff: Jeffery Hicks is a Microsoft MVP in Windows PowerShell, Microsoft Certified Trainer and an IT veteran with over 20 years of experience, much of it spent as an IT consultant specializing in Microsoft server technologies with an emphasis in automation and efficiency. He works today as an independent author, trainer and consultant. Jeff writes the popular Prof. PowerShell column for MPCMag.com, is a regular contributor to the Petri IT Knowledgebase, 4SysOps and the Altaro Hyper-V blog, as well as frequent speaker at technology conferences and user groups. If he isn’t writing, Jeff is most likely recording training videos for companies like TrainSignal or hanging out in the forums at PowerShell.org. Jeff’s latest books are Learn PowerShell 3 in a Month of Lunches, Learn PowerShell Toolmaking in a Month of Lunches and PowerShell in Depth: An Administrators Guide. You can keep up with Jeff at his blog http://jdhitsolutions.com/blog , on Twitter at @jeffhicks and on Google Plus (http:/gplus.to/JeffHicks)

Event details >> Join Meeting


BAVC Virtual Chapter Meeting – “Introduction to Mahout for HDInsight”
Professional Development – Online Event

Language: English

Date: Wednesday, June 12, 2013

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

Cost: Free

Speakers: Christopher Price, Senior BI Consultant Pragmatic Works

Summary: In this session, we will introduce a Mahout, a machine learning library that has multiple algorithms implemented on top of Hadoop and HDInsight. We will start by introducing the foundational concepts needed to understand clustering, classification and collaborative filtering before demonstrating what it takes to get started with Mahout. In addition to learning how you get Mahout set-up, you will learn what it takes to process and prepare data, how to execute an embarrassing parallel batch recommendation job and subsequently how to integrate the result back into your existing ecosystem.

About Christopher: Christopher Price is a senior business intelligence consultant with Pragmatic Works, based in Tampa, FL. He has a bachelor’s degree in MIS and an MBA, both from the University of South Florida, and previously worked as a software architect before being bitten by the BI bug. His current focus is on ETL and data integration, data quality and MDM, SSAS, SharePoint, and Big Data. Chris regularly speaks at SQLSaturday, Code Camp, and other community events. He has authored multiple whitepapers and books and served as technical editor for others.

Event details >> Register


The BI Guy’s Little Guide to Big Data
PASS Big Data Virtual Chapter – Online Event

Language: English

Date: Tuesday, July 23, 2013

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

Overview: You know Pig is more than a farm animal and that Hive is not some ultra-hip bar. You’ve beyond the buzz words and the word count demos. Now¦you’re ready to figure out how it all fits in. In this session we will review common integration scenarios, proven patterns and best practices for integration Big Data solutions into your existing data warehouse and BI architecture. Learn how you too can ride the Big Data wave without reinventing the wheel to both enhance the information you currently deliver while solving problems that were previously unapproachable.

Speaker: Christopher Price

About Chris: Chris Price is a Sr. BI Consultant with Pragmatic Works based out of Tampa, FL. He has a B.S. in MIS and a MBA, both from the Univ. of South Florida. He began his career as a developer working his way into a software architect role before being bitten by the BI bug. His current focus is on ETL and Data Integration, Data Quality and MDM, SSAS, SharePoint and Big Data. He regularly speaks at SQL Saturdays, Code Camps and other community events. He has authored multiple whitepapers and books and served as technical editor for a range of BI topics. You can follow Chris on his blog at http://bidn.com/blogs/cprice1979/ or on Twitter at @BluewaterSQL.

Cost: Free

Event details


SSIS – Effective Control Flow Execution

Language: English

Date: Wednesday, July 24, 2013

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

Cost: Free

Summary: Controlling execution of tasks in Control Flow tab of SSIS package can be much easier with getting help of Foreach Loop container. Foreach loop container provides ability to loop through items of a list. There are 7 types of enumerators for using in this Foreach loop, which provides wide range of lists to be used in loop structure. For example looping through array of items in a variable, or nodes and elements of an XML data, or looping through excel sheets, looping through SQL Server data objects…. In this session audience will learn about all 7 types of enumerators, and real world scenarios of using them in SSIS packages. One of the main benefits of loop structures are helping in creating dynamic task execution, for example dynamic data flow. In this session, there will be samples of creating dynamic data flows with help of Foreach Loop enumerators.

Speaker: Reza Rad: Author, Trainer, Speaker and Senior DW/BI Consultant

About Reza Rad: He has a BSc in Computer engineering; he has more than 10 years’ experience in databases, programming and development mostly on Microsoft technologies. He is a Microsoft MVP in SQL Server for three continues years (from 2011 till now) for his dedication in Microsoft BI. His articles on different aspects of technologies, especially on MS BI, can be found on his blog: http://www.rad.pasfu.com . He wrote some books on MS SQL BI and also is writing some others, He is also an active member on online technical forums such as MSDN and Experts-Exchange, and is a moderator of MSDN SQL Server forums, and is a MCP, MCTS and MCITP of BI. He is the leader of New Zealand Business Intelligence users group. He is a Technical Speaker in TechEd, SQL Saturdays, SQL users groups, and Conferences. And He is a Microsoft Certified Trainer.

Event details >> Register

By |July 14th, 2013|Uncategorized|

Colorado SQL Events : June 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, June 17th

Main Presentation:

How NOT to Migrate to SQL Server 2012

Do you want to avoid a potential train wreck when migrating to SQL Server 2012? Todd has just finished up a successful side-by-side migration going from SQL2005 to SQL2012. The project began last summer and launched on 6/8/2013. The system in question is a mission-critical OLTP hosting multi-terabyte databases and is used by the company’s website and many internal applications. The system is a FCI+AG running on three cluster nodes, each 384GB, 2P8C. We will look at several challenges to the project and how they could have been better managed or avoided. Shortcomings to discuss (lack of): data leadership, communication, budget, physical servers, virtual machines, disk space, technical expertise, application testing, and disaster recovery. Why you don’t upgrade other database systems on the same day that have dual-dependencies. We will also look at tools and documentation which assisted in the migration.

 

Presenter: Todd Kleinhans, Senior SQL Server DBA

Todd Kleinhans has been working with SQL Server since 1999. He has worked as a dba, developer, data architect, manager, and consultant. He is currently a Senior SQL Server DBA consultant at Datavail. Todd is also the current VP of Marketing for the Denver SQL Server User Group. He has presented at user groups, SQL Saturdays, and the Rocky Mountain Trifecta.

 

Meeting Location

UNC Loveland Center at Centerra

2915 Rocky Mountain Ave.
Loveland, CO 80538
Silverton Conference Room 2nd Floor


View Larger Map


Colorado Springs SQL

 

Date: Wednesday, June 19th

Main Presentation:

What every DBA should know about NoSQL

NoSQL is one of the buzzwords you hear going around in the developer world. As DBAs inevitably someone will come to us for help or advice on (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.

 

This presentation will cover: What exactly NoSQL is (and is not), introductions to some of the common NoSQL flavors, dispel some common misconceptions about NoSQL, and we will look at when you might (or might not) want to leverage it for a solution.

 

Presenter: Kelly Martinez, Developer / DBA

Kelly Martinez is a Developer/DBA currently working in municipal government. With over 15 years of I.T. experience he has also worked as a Web Developer in the Open Source space and as a System Administrator on both Linux and Windows.

 

Meeting Location

Hyatt Place – Colorado Springs

503 Garden of the Gods Rd W,

Colorado Springs, CO


View Larger Map


BoulderSQL

 

Date: Tuesday, June 18th

Main Presentation:

Hardware 201: Selecting and Sizing Database Hardware for OLTP Performances

The foundation of database performance is the underlying server hardware and storage subsystem. Even the best designed and optimized database application can be crippled by an inadequate hardware and storage infrastructure. Recent advances in new processors and chipsets, along with improvements in magnetic and SSD storage have dramatically changed the evaluation and selection process compared to the past. Many database professionals struggle to keep up with new technology and often simply let someone else make their hardware selection and sizing decisions. Unfortunately, the DBA usually gets the blame for any performance issues that crop up later. Don’t let this happen to you! This session covers current and upcoming hardware from both Intel and AMD and gives you the tools and resources to make better hardware selection decisions to support SQL Server OLTP workloads.

 

 

Presenter: Glenn Berry, SQL Server MVP

is a SQL Server MVP, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection, full text search, and SQL Azure.  He is also an Adjunct Faculty member at University College – University of Denver, where has been teaching since 2000. He recently completed the Master Teacher Program at Denver University – University College. He is the author of two chapters in the book SQL Server MVP Deep Dives, and blogs regularly at http://sqlserverperformance.wordpress.com.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

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, June 20th

Time: 5:30 – 8:30 pm

Main Presentation: Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance

Presenter: Glenn Berry, SQL Server MVP

Glenn Berry is a SQL Server MVP, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection, full text search, and SQL Azure.  He is also an Adjunct Faculty member at University College – University of Denver, where has been teaching since 2000. He recently completed the Master Teacher Program at Denver University – University College. He is the author of two chapters in the book SQL Server MVP Deep Dives, and blogs regularly at http://sqlserverperformance.wordpress.com.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

Microsoft
7595 Technology Way, Suite 400
Denver, CO 80237


View Larger Map

 

By |June 14th, 2013|Uncategorized|

PASS Summit 2013

PASS Summit is the world’s largest and most intensive technical training conference for Microsoft SQL Server and BI professionals. But more than that, it’s your conference planned and presented by the SQL Server community, for the SQL Server community.

Join the conference in Charlotte and get the top-notch training, technical tips and tricks, and networking and connections you need to take your SQL Server skills to the next level.

WhatPASS Summit 2013

Dates: October 15-18, 2013

Location: Charlotte, NC

VenueCharlotte Convention Center

Registration:

Rates and Schedule

Application & Database Development

The primary audience for this track is developers and database administrators focused on building and supporting successful applications using SQL Server and related technologies. This track provides in-depth knowledge from industry experts who have successfully used the technologies to solve complex tasks and build real solutions. The track is designed to cover all aspects of SQL Server and related application development, including architectural design, coding, testing, troubleshooting, data access methods, and optimization.

BI Information Delivery

Designed for BI architects, application developers, and BI analysts, this track addresses the implementation and use of front-end technologies that deliver BI to business users and enable self-service BI. It will cover concepts and implementation, best practices, and lessons learned. Specific technologies include SQL Server Reporting Services, SharePoint Server, Performance Point Services, PowerPivot for Excel and SharePoint, Power View, Report Builder, Excel and Excel Services, Visio, and .NET. Topics will include scorecards, dashboards, and self-service BI.

PASS Summit offers the following 6 tracks to choose from;

BI Platform Architecture, Development & Adminstration

Designed for BI architects, developers, and administrators, this track focuses on BI infrastructure, administration, architecture, and development on the Microsoft BI Platform. Technical content will cover SQL Server Analysis Services, SQL Server Integration Services, SQL Server Master Data Services, SQL Server Reporting Services, and troubleshooting and administration of SharePoint Server. Focus will be on best practices and lessons learned, upgrading and migration, scale-up and scale-out strategies, and new capabilities to consider for rollout and deployment.

Cloud Application Development & Deployment

This track is for developers and IT professionals interested in leveraging their existing SQL Server skills to take advantage of the benefits of Windows Azure Data Services. It focuses on concepts and application design, best practices, and lessons learned – whether attendees are looking to develop directly in the cloud, utilize a private cloud solution, or extend their existing environment for a hybrid solution.

Enterprise Database Administration & Deployment

This track is designed to equip IT professionals for the challenges inherent in the ever-changing database environment and to prepare them to work efficiently with other professionals involved in enterprise database systems. It addresses the diverse range of topics that DBAs face when working in a production database environment, including consolidation and virtualization, application integration, web integration, capacity planning, data warehousing, and security.

Professional Development

This track offers something for every data professional, whether they are a SQL Server administrator or developer or a BI specialist. It includes sessions to help attendees further their career, with focus on technical writing, speaking, project management, career planning, interviewing for a new job, making the move into management, and more.

Click here for more event details

By |June 9th, 2013|Uncategorized|