Baltimore SQL Server User Group Schedule

2017 Meeting Schedule

 

Date Session
February 21, 2017 Title - Kicking and Screaming: Replacing Profiler with Extended Events

Abstract - There have been three new releases of SQL Server since the introduction of Extended Events in SQL Server 2008, and DBAs and developers alike *still* prefer Profiler. Friends, it's time to move on. If you've tried Extended Events and struggled, or if you've been thinking about it but just aren't sure where to begin, then come to this session. Using your existing knowledge and experience, we bridge the gap between Profiler and Extended Events through a series of demos, starting with the Profiler UI you know and love, and ending with an understanding of how to leverage functionality in the Extended Events UI for data analysis. By the end of this session, you’ll know how to use Extended Events in place of Profiler to continue the tasks you've been doing for years--and more. Whether you attend kicking and screaming, with resignation because you’ve finally given up, or with boundless enthusiasm for Extended Events, you'll learn practical techniques you can put to use immediately.

Speaker - ERIN STELLATO
SQLskills
Principal Consultant

Erin Stellato is a SQL Server MVP and lives in Cleveland, OH. She has over 15 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include statistics, performance tuning, Extended Events, and helping accidental/involuntary DBAs figure out how SQL Server works. Erin is an active member of the SQL Server community, has volunteered for PASS at the local and national level, and is a regular speaker at conferences like SQLintersection and the PASS Summit. Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.

Email: Erin@SQLskills.com 
Website: http://www.SQLskills.com 
Full Bio: http://www.sqlskills.com/about/erin-stellato/ 
Blog: http://www.SQLskills.com/blogs/Erin 
Twitter: http://twitter.com/ErinStellato 
SQL Server MVP since 2012

Download Erin's slide deck.



Topic - Intro to PS and PS SQL server functionality.

Speaker - Mike a BSSUG MEMBER SINCE 2010.


Sponsor - Apex Systems - http://www.apexsystemsinc.com/

Apex Systems is the 6th largest technical staffing firm in the US. Apex was founded in 1995, is headquartered in Richmond, and has a presence in about 50 markets across the US. We specialize in placing technologists on a contract, contract-to-hire, and direct hire basis. Apex has specific technology practices, such as Database/BI, with skill set aligned Recruiters. The Senior Database Recruiter for our Baltimore and DC offices works with 20-25 clients who have SQL environments and typically sees about 10 openings a month for SQL Developers and/or DBA’s. For more information on Apex, visit www.apexsystemsinc.com, or contact Jared Sanson (LinkedIn) our SQL Recruiter for Baltimore and DC.

Apex Systems
March 21, 2017 Title - Top tips and tricks for SQL Server 2016

Abstract - This session will dive into new features and mechanics that change the way we do things. From JSON to performance. SQL Server 2016 is loaded with features and it’s easy to get lost in the weeds. Join me as I shed light on the most useful features, tips and tricks.

Speaker - Daniel Janik

Daniel Janik has been supporting SQL Server for 18 years. Six of those years were at Microsoft Corporation supporting SQL Server as a Senior Premier Field Engineer (PFE) where he supported over 287 different clients with both reactive and proactive database needs. Daniel has presented at many community events and SQL Saturdays.

Sponsor -
Sponsor - Redgate Software

Since 1999, Red Gate Software has produced ingeniously simple tools for over 600,000 Microsoft technology professionals worldwide.  We currently specialize in tools for MS SQL Server, .NET, Oracle, and Windows Azure. Our philosophy is to design highly usable, reliable tools that solve the problems of DBAs and developers.

Red-Gate.com


Redgate
April 18, 2017 Title - Power BI: Self-Service Reporting and Dashboards

Abstract - Analyzing data, creating dashboards, and answering business questions has never been easier than with Power BI. Whether you work in the cloud or on-premises, Power BI has a solution, and some of those solutions are even provided at no cost to you! This session will explain what Power BI is, how it is useful to you, and how you can get started immediately using these tools. No previous knowledge is needed to attend this session.

Speaker - 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 ETLs, 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 numerous technical books. You can read more on her website, http://www.jessicammoss.com.

Sponsor - Coming soon...
May 16, 2017 Title - Coming soon...

Abstract - Coming soon...

Speaker - KK - Pending

Sponsor - Coming soon...
June 20, 2017 Title - Coming soon...

Abstract - Coming soon...

Speaker - Ben Debow

Sponsor - Apex Systems - http://www.apexsystemsinc.com/ and TBD
July TBD, 2017 Title - Coming soon...

Abstract - Coming soon...

Speaker - Coming soon...

Sponsor - Quest Software
August TBD, 2017 Title - Coming soon...

Abstract - Coming soon...

Speaker - Coming soon...

Sponsor - Apex Systems - http://www.apexsystemsinc.com/ and TBD
September TBD, 2017 Title - SQL Server Performance Tuning

Abstract - In "SQL Server Performance Tuning", Hilary Cotter, describes how to
diagnose, troubleshoot and solve common SQL Server Performance tuning.
This session will arm you with tools to do benchmarking, diagnosing,
and resolving problems that you will face on most environments. You
will leave this talk with an approach to performance tuning which will
help you to make your SQL Servers handle greater loads on the same
hardware.

Speaker - Hilary Cotter

Sponsor - Coming soon...
October TBD, 2017 Title - Coming soon...

Abstract - Coming soon...

Speaker - Coming soon...

Sponsor - Apex Systems - http://www.apexsystemsinc.com/
November TBD, 2017 Title - SQL Server Extended Events

Abstract - Coming soon...

Speaker - Roman Rehak

Sponsor - Coming soon...
December TBD, 2017 Title - Coming soon...

Abstract - Coming soon...

Speaker - Coming soon...

Sponsor - Coming soon...

 


 

2016 Meeting Schedule

 

Date Session
January 19, 2016 Title - BSSUG Job Fair and Career Advice

Abstract - Come network with organizations hiring in 2016 and learn about some of the career best practices.  This is a great opportunity to learn and grow your career, whether you are currently in the job market or not.  Learn about the latest trends in the market, gain valuable advice on how to advance your career and get your questions answered to make sure you are on the right career path.

Speakers and Sponsors:
 
Apex Systems - http://www.apexsystemsinc.com/
 
Experis - http://www.experis.com/


RDA - http://www.rdacorp.com/
February 16, 2016 Meeting cancelled due to inclement weather and school closures.
March 15, 2016 Title - Enhancing Data and Predictive Analytics with Azure HDInsight

Abstract - The pervasiveness of Big Data has created significant challenges for companies that have historically utilized relational database management systems to perform data analysis and predictive analytics. This presentation outlines the challenges that stem from Big Data as it relates to deriving value from data and how Azure HDInsight can serve as a data platform that significantly enhances the data analysis and predictive analytics capabilities of companies.

Speaker - Based in Atlanta, GA, Cornell A. Emile is a Senior Software Engineer with RDA Corporation. Since 2001, he has designed, developed, and maintained data-centric solutions within multiple industries such as Finance, Digital Marketing, State and Federal Government using Microsoft's BI stack. His main interests include architecting data solutions, optimizing large relational databases, ETLs, Business Intelligence and NoSQL databases.

Download Cornell's slide deck.

Sponsor - Panorama Software is a leader of the Business Intelligence market with more 25 years of industry experience and in-depth knowledge of the BI Software Industry. The company’s OLAP software technology was acquired by Microsoft Corporation and formed the basis for Microsoft’s database technology known as OLAP Services and renamed Analysis Services 2000. Today with Panorama Necto a worldwide leader in next generation self-service smart data discovery with more than 2,500 customers. It leverages a suggestive discovery engine that simplifies the business users’ data preparation while automating pattern exploration and analysis. Panorama Necto is powered by a unified and governed visualization and unique collaboration platform.

April 19, 2016 Title - Power BI Desktop Fundamentals

Abstract - As businesses move from the reporting to analytical era, I want you to come join me in to learn about the next generational or analytical tools from Microsoft - Power BI Desktop.  Power BI overcomes many of the shortcomings of SQL Server Reporting Services and significantly reduces the time needed for ETL processes commonly addressed with SQL Server Integration Services. I will walk you through Power BI’s top features, internal components, how to create dashboards and finally how to analyze your data.

Download Junaith's slide deck.

Speaker - Junaith Haja is a Senior Business Intelligence Consultant with Browse Info Solutions, Inc and leads a Microsoft SQL Server and BI team.

Sponsors - Redgate Software, Nevron and MSSQLTips.com

                   
May 17, 2016
Title - Analyze your query plan like a Microsoft Engineer! (SQL Server 2016 Edition)

Abstract - This session is a deep dive into query plans and is presented by a former Microsoft PFE (Field Engineer). Learn how a Microsoft Engineer looks at plans and go beyond the typical! There will be plenty of demos and a lot to learn. Join me as I cover the "noteworthy" query plan patterns that go beyond the normal areas that customer tend to investigate. This session covers SQL Server 2005 forward and includes the new SQL Server 2016 Query Store and Live Query Statistics.

Speaker - Daniel Janik - Principal Consultant, Fortified Data

Daniel Janik has been supporting SQL Server for 18 years. Six of those years were at Microsoft Corporation supporting SQL Server as a Senior Premier Field Engineer (PFE) where he supported over 287 different clients with both reactive and proactive database needs. Daniel has presented at many community events and SQL Saturdays.



Title - BSSUG Resume Review and Revamp

Abstract - Bring a physical copy of your resume to this meeting and get feedback from recruiters that can help you land your next opportunity.  Learn about how to customize your resume to stand out from the field and get your questions answered.   



Sponsor - Apex Systems - http://www.apexsystemsinc.com/
Apex Systems is the 6th largest technical staffing firm in the US. Apex was founded in 1995, is headquartered in Richmond, and has a presence in about 50 markets across the US. We specialize in placing technologists on a contract, contract-to-hire, and direct hire basis. Apex has specific technology practices, such as Database/BI, with skill set aligned Recruiters. The Senior Database Recruiter for our Baltimore and DC offices works with 20-25 clients who have SQL environments and typically sees about 10 openings a month for SQL Developers and/or DBA’s.
For more information on Apex, visit www.apexsystemsinc.com, or contact Jared Sanson (email | LinkedIn) our SQL Recruiter for Baltimore and DC.

June 21, 2016 Title - Getting Started with BI

Abstract - Business Intelligence (BI) is a hot topic, and getting hotter. Today's businesses want to use their data for analysis and to make better decisions. The challenge is retrieving and compiling data from various sources, and to present the data for all users. There are a variety of self-service and enterprise tools and solutions, available today. Microsoft has invested heavily in offering a strong toolset.

In this talk, we will look at the process of creating a business intelligence solution. We will look at the tools in the ever-growing Microsoft BI stack. We will look at considerations when retrieving and processing data from source systems (i.e. Custom web applications, CRM, third-party services, raw log files, etc.). And, we will also look at self-service and enterprise solution designs.


Speaker - Stan Bice is a Senior Data Warehouse Developer for PANDORA Jewelry, based in Baltimore. He has over 20 years of overall software development experience, creating solutions for a variety of well-known brands and industries. He has designed and developed client-server and web-based solutions, along with database and reporting solutions. He has focused on database development, data warehouses and business intelligence over the past 8 years.


Sponsor - Experis - http://www.experis.com/

Experis accelerates business growth and careers by intensely attracting, assessing and placing specialized expertise in IT, Finance & Accounting, Engineering and other industries. We precisely deliver in-demand talent for mission-critical positions, enhancing the competitiveness of the organizations and people we serve. We also apply our expertise to provide a suite of proven workforce solutions that improve our clients' productivity, efficiency and cost containment.
July 19, 2016 Title - Introduction to SQL Server 2016 Reporting Services

Abstract - Reports, dashboards, and indicators are an essential part of your job as a report analyst.  SQL Server Reporting Services (SSRS) 2016 gives you the ability to create these items to share with coworkers and management.  This session will walk you through how to design, develop, deploy, and maintain reports within your environment.  As a bonus, we will cover mobile reports, introduced in SSRS 2016!

Speaker - Jessica M. Moss is an architect, speaker, author, and Microsoft Data Platform MVP of SQL Server business intelligence.  Jessica's expertise includes data warehouse modeling, extracting/transforming/loading data, creating business and semantic models, designing reports and dashboards, and helping people 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 numerous technical books.  You can read more on her website, http://www.jessicammoss.com.

Sponsor - Panorama Software is a leader of the Business Intelligence market with more 25 years of industry experience and in-depth knowledge of the BI Software Industry. The company’s OLAP software technology was acquired by Microsoft Corporation and formed the basis for Microsoft’s database technology known as OLAP Services and renamed Analysis Services 2000. Today with Panorama Necto a worldwide leader in next generation self-service smart data discovery with more than 2,500 customers. It leverages a suggestive discovery engine that simplifies the business users’ data preparation while automating pattern exploration and analysis. Panorama Necto is powered by a unified and governed visualization and unique collaboration platform.

August 16, 2016 Title - Extracting Value from Structured and Unstructured Data with SQL Server’s PolyBase

Abstract - As the volume and velocity of data continues to grow exponentially, companies are faced with the challenge of deriving valuable insights from data sets that are stored within SQL Server and various Big Data platforms (e.g. Hadoop).

During this introductory session to the PolyBase feature of SQL Server 2016, we will explore how companies can leverage PolyBase to connect structured data that exists within SQL Server to unstructured data that is stored in Azure HDInsight.

Download Cornell's slide deck.

Speaker - Based in Atlanta, GA, Cornell A. Emile is a Senior Software Engineer with RDA Corporation. Since 2001, he has designed, developed, and maintained data-centric solutions within multiple industries such as Finance, Digital Marketing, State and Federal Government using Microsoft's BI stack. His main interests include architecting data solutions, optimizing large relational databases, ETLs, Business Intelligence and NoSQL databases.

Sponsor - Business Problems – Solved with Business Thinking and Technology Expertise

We help our clients leverage technology to get their businesses moving.  But with us, it’s not just about the technology.  Our team has the experience to understand that successful engagements first require the time and thinking to understand clients’ business needs, and only then do you map appropriate technology solutions. It’s this approach that helps us to solve our clients’ complex business challenges that can often cost companies precious time, resources, and money.
 
RDA – Technology Expertise. Business Thinking. Let’s Go!


RDA
September 20, 2016

Title - Monitoring BI Performance Using IDERA SQL BI Manager

Abstract - How do you know how efficient or how long your MDX and DAX queries are taking? How do you tune your query performance in SSAS? What is causing my SSIS packages to fail? What are the bottlenecks in my SSRS environment? Who is running what reports and how long are they taking? These are just some of the key questions that you should be asking about your Microsoft BI environment. Even if I ask these questions, how do I get the answers. We will take a look at IDERA's BI Manager product to get the answers to these questions and more.

Speaker - Stan Geiger

 


 

Title - Administring SSIS 2012 and 2014 for DBAs

Abstract -
Make your SSIS Life easy by learning SSIS administration. There is lots of new stuff to learn in SSIS 2012 and 2014, to name a few: SSIS Catalog, Environmental Variables, Encrypting passwords. We will cover new upcoming features in 2016. Topics covered are:
 - Connection Manager Basics
 - Parameters and variables basics
 - Package workflow - Similar to Maintenance plans
 - Package Security
 - Deploying Packages
 - Different methods of Project Deployment
 - How to build a SSDT project back from Integration Catalog
 - Logging options for SSDT
 - Executing Packages through SQL Agent Jobs
 - Scheduing SQL Server Agent Jobs to execute packages
 - SSIS performance tuning
 - Tips, Tricks and Best Practices

Speaker -
Ravi Kumar

 

Download Ravi's slide deck.

 



Sponsor - idera

Idera provides powerful and easy-to-use tools to help you manage your Windows world, including Microsoft SQL Server, SharePoint and PowerShell. Our award-winning solutions address real-world challenges including performance monitoring, backup and recovery, auditing and compliance and change and configuration management. Headquartered in Houston, TX, Idera was founded by veterans in the systems and database management industry to bring to market battle-proven technologies developed by practicing database professionals.

October 18, 2016 Title - Apex Systems Job Fair

Abstract - Come network with Apex Systems to learn about opportunities in the area.  This is a great opportunity to learn and grow your career, whether you are currently in the job market or not.  Learn about the latest trends in the market, gain valuable advice on how to advance your career and get your questions answered to make sure you are on the right career path.



Title
- Implementing Full Text Search of PDF documents with PostgreSQL

Abstract - This presentation will provide an overview of implementing full text search of PDF documents with the PostgreSQl open source database. I will use a Ruby on Rails application running on Ubuntu Linux using VMWare's VMPlayer running on Windows.

Speaker - Ron Jewell



Title - Advanced Power BI with the Power Query Formula Language

Abstract - When using Power Query to retrieve and transform data, there is code that is generated and executed within Power BI. This code is the Power Query Formula Language (informally known as “M”). This language is very powerful and can perform a variety of simple to advanced tasks. Using this language, beyond the Power BI dialogs, menus and toolbars, you can develop a wide range of data loading and transformation scenarios. This demo-heavy session will introduce the Power Query Formula Language. We will examine how the to use the language to create simple and advanced data loading and transformation solutions. There will be several real-world scenarios that show the power of this language and application within Power BI.

Speaker - Stan Bice is a Senior Data Warehouse Developer for PANDORA Jewelry, based in Baltimore. He has over 20 years of overall software development experience, creating solutions for a variety of well-known brands and industries. He has designed and developed client-server and web-based solutions, along with database and reporting solutions. He has focused on database development, data warehouses and business intelligence over the past 8 years.

Stan has spoken at user groups and code camps, and has participated at give camps. In his spare time, he is active in his church, works with a volunteer fire department, and is a technical reviewer for Manning Press. Stan also enjoys learning other software development tools and skills.



Sponsors - Apex Systems (http://www.apexsystemsinc.com/) and MSSQLTips.com

Apex Systems is the 6th largest technical staffing firm in the US. Apex was founded in 1995, is headquartered in Richmond, and has a presence in about 50 markets across the US. We specialize in placing technologists on a contract, contract-to-hire, and direct hire basis. Apex has specific technology practices, such as Database/BI, with skill set aligned Recruiters. The Senior Database Recruiter for our Baltimore and DC offices works with 20-25 clients who have SQL environments and typically sees about 10 openings a month for SQL Developers and/or DBA’s.
For more information on Apex, visit www.apexsystemsinc.com, or contact Jared Sanson (email | LinkedIn) our SQL Recruiter for Baltimore and DC.

                     
November 15, 2016 Title - Analyzing I/O Subsystem Performance

Abstract - SQL Server is often I/O bound - but why? Do you feel lost when talking to your storage administrator? Are your storage subsystems like a mysterious black box where your databases live but you can’t go visit? This session will get you up to speed with the fundamentals of storage subsystems for SQL Server. You will learn about the different types of storage that are available, and how to decide what type of storage to use for different workload types. You will also learn useful tips and techniques for configuring your storage for the best performance and reliability. We’ll cover methods to effectively measure and monitor your storage performance so that you will have valuable information and evidence available the next time you have to discuss IO performance with your storage administrator. Come to this session to learn how to analyze I/Os as well as options to reduce the bottlenecks.

Speaker - Glenn Berry of SQL Skills

Download Glenn's slide deck.

Sponsor - Experis - http://www.experis.com/

Experis accelerates business growth and careers by intensely attracting, assessing and placing specialized expertise in IT, Finance & Accounting, Engineering and other industries. We precisely deliver in-demand talent for mission-critical positions, enhancing the competitiveness of the organizations and people we serve. We also apply our expertise to provide a suite of proven workforce solutions that improve our clients' productivity, efficiency and cost containment.
December 13, 2016 Title - Building Disaster Recovery with AlwaysOn

Abstract - This presentation will cover generic issues and challenges involved in building a Disaster Recovery site, and then you how you can build a hot DR site using the AlwaysOn Availability Groups technology in SQL Server 2016. It will provide tips and recommendations based on real life implementation. While the focus of the session will be on building a remote DR solution, much of the content will also be applicable to maintaining a local standby server using AlwaysOn.

Speaker - Roman Rehak

Download Roman's slide deck.

Sponsor - Apex Systems - http://www.apexsystemsinc.com/
Apex Systems is the 6th largest technical staffing firm in the US. Apex was founded in 1995, is headquartered in Richmond, and has a presence in about 50 markets across the US. We specialize in placing technologists on a contract, contract-to-hire, and direct hire basis. Apex has specific technology practices, such as Database/BI, with skill set aligned Recruiters. The Senior Database Recruiter for our Baltimore and DC offices works with 20-25 clients who have SQL environments and typically sees about 10 openings a month for SQL Developers and/or DBA’s.
For more information on Apex, visit www.apexsystemsinc.com, or contact Jared Sanson (email | LinkedIn) our SQL Recruiter for Baltimore and DC.

 

 


 

2015 Meeting Schedule

 

Date

Speaker

Title and Abstract

Sponsor

January 20, 2015

Kevin Goff,
SQL Server MVP

 

Title - Introduction to SQL Server 2014 In-Memory Optimized Tables (formerly “Hekaton”)
 
Abstract - This session will cover the benefits of Hekaton, why developers and DBAs would want to use Hekaton, and the different options for creating Hekaton tables.

Hekaton is Microsoft's code word for their new OLTP in-memory, optimized data processing option for frequently-used tables in SQL Server 2014. In certain instances, Hekaton can yield performance gains of over 10x. This session will cover the benefits of Hekaton, why developers and DBAs would want to use Hekaton, and the different options for creating Hekaton tables. We'll also look at the native-code stored procedure optimizations when using Hekaton. Additionally, this session will show the range and limitations of Hekaton and how it differs from traditional SQL Server tables (such as transaction handling). Along the way, the session will have several code demonstrations where we'll look at performance benchmarks. If you've heard about Hekaton and in-memory optimizations and terms such as 'latch and lock free structures' and wondered what it all means, this session is for you!
Sudina Search
  Steve Schneiders Title - Sudina Search Q&A on the 2015 Job Market
 
Abstract - Learn about the state of the current job market, recommendations to find your next opportunity, how to avoid some of the pitfalls of job searching and more...
 
February 17, 2015   Meeting cancelled due to
HCC closure.

 
March 17, 2015 Scott Stone, Product Manager

Title - Performance Monitoring with SQL Diagnostic Manager

Abstract - Learn all that SQL Diagnostic Manager can do to help you be a better SQL Server Professional.
idera
  Danette Riviello
Manager, Database Operations
 
Magellan Health


Title - Become a SQL Server Performance Detective
 
Abstract - When your SQL Server database is having performance issues, you need to quickly and accurately diagnose and resolve performance issues.  Like any good detective, you need to look for clues to find “The Smoking Gun.”  We will cover various tools at our disposal which can help us pinpoint and resolve issues quickly, using Dynamic Management Views (DMVs), SQL Profiler and other queries.  

Download Session Materials
 
 

Jeremy Kadlec of Edgewood Solutions and MSSQLTips.com

 

Title - SQL Server Agent Tips and Tricks

Abstract
- Let's dig into tips and tricks with SQL Server Agent to improve your value as a SQL Server Professional.  Attend this session to learn how SQL Server Agent can help you be more productive, save significant amounts of time and demonstrate your value to the organization.   

Download Session Materials
 
April 21, 2015 Paul Randal of SQL Skills

 
Title - Performance Troubleshooting Using Wait Statistics
 
Abstract - One of the first things you should check when investigating performance issues are wait statistics - as these can often point you in the direction for further analysis. Unfortunately many people misinterpret what SQL Server is telling them and jump to conclusions about how to solve the problem - what is often called 'knee-jerk performance tuning'. In this session, you will learn what waits are, how to analyze them, and potential solutions to common problem patterns.

Download Session Materials
SIOS
and 
SanDisk
May 19, 2015 Erica Woods and Vivek Mehta of Apex Systems Title - Be Heard!  Effective Communication Strategies!

Abstract - Strong communication is a key skill that’s beneficial no matter what industry you’re in, and what job you do.  Companies and hiring Managers are always seeking individuals who are clear and concise, and are able to put together an effective “message.”  Yet, despite the importance of quality communication, it’s a skill that many people lack and don’t put enough of a focus on improving.  Candidates often miss out on getting a job or an internal promotion due to insufficient communication skills. Strong communication skills, both verbal and written, can be a huge differentiator for you!  During this session, we’ll focus on the main types of communication, qualities of “effective communicators,” the impact of body language, hurdles to effective communication and strategies you can utilize to enhance your overall communication skills. 

Download Session Materials
Apex Systems
 

Kun Lee

Title - Real World Enterprise SQL Server Replication Implementations
 
Abstract - Come learn how to design, setup and manage SQL Server Replication for a large distributed enterprise with multiple data centers.  Learn about some of the technical options such as Re-publishers, Hub and Spoke architecture, Peer-to-Peer replication, pre and post snapshots, automating deployments, monitoring, optimizations and more.  With each of these options I will outline many of the configuration options, benefits and issues for each of the technologies based on my experience from the field.  My goal is to share my findings to help you make better decisions when using SQL Server Replication so you don’t have to go through the same issues that I have experienced.

Download Session Materials
 
June 16, 2015 Greg Robidoux of Edgewood Solutions and MSSQLTips.com

Title - SQL Server Indexing
 
Abstract - There are several areas of SQL Server that need to be configured and tuned to optimize database performance, one of these areas is SQL Server indexing.   In this session, we will discuss what you need to know about indexing to help  improve database performance.   In this session we will cover these items:

  • Clustered and Non-clustered Indexes
  • Covering Indexes
  • Indexes with Included Columns
  • Columnstore Indexes
  • Index Statistics
  • How Indexes are used for Table Joins
  • Indexing for WHERE, GROUP BY, ORDER BY
  • Filtered Indexes
  • Using DMVs to get insight into Index Usage
  • Query Plans and more  

 

Join us for this session to learn about SQL Server indexing to improve your database performance.

 

Download Session Materials

Experis
July 18, 2015 BSSUG Summer Social Event Come enjoy a baseball game with your family and the BSSUG community.    

WHEN: July 18, 2015 @ 6:30 PM    

WHERE: Prince George's Stadium located at 4101 Crain Hwy, Bowie, MD 20716    

Join us at the Picnic Pavilion for the following:  
- Grilled All Beef Hot Dogs
- Quarter Pound Hamburgers
- Pulled Barbeque Chicken Sandwiches
- Sides
- Desserts    

Pricing for the event includes admission to the game and food in the Picnic Pavilion:  
- Adult = $30.00 each
- Children age 3 to 5 = $10 each
- Children age 2 & under = FREE    

Registration deadline: Tuesday, June 16, 2015.    

Please remit payment via:  
- PayPal - bssuginc@yahoo.com
- Our next meeting via check made payable to BSSUG, Inc.
- Cash at our next meeting
- Can't make the June meeting, but will be at the game?  Let Ray know.    

Any questions?  Contact Ray Barley @ 410.804.4658 or raymondbarley@gmail.com.

See you at the game!
 
July 21, 2015 Samuel Vanga Title - From Zero to Loading a Data Warehouse
 
Abstract - You're tasked to create the ETL process for a brand-new data warehouse. Where do you start? Data warehouse ETL boils down to three specific problems: Staging, Dimensions, and Facts. This session will show you solutions to these three problems. You'll first learn the fundamentals of a data warehouse before diving into creating packages and leveraging common patterns. You'll see both simple and advanced scenarios such as incrementally loading staging tables, processing type1 and type2 slowly changing dimensions, early arriving facts, snapshot fact tables, and bridge tables. If you want to create scalable and efficient SSIS packages to load a data warehouse, this session is for you.

Download Session Materials
Red-Gate
August 18, 2015 Wayne Sheffield, a Microsoft Certified Master in SQL Server, started working with xBase databases in the late 80′s. With over 20 years in IT, he has worked with SQL Server (since 6.5 in the late 90′s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles at www.sqlserver central.com, a co-author of SQL Server 2012 T-SQL Recipes, and enjoys sharing his knowledge by presenting at SQL PASS events and blogging at http://blog.wayne sheffield.com/wayne.

Wayne Sheffield
Title - Crazy Things Developers Do!
 
Abstract - Throughout my career, I’ve seen developers do some pretty crazy things to databases (and truth be told, I’ve done some of these myself!). Come to this session to learn what we do and why it’s bad to the database server (or your career)… and alternatives that can be used instead. Some of the topics that we’ll discuss are the pitfalls of using NOLOCK, how coding mistakes open up the database for SQL Injection attacks, and how design choices keep SQL Server dumb – and if it was allowed to be smart, it would be faster! Trust me… your DBA will love you for making these changes.
Syncfusion
September 15, 2015 Ray Barley of RDA Title - Introduction to Running SQL Server in an Azure VM

Abstract - Learn about how to setup and run a SQL Server instance in an Azure virtual machine.
RDA
  Rich Cargile of RDA Title - SQL Server and Azure

Abstract - SQL Server 2014\2016 is, in my opinion is a little undersold by Microsoft. I think it is on the edge of one of the larger revolutions in Database technologies in the recent past. The reason is that we have a new technology out there, and your may have heard of it, it’s called the cloud. Microsoft's version of cloud technologies is called Azure.  

In this session, we will learn some details of using SQL Server 2014 with Azure, as well as Azure Database as a Service. We’ll explore how SQL Server integrates with Azure, and how you can put one toe in the water and get started integrating the cloud into your organization.
 
October 20, 2015

Roman Rehak of mywebgrocer

 

Title - Database Maintenance Options and Guidelines
 
Abstract - This session will discuss two options for setting up database maintenance operations such as backups, integrity check and index/statistics updates. First we will look at the advantages and disadvantages of the built-in Database Maintenance Plans, and discuss some tips around using them effectively. In the second part we will look at an alternative solution developed by Ola Hallengren that’s becoming more and more popular among DBAs since it offers a lot of flexibility and features not available in the native maintenance plans. I will also offer some guidelines about setting up maintenance plance so they do not interfere with your production environment.

Download Session Materials
idera
 

Jeremy Kadlec of Edgewood Solutions and MSSQLTips.com

 

Title -  SQL Server Job Management Tips and Tricks

Abstract
- Come learn about valuable SQL Server Job Management Tips and Tricks to solve some of the toughest situations.

Download Session Materials
 
November 17, 2015 Ravi Kumar,
Senior Business Intelligence Developer LMO Advertising
Title - What Makes SSIS Tick? A Look at Internals for Performance

Abstract - You can build basic SSIS packages, or you can build packages that perform. In this session, you'll learn about the internals of Integration Services. Using this knowledge, we'll review the DOs and DON'Ts that lead to improved ETL performance. (This session applies to SSIS versions from 2008, 2012, and 2014.)

About Ravi:
I have over 10 years of experience working with SQL Server, over 8 years experience with SQL BI and over 3 years of DBA Exprience.

Download Session Materials
Experis
December 15, 2015 J. Michael Shields of McCormick IT Title - Recovery Scenarios: Are you prepared to handle the different recovery situations that may pop up at any moment?

Abstract - Imagine being called on your way to work one morning and being directed to go to a meeting as soon as possible. Upon arriving, a Vice President describes a disaster which just happened to a newly acquired company and that the success of keeping this company's sales alive all depends on you recovering a SQL Server instance that you know nothing about which uses an unfamiliar third party backup vendor. How about being called by a frantic person in accounting on Christmas Eve stating that all the US sales for the year are missing and month/year end jobs start early next week? Are you prepared to handle these types of recoveries as well as other scenarios? Come to this session to learn about the different levels of SQL Server restores as well as alternative recovery methods that may be available.
Apex Systems
  Pending Pending  

 


 

2014 Meeting Schedule

Date

Speaker

Title and Abstract

Sponsor

January 21, 2014

  Meeting cancelled due to HCC closure.  
February 18, 2014 Slava Murygin
Title - Inside of SQL Server Indexes
 
Abstract - Index Internals. Simple indexing from within. Covers Heaps, Clustered and Non-Clustered Indexes. Included columns and filtering. Materialized views. Also can show how Updatable Columnstore Indexes work in SQL Server 2014 (if time allows).
Logi Analytics
  Derek Strasbaugh of Microsoft Title - SQL Server Workloads on Windows Azure
 
Abstract - In this session we will discuss and demonstrate the cloud integration capabilities of SQL Server with the Windows Azure Platform.  The demonstrations will include common scenarios for leveraging hybrid cloud infrastructure - deploying SQL Server 2014 running on a Windows Azure Virtual Machine, Windows Azure SQL Database and Windows Azure SQL Backups We will also discuss best practices and demonstrate techniques for managing both on-premises and cloud-based resources.

Download Session Materials
 
March 18, 2014 Bill Anton of Prime Data Intelligence, LLC Title - Bus Matrix...the foundation of your Dimensional Data Model 
 
Abstract - The Bus Matrix is the cornerstone of a successful Dimensional Data Warehouse strategy. It serves many purposes: from communicating requirements, capabilities, and expectations with the business users down to the prioritization and delegation of tasks across the development team. Join me in this session and learn what a Bus Matrix is, why it is the single most important document in your Data Warehouse project, and what can go wrong without it. We'll also cover several approaches for creating and maintaining the Bus Matrix document.
Download Session Materials
Robert Half Technology
April 22, 2014 Erica Woods and Vivek Mehta of Apex Systems Title - IT and SQL Server Tech Trends
 
Abstract - Interested in getting a gauge of what’s trending in the Information Technology and SQL Server world?  In this session, we’ll provide some insight on the following: top tech markets, overall salary and compensation trends, top titles in Information Technology by salary, the top technologies in demand, SQL Server trends, and trends in how employers are addressing employee motivators.  This information will be based on findings from our 1,000+ clients across the country, Wanted Analytics insights, the annual Dice report, and CareerBuilder findings. 
Download Session Materials
Apex Systems
  Samuel Vanga Title - Team-based Database Development - Playing Nice With Others
 
Abstract - As soon as you've more than one person working on a development effort, you're going to see issues with collaborating and integrating your work - you may not know what the other person is doing, or your changes may break others code. In this session, you'll learn how development practices such as version control, unit testing, continuous integration, etc., can help ease some of your team-development headaches. You'll see demonstrations (using Red Gate tools) of how to implement these practices in your environment and improve the productivity, efficiency, and quality of your development process.

Download Session Materials
 
May 20, 2014 Bryan Murray of EPSGlobal Learn about Virident... EPSGlobal
  Derek Strasbaugh of Microsoft Title - SQL Server 2014: In-Memory Enhancements
 
Abstract - One of the key goals organizations are trying to achieve today is getting to a state where the business can be driven as close as possible to real-time, powered by real-time insights.  The barriers to this operational tempo have traditionally been speed and throughput. With data volumes getting larger and larger, how do you gain insights quickly across your transactional, historical, and third party data – using both relational and non-relational data to make better and faster business decisions?  This is the heart of the problem that in-memory database technology helps to solve. 

With Microsoft SQL Server 2014 in-memory technologies built-in across OLTP and data warehouse workloads, we’ll show how we can drive significantly faster transactions, faster queries and faster insights using familiar technologies, syntax and tools. These developments help businesses not only deliver bigger, faster applications but also do more with less hardware. 
 
June 17, 2014

Kun Lee

Title - How to Collect and Translate Performance Data into Real World SQL Server Performance Tuning
 
Abstract - “The CPUs on my SQL Server is run on average at 80% . Is that bad?”

Well, the answer would be one of the famous Microsoft answers “ It All Depends.”  In this session, I will talk more about this scenario by using Performance Monitor (A.K.A PerfMon).  PerfMon is one of the well-known native tools for troubleshooting performance issues.  Unfortunately, the data this tool collects can be overwhelming if you are new to the tool.  Even with some experience with the tool, it takes time to process the data and see the big picture.  

During this demo centric session, I will dig into using PerfMon and how to use the data to answer some common questions.  For example, “I want to upgrade my server. Could you tell me where the bottlenecks are so we can spend our resources correctly?”

Download Session Materials
idera
July 15, 2014 Andy Warren

Andy Warren is a SQL Server consultant and trainer based in Orlando, FL, with over 14 years of experience. Focusing on administration, performance tuning, and SQL Server patterns and practices, he's been a SQL Server MVP since 1998. Andy served two terms on the PASS Board of Directors, was a founding principal in SQLServerCentral, and created both the SQLSaturday and SQLRally event models.
Title - Credit Card Security For the SQL DBA
 
Abstract - Are you storing or planning to store credit card numbers? If so, you need to learn all you can about the requirements for PCI compliance. We'll cover how PCI works from the requirements to the final audit, and everything in between that you'll need to know something about. We'll talk about encryption, key management, logging, alerting, administration access, granular permissions, tokenization, and as much more as we can fit into an hour. It's a complex topic, but that just makes it more interesting!

Download Session Materials
Logi Analytics
August 19, 2014

Roman Rehak of mywebgrocer

 

Title - Two for Tuesday: 1) Using Policy Management for Database Administration. 2) Effective use of Database Mail
 
Abstract - Policy management is a useful database administration feature that allows to implement policies and enforce them across multiple SQL Servers. Using this feature you can easily implement notifications, enforce naming conventions, etc. This presentation will give an overview of this feature and provide several useful examples you will be able to implement on your servers.

SQL Server provides a mailing framework called Database Mail. You will learn how Database Mail works, how to set it up, how to use it effectively for notifications, and other every daily database administration tasks.
Download Session Materials
Microsoft
    BSSUG HAPPY HOUR!!!  Join us!  
September 16, 2014 Bill Anton of Prime Data Intelligence, LLC

Bill Anton is an independent consultant whose primary focus is designing and developing Data Warehouses and Business Intelligence solutions using the Microsoft BI stack. When he's not working with clients to solve their data-related challenges, he can usually be found answering questions on the MSDN forums, attending PASS meetings, or writing blog entries over at http://byobi.com.
Title - SSAS 2012: 20 Minute Tabular Model
 
Abstract - The Tabular model in Analysis Services 2012 is still the new kid on the block. Based on xVelocity, a new highly compressed in-memory technology, Tabular models promise considerable performance improvements over Multidimensional models in many scenarios. But, as is the case with any new technology, there are certain limitations of which to be aware. Join me in this introductory-level session focusing on how Tabular fits into the Microsoft BI stack, the major factors to consider when choosing between Tabular and Multidimensional technologies, and finally a live demo where we'll build a basic Tabular model in visual studio.
idera
October 21, 2014

Karriem O. Lateef

Technology Solutions Specialist for Microsoft Corporation




Karriem has been a technology professional for over 17 years, with extensive experience in Oracle and PL/SQL before making the transition to the Microsoft RDBMS platform, with a focus on SQL server and Azure.

Title - SQL Server 2014 In-Memory OLTP
 
Abstract - New in SQL Server 2014, In-Memory OLTP can significantly improve OLTP database application performance by allowing certain workloads to run in-memory, freeing them from the latching contention of disk based tables and procedures.  In-Memory OLTP is a memory-optimized database engine integrated into the SQL Server engine, optimized for OLTP. 
Microsoft
 

Jeremy Kadlec of Edgewood Solutions and MSSQLTips.com

 

Title - SQL Server Database Security Best Practices
 
Abstract - With the numerous data breaches that are popping up in the news all the time, we as SQL Server Professionals need to take a hard look at our environment and make the most out of the native SQL Server features available to us.  Nobody wants to see your company in the news for the wrong reasons.  But should you only be concerned about external threats?

In this demo centric session, we will focus on the following topics:
- Security Assessment and Realistic Implementations
- SA Login and Administrative Rights to SQL Server
- Practical approaches to secure SQL Server data
- Identifying and analyzing SQL Server permissions
- Auditing Options
 
November 18, 2014 Ravi Kumar

Ravi Kumar

Ravi has over 10 years of experience working with SQL Server, over 7 years experience with SQL BI and 3 years of DBA Exprience. Ravi recently became part of SQL community and he is loving it!!
Title - Learn how to Think like SSIS
 
Abstract - You wouldn't drive to a new place without directions? Then why build a SSIS package without having a road map on how to build it. Learn how to think like SSIS, make your ETL life easy, and convert a Process into an SSIS Package.  If time allows, we will also cover SSIS Package Configurations, security and deployment. Expect to participate actively in the class. 
Robert Half Technology
December 16, 2014 Erica Woods and Vivek Mehta of Apex Systems Title - Starting a new job on the right foot
 
Abstract - Your first couple months at a new job can really set the tone for your career path at the company. If you want to set yourself apart and grow, you’ll want to make every effort to establish yourself as a reliable, eager and competent professional right from the gates! In this session, we’ll highlight our top recommendations to get started on a high note, and demonstrate both your capabilities, initiative, and desire to grow within the organization!

Download Session Materials
Apex Systems
 

Ray Barley of RDA Corp

 

Title - Implementing a Team Foundation Server (TFS) Automated Build for a Business Intelligence (BI) Project
 
Abstract - TFS automated build allows you to implement continuous building and testing of Visual Studio / SQL Server Data Tools (SSDT) solutions.  

A typical BI solution has the following project types:
- SQL Server Database; i.e. Data warehouse based on dimensional model; e.g. Kimball
- SSIS packages to perform ETL
- SSAS cube for ad-hoc querying and analysis
- SSRS for reporting  

The TFS automated build only handles the SQL Server database project.  For the other project types (SSIS, SSAS and SSRS) you have to roll your own MSBuild project files and possibly create your own  MSBuild custom tasks.   

This session will walk through setting up a TFS automated build for a typical BI project.  I will cover:  

- A quick introduction to MSBuild
- Creating MSBuild project files for SSIS, SSAS and SSRS projects
- Creating MSBuild custom tasks
- Creating the build definition
- Running the TFS automated build

Download Session Materials
 
    BSSUG HAPPY HOUR!!!  Join us!  


 

2013 Meeting Schedule

Date

Speaker

Title and Abstract

Sponsor

January 28, 2013

Derek Strasbaugh of Microsoft Title - The Microsoft Big Data Story
 
Abstract - The session will cover Big Data as an emerging technology that every database professional should care about with a focus on Microsoft’s Big Data platform offering. Demos will include Hadoop on Azure, on-premise Hadoop as well as Big Data integration with Microsoft’s BI stack.
LogiXML
February 19, 2013

Jeremy Kadlec of Edgewood Solutions and MSSQLTips.com

 

Title - Source Control Your SQL Server Environment

 

Abstract - Coding and managing SQL Server code between numerous environments can be cumbersome. Everyone recognizes the need for establishing SQL Server coding best practices, but it is easier said than done. In this session we are going to review some of the source control systems on the market and provide recommendations for integrating a solution into your development processes to make your life easier.

Download Session Materials

SQL Power Tools

March 19, 2013

Erica Woods of Apex Systems Inc. and Brandon Berlett of Experis

Title - Developing your Professional Brand


Abstract - Have you ever thought about how you brand and market yourself?  What is the brand people assign to you based on their interactions with you, feedback from others, and what’s available online?  What is the perception of your brand that potential employers will have from doing simple Google searches to learn more about you?   Now, more than ever, it’s important to evaluate what your perceived brand might be, and spending time thinking about what you want your brand to be.  You need to determine how you’ll achieve that brand, how you can effectively communicate your brand, and what other actions you can take to influence your brand.  We’ll hit on all these points, along with qualities that may be desirable to have as part of your ‘Professional Brand,’ during this session.

 

Download Session Materials

Apex Systems
  Slava Murygin
Title - Where I am? What is you SQL Server skill level?

Abstract -  When you go to an interview it is very hard to determine your exact skill level and what you can do. You shouldn't underestimate or overestimate yourself.  In this presentation, I will help you find your answer.

Download Session Materials
 
  Slava Murygin
Title - SSMS Hot-Keys

Abstract - Life is short, do not waste it memorizing complicated queries and typing them repeatedly. Create useful queries once and use them forever.

Download Session Materials
 
April 16, 2013 Trayce Jordan of Microsoft Title - Roll your own "Availability Groups" in SQL 2008/8R2

Abstract - You are using SQL 2005, 2008 or 2008R2.   You’d like to move to SQL but for any number of reasons, you can’t upgrade yet.  You liked database mirroring But you find dealing with server name changes, DNS changes and/or SQL aliases is too cumbersome for disaster recovery failovers.  What you’d like Is to combine database mirroring with SQL Server Failover Clustering.   This presentation will show you some techniques in dealing with SQL Clusters and how you can combine them with database mirroring to implement an “Availability Group”-like solution – where you can “failover” groups of mirrored databases from their primary server to their secondary and back – without having to make DNS updates, change SQL aliases, or change connection strings. While these solutions provide added capabilities that are not present “out of the box”, they will not do everything that SQL 2012 Availability Groups provide. We’ll end the presentation with a comparison / contrast of this solution with the “real” SQL 2012 Availability groups.

Bio - As a Microsoft SQL Server Premier Field Engineer, Trayce conducts training, teaches workshops, provides technical support, performance troubleshooting, upgrade advice, and disaster recovery recommendations.
TrainUp

May 21, 2013

Jessica M. Moss
and Phil Noakes
Title - Realizing the Power of Microsoft Reporting

Abstract - Once you’ve loaded your data into a star schema and built an Analysis Services 2012 cube around it, you are ready to harness the power of multi-dimensional analysis. Then, what are your next steps? You need to decide how to create and display reports. Should you go with Reporting Services, Power View or another reporting tool? This session will explore and demonstrate the different reporting options for deriving business intelligence.

Phil Noakes
Mr. Noakes is a certified IT Professional in SQL Server Business Intelligence and SQL Server Development. He has over six years of experience in consulting on all facets of SQL Server and delivering BI solutions.

Jessica M. Moss
Ms. Moss, a SQL Server MVP, is a well-known practitioner, author, and speaker in Microsoft SQL Server business intelligence. Jessica has created numerous data warehousing solutions and authored technical content for multiple magazines, websites, and five technical books.
idera
June 18, 2013

Roman Rehak of mywebgrocer

 

Title - 24/7 Database Administration
 
Abstract - Keeping your SQL Server databases available 24/7 is a very challenging task. This presentation will discuss the issues and challenges involved, possible strategies, and provide many recommendations about how to make sure your environment remains available around the clock. The presenter manages a team of DBAs responsible for several ecommerce websites with high required uptime so this presentation will be very much "from the trenches" material.

Download Session Materials
Robert Half Technology
July 16, 2013 Erica Woods of Apex Systems Inc. and Brandon Berlett of Experis

Title - Career Crossroads - Should I Stay or Should I Go

 

Abstract - Have you reached the point where you are considering a change of pace?  If you find yourself at the career crossroads you are not alone.  We will take a look at the most common reasons professionals make a move and how to transition without burning bridges.  Our discussion will cover obstacles, opportunities and the potential pitfalls in the search for “greener pastures”.   Whether you are committed to taking the plunge or standing on the edge testing out the waters, this discussion with provide insights and suggestions to help you make the right choice. 

Download Session Materials

MSSQLTips.com
 

Jeremy Kadlec of Edgewood Solutions and MSSQLTips.com

 

Title - SQL Server Jeopardy

 

Abstract - Test your SQL Server knowledge and see what you might win...

 
August 20, 2013 Samuel Vanga

Title - Biml for Fun and Profit with SSIS

 

Abstract - Business Intelligence Markup Language is a game-changer. It provides a powerful mechanism to automatically create SSIS packages. The output of a Biml file is the same package you'd create using the UI, but Biml is exponentially faster and easily reusable. Come learn 1) basics of Biml 2) automating SSIS development and 3) creating packages dynamically from metadata.

 

Download the session materials

Robert Half Technology
 

Jeremy Kadlec of Edgewood Solutions and MSSQLTips.com

 

Title - SQL Server Agent - Expand the Possibilities

 

Abstract - Have you just scratched the surface of what SQL Server Agent has to offer?  Check out this session to expand the possibilities of what you can do with SQL Server Agent to improvement the management of your environment.

 

View the Session Materials

 
September 17, 2013 Erica Woods of Apex Systems Inc. and Brandon Berlett of Experis

Title - Resume Writing 101- Creating a Personal Marketing Piece

 

Abstract - The importance of an effective, well-written and user-friendly resume can’t be overstated.  Your resume is usually the first thing a potential employer sees; it’s often the first impression of you as a candidate.  Studies have shown that the average employer scans a resume for 15-30 seconds before deciding whether to move forward with a candidate.  Resumes should be written to communicate your brand, skills, and interests.   They should give an immediate indication of your qualifications, demonstrate your potential as a fit for the employer, and show you’re a candidate worth strong consideration.  

 

In this session, we’ll provide advice on how to really enhance your resume and communicate your brand to help grab the attention of potential employers.  Hopefully you’ll walk away with some insight on how to craft a resume that’s a major personal marketing piece.

Download Session Materials

idera
 

Edwin Sarmiento,     SQL Server MVP

 

Title - Fundamentals of SQL Server AlwaysOn Availability Groups

 

Abstract - Almost every SQL Server DBA wants to get their hands on implementing SQL Server 2012 AlwaysOn Availability Groups. Sure, it’s easy to setup and configure. But we can’t ignore the basics. In this webcast, we will look at the underlying concepts behind AlwaysOn Availability Groups – how it works under-the-covers and how you can leverage this information to efficiently design a highly available database. We will cover:

  • How Windows Server Failover Clustering and Database Mirroring works
  • How these two technologies form the foundation for understanding AlwaysOn Availability Groups
  • How to efficiently design a highly available database using AlwaysOn Availability Groups

Don’t miss this session to make AlwaysOn work in your environment.
 
October 15, 2013

Ray Barley of RDA Corp

 

Title - Introduction to SQL Server Analysis Services (SSAS) Tabular Model

 

Abstract - SSAS 2012 introduces a new tabular model that can be used in business intelligence applications rather than the traditional multidimensional model. SSAS tabular offers an in-memory database for fast queries and Data Access Expressions (DAX) for querying the model. DAX is very similar to Excel formulas.

 

The goal of this session is to show you how to build a tabular model using SQL Server Data Tools, deploy the model to an Analysis Server, and quickly build some simple queries to see the model in action.

RDA
    Title - SQL Server Jeopardy - Grand Prize - SQL Server Live Registration  
November 19, 2013

Kun Lee

 

Title - SQL Server Baseline for Performance Diagnostics

Try to beat the “All Depends” Scenarios

 

Abstract - We have all heard the response “It All Depends” when it comes to a solution for SQL Server performance tuning. In this presentation we will demonstrate how having a baseline will help to reduce this situation. The collected metrics can provide better justification for your recommendations when you talk to your system administrators, developers, network administrators or your management. Throughout this session, I will talk about what you want to baseline when you get a brand new system as compared to an existing system when there is a performance problem. Some of the techniques I will demonstrate can be used to troubleshoot existing performance issues for many different area such as Virtual Machines, Physical servers, SANs, DAS, Network, etc.

Download Session Materials

SQL Power Tools
December 17, 2013 Erica Woods of Apex Systems Inc. and Brandon Berlett of Experis 

Title - Interview Best Practices

 

Abstract - Your resume is only the ticket in the door, the interview is the performance. When it comes to your career, “winging it” is not an option. For most, success comes through practice and skill development. This is what separates the professionals from the amateurs. Need help handling the difficult questions, avoiding the common pitfalls, and navigating the path to achieving your next career opportunity? Our presentation aims to cover the tips and techniques to help you perform at your best. We will provide a high level overview of best practices and highlight the key areas that are commonly overlooked by candidates for hire. You will walk away better positioned to showcase your talents and ultimately advance your career.

 

Download session materials.

Apex Systems
  Chuck Rivel, Principal Architect, RDA Corporation

Title - Cube in the Cloud

 

Abstract - Did you know that you can use a Windows Azure Virtual Machine to run to run SQL Server business analytics related technologies like Reporting Services and ANalysis Services? In this session we will walk through how to stand up and work with an instance of SSAS in the cloud using the Azure Management Portal.

 
    BSSUG and Apex Systems Holiday Happy Hour @ Nottinghams  

 


 

2012 Meeting Schedule

Date

Speaker

Title and Abstract

Sponsor

January 9, 2012

Ray Barley of RDA Corp

 

Title - What Every DBA Needs to Know About SharePoint

 

Abstract - This session will provide an introduction to the SharePoint 2010 architecture then delve in to what a DBA needs to know to administer the many databases in a SharePoint 2010 farm.

Apex Systems

February 20, 2012

Edwin Sarmiento, SQL Server MVP

 

Title - SQL Server 2012 AlwaysOn

 

Abstract - SQL Server 2012 will have quite a few features aimed towards providing High Availability for database architectures. In this session, we will explore the new AlwaysOn Availability Groups feature for high availability and disaster recovery and the increased productivity created by read-only access to secondary database mirror replicas.

 

Bio - Edwin Sarmiento works as a SQL Server DBA for The Pythian Group in Ottawa, ON in Canada.

Experis

March 19, 2012

Derek Strasbaugh of Microsoft

Title -SQL Server 2012 PowerView and BISM

 

Abstract - PowerView is a new product feature in SQL Server 2012 that enables end users to build data visualizations that are print and presentation ready using the new BI Semantic Model. It continues Microsoft's efforts to deliver self-service BI capabilities to the end user. This talk will demonstrate how early adopters are already using these new capabilities, discuss best practices and lessons learned and show you how to incorporate PowerView into your solutions.

 

Bio - Derek is a Data Platform Specialist with Microsoft focused on the federal marketplace. Prior to joining Microsoft in 2011, Derek worked for a couple of local partners in program and project management and engineering roles. He has worked with SQL Server and other database technologies for the last fifteen years.

idera

April 16, 2012

Geoff Snowman

Title - Using XQuery in SQL Server

 

Abstract - It's impossible to overstate the importance of XML as a data format. This presentation will drill down into XPath and XQuery, two of the standards from W3C that support XML. XPath allows you to identify a sub-node within an XML document. It's the standard format for searching XML documents. XQuery builds on XPath to allow selection and manipulation of sections within an XML document. Microsoft has adopted XQuery as the query language for XML documents stored in SQL Server. When you read XML data from a SQL Server 2008 database, you'll typically need to use a combination of SQL and XQuery to select the XML that you require.

Red-Gate

May 21, 2012

Jessica M. Moss, SQL Server MVP

Title - Upgrading and Overhauling Your SSIS Packages for 2012

 

Abstract - SQL Server 2012 makes great strides in the development, maintainability, and administration features of Integration Services packages. Whether you already have packages from an earlier version or you are starting from scratch, you will learn how to take advantage of these new features. In this session, we will show: an upgrade of Integration Services packages from 2008 R2 to 2012, the modifications needed to run these packages in 2012, and the information produced about package execution.

 

Bio - Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server business intelligence.

Telerik

June 18, 2012

Roman Rehak of mywebgrocer

 

Title - SQL Server 2008 Reporting Services Programming

 

Abstract - SQL Server 2008 Reporting Services provides rich and powerful programming framework. This session will give you an overview of many available options for programming Reporting Services. We will cover the Reporting Services Web Service, URL Access, ReportViewer and custom assemblies. We will also talk about integrating reports into both Windows and Web applications.

 

Bio - Roman Rehak is a Principal Database Architect at MyWebGrocer.com in Burlington, VT. He specializes in SQL Server development and database architecture. He writes articles for Visual Studio Magazine, SQL Server Magazine, SearchSqlServer.com and other technical publications. Roman presents at user groups and conferences in US and Canada. He has served as the Tech Chair for the SQL Server track at DevTeach and PASS conferences, and is the president of the Vermont SQL Server User Group.

 

Download presentation materials.

Apex Systems

July 16, 2012

Jeremy Kadlec of Edgewood Solutions

 

Title - The Ins and Outs of SQL Server Integration Services

 

Abstract - Have you heard of SSIS? Have you tried to build an SSIS Package, but weren’t sure where to start? Do you have a need to enhance SSIS Packages developed by a previous team member? Attend this session to learn how to design, build, deploy and troubleshoot SSIS Packages in SQL Server 2008. This demo-rich session will get you up to speed quickly and demonstrate valuable features to benefit your next SSIS Project.

 

Bio - Jeremy is the CTO @ Edgewood Solutions, co-founder of MSSQLTips.com and a SQL Server MVP.

 

Download presentation materials.

Blackboard Analytics
August 20, 2012

Edwin Sarmiento, SQL Server MVP

 

Title - Implementing SQL Server 2012 on Windows Server Core

 

Abstract - SQL Server DBAs have relied so much on graphical user interface (GUI) to administer and manage database servers. So, why take away the GUI? If you’re more into using the command-line and PowerShell to manage your servers, come to this session to learn how to implement SQL Server 2012 on Windows Server Core.

 

Bio - Edwin Sarmiento works as a SQL Server DBA for The Pythian Group in Ottawa, ON in Canada.

Technisource
September 17, 2012

Kevin Goff, SQL Server MVP

 

 

 

Title - Getting the most out of the new columnstore index in SQL Server 2012

 

Abstract - It might initially seem far-fetched that a company would upgrade (as some are doing) to SQL Server 2012 “just” for a database index. But after you see the performance enhancements gained from the new columnstore index in SQL Server 2012, you’ll see why many are calling this one of the most important new features in the history of SQL Server.

 

In this presentation, I’ll talk about the specific physical aspects of columnstore index in SQL Server 2012, how to create it, and what environments (mainly data warehousing environments) can make use of it. I’ll show performance benchmarks between columnstore indexes in SQL Server 2012, and compare them to index strategies prior to SQL Server 2012. We’ll see that the columnstore index can run queries at least 10 times faster than all other types of indexes.

 

I’ll also talk about the new “batch mode” process in SQL Server that can take operators like hash join and run them in a fraction of the time. Finally, I’ll show some T-SQL queries that can’t directly take advantage of the new columnstore index, and how we might work around some of the limitations to still gain huge performance benefits. I can almost guarantee that you’ll utter a few “oohs” and “aaahs” after seeing the performance gains from the columnstore index.

 

Bio - Kevin S. Goff (http://www.kevinsgoff.net) is a Microsoft SQL Server MVP, SQL Server/Business Intelligence Practice Manager for SetFocus LLC, author of 2 books, regular columnist for CoDe Magazine on .NET, SQL Server, and Business Intelligence topics, and a frequent speaker at community events in the Mid-Atlantic region.

 

idera
  Erica Woods of Apex Systems Inc. and Brandon Berlett of Experis Title - Finding and Working with Recruiters

Abstract - Coming soon...
 
October 15, 2012

Jeremy Kadlec of Edgewood Solutions

 

Title - SQL Server Indexing

 

Abstract - Indexing your SQL Server database should not be an afterthought. Indexing should be included in the development and testing phases of your release cycle in addition to tweaking in production. Without the proper indexes high performance will not be achieved, your databases can be severely bloated and the user experience will suffer. Attend this session to learn how to establish your indexing goals, work through a process to ensure you have the correct indexes and work through half a dozen demos to build your indexing knowledge.

 

Telerik

November 19, 2012 Chuck Rivel, Principal Architect, RDA Corporation

Title - Building a PerformancePoint Dashboard from a Tabular Model in SSAS 2012

 

Abstract - I will be walking through the building of a Tabular model and then creating a PerformancePoint 2010 dashboard against the model. The tabular model is a new in SQL 2012 Analysis Services and everything in the model is stored in memory as opposed to traditional MOLAP cube storage. In addition, working with the tabular model for PerformancePoint is just as simple as working with a dimensional model, with a few differences that I will point out.

 

Experis

December 17, 2012

Ray Barley of RDA Corp

 

Title - Introduction to SQL Server Data Tools

 

Abstract - SQL Server Data Tools (SSDT) is the replacement for Business Intelligence Development Studio (BIDS) which has been included in versions of SQL Server prior to SQL Server 2012. SSDT has all of the capabilities of BIDS along with some nice enhancements. In this session I will provide an introduction to SSDT and focus on the following areas:
+ Installation
+ Creating a SQL Server Database Project
+ Modify Database Schema
+ Schema Compare and Update
+ Snapshot Project
+ Publish

 

Red-Gate

 


 

2011 BSSUG Meeting Schedule

2011 Baltimore SQL Server Users Group Meeting Schedule

Date

Speaker

Title and Abstract

Sponsor

January 3, 2011

No Meeting

February 14, 2011

Yair Granek

Title - Plug and Play Scalability & Performance Solution

Abstract - Information runs today’s business. Customers, employees and real time applications rely more and more on the content of the DB’s. As the demand on the DB’s continue to increase, IT’s, developers and system architects search for ways to maintain Performance levels and Response Time during heavy loads or Peaks, without major investment in infrastructure nor modification of the applications/DB.

Established in 2007, SafePeak Technologies is a privately held company. It is led by an experienced management team and backed by leading investors.

SafePeak Technologies, a leading company in the area of performance and scalability of enterprise application systems, developed a pioneering solution that gives instant acceleration of performance and scalability of existing information applications and systems. Specifically, SafePeak is an industry first automated in-memory dynamic caching solution, that boosts speed of data access to microsecond speed, while has a seamless integration that requires no code changes on application and database levels (Plug & Play).

SafePeak installations accelerate Web Servers, E-commerce portals, Document Management, CRM, ERP and other enterprise applications.

SafePeak works with well established partners creating a global reselling channel network for distribution and support of SafePeak solutions in different local markets. Partners from USA, Europe and Asia Pacific are already providing local reselling and support service.

View Presentation Slides

SafePeak

Ilay Golferd

Title - SQL Server Query Performance Monitoring

 

Abstract - This session will cover the following items:

What is query performance monitoring as I understand it
What specifically to monitor
Execution times for stored procedures and user defined functions
Deadlock detection
Lock chain detection
How to interpret the results

Jeremy Kadlec of Edgewood Solutions

Title - New Features in SQL Server 2008 for DBAs - Part 2

Abstract - Come check out some new features in SQL Server 2008 that will not only benefit your organization, but you as a DBA. This demo packed session will cover multi-server administration, multi-query, policy based management, new T-SQL commands and more. In this session we will break down these topics so you can see how they will benefit you, your team and your organization.

Bio - Jeremy is the CTO @ Edgewood Solutions, co-founder of MSSQLTips.com and a SQL Server MVP.

March 14, 2011

Kun Lee

Title - SQL Server Transactional Replication - Advanced Features, Scripting, Source Safe and more

 

Abstract - Replication is one of the important Microsoft SQL Server features for many companies. However, very often I see many DBAs and Developers maintaining replication through the GUI. This makes it harder to standardize the deployment and even harder to automate it. In our environment we have a number of special requirements to maintain replication, such as special indexes on the subscribers, supporting republishing replication (AKA, Publishing Subscriber) and most important, keeping all code in Source Safe. So, I’d like to share what I have done with my current company with a lot help from my colleagues. Hopefully these lessons learned will help other DBAs or I can get great feedback from you on our approach, so that I can apply your lessons learned, to my current process.

View Presentation Slides

Bio - Kun is a database administrator in Bethesda, Maryland. His areas of interest are database administration, architecture, data modeling and development. He loves technologies of all kinds.

Idera

April 11, 2011

Andy Novick

Title - Programming with the SQLCLR in SQL Server

Abstract - SQL Server provides the capability to run .Net code right inside SQL Server Engine on a par with T-SQL in what’s called the SQLCLR. This gives the programmer an expanded choice of programming language and some new object types. This presentation shows you how to write C# or VB.Net routines and execute them in SQL Server as one of the supported SQL object types:

  • Stored Procedure
  • Scalar or Table User-defined Function
  • Trigger
  • User-defined Aggregate
  • User-defined Type

Each of these objects has its own requirements and opportunities. Using the SQLCLR as opposed to T-SQL has tradeoffs and we’ll examine when T-SQL is better and when using SQLCLR is best. We’ll also take a look at error handling and performance comparisons between T-SQL code and similar .Net code.

Bio - Andy Novick is a SQL Server Developer in the Boston area with 25 years of database and application development experience.

Telerik

May 9, 2011

Vladimir Yangurskiy of Microsoft

Title - Using PowerShell™ in SQL Server Management

Abstract - In this presentation I’m going to show how to setup/configure and use PowerShell™ for SQL administration. Also, in series of practical examples I’ll demonstrate how you can utilize your existing knowledge of SQL Server to customize PowerShell for your day-today needs.

View Presentation Slides

Experis IT

June 13, 2011

Roman Rehak of mywebgrocer

Title - SQL Server Development Tips and Tricks

Abstract - This session will cover many common issues, challenges and problems encountered when developing for, or administering SQL Server as well as examining best ways to modify, script and copy database objects from development to production environment. Session materials for the attendees will include custom utility tools and stored procedures written by the speaker for simplifying SQL Server development and database update deployment.

View Presentation Slides

MSSQLTips.com

July 11, 2011

Ray Barley of RDA Corp

Title - Building BI Solutions with SharePoint 2010 and SQL Server 2008 R2

Abstract - An overview of building Business Intelligence solutions that leverage SharePoint 2010 and SQL Server 2008 R2. Topics to be discussed include building dashboards with PerformancePoint Services, self-service BI with Excel 2010 PowerPivot and Report Builder 3.0, and configuring/running Reporting Services in SharePoint Integrated mode.

Ray will be raffling off several copies of a new book that he co-authored: SharePoint 2010 Business Intelligence Unleashed

View Presentation Slides

Bio - Ray Barley is a Principal Architect at RDA Corporation (http://www.rdacorp.com).

Red Gate

August 8, 2011

Edwin Sarmiento, SQL Server MVP

Title - Gone Clustering in 60 Minutes

 

Abstract - Creating a SQL Server 2008 Failover Cluster on Windows Server 2008 has become a lot easier with the availability of online resources such as MSSQLTips.com. However, making it easy does not mean ignoring the basic principles of the underlying technology. In this session, learn the fundamentals and principles behind how Windows Failover Clustering works and how SQL Server leverages on the technology, allowing you to build highly available database infrastructures.

Bio - Edwin Sarmiento works as a SQL Server DBA for The Pythian Group in Ottawa, ON in Canada.

LogicMonitor

September 12, 2011

Jeremy Kadlec of Edgewood Solutions

Title - SQL Server Denali for DBAs and Devs

Abstract - With SQL Server Denali CTP 3 bits available for download, come check out what is new, what has changed and what has stayed the same in SQL Server. Jeremy will share some of his experiences with Denali testing and deliver some demos to start to introduce the new feature set. Come join us to get your first exposure to SQL Server Denali to learn how debugging has improved, what you have access to in a contained database and much more.

Bio - Jeremy is the CTO @ Edgewood Solutions, co-founder of MSSQLTips.com and a SQL Server MVP.

View Presentation Slides

Telerik

October 10, 2011

Jeremy Kadlec of Edgewood Solutions

Title - Building Blocks for Your SQL Server Career

Abstract - Do you have the needed skills for your SQL Server career? Whether you are looking to land your first job or advance into a managerial position, this session will offer recommendations to you. From interview tips to skills all employers are looking for in SQL Server professionals, this session will benefit you.

Bio - Jeremy is the CTO @ Edgewood Solutions, co-founder of MSSQLTips.com and a SQL Server MVP.

Redtail Creek Software

Ray Barley of RDA Corp

Title - Creating SharePoint 2010 Content Databases with PowerShell

Abstract - PowerShell is now the preferred way to perform SharePoint administration. This session will demo how to use PowerShell to create content databases and site collections that are associated with a specific content database.

Bio - Ray Barley is a Principal Architect at RDA Corporation (http://www.rdacorp.com).

November 14, 2011

Ray Barley of RDA Corp

Title - Introduction to Log Shipping and Database Mirroring

Abstract - In this session we will discuss the pros and cons of log shipping and database mirroring. We'll walk through demonstrations of how to perform the setup using SQL Server management Studio and by running T-SQL scripts.

Bio - Ray Barley is a Principal Architect at RDA Corporation (http://www.rdacorp.com).

log-shipping-and-mirroring.zip

Idera

December 12, 2011

Brad McGehee of Red Gate

Title - Introduction to SQL Trace

Abstract - While many DBAs are familiar with SQL Server Profiler, they are not familiar with SQL Trace. Very briefly, SQL Trace allows you to capture Profiler traces using system stored procedures, without the extra overhead of using the Profiler GUI, helping to minimize the amount of resources used for capturing traces.


In this session you will learn: What is SQL Trace; The Pros and Cons of Using SQL Trace; How SQL Trace Works; What are the SQL Trace System Stored Procedures; How to Create Your Own SQL Trace Script; How to Query Trace Data Directly From a Trace File; and How to use the SQL Server Profiler GUI to Automatically Write SQL Trace Scripts.

This session is filled with demonstrations, and assumes attendees have a basic understanding of how to use Profiler. After attending the session, attendees will be able to return to work and immediately put what they have learned into practice.

Bio - Brad M. McGehee is the Director of DBA Education for Red Gate Software, an accomplished Microsoft SQL Server MVP with over 15 years’ SQL Server experience, over 6 years’ training experience, and has been involved in the industry since 1982.

View Presentation Slides

Red Gate

 


 

2010 BSSUG Meeting Schedule

 

2010 Baltimore SQL Server Users Group Meeting Schedule

Date

Speaker

Title and Abstract

Sponsor

January 4, 2010

Bob Harford

Title - Geographic Information Systems using SQL Server, SharePoint, Virtual Earth, and GeoAnalyzer

Abstract - Using mock/notional data, will provide a quick example of how to build a SQL Server Analysis Services cube from a relational database – for example number of UN Peacekeepers deployed by region in Africa. Display data from that cube within SharePoint. And finally project data onto geographic maps using Virtual Earth and a product called GeoAnalyzer – showing, for example, on a map how many Peacekeepers are deployed where, and even drill down and physically see the mock UN force encampment site using Virtual Earth.

In short, a tabular, Excel-type listing of countries and their UN Peacekeeper totals gives the same information as a color-code map. But the Excel doc cannot as easily show the patterns associated with what physical locations are over/under represented. Plus people like maps.

Download Presentation Slides

Attunity

Attunity

Title - Operational Data Replication (ODR) for Heterogenous Sources with Attunity CDC for SSIS

Abstract - During this presentation, sponsored by Attunity, you will learn how to leverage your SQL Server skills and software to reduce cost and accelerate operational data replication (ODR) and integration across heterogeneous data sources enabling operational reporting, business intelligence and data warehousing projects. Attunity's Kevin Maguire wioll explain CDC concepts and benefits and how CDC can assist you with data replication and integration projects. If time permits, he will demonstrate Attunity's CDC for SSIS product using SQL Server as a source to various targets.

February 1, 2010

Joe Webb

Title - SQL Server Locking and Blocking Made Simple

Abstract - A good working knowledge of how SQL Server makes use of locking and transaction isolation levels can go a long way toward improving an application's performance. In this session, we will explore SQL Server's locking methodology and discover techniques for enhancing query response times.

Idera

March 1, 2010

Vladimir Yangurskiy

Title - SQL Server Management Studio Extensibility: Custom Reports and Report Packs

Abstract - During this presentation, I’m going to show you how to create new or adapt existing Reports and integrate them with SQL Server Management Studio. Also, I’m going to explain SQL Server Management Studio Extensibility model and show you how to create Report Packs.

Download Presentation Slides

Red-Gate

Bob Harford Title - SharePoint web parts to surface SQL Server geography/geometry data types

 

Abstract - In January we showed how to go from a text based address (such as 1400 Pennsylvania Avenue, Washington DC) to a value stored in a SQL Server table in a Geometry data type field.

We also showed how to display data on static, color-coded maps using SQL Server 2008 Reporting Services.

The focus off this discussion will be the technical details on how to go from geometry data stored in SQL Server to dynamic maps (zoom in, zoom out) that are displayed within SharePoiont using the ESRI MapIt product. We'll also review the difference between the geography data type and the geometry data type.

April 5, 2010 Brad McGehee

Title - How to Use the SQL Server 2008 Performance Data Collector to Analyze Query Performance

Abstract - In SQL Server 2008, the Performance Data Collector was introduced. This powerful tool collects a great variety of performance-related data, and stores it in a database so DBAs have the ability to “go back in time” and see how their well their SQL Servers are running. While the Performance Data Collector collects a wide variety of information, one if it’s most useful features is the ability to identify and analyze poor query performance.


In this session, you will learn how to use the Performance Data Collector to analyze poorly performing queries, and what to do about them. More specifically, we will take a look at a wide variety of examples of poorly performing queries, as captured by the Performance Data Collector, and learn how we can use the data to identify specific problem queries, and then to figure out different ways to fix them.


This session is filled with demonstrations, and assumes attendees already have a fundamental understanding of how the Performance Data Collector works, as this session focuses exclusively on the “Query Statistics” feature of the Performance Data Collector. After attending the session, attendees will be able to return to work and immediately put what they have learned into practice.

Red-Gate

Danette Riviello

Title - Troubleshooting deadlocks and other application pitfalls

Abstract - In this presentation, we will discuss several common pitfalls that can bring can cause performance issues with your applications and sometimes prevent your data from being saved. The first pitfall is to not have the correct indexes on your tables. Performing a table scan can not only slow down your results, but can lock the entire table, so that other users are blocked from using the application. Poorly performing processes sometimes result in timeouts, leading to the second pitfall – not properly handling database connections. Another major pitfall is to not properly manage your joins, resulting in deadlocks. You will learn about some scripts and commands to detect and correct index issues, deadlock issues and the proper handling of database connections in applications.

Download Presentation Slides

May 3, 2010

Monica DeZulueta of Microsoft

Title - Self-Service Business Intelligence with SQL Server 2008 R2

Abstract - SQL Server® 2008 R2 ships a wealth of Business Intelligence components, broadening the reach of BI across the entire enterprise with familiar and intuitive tools and helping maximize return on investment and increasing IT efficiency at scale. This session will cover Self Service Analysis and Reporting offerings in SQL Server, Office 2010 and SharePoint 2010. Self-Service Analysis allows users to pull from a multitude of data sources and do analysis on the client side using Powerpivot within Excel. The analysis can then be published to a Sharepoint site where users can share the analysis across the enterprise. SQL 2008 R2 Reporting greatly facilities ad-hoc reporting as well as include mapping controls.

MSSQLTips
June 7, 2010 Fusion-IO

Title - Accelerating SQL with Solid State Technology

Abstract - Solid-state technologies are changing the way that MS SQL users run their databases. DBA’s are achieving significant TCO savings through performance enhancements, reliability improvements, and reduced energy and real estate costs using solid-state technologies. Solid state is changing the way datacenters look and how MS SQL Servers perform.
This session will address:
1) On overview of solid state technology options for SQL Server

2) Why solid state makes a difference?

3) An comparison of the different types of NAND Flash-based products and the advantages and disadvantages of each:
a. Disk-based SSDs
b. Onboard/Embedded PCI Express devices
c. Host-based PCI Express devices

4) Customer proof: Wine.com case study

Fusion-IO

Chad Boyd Title - SQL Server Service Broker

Abstract - Service Broker is a new queuing and asynchronous messaging technology available with Sql Server 2005 & 2008. Service Broker can help database developers build secure, asynchronous, reliable, loosely-coupled, scalable applications without requiring complex and expensive add-on software or additional hardware. Because Service Broker is part of the Database Engine, administration of these applications is part of the routine administrative of the database. Find out how Service Broker makes it easier than ever for you to build reliable, scalable, asynchronous, queued database applications. When combined with other features within the Sql Server engine like the CLR and XML enhancements, SQL Server provides a great platform for building the next generation of business applications.

July 19, 2010 Jesse McLain

Title - TSQL code to determine possible unique keys of raw data.

Abstract - I will be describing an algorithm I wrote that employs a hybrid recursive/iterative approach to determining the minimal unique key (if one exists), for a given table of raw data. The presentation will cover the problems involved in developing a solution and various approaches I considered, and of course a review of the solution at which I ultimately arrived.


Download Presentation Slides

AllSearch

Chad Boyd Title - SQL Server Service Broker - Demos

 

Abstract - Service Broker is a new queuing and asynchronous messaging technology available with Sql Server 2005 & 2008. Service Broker can help database developers build secure, asynchronous, reliable, loosely-coupled, scalable applications without requiring complex and expensive add-on software or additional hardware. Because Service Broker is part of the Database Engine, administration of these applications is part of the routine administrative of the database. Find out how Service Broker makes it easier than ever for you to build reliable, scalable, asynchronous, queued database applications. When combined with other features within the Sql Server engine like the CLR and XML enhancements, SQL Server provides a great platform for building the next generation of business applications.

Download Presentation Slides

AllSearch
August 2, 2010

Ray Barley of RDA Corporation

Jeremy Kadlec of Edgewood

Title - SQL Server 2008 R2 Community Launch Event

Abstract - We'll provide a breakdown of what's new in SQL Server 2008 R2. Ray will cover developer topics and Jeremy will cover DBA topics.

Download Presentation Slides

Edgewood Solutions

September 13, 2010

Cancelled

October 4, 2010

Ray Barley of RDA Corporation

Michael Grant
of iLand

Title - SQL Azure Overview

Abstract - SQL AZURE is Microsoft’s relational database-in-the-cloud offering. At a high level SQL AZURE allows you to instantly provision a database in the cloud, then simply change your database connection string to the database URL and you are ready to go. You can use the same database access code (e.g. ADO.NET), tools (e.g. SQL Server 2008 R2 Management Studio) and utilities (e.g. BCP, SSIS) to work with your data. However, SQL AZURE provides a subset of the capabilities in SQL Server. In this session we will provide an overview of SQL AZURE covering architecture, high availability, security model, administration, and billing. In addition we will highlight the important differences between SQL Server and SQL AZURE so that you can make an informed choice as to which of your applications can benefit from SQL AZURE.

Download Presentation and Demos

Title - Disaster Recovery in the Cloud

 

Abstract - We will present the most effective strategies for using Cloud Computing Resources as the backbone of a successful Disaster Recover Plan. Businesses of all sizes are taking advantage of SAN to SAN, VMWare SRM and other software based replication technologies to insure that when the next unplanned outage happens the data will be secured in a cloud datacenter with available computing resources to resume business. In addition to learning how to protect server workloads we will also discuss the ways that virtual desktops are simplifying Business Continuity Plans.

iLand

November 1, 2010

Geoff Snowman of SolidQ

Title - SQL Azure Advanced Topics

Abstract - SQL Azure can solve complex network connectivity and security issues when used as a data distribution hub for mobile applications, and the Microsoft Sync Framework can synchronize SQL Azure with an occasionally-connected mobile application. In this session, you'll see the complete life cycle of data flowing through a sales order application running on mobile laptops.

The demonstration will include pushing catalog data from an on-premise database to SQL Azure using SSIS, syncing the catalog data to the sales people's laptops via Sync Framework, taking orders while disconnected, syncing orders back to SQL Azure, then bringing orders back to the on-premise ERP system via SSIS.

You will learn:

- What is the Microsoft Sync Framework?

- How to use the Sync Framework to sync mobile devices with a back-end database

- How to use SQL Azure as a data hub to distribute data from an on-premise database

- How to use SSIS to copy data from an on-premise database to SQL Azure and back again

- How to deploy databases in SQL Azure

AllSearch

Jeremy Kadlec of Edgewood Solutions

Title - New Features in SQL Server 2008 for DBAs

Abstract - Come check out some new features in SQL Server 2008 that will not only benefit your organization, but you as a DBA. This demo packed session will cover multi-server administration, multi-query, policy based management, new T-SQL commands and more. In this session we will break down these topics so you can see how they will benefit you, your team and your organization.

AllSearch

December 6, 2010

Rob David of Sentrigo

Title - A new angle on a popular attack vector: SQL Injection

Abstract - This presentation is intended to expand the audience’s understanding of what SQL Injection is, how it is conducted, and how it can be countered. Though many types of SQL injection can be prevented by secure coding practices, one can limit and even stop SQL injection attacks by deploying the correct tools to protect applications and databases. Certain classes of SQL injection, including those exploiting zero-day vulnerabilities, can be entirely blocked by deploying deep inspection tools, which will be demonstrated in the presentation.

Take away points:
• Characteristics and dangers of SQL Injection Attacks
• Secure coding practices
• Existing tools for SQL Injection prevention and techniques to evade them
• New resilient technologies used to solve entirely SQL injections, even those exploiting zero-day vulnerabilities

Sentrigo

Jesse McLain

Title - An Introduction to Data Profiling

 

Abstract - I will provide an overview of data profiling, including what it is, who should use it, how it can be implemented, and why it is important. A code sample demonstrating rudimentary data profiling will be provided and reviewed.


Download Presentation and Demos

Sentrigo

 

 


 

2009 BSSUG Meeting Schedule

Coming soon... 

 

Copyright (c) 2012 - 2016 BSSUG INC. All Rights Reserved.