PASS Archives - Page 3 of 4 - DawaBI

PASS

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|

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|

PASS SQL Saturday Events : June 2013

 

PASS SQLSaturday 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).

 

#229 / Dublin, Ireland

Date: Saturday, June 21-22, 2013

Time: Friday 9:00 am – 5:00 pm
Saturday 9:00 am – 5:00 pm

Cost: Saturday Free + $22.00 (11Euro) For lunch

Venue: Hilton Dublin, Charlemont Place, Dublin 2

This year they are hosting a two-day, training event covering SQL Server 2012, Business Intelligence, Database Administration and Personal Development.

Friday Preconference Training Day (21st of June) will contain 3 fantastic full day training sessions:
– Productivity and Leadership Skills for the IT Professional by Kevin Kline
– Self-Service BI and Office 2013 by Chris Webb
– SSIS, MDS and DQS by Matt Masson
These full-day sessions can be booked for ‚¬249.

SQLSaturday – the GATHERING (22nd of June) will be free one-day training community event with a range of well-known Microsoft speakers, MVP speakers and new community speakers.

Register Now!
Admittance to this event is free, however we do have an optional charge ‚¬11 to offset the costs of providing lunch for everyone on the day.

Hotel Accommodation
22nd of June will be a busy night for Dublin hotels. The Hilton Hotel have given us a special rate for our delegates of ‚¬159 for a single room B&B / ‚¬169 for a double room B&B. These rooms will be allocated on a first-come, first served basis…. so don’t hesitate, book now to avoid disappointment!

Event details >> Register


#226 / South Florida – Davie, FL

Location: 3301 College Ave, Davie, FL, 33314

Date: Saturday, June 29, 2013

Time: 8:00 am – 5:00 pm ?

Cost: Free, Includes lunch

Event details >> Register

Submitted Sessions

Here is the list of sessions submitted so far. The goal is to feature as many different speakers and topics as possible, but space limitations prevent from accepting every session. Details on each session can be found by clicking the links below.

Title Speaker Level
(Way Too Much) Fun with Reporting Services Stacia Misner Beginner
A Balanced BI Approach (Self-Service & Corporate) Anthony Sammartino Intermediate
A Big Data Primer Stacia Misner Beginner
Agile BI with SQL Server 2012 and TFS 2012 Mohamed Kabiruddin Intermediate
AlwaysOn – Finally, A usable ‘mirror’! Jim Murphy Beginner
Applied Enterprise Semantic Mining Mark Tabladillo Intermediate
Bad, less Bad, not Bad; rewriting bad SQL Code Jeffrey Garbus Beginner
Best Practice Data Visualization Jen Underwood Intermediate
Building a SQL Server for Optimal Performance Gareth Swanepoel Beginner
Building a Windows 8 app from scratch (English) Russell Fustino Beginner
Building Your Own SQL Server Virtual Playground Kendal Van Dyke Intermediate
Changing Data Is Easy, Managing Data Change is Hard! James McAuliffe Intermediate
Code Paradigms in BIDS Frank Quintana Intermediate
Column Level Encryption David Dye Beginner
Dashboard Do’s and Don’ts Stacia Misner Beginner
Data Mining Innovation with SQL Server 2012 Mark Tabladillo Advanced
Data Partitioning in VLDB Dmitri Korotkevitch Advanced
Data Profiling, Cleansing, Enrichment & Matching with SSIS Christopher Price Beginner
Database Design Disasters: Common Mistakes Found in the Wild Richie Rump Intermediate
Dealing With Errors in SSIS 2012 David Dye Advanced
Discover, Document, & Diagnose Your Servers on Your Coffee Break Kendal Van Dyke Beginner
Entity Framework: Or How I Learned to Stop Worrying and Learned to Love Developers Richie Rump Intermediate
ETL Automation Using SSIS Jorge Novo Intermediate
Exploring The Microsoft Reporting Technologies David Ortiz Beginner
From 0 to big data in 60 minutes Luis Figueroa Intermediate
Getting started with Master Data Services 2012 Luis Figueroa Beginner
HDInsight: What’s all the Hadoopla about Big Data? Rafael Salas Intermediate
Help! I’ve Got XML In My Database! Kendal Van Dyke Intermediate
How to be a GREAT DBA Jeffrey Garbus Beginner
Implementing a HIPAA Compliance Strategy with SQL Server Brandon Leach Beginner
Implementing Auditing in SQL Server 2012 David Dye Beginner
Indexing for Join Optimization Jeffrey Garbus Advanced
Indexing for performance Jeffrey Garbus Intermediate
Into the Wild,Taming Unstructured Data Christopher Price Intermediate
Introducing Cube World To Users From Flat Table Land Michael Antonovich Intermediate
Introduction to SQL Server Replication Chad Churchwell Beginner
MDS in Practice: An Integrated Approach Christopher Price Beginner
Moving Big Data – SSIS, Pig, and Sqoop John Welch Beginner
PowerShell Working with XML and SMO Max Trinidad Intermediate
Present This, Not That! Kendal Van Dyke Beginner
Putting Quality Back Into Your Data Analysis Michael Antonovich Intermediate
Report Builder: Reports made Easy. Yelena Pavlyuk Beginner
Secrets of Enterprise Data Mining Mark Tabladillo Intermediate
Self-Service ETL and Data Explorer: Are we there yet? Rafael Salas Intermediate
Self-Service Visualization with Power View Anthony Sammartino Beginner
Social Marketing 2013 for Microsoft Professionals Mark Tabladillo Beginner
SQL Server – Practical Troubleshooting Dmitri Korotkevitch Intermediate
SQL Server 2012 AlwaysOn for HA and DR Chad Churchwell Intermediate
SQL Server 2012 AlwaysOn Step-by-Step David Bermingham Intermediate
SQL Server 2012 ColumnStore Indexes Gareth Swanepoel Intermediate
SQL Server 2012 IaaS and SQL Database In Depth Herve Roggero Intermediate
SRS Report Builder for Business Intelligence David Eichner Beginner
SSAS Tabular and PowerPivot – Choose Your Own Adve Anthony Sammartino Intermediate
SSIS – Integrating PowerShell in a ScriptTask component Max Trinidad Intermediate
SSIS Programming using .Net Jorge Novo Advanced
SSIS Programming Using .NET Jorge Novo Advanced
Stay ahead with Change Data Capture Jose L. Rivera Intermediate
Taking BI to the Next Level: Collaboration Stacia Misner Intermediate
TempDB under the hood Sam Mesel Advanced
The T-SQL Features in SQL Server 2012 You Can’t Ignore Richie Rump Intermediate
Tips on how to get your next GREAT job! Hanneh Bandi Non-Technical
Tuning Analysis Services Processing Performance John Welch Advanced
Unit Testing SSIS Packages John Welch Intermediate
Upgrade your TSQL to the NEXT level Jose L. Rivera Intermediate
Visualizing Data with Reporting Services Christopher Price Beginner
Whats New in T-SQL With SQL Server 2012 David Dye Beginner
Wrangling performance with Resource Governor Brandon Leach Beginner
Zero To Cube in 60 Minutes Dustin Ryan Beginner

 


By |June 9th, 2013|Uncategorized|

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

 

HASSUG & H-BI Monthly Meeting – June 11, 2013
In-Person & Online Event

Language: English

Date: Tuesday, June 11, 2013

Time: 12:30 pm – 3:30 pm (Mountain Time)

Cost: Free

Featured Presentation

Extend Your Knowledge with Extended Events!

Speaker: Janis Griffin, Senior DBA Confio Software, Inc.

Summary: SQL Server Extended Events can be used to gather a wide range of performance information, and in troubleshooting in SQL Server. Extended Events use less system resources and provide better information than SQL Profiler and they allow for correlation of SQL Server event data alongside of OS or Application event data. This presentation will explore what Extended Events are, how to set them up and use them in several case studies in 2012.

About Janis: Janis Griffin has over 25 years of DBA experience including design, development and implementation of many critical database instances. Her primary focus has always been database performance. Before coming to Confio, she held many DBA positions, primarily in the Telecom/Network Industry, working with real-time network / OLTP databases. At Confio, her primary focus is assisting customers in finding and fixing database performance issues.

Introduction to Big Data

Speaker: Tyler Chessman

Summary:  Tyler will answer the question: What is Big Data? Then, he will give a DBA’s perspective of Big Data. Finally, he will discuss Microsoft’s approach to Big Data via Data Management, Data Enrichment, and Insight.

Event details >> Join Meeting


Virtualization – “Monitoring Virtual SQL Servers”
Professional Development – Online Event

Language: English

Date: Wednesday, June 12, 2013

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

Cost: Free

Speakers: Jes Borland & Grant Fritchey

Summary: Many of the metrics used to monitor performance on SQL Server are completely unaffected by whether or not you’re running on a virtual machine. Some of those metrics are seriously impacted. Knowing which metrics are impacted and, more importantly, why, is the purpose of this session. We’ll spend time outlining what you can monitor normally in SQL Server, and we’ll show what parts of monitoring require you to do things differently because of the nature of virtual servers. You will be able to gather meaningful metrics from your own systems using the information presented in this session.

Event details >> Register


BI Implementation for Healthcare Surveillance
Business Intelligence – Virtual Chapters – Online Event

Language: English

Date: Wednesday, June 19, 2013

Time: 8:00 am – 9:00 am PDT

Overview: Business Intelligence (BI) systems are collections of tools that provide the ability to transform huge amount of data into Knowledge and, eventually, informed decisions. BI systems are nowadays are among the essential tools in many industries, such as banking and marketing. Many BI implementations have also been conducted in healthcare, and many of them have already shown significant positive results. This session will highlight the utilization of BI in the healthcare surveillance field. It will focus on a BI implementation that took place in one of the heath councils in the state of Florida. The speaker will start by covering the Information Technology (IT) infrastructure of the council prior to the project initial. He will then walk through the different project phases until the system development completion. The speaker will also highlight the key system components and provide a number of demonstrations to illustrate their functionality and benefits.

Speaker: Raed AlHazme

About Raed: Raed AlHazme holds a master’s degree in biomedical informatics. He is also an MCTS in the Development and Implementation of Microsoft Business Intelligence, HL7 certified, and Lean Six Sigma Green Belt certified. Raed is currently pursuing his PhD in biomedical informatics at the University of Medicine and Dentistry/Rutgers University.Recently, Raed was the key designer, developer and implementer of a complete BI system for Broward Health Planning Council (BRHPC) at the state of Florida. The system included an Extraction Transformation and Loading (ETL), data cubes, analytical reports, analytical maps, and a SharePoint 2010 solution to deploy the BI components. Raed is currently working on expanding the BI system to cover the other health planning councils at the state of Florida.

Cost: Free

Event details >> Register


DArch – Challenge Designing Finance DW

Language: English

Date: Thursday, June 20, 2013

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

Cost: Free

Summary: Challenges to designing financial warehouses, lessons learnt In today’s rapidly changing financial world, designing robust and durable data warehouses can be a challenge that does not always stand the test of time. In this presentation, we shall look at some of the challenges and design issues that were encountered whilst designing two custom warehouses and the steps that were required to cope with ongoing requirement changes, indecision from management, and shrinking budgets; all of which affected the progress of moving these projects from the design board to a profitable production stage.

Speaker: Steve Simon, Senior Business Intelligence Development Engineer Atrion Networking Corporation

About Steve Simon: Steve Simon is a SQL Server MVP and a senior BI Development Engineer with Atrion Networking. He has been involved with database design and analysis for over 25 years. Steve has presented papers at eight PASS Summits and one at PASS Europe 2009 and 2010. He has just recently presented a Data Quality Services presentation at the PASS Nordic Rally in Copenhagen. Steve has also presented 5 papers at the Information Builders’ (IBI) International Summits. He is a PASS regional mentor & chair of the Oracle/SQL Server VC.

Event details >> Register


PowerPivot and Complex DAX Expressions
BI Virtual Chapter

Language: English

Date: Wednesday, June 26, 2013

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

Cost: Free

Summary: PowerPivot is a powerful new tool able to slice and dice data in memory very fast. In this session you will learn how to build complex situations like, parent child hierarchies, Many to Many, and using inactive Relationships and learn some string manipulations. Come see these complex DAX functions and leave with some great DAX knowledge. Key takeaways: Learn DAX expressions like parent child hierarchies and Many to Many.

Speaker: Mike Davis

About Mike Davis: Mike Davis, MCITP, is a Managing Project Lead and BI Architect at Pragmatic Works. He is an author with books covering Business Intelligence and SSIS. Mike is an experienced speaker and has presented at many events such as several SQL Server User Groups, Code Camps, SQL Server Launches, SQL Saturday, and SQL Rally. Mike is an active member at his local user group (JSSUG) in Jacksonville, FL.

Event details >> Register


Summer Performance Palooza 2013
Performance Virtual Chapter

Language: English

Date: Tuesday, June 27, 2013

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

Cost: Free

Featured Presentations

 

9:00 – How the SQL Server Engine Thinks

Speaker: Brent Ozar

RSVP: https://attendee.gotowebinar.com/register/3571390038980185344
Abstract: When you pass in a query, how does SQL Server build the results? We’ll role play: Brent Ozar will be an end user sending in queries, and you’ll be the SQL Server engine. Using simple spreadsheets as your tables, you’ll learn how SQL Server builds execution plans, uses indexes, performs joins, and considers statistics. This session is for DBAs and developers who are comfortable writing queries, but not so comfortable when it comes to explaining nonclustered indexes, lookups, and sargability.

About Brent: Brent Ozar specializes in making SQL Server faster and more reliable. He’s a Microsoft Certified Master of SQL Server and MVP, and he has over a decade of experience. He coauthored Professional SQL Server 2008 Internals and Troubleshooting, and he loves sharing knowledge at BrentOzar.com.

10:00 – Updates to Statistics and the Effect on Query Performance

Speaker: Erin Stellato, Senior Consultant SQLskills.com

RSVP: https://attendee.gotowebinar.com/register/8095340527805459712
Abstract: Someone comes up to you and says my query is slow. Where do you begin? Do you start with the query itself? The query plan? SQL Server DMVs? There are many areas to investigate and one common area of focus is statistics. Statistics are an easy target for blame when performance is poor, and updating statistics without sufficient background information is a popular response as a quick fix. But what does updating statistics really do to your query plans? And is that the right solution? While updating statistics may solve your problem in the short-term, it may bury the true root cause. If you’re not familiar with what happens to query plans when you update statistics, then don’t miss this session. We’ll set the stage with a review of what statistics are, how the optimizer uses them, and discuss the various ways you can update them. Then we’ll explore what happens to plans when you do update statistics, and you’ll see why that might not always be the right long-term solution.

About Erin: Erin Stellato is a senior consultant with SQLskills and lives in Cleveland, OH. She has over 12 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include internals, performance tuning, and high availability and disaster recovery. Erin is a SQL Server MVP and an active member of the SQL Server community. She is involved with the Ohio North SQL Server User Group and blogs at SQLskills.com/blogs/erin. You can find her on Twitter at @ErinStellato.

11:00 – 10 Bad Habits that can Kill Performance

Speaker: Aaron Bertrand, Senior Consultant SQL Sentry, Inc.

RSVP: https://attendee.gotowebinar.com/register/5110462226512473088
Abstract: Bad habits: we all have them. SELECT * is the obvious one; but in this session you will learn about various other habits and why they can be bad for performance. Come learn how these habits develop, what kind of problems they can lead to, and how you can avoid them.

About Aaron: Aaron Bertrand is a senior consultant for SQL Sentry, makers of performance monitoring and event management software for SQL Server, Analysis Services, and Windows. He blogs at sqlperformance.com and sqlblog.com, has been an MVP since 1997, will soon be a three-time SQL Cruiser, and speaks frequently at various community events. You can find his MVP profile at https://mvp.support.microsoft.com/profile/Aaron.

12:00 – Using Performance Monitor for your Virtual Servers

Speaker: Wendy Pastrick, Consultant BlueGranite

RSVP: https://attendee.gotowebinar.com/register/641338885939701248
Abstract: Your SQL Servers have now been virtualized, and you are monitoring them successfully. Do you know what the performance is like on the host, though? Using Performance Monitor (perfmon) we will look at the counters you need to have in place to know if your host is performing well. Set up the counters, collect the data and have meaningful conversations with your Virtualization or Infrastructure team.

About Wendy: Wendy Pastrick is a consultant in Chicago with BlueGranite, a Business Intelligence firm. She has been working with SQL Server since 2001 and specializes in server maintenance, migration and upgrades as well as architecting for high availability and disaster recovery. Wendy is an active member of the PASS organization, currently serving on the Board of Directors and often speaks at local user groups and SQL Saturday events. She has recently been awarded an MVP from Microsoft for SQL Server.

13:00 – Looney Tuner? No, there IS a method to my madness!

Speaker: Janis Griffin, Senior DBA Confio Software, Inc.

RSVP: https://attendee.gotowebinar.com/register/2019100622824750592
Abstract: SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL Diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.

About Janis: Janis Griffin has over 25 years of DBA experience including design, development and implementation of many critical database instances. Her primary focus has always been database performance. Before coming to Confio, she held many DBA positions, primarily in the Telecom/Network Industry, working with real-time network / OLTP databases. At Confio, her primary focus is assisting customers in finding and fixing database performance issues.

14:00 – Pivoting Performance Data & Pinpointing Problems

Speaker: Brian Flynn

RSVP: https://attendee.gotowebinar.com/register/2073955257666587136
Abstract: Got performance problems? Struggling crack the case? Whether the problem is SQL Server, Windows, IIS or anything else. I’ve got a technique for logging and analyzing performance data using tools you probably have. Using these tools I have been able to find needles in haystacks and effectively communicate the nature of the problems to people at all levels. You don’t need an expensive 3rd party product if you’ve got elbow grease and the code I’ll give you. In this session, I’ll demonstrate how I capture and analyze DMV and WMI counters. I’ll tell some stories how this helped me solve some mysteries. You could use this pattern for any counters you can get your hands on. Join me for some mystery SQL theatre!

About Brian: Brian Flynn has been working in IT since his college days in 1995, beginning as a desktop support technician. Since graduating with a Computer Science & Mathematics degree from SLU in 1999, he has served in many roles such as web and database development, administration and system engineering of multiple disciplines including web, database, mail and networking. He has been functioning in management capacities since 2008 and enjoys promoting social interaction and team building among I.T. pros.

15:00 – Index Methods You’re Not Using

Speaker: Jes Borland, Consultant Brent Ozar Unlimited

RSVP: https://attendee.gotowebinar.com/register/8999427157149141248
Abstract: There are index methods in SQL Server that can enhance the performance of your queries – but most likely, you aren’t using them! Using examples, I’ll show you how indexed views, filtered indexes, and compressed indexes work; how they can improve performance; and what situations each is best used in. If you have a solid knowledge of index basics and want to add to your collection, this is the session for you!

About Jes: Jes Schultz Borland is a consultant with Brent Ozar Unlimited and a Microsoft SQL Server MVP. She holds an AAS – Programmer / Analyst degree and has worked with SQL Server as a developer, report writer, DBA, and consultant. She is an active member of PASS, President of FoxPASS in northeast Wisconsin, founder of Tech on Tap, and a LessThanDot.com blogger. Jes frequently presents at user groups, SQLSaturdays, and other community events. She is also an avid runner and chef.

16:00 – How to Build an Affordable SQL Server Lab

Speaker: Todd Kleinhas, Senior SQL Server DBA consultant Datavail

RSVP: https://attendee.gotowebinar.com/register/5686199500230306048
Abstract: Do you have an affordable lab set-up running SQL Server 2012 on Windows 2012 to learn and play with? In the 70-462 Administering Microsoft SQL Server 2012 Databases Training Kit, you will need six (!) machines on their own domain to complete the exercises. Using VMWare Workstation 9 ($250), Todd will show how to set up your lab environment on a ~$500 laptop running Windows 7 64-bit, 8GB of RAM, and an SSD drive using less than 40GB of space for the six virtual machines! Using free iso(s), we will run through several of the set-up exercises from the 70-462 Training Kit in order to build out the training lab. Participants will leave with enough knowledge and links to resources to build their own affordable SQL Server 2012 lab.

About Todd: 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.

More Event details

By |June 9th, 2013|Uncategorized|

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

 

Adam Belebczuk – Introduction to SQL Server 2012 A
DBA Fundamentals – Canada/US Online Event

Language: English

Date: Tuesday, May 7, 2013

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

Cost: Free

Event details >> Register


TBA – “Details of our upcoming event are still being ironed out…”
Professional Development – Online Event

Language: English

Date: Wednesday, May 8, 2013

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

Cost: Free

Event details >> Register


HASSUG & H-BI Monthly Meeting
Professional Development – Online Event

Language: English

Date: Tuesday, May 14, 2013

Tentative 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

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

Cost: Free

Event details >> Register


Robert Davis – Case Study: Designing a Global Scaled-out Architecture Level

Summary: How do you deliver a public-facing website on a global scale? To be truly competitive in a global market, you need to deliver a high performing website no matter what part of the world the user is in. Scaling out websites to multiple locations is easy, but it doesn’t really provide the performance required if the website has to get data from halfway around the world. This session will look at the challenges to scaling out the entire application to meet global performance requirements and how we addressed these challenges for an existing web application.

About Robert: Robert is a SQL Server 2008 Certified Master and an experienced Database Administrator, SQL Server evangelist, speaker, writer, and trainer. He has worked with SQL Server for 13+ years, most recently as Chief SQL Server Evangelist for Idera Software. Previously he served as PM for the SQL Server Certified Master Program at Microsoft Learning, and as a production DBA at Microsoft. Robert helped found the PASS Data Architecture Virtual Chapter and was co-author of Pro SQL Server 2008 Mirroring

Language: English

Date: Thursday, May 16, 2013

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

Cost: Free

Event details >> Register


SQL Server Disk I/O
WVPASS – Canada/US

Language: English

Date: Thursday, May 16, 2013

Time: 4:00 pm – 6:00 pm (Mountain Time)

Cost: Free

Event details >> No registration link provided


HBase and HDInsight Java Script Console
PASS Big Data Virtual Chapter

This session continues on building an understanding on HadoopmEcosystem Components, with a focus on HDinsight Javascript shell and NOSQL DB HBase.

Language: English

Date: Tuesday, May 21, 2013

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

Cost: Free

Event details >> Register


By |May 2nd, 2013|Uncategorized|

PASS SQL Saturday Events : May 2013

 

PASS SQLSaturday 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).

 

#209 / Rochester, NY

Date: Saturday, May 11, 2013

Time: 8:45 am – 5:00 pm (Check-in @ 8:00 am)

Cost: Free + $5.00 For lunch

Event details >> Register


#212 / Redmond, WA

Date: Saturday, May 18, 2013

Time: 8:00 am – 5:00 pm

Cost: Free, Includes lunch

Event details >> Register


#216 / Krasnodar, Russia

Date: Saturday, May 18, 2013

Time: 8:00 am – 5:00 pm

Cost: Free

Event details >> Register


#220 / Atlanta, GA

Date: Saturday, May 18, 2013

Time: 8:00 a.m. – 5:00 p.m.

Cost: Free, $10 for lunch

Event details >> Register


#209 / Prishtina, Kosovo

Date: Saturday, May 18, 2013

Time: 8:00 am – 5:00 pm

Cost: Free

Event details >> Register


#208 / Riyadh, Saudi Arabia

Date: Saturday, May 25, 2013

Time: 8:00 a.m. – 5:00 p.m.

Cost: Free

Event details >> Register


#219 / Kiev, Ukraine

Date: Saturday, May 25, 2013

Time: 8:00 a.m. – 5:00 p.m.

Cost: Free

Event details >> Register


#224 / Sydney, Australia

Date: Saturday, May 25, 2013

Time: 8:30 a.m. – 4:45 p.m.

Cost: Free

Event details >> Register


By |May 1st, 2013|Uncategorized|

PASS Virtual Chapter Events – September 2012

PASS DBA Fundamentals Virtual Chapter

fundamentals.sqlpass.org / Twitter:  @DBAFundVC

September 4, 2012 – 11:00 a.m. CST

Introduction to SQL Server Service Broker

Speaker:  Adam Belebczuk

In this session, we’ll cover the basics of setting up SQL Server Service Broker from the ground up with lots of demos.  We’ll discuss some pros and cons to using Service Broker, some common problems encountered when using it, and some example use cases.  If you’ve ever been curious about Service Broker, need to send data between databases or instances, or are wondering if Service Broker is right for your organization, then you won’t want to miss this session.

Speaker Bio:  Adam Belebczuk is a Developer turned Accidental DBA that works for a small SaaS provider in Cleveland, Ohio.  Adam is an MCITP DBA 2005/2008 and belongs to the Ohio North SQL Server User Group & Professional Association for SQL Server (PASS).  In addition to all things technological, he also loves to make electronic music, cook, go skiing, read, and help educate his fellow geeks whenever the opportunity presents itself.

Contact URL:  http://www.SQLDiablo.com

 

PASS Data Warehousing and Business Intelligence Virtual Chapter

Web:  http://BI.sqlpass.org / Twitter:  @PASSBIVC / Email:  PASSDWBIVC@sqlpass.org

September 6, 2012 – 12:00 p.m. EDT

Exploring Your Data with Power View

Speaker:  Jessica Moss

URL:  https://www.livemeeting.com/cc/usergroups/join?id=4S69WQ&role=attend&pw=X%27_Z35q_g

Exploring your data has never been easier with Power View included in SQL Server 2012.  Learn how to analyze and discover new trends in your information by using the intuitive, easy to use, and business-friendly tool.  This session will not walk through installation of the tool, but will instead describe the different visualizations provided and when you would use each one.

Speaker Bio:  Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server business intelligence.  Jessica’s expertise includes data warehouse modeling, Integration Services ETL’s Analysis Services semantic modeling, Reporting Services report design, and helping customers across industries successfully implement and enhance their business intelligence solutions.  Jessica enjoys sharing her knowledge with the central Virginia community, speaks regularly at user groups, code camps, and conferences, and has co-authored technical books.  You can read more on her website:  http://www.jessicammoss.com.

 

PASS SQL Professional Development Virtual Chapter

September 12, 2012 – 10:00 a.m. PST

The Art of the Question – How can IT Pros be more successful?

Speaker:  Brian Moran

www.323livemeeting.com/cc/usergroups/webJoin?id=PCGZ5W&role=attend

 

PASS SQL Performance Virtual Chapter

Web:  performance.sqlpass.org

September 27, 2012 – 6:00 p.m. GMT

I feel the need . . . the need for speed

Speaker:  Jeff Renz

Every project that I worked on I’ve always felt that users want everything to be fast . . . really fast.  Since we tend to be constrained by time and money we want to best leverage the tools and techniques that make the project successful . . . “fast.”  With the introduction of SQL 2012 we need to understand what we get by implementing a SQL Server 2012 solution.  That led me to these questons:

Is SQL Server 2012 really faster and more efficient than SQL Server 2008 R2 when I load data and query data?  Does a SQL Server 2002 Tabular model perform the same as a SQL 2012 Dimensional Model?  Are there really any performance differences when loading data using SSIS 2012 compared to other data loading approaches?  Does SQL Server 2012 offer me anything specific that would cause me to change how I would design my database to take advantage of new performance features?  Find out the answer to these questions and more in my session.

Speaker Bio:  Jeff Renz has developed databases using SQL Server for over 13 years, primarily focused on global manufacturing and supply chain data collection and reporting.  In the past two years he has implemented two large data warehouses using data vault architecture for Abound Solar.  Jeff has a Bachelors degree in computer sciences and a Masters degree in operations research from the Colorado School of Mines.  Jeff is a Certified Data Vault Data Modeler by the Genessee Academy.

View the Live Meeting:  www323.livemeeting.com/cc/usergroups/webJoin?id+G2JHM2&pw=W%5Dw5%22K45B&role=attend

 

 

By |September 4th, 2012|Uncategorized|

PASS SQL Saturday – September 2012

PASS SQLSaturday 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 lunch fee of $10.00 may be charged so that lunch may be provided (not pizza).

 

#162 / Cambridge, MA

Saturday, September 8, 2012

8:00 a.m. – 5:00 p.m.

Register at:  http://www.sqlsaturday.com/162/register.aspx

 

#167  / Columbus, GA

Saturday, September 8, 2012

8:00 a.m. – 5:00 p.m.

Register at:  http://www.sqlsaturday.com/167/register.aspx

 

#170 / Munich

Saturday, September 15, 2012

8:00 a.m. – 5:00 p.m.

Register at:  http://www.sqlsaturday.com/170/register.aspx

 

#156 / Providence

Saturday, September 15, 2012

8:00 a.m. – 5:00 p.m.

Register at:  http://www.sqlsaturday.com/156/register.aspx

 

#157 / San Diego

Saturday, September 15, 2012

8:00 a.m. – 5:00 p.m.

Register at:  http://www.sqlsaturday.com/157/register.aspx

 

#154 / St. Louis, MO

Saturday, September 15, 2012

8:00 a.m. – 5:00 p.m.

Register at:  http://www.sqlsaturday.com/154/register.aspx

 

#169 / Denver, CO

Saturday, September 22, 2012

8:00 a.m. – 5:00 p.m.

Register at:  http://www.sqlsaturday.com/169/register.aspx

 

#155 / Lima, Peru

Saturday, September 22, 2012

8:00 a.m. – 5:00 p.m.

Register at:  http://www.sqlsaturday.com/155/register.aspx

 

#160 / Kalamazoo, MI

Saturday, September 22, 2012

8:00 a.m. – 5:00 p.m.

Register at:  http://www.sqlsaturday.com/160/register.aspx

 

#149 / Minneapolis, MN

Saturday, September 29, 2012

8:00 a.m. – 5:00 p.m.

Register at:  http://www.sqlsaturday.com/149/register.aspx

 

#151 / Orlando, FL

Saturday, September 29, 2012

8:00 a.m. – 5:00 p.m.

Register at:  http://www.sqlsaturday.com/151/register.aspx

 

#152 / Romania

Saturday, September 29, 2012

8:00 a.m. – 5:00 p.m.

Register at:  http://www.sqlsaturday.com/152/register.aspx

 

By |September 4th, 2012|Uncategorized|

PASS Virtual Chapter Events – July 2012

 

Date:  Thursday, July 10

Time:  11:00 a.m. – 12:00 p.m. Central Time

Virtual Chapter:  DBA Fundamentals

Event URL:  http://www.livemeeting.com/cc/usergroups/join (Meeting ID TW8M35, Entry Code Prxcw2F-H)

 

Subject:  ‹DBA

Now that you’re a DBA where do you start?  You have backups, don’t you?  Are you really sure?  Tools for the DBA really help you do your job, so we will talk about some tools to use.  I’ll talk about how you can get help when you need it.  I’ll point you to some really good scripts to use for monitoring or for using for your whole maintenance cycle on your SQL Servers.

‹Presenter:  David Smithey has 31 years of IT experience.  He has 9 years of experience as an SQL Server DBA and before that he was a developer.  He has worked/consulted for companies such as Acustar, Computer Services Corporation, the Pentagon, Boeing and NASA.  He is currently employed by Curves International.  ‹Email:  david@davidsmithey.com ‹ Twitter:  @DavidKSmithey

 

Date:  Thursday, July 26

Time:  12:00 p.m. – 1:00 p.m. Central Time

Virtual Chapter:  Data Architecture Virtual Chapter

Event URL:  http://www.livemeeting.com/cc/usergroups/webJoin?id=CZC34P&pw=nP%28qm%3A2RN&role=attend

Subject:  ‹Where Are My (Primary) Keys?

 

In this session, we revisit some of the fundamental design principals of relational databases – normalization rules, key selection, and the controversies associated with these issues — from a very hands-on, practical perspective.  We also consider the benefits and challenges of using different types of keys (natural, surrogates, artificial, others) from multiple aspects, including data consistency, application development, maintenance, portability, and performance.
Session takeaways:
Understand the profound impact of key selection on the entire application lifestyle
Learn to identify when it is best to use natural or artificial keys
Learn how to minimize performance, portability, and maintenance issues during the early database design phase
‹Presenter:  ‹Ami Levi, CTO, DBSophic – Ami Levin is a Microsoft SQL Server MVP since 2006, with over 20 years of experience in development and IT.  For the past 14 years, he has been consulting, teaching, writing, and speaking about SQL Server worldwide.  Ami’s areas of expertise are data modeling, database design, T-SQL, and performance tuning.  He leads the Israeli SQL Server user group (ISUG), moderates the Hebrew MSDN SQL Server support forum, and is a regular speaker at Microsoft Tech-Ed Israel, Dev Academy, and other SQL Server conferences.  Ami speaks often at user group meetings in Israel and Europe and writes articles about SQL Server.
By |June 21st, 2012|Uncategorized|

PASS Summit – November 2012

PASS Summit is the world’s largest and most intensive technical training conference for Microsoft SQL Server community for the SQL Server community.

 

Since 1999, PASS Summit has delivered the most technical sessions, the largest number of attendees, the best networking, and the highest-rated sessions and speakers of any SQL Server event in the world.  Join us for top-notch training, technical tips and tricks, and the connections you need to take your SQL Server skills to the next level.

 

PASS Summit 2012

Washington State Convention and Trade Center

November 6-9, 2012

Seattle, WA

 

Register for only $1,395 until June 30, 2012

 

Event Link:  www.sqlpass.org/summit/2012/Registration.aspx

 

By |June 21st, 2012|Uncategorized|