ColoradoSQL Archives - Page 3 of 3 - DawaBI

ColoradoSQL

ColoradoSQL in June

All ColoradoSQL user group meetings start at 5:30 and provide food and refreshments. There is no cost to attend so bring a co-worker.

BoulderSQL

Third Tuesday

Level 3 Communications

Room 4LA-07

1025 Eldorado Blvd
Broomfield, CO 80021

Warm-up Presentation

Transaction Basics

Paul Paiva

An overview of what transactions are all about. The following areas will be covered:

  • What is a transaction?
  • What is a distributed transaction?
  • When should I use a transaction?
  • How to use transactions during ad hoc work in the SSMS query window to safeguard against accidents.

Actual code samples will be presented and executed, live!

 

Paul Paiva has 16 years experience in virtually all aspects of Microsoft SQL Server.  In these years he has worked in the roles of production DBA, database developer, database architect, applications developer, business intelligence and data warehouse developer, and instructor for students aspiring for MCDBA certification.  He has performed numerous data migrations and supported large databases (3 Terabyte, 1+ billion rows) with high transactions. Presently he is an independent SQL Server consultant with CoCreative Solutions.  He is a member of the Professional Association for SQL Server (PASS), blogs about lessons learned from a developer’s approach to SQL Server administration, and has been the co-president of the Boulder SQL Server Users’ Group for the past two years.

 

Main Presentation

Isn’t That Spatial?

Jason Horner (twitter)

 

This presentation is a 1hr deep dive into the spatial features introduced in Sql Server 2008.  We will cover the basics of working with spatial data including: importing, querying, and visualizing.  As time permits, we will dive into some best practices for working with spatial data and ways to improve spatial query performance.

 

Jason has been working with SQL Server since version 6.5 and currently holds several Microsoft certifications including: MCSD, MCDBA and MCTS. His most recent focus has been architecting large scale BI solutions. Previously, he helped architect, design, and build several high volume OLTP systems in a wide range of business domains.

SpringsSQL

Third Wednesday

Mr. Biggs

5825 Mark Dabling Boulevard
Colorado Springs, CO 80919

Warm-up Presentation

Isn’t That Spatial?

Jason Horner (twitter)

 

Isn’t that Spatial is a 30 minute whirlwind tour of the spatial features introduced in SQL Server 2008. We will cover the basics of working with spatial data including: importing, querying, and visualizing. As time permits, we will dive into some best practices for working with spatial data and ways to improve spatial query performance.

 

Jason has been working with SQL Server since version 6.5 and currently holds several Microsoft certifications including: MCSD, MCDBA and MCTS. His most recent focus has been architecting large scale BI solutions. Previously, he helped architect, design, and build several high volume OLTP systems in a wide range of business domains.

 

Main Presentation

Managing SQL Server Permissions

Mike Fal

When your boss asks you who has access to your databases, do you break out into a cold sweat? Or, instead, are you worried about those other people who might have ‘sa’ access to your server and might be causing trouble on your server? Either way, as DBAs we need to be able to audit our SQL Server security. This presentation will give you a general overview of the different types of roles that you can use to manage access, what they mean, and how we look at the security gremlins hiding under the covers of our databases.

 

Mike Fal is a SQL Server DBA with 10+ years of experience, with some brief excursions into Oracle and Netezza. He currently works for a nation-wide marketing agency, supporting over 100 database servers with databases from 1 GB to 4 TB in size. Mike holds a Bachelor’s Degree from the University of Colorado at Boulder and has been caught playing trombone in public on more than one occasion.

DenverSQL

Third Thursday

Microsoft DTC Office

7579 Technology Way, Suite 400
Denver, CO 80237

Warm-up Presentation

Securing Your Service Accounts

Brandon Tucker

 

“What are service accounts, and how do they affect me?” Everyone’s asked it before, and some have never gotten the proper answers. Though it’s unlikely to answer all the questions of the universe in this 30-minute presentation, we’ll explore the security concerns with service accounts, pitfalls to avoid, and considerations to streamlining your SQL Server service accounts!
Over the past five years, Brandon has explored the SQL Server product as both a developer, administrator, and consultant. Starting in Salt Lake City, he translated his academic knowledge base into real-world scenarios in the health insurance, education, and transportation industries. Brandon has presented at Code Camps/User Groups in UT, as well as User Groups/SQL Saturdays here in Denver. On the side, Brandon casually DJs electronic music and enjoys disc golf, skiing, and beer. He currently holds a BS Computer Science from Neumont University (by way of Bucknell University) and an MCITP: Database Developer.

Main Presentation

SSIS Data Transformations

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

 

Stunningly handsome yet surprisingly humble, Mike Sexton spent the first ten years of his career as a public defender in New York. Realizing he could make far more money as a junior programmer than as a lawyer with 10 years’ experience, he had a revelation, the words of which that are not appropriate for a family publication. Since then Mike has traveled the lands taming errant database applications, publishing and blogging at www.sqlmountain.com. He recently published Applied Architecture Patterns on the Microsoft Platform, which may be found at finer bookstores. Mike can be found living the high life in Colorado with a hot blonde on his arm.

By |June 15th, 2011|Uncategorized|

ColoradoSQL in May

All ColoradoSQL user group meetings start at 5:30 and provide food and refreshments. There is no cost to attend so bring a co-worker.

BoulderSQL

Tuesday May 17

Level 3 Communications

Room 4LA-07

1025 Eldorado Blvd
Broomfield, CO 80021

 

Presentation

Managing SQL Server Permissions

Technorati Tags: ,User Group

Mike Fal

When your boss asks you who has access to your databases, do you break out into a cold sweat? Or, instead, are you worried about those other people who might have ‘sa’ access to your server and might be causing trouble on your server? Either way, as DBAs we need to be able to audit our SQL Server security. This presentation will give you a general overview of the different types of roles that you can use to manage access, what they mean, and how we look at the security gremlins hiding under the covers of our databases.

Mike Fal is a SQL Server DBA with 10+ years of experience, with some brief excursions into Oracle and Netezza. He currently works for a nation-wide marketing agency, supporting over 100 database servers with databases from 1 GB to 4 TB in size. Mike holds a Bachelor’s Degree from the University of Colorado at Boulder and has been caught playing trombone in public on more than one occasion.

SpringsSQL

Wednesday May 18

Mr. Biggs

5825 Mark Dabling Boulevard
Colorado Springs, CO 80919

 

Presentation

Encryption, Compliance and Auditing

Tom Norman (twitter)

I have this database which must meet all of these governmental regulations. Just like the government to make life a lot harder but wait, now they say I most also meet International regulations. Can this be true? Why me? Let’s look at what we can do to help us pass audits and comply with the laws around us. We will explore the features in SQL Server 2008 which help us.

 

Tom Norman, Sql Server Database Administrator, TSYS. Tom has been working with Sql Server since 1998. He has worked internationally with Sql Server. His current responsibilities include Replication, Performance and Server Compliance of all Production databases in the US and UK. Tom and his team are currently working on a project to upgraded several products to Sql Server 2008 R2 and bring them into PCI compliance. Tom is the past President of the Denver Sql Server User Group.

DenverSQL

Thursday May 19

Microsoft DTC Office

7579 Technology Way, Suite 400
Denver, CO 80237

 

Warm-up Presentation

Isn’t That Spatial?

Jason Horner (twitter)

Isn’t that Spatial is a 30 minute whirlwind tour of the spatial features introduced in SQL Server 2008. We will cover the basics of working with spatial data including: importing, querying, and visualizing. As time permits, we will dive into some best practices for working with spatial data and ways to improve spatial query performance.

Jason has been working with SQL Server since version 6.5 and currently holds several Microsoft certifications including: MCSD, MCDBA and MCTS. His most recent focus has been architecting large scale BI solutions. Previously, he helped architect, design, and build several high volume OLTP systems in a wide range of business domains.

Main Presentation

Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance

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

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

By |May 16th, 2011|Uncategorized|

DenverSQL UG Meeting: Tim Mitchell presents Dirty Data? Clean it up!

Denver SQL Server User Group – Thursday, February 17, 2011

Main Presentation
“Dirty Data? Clean It Up! By Tim Mitchell”

Dirty Data? Clean It Up!

Dirty data is everywhere, and it’s headed for a database near you.  Extraction, transformation, and loading (ETL) can be difficult, but often the most challenging component of that process is the validation and clean up of data.  Information must be cleansed in such a way that it retains its original message and business value, while conforming to the expectations of the destination system(s).  In this session, we will discuss some of the high-level challenges of dealing with dirty data, along with some infrastructure-agnostic recommended practices for doing so.  Further, we will dig in and get our fingernails dirty (pun intended) on some specific ways that SQL Server Integration Services (SSIS) can be used to cleanse incoming data.

 

About the Presenter

Tim Mitchell is a business intelligence consultant, database developer, speaker, and trainer.  He has been working with SQL Server for over 7 years, working primarily in business intelligence, ETL/SSIS, database development, and reporting.  He has earned a number of industry certifications and holds a Bachelor’s Degree in Computer Science from Texas A&M at Commerce, and is a Microsoft SQL Server MVP.  Tim is a business intelligence consultant for Artis Consulting in the Dallas, Texas area.  As an active member of the community, Tim has spoken at venues including numerous SQL Saturday events, Houston Tech Fest, and various user groups and PASS virtual chapters.  He is a board member and speaker at the North Texas SQL Server User Group in Dallas, is co-chair of the PASS BI Virtual Chapter, and is an active volunteer for PASS.  Tim is an author and forum contributor on SQLServerCentral.com and has published dozens of SQL Server training videos on HDIDS.com.  You can read his blog at TimMitchell.net or follow him on Twitter attwitter.com/Tim_Mitchell.

 


As usual, we will make time for question and answer sessions, networking, and eating. Prizes will be awarded at the conclusion of the meeting.

Our meeting location has changed!

Starting in January 2011,
we will be meeting at the Microsoft headquarters!7595 W. Technology Way, Suite 400
Denver, CO 80237
(720) 528-1700
map

Meeting Agenda:
5:30 – 6:00 – Food / Socializing
6:00 – 6:10 – User Group Business
6:10 – 6:30 – Open Panel/Questions & Answers
6:30 7:00 30 minute presentation
7:00 – 8:00 Main presentation
8:10 – Give Away / Wrap-Up

By |February 17th, 2011|Uncategorized|

Denver SQL Server UG September meeting

For the past 1 1/2 years now we’ve been hosting two presentations each meeting.  The first presentation is typically a 30 minute intro level topic and the second a 60 minute more advanced topic.  This month we are giving something else a go.  We are hosting two 60 minute presentations.  The first topic is Turbocharge SQL Server Insert Performance with the Hidden SqlCommandSet Class being presented by Brooke Philpott of SQL Sentry.  The second presentation is Efficient Operational Data Replication (ODR) with the Attunity CDC Suite for SSIS by Doug Wheaton of Attunity.  Attunity is also the featured sponsor for this month.

 

Here is more detail:

SQLSentry02-72

The first presentation, “Turbocharge SQL Server Insert Performance with the Hidden SqlCommandSet Class” will be given by Brooke Philpott of SQL Sentry.
SQL Server provides multiple ways to insert data using ADO.NET. We’ll explore individual writes as well as batched writes in non-RPC and RPC form, with a focus on using the internal SqlCommandSet class to get as close as possible to bulk-copy performance, without the restrictions. Along the way we’ll look at the impact of the various methods on the SQL Server plan cache, and address ways to prevent plan cache bloat when using high-volume inserts, ultimately arriving at a method that is very fast and has minimal impact on the plan cache.
Brooke Philpott is a Senior Technical Lead at SQL Sentry, Inc. Brooke is the lead developer of SQL Sentry’s award-winning software products. He was also part of the DBA team managing the largest SQL Server hosting shop in the Southeastern United States. Brook has BS in Mathematics from Davidson College. His hobbies include cooking, photography, music, and video games. You can read his blog here: http://brooke.blogs.sqlsentry.net/

 

attunitylogo

The second presentation, “Efficient Operational Data Replication (ODR) With the Attunity CDC Suite for SSIS” will be given by Doug Wheaton of Attunity.
During this presentation you will learn how to leverage your SQL Server skills and software to reduce cost and accelerate operational data replication (ODR), synchronization, and real-time integration of heterogeneous data sources including SQL Server, Oracle, and DB2. Doug will explain CDC (change data capture) and ODR concepts and benefits as well as how you can use them to enable operational reporting and business intelligence or to maintain data consistency across systems.
Doug Wheaton is a Senior Software Engineer at Attunity and has over 20 years of experience in the content, workflow management and data integration space. He has written numerous related articles and has presented at many Microsoft conferences throughout the US on the topic of data integration using Microsoft SSIS.
Location:

AmeriTeachlogo
AmeriTeach
7800 East Dorado Place, Suite 150
Greenwood Village, CO 80111
720-346-1710
Meeting Agenda:
5:30 – 6:00 – Food / Socializing
6:00 – 6:10 – User Group Business
6:10 – 6:15 – Open Panel/Questions & Answers
6:15 – 7:15 – Presentation 1
7:15 – 8:15 – Presentation 2
8:15 – 8:20 – Give Away / Wrap-Up

 

And of course: SQL Saturday #52 Colorado is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free with the exception of a $10 lunch fee; all other costs are covered by donations and sponsorships. Please also let friends and colleagues know about the event.
Registration for the 9/25 event is now open at: http://www.sqlsaturday.com/52/register.aspx

By |September 16th, 2010|Uncategorized|

Presentation materials: Intro to Analysis Services (SSAS)

 

I did a presentation last week for the Denver SQL Server User Group (www.DenverSQL.org) and the Colorado Springs SQL Server User Group (www.SpringsSQL.org) on Intro to Analysis Services.  The slide deck can be found here.  Both were short presentations (30 minutes) aimed at getting folks started with Analysis Services.

Both user groups have gone to two presentations a night.  The first topic is aimed at entry level folks and is 30 minutes long.  The second topic is more advanced for 60 minutes.  If you are interested in speaking, let me know.  We are always looking for good speakers to present.

By |June 26th, 2009|Uncategorized|