PASS Virtual Chapters Archives - DawaBI

PASS Virtual Chapters

PASS Virtual Chapter Events: September & October 2014

PASS Virtual Chapter Events: September 2014

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.

Date Time Title Link
September 16th 11:00 CST The Roadmap to Better Performance: Reading Query Plans https://attendee.gotowebinar.com/register/3935830875052414466
September 17th 12:00 PST Learn JavaScript Properly Part 2 https://attendee.gotowebinar.com/register/4322399372235297538
September 17th 4:00 EST Absolute Beginners Presentation for Power BI for Office 365 https://attendee.gotowebinar.com/register/4757737807317828865
September 18th 12:00 EST Insider's Introduction to Microsoft Azure Machine Learning (AzureML) http://bit.ly/PASSBAVC091814
September 26th 11:00 EST Improving Query Efficiency with Data Access Layers http://oracle.sqlpass.org/
October 8th   12:00 CST Understanding your SQL Server IO Bottlenecks and how Flash can solve them https://attendee.gotowebinar.com/register/6093820357156042754
October 16th 10:00 EST MrExcel's Favorite Excel Tips & Tricks https://attendee.gotowebinar.com/register/8089449354432962050

 

By |September 11th, 2014|PASS, Virtual Chapters|

PASS Virtual Chapter Events: August 2014

 

Date Time Title Link
August 15th 12:00 EST Manage Your Shop with CMS and Policy Based Management https://attendee.gotowebinar.com/register/4279519516082609665
August 19th 11:00 CST The Roadmap to Better Performance: Reading Query Plans https://attendee.gotowebinar.com/register/2124351382524970497
August 20th 12:00 PST Learn JavaScript Properly http://bookreaders.sqlpass.org/
August 21st 12:00 EST Looking Through the Windshield: Creating Forward-looking Dashboards and KPIs  https://attendee.gotowebinar.com/register/5282114692357849346
August 21st 1:00 EST SQL Server Security Easy Button https://attendee.gotowebinar.com/register/4752057729799585025
August 27th   12:00 EST The Curious Case of Isolation Levels http://dba.sqlpass.org/

 

By |August 15th, 2014|PASS, Virtual Chapters|

PASS Virtual Chapter Events: June 2014

 

Date Time Title Link
June 11 12:00 MST PASS DBA Virtual Chapter: A Comedy of Errors sponsored by Dell Software https://attendee.gotowebinar.com/register/1711991640373835777
June 11 10:00 MST Whats New in Hyper-V 2012 R2 https://attendee.gotowebinar.com/register/308303418870126593
June 13 12:00 CST SQL 2014 Clustered Updatable Columnstore Indexes https://attendee.gotowebinar.com/register/7946480954532285698
June 17 11:00 UTC Rolling Upgrades, The Easy Way! https://attendee.gotowebinar.com/register/3511824004444615426
June 19 12:00 EST The Accidental Report Designer: Data Visualization Best Practices in SSRS https://attendee.gotowebinar.com/register/5392867398311459330
June 26  2:00 EST Workload Tuning with Distributed Replay https://attendee.gotowebinar.com/register/1254440871617041921
By |June 10th, 2014|Virtual Chapters|

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

Application Development – Virtual Chapters

Date: Friday, December 6, 2013

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

Cost: Free

Language: English

Featured Presentation: Isn’t That Spatial: Spatial Data for the App Dev

Register

Virtualization – Virtual Chapters

Date: Wednesday, December 11, 2013

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

Cost: Free

Language: English

Featured Presentation: Virtualization Question & Answers with Brent Ozar

The Virtualization Virtual Chapter (aka SIG) is dedicated to better management of SQL Servers in virtual environments like Microsoft Hyper-V and VMware vSphere. We: Help the community by producing things like monthly training webcasts, a centralized list of helpful virtualization-savvy administrators, and a periodic report of what works well under virtualization and what isn’t quite working yet. Help virtualization vendors by getting training and configuration information out to the people who need it, and helping the vendors build a better product with our feedback. Help PASS management by building assets that PASS can leverage (like a library of training content) and showing that PASS solves real DBA problems.

Speaker Info:

Brent Ozar is a Microsoft Certified Master of SQL Server 2008 and a Microsoft SQL Server MVP. He has over a decade of experience with SQL Server, systems administration, SAN storage, virtualization, and project management. Today, he’s a consultant for Brent Ozar Unlimited. Previously, Brent was a SQL Server expert at Quest Software and a DBA at Southern Wine & Spirits, a Miami-based wine and spirits distributor. Brent blogs at http://www.BrentOzar.com like it’s going out of style.

Event Details >> Attend

Database Administration – Virtual Chapters

Date: Wednesday, December 11, 2013

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

Cost: Free

Language: English

Featured Presentation: Load Testing with SQL Server Tools sponsored by Dell Software

It’s often difficult to know how your SQL Servers will perform under different loads. By performing load testing, we can gain these key insights, perform modifications to existing configurations, and understand the impact on performance levels. Come learn about the native tools at our disposal for performing these important load tests and how we can identify when performance levels begin to drop. Using demos of these native tools including Distributed Replay Utility (DRU), Database Tuning Adviser (DTA), Perfmon, Extended Events, and Profiler we’ll see how to plan and perform a load test project, gain an understanding of SQL Server’s performance under varying load scenarios, and discover which tell-tale indicators can help alert us to performance degradation.

Speaker Info:

Neil Hambly is a 14-year SQL Server veteran, with expertise in SQL Server from version 6.5 to the latest 2012 edition. He’s held database roles at major organizations, including the BBC, ABN AMRO, and Accenture, as well as at a number of market-leading companies. Currently CTO/Founder at SQLnextSteps, he’s worked as a DBA, developer, and architect. Leader of the PASS London Chapter, Neil can frequently be found speaking at UK and international events.

Attend

Big Data Virtual Chapter – Virtual Chapters

Date: Tuesday, December 17, 2013

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

Cost: Free

Language: English

Featured Presentation: Building a Big Data Architecture

Big data solutions call for different architectural solutions than our traditional workloads. Here we examine several ideas related to the architecture”cloud versus on premises, picking toolsets and distribution, and how to plan for growth and change in the stack.

Speaker Info:

Joey D’Antoni is an Architect with over a decade of experience working in both Fortune 500 and smaller firms. He is currently solutions architect for SQL Server and Big Data for Anexinet in Blue Bell, PA. He holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University. He is a frequent speaker at events such as PASS Summit and TechEd.

Register

By |December 4th, 2013|Uncategorized|

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

DBA Fundamentals – Virtual Chapters

Date: Tuesday, November 5, 2013

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

Cost: Free

Language: English

Featured Presentation: Statistics Starters

Have you been updating statistics as part of your maintenance plan, even though you’re not really sure what they are? Have you been asking yourself where statistics exist, how to find them, and what people mean when they say check statistics? Do you look at the database options for statistics and wonder if they really matter? It’s time to end the guessing and start understanding the basics about statistics. In this session I’ll answer these questions using straight-forward demos and real-world examples. And if you haven’t been updating statistics as part of your maintenance plan don’t worry, I’ll get you started.

Speaker Info:

Erin Stellato is a Principal 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. 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.

There will be a drawing for a $100 Amazon gift card at the end of the meeting. A winner will be randomly chosen from all those in attendance for the whole webcast who provide their email address.

Register

Big Data Virtual Chapter – Virtual Chapters

Date: Tuesday, November 5, 2013

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

Cost: Free

Language: English

Featured Presentation: Table Partitioning: Secret Weapon for Big Data Pro

Big Data starting to slow you down? Data growth putting your maintenance tasks in danger of not meeting your SLAs? Wish you could archive old data with minimal impact to your tables during the archive process or that you could eliminate most of the data in your tables when you query them? If so, it’s time you consider implementing table partitioning to help with general performance and reduce your window for completing maintenance tasks. Come learn how table partitioning works and when it should be implemented. You’ll see how to initially configure partition functions and partition schemes to have a rock-solid partitioned table. And you’ll learn how to implement an automated sliding window to maintain your partitioned tables and ensure optimal performance.

Speaker Info:

John Sterrett is a database administration senior advisor for Dell, directly responsible for several mission-critical databases. Previously, he was a senior DBA focused primarily on performance tuning at a Remote DBA service company with over 200 SQL Server clients. He has presented at many community events, including PASS Summit, SQLRally, 24 Hours of PASS, SQLSaturday, and local PASS Chapter and Virtual Chapter meetings. He is a PASS Regional Mentor for the South Central US region, co-founded the West Virginia SQL Server User Group, and hosted the first and second SQLSaturday in West Virginia. He is a syndicated blogger at SQLServerPedia and SQLServerCentral.com and a writer for MSSQLTips.com.

Event Details >> Attend

Business Analytics – Virtual Chapters

Date: Thursday, November 7, 2013

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

Cost: Free

Language: English

Featured Presentation: Power BI Info Management and Data Stewardship

Business intelligence tools continue to improve, letting users shorten their time to insight and take that insight to more devices in more places. But this evolution of BI doesn’t change one fundamental fact of information management: You can’t gain insight from data you can’t access. In this session, Matthew Roche and Ofer Ashkenazi will introduce the role of the data steward and the self-service information management capabilities included in Power Query and Power BI for Office 365, focusing on how Power BI empowers business users to add value to the organization.

Speaker Info:

Matthew Roche is a Senior Program Manager on the SQL Server product team, working on Self-Service Information Management (SSIM) in Power BI, and who has worked on the SQL Server Enterprise Information Management (EIM) platform including SQL Server Integration Services (SSIS), Master Data Services (MDS) and Data Quality Services (DQS). Before joining Microsoft in 2008, Matthew was a business intelligence consultant and trainer and a Microsoft SQL Server MVP. In addition to implementing small- and large-scale BI solutions with SQL Server, Matthew has presented on SQL topics at major technical conferences, code camps, and user groups across the US and in Europe. Ofer Ashkenazi is a Senior Product Planner with the Data Platform Group (Information Services). His focus is on Power BI, in particular Power Query, the Data Catalogue, and the Data Stewardship Experience in Power BI. Before this role, Ofer was the planner for SQL Azure and other cloud data services, including the Azure Data Marketplace. He was also the product planner and senior technical product manager with the Enterprise Application Platform Marketing team at Microsoft. Ofer’s roles include planning for new services releases, briefing market analysts, and presenting at conferences. Before joining Microsoft, Ofer served as a Microsoft Regional Director, BizTalk Server. At the same time, he managed a BizTalk Server consulting, training, and professional services business for a Microsoft partner.

Attend

Business Intelligence – Virtual Chapters

Date: Thursday, November 7, 2013

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

Cost: Free

Language: English

Featured Presentation: The Accidental Business Intelligence Project Manager

You’ve watched the Apprentice with Donald Trump and Lord Alan Sugar. You know that the Project Manager is usually the one gets fired. You’ve heard that Business Intelligence projects are prone to failure. You know that a quick Bing search for why do Business Intelligence projects fail?’ produces a search result of 25 million hits! Despite all this¦ you’re now Business Intelligence Project Manager now what do you do? In this session, Jen will provide a sparks from the anvil’ series of steps and working practices in Business Intelligence Project Management. What about waterfall vs agile? What is a Gantt chart anyway? Jen will give you some ideas and insights that will help you set your BI project right: assess priorities, avoid conflict, empower the BI team and deliver the Business Intelligence project successfully!

Speaker Info:

Jen Stirrup, a SQL Server MVP and PASS Director-At-Large (Elect), is best-known for her work in business intelligence & data visualization. She runs Copper Blue Consulting, delivering business-critical solutions that add enterprise value. Jen has presented at TechEd North America, TechEd Europe, PASS Summit, and SQLBIts, as well as at SQLSaturday events in Europe. She won PASS’s prestigious Passion Award, presented at Summit 2012, for her work in supporting the SQL Server community in Europe.

Register

Virtualization – Virtual Chapters

Date: Wednesday, November 13, 2013

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

Cost: Free

Language: English

Featured Presentation: Testing and Benchmarking SQL Server Consolidation

Whether you are consolidating SQL Server on a hypervisor or bare-metal, proper testing and benchmarking of SQL workloads is critical. This session will introduce you to testing methodologies for the most commonly consolidated SQL Server workloads. CPU and memory configurations will be discussed as well.

Speaker Info:

Andrew: Frank Cicalese is a Technical Solutions Architect with Cisco Systems, Inc., assisting customers with their design of SQL Server solutions on Cisco Unified Compute System. Before joining Cisco, Frank worked at Microsoft Corporation for 10 years, excelling in several positions, including as Database TSP. Frank has in-depth technical knowledge and proficiency with database design, optimization, replication, and clustering and has extensive virtualization, identity and access management and application development skills. He has established himself as an architect who can tie core infrastructure, collaboration, and application development platform solutions together in a way that drives understanding and business value for the companies he services.

Event Details

Book Readers – Virtual Chapters

Date: Wednesday, November 20, 2013

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

Cost: Free

Language: English

Featured Presentation: Delivering Business Intelligence 5th Meeting

Speaker Info:

Ike Ellis SQL, Business Intelligence, and Data Consultant. He’s been a SQL Server MVP since 2010. He has 17 years of experience writing software and working with SQL Server. He’s the principal SQL course author and instructor for DevelopMentor. His twitter handle is@ike_ellis. Find more information at www.ikeellis.com

Brad Cunningham C# MVP since 2008. He’s always on the cutting edge of software development, writing for the new web, mobile, and enterprise solutions. His code has been featured all over the Internet, on numerous pod casts and user groups. You can find him on twitter as @foovanadil.

Rob Sullivan Bona fide Alpha Nerd, SQL Server DBA by day and code slinger by night. He is the SQL Dude for Tekpub, open source contributor to .NET Micro ORMS, speaker and can occasionally be found on This Developers Life. In his free time, he frequents various user groups in Oklahoma City or pretty much anywhere that has pizza.

Scott Reed An Azure MVP since 2011. Scott’s career in software began in 1993 at IBM. Along the way, he has developed enterprise solutions for both Microsoft and Cardinal Health. Scott is a generalist, his interests ranging from data access technologies and multithreading to communications and UI technologies. Scott holds a BS in Computer Science and math from Virginia Tech.

Event Details

By |November 1st, 2013|Uncategorized|

PASS Virtual Chapter Events : October 2013

 

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


Business Analytics – Virtual Chapters

Date: Tuesday, October 3, 2013

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

Cost: Free

Language: English

Featured Presentation: Predictive Analytics using In-Database Models

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

 

Speaker Info:

Jim Zhang Fuzzy Logix

Register


HASSUG & H-BI Monthly Meeting

Date: Tuesday, October 8, 2013

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

Cost: Free

Language: English

Schedule:

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

Event Details >> Attend


Professional Development – Virtual Chapters

Date: Wednesday, October 9, 2013

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

Cost: Free

Language: English

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

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

Speaker Info:

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

Attend

 


PASS Big Data Virtual Chapter – Virtual Chapters

Date: Wednesday, October 9, 2013

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

Cost: Free

Language: English

Featured Presentation: Sentiment Analysis with Big Data

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

Speaker Info:

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

Event Details

 


Business Analytics – Virtual Chapters

Date: Thursday, October 24, 2013

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

Cost: Free

Language: English

Featured Presentation: Brust on Business Analytics

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

Speaker Info:

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

Attend

 

By |October 2nd, 2013|Uncategorized|

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 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 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 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|