What we're about

The Richmond SQL Server Users Group (RichmondSQL) is located in Richmond, Virginia. We are an active group of SQL Server professionals that meet for networking and presentations on many SQL Server topics, including:

Database Design & Development

Performance Tuning & Troubleshooting

Business Intelligence

SQL Server Administration

Meetings are always FREE and food is provided.

Meeting Format

6:00pm - 6:30pm | Free food / beverages, networking and group discussion.

6:30pm - 8:00pm | Announcements & speaker presentation.

(by joining this group you agree to adhere to the below policy)

Anti-Harassment Policy

Minimum Code of Conduct

1. No disrespectful behavior. This includes threats, harassment, stalking, abuse, slurs, profanity, personal attacks, sexual remarks or innuendos, physical violence, public speculation about others, and any other behavior that you would not tolerate displayed towards you.

2. Respect the presenter and other attendees

· Ask questions but respect the presenter’s wishes regarding when to ask questions.

· Avoid asking questions or making statements that will side-track the presentation. However it’s intended, it may be seen as hijacking the presentation.

3. No impersonations of a Microsoft or user group employee, agent, manager, host, or another user.

4. No illegal or offensive activities. Members will not publish, post, distribute, or disseminate defamatory, infringing, obscene, or other unlawful material or discussion in any group forum or post. This includes, but is not limited to, child pornography, bestiality, incest, illegal drugs, software piracy, discriminatory/racist statements or images, and harassment.

5. Accountability. Members are fully responsible and liable for anything they say (whether orally or in writing) or do. This includes any actions taken based on advice or information received in presentations, online forums, or elsewhere. Remember, always test what you plan to do, regardless of the source of the information.

6. No libel or slander against the user group, Microsoft, or other persons or entities. Libel includes false statements made in written form, such as statements posted to forums or other publicly accessible websites, electronic mail, or any other printed form.

7. No confidentiality violations. Members may inadvertently gain access to certain non-public information during their participation in the group and are expected to honor the confidentiality of the information.

8. No plagiarism. Members may post their own original work or work that they have written permission to post. If a member cites another author’s work, please provide any necessary attribution according to the requirements associated with the original author’s work. Learn more about copyright at:

( https://www.microsoft.com/en-us/legal/Copyright/Default.aspx )

9. No discrimination or harassment. This user group is committed to providing a harassment-free experience to members regardless of age, ancestry, color, gender identity or expression, marital status, medical condition, national origin, physical size, physical or mental disability, political affiliation, veteran status, race, religion, sex (including pregnancy), sexual orientation, or technology choices. Harassment is unwelcome verbal, physical or virtual behavior based on the characteristics identified above.

10. No sexual harassment. Sexual harassment is unwelcome verbal, physical or virtual behavior based on sex and includes gender-based harassment of a person of the same or different gender. Examples of sexual harassment include, but are not limited to:

· Unwelcome sexual advances

· Sexual comments or inappropriate gender-based jokes

· Excessive, unwelcome romantic attention

· Offering or conditioning an employment benefit or preferential treatment, like a promotion or job assignment, in exchange for sexual favors

· Unwelcome physical contact

· Sharing or displaying sexually explicit content

· Using sexually degrading words

Reporting Conduct Violations

If you become aware of a conduct violation on or offline, you are encouraged to report it to a user group leader.

If you are being harassed, notice that someone else is being harassed, or have any other concerns, please contact a user group leader or member of the event staff immediately.

Upcoming events (4+)

Andy Leonard - Getting Started with the Azure Data Factory REST API

Azure Data Factory - ADF - is a cloud data engineering solution. While the ADF GUI and properties surface lots of cool and useful functionality, some functionality is encapsulated in the ADF REST API. In this session, I demonstrate using the ADF REST API to save money when using Azure-SSIS integration runtimes and stopping a Foreach activity on a failure (not native functionality).

About Andy:
Andy Leonard is a husband, dad, and grandfather; creator of – and Data Philosopher at – DILM (Data Integration Lifecycle Management) Suite; a blogger, founder and Chief Data Engineer at Enterprise Data & Analytics; an SSIS and Azure Data Factory trainer, consultant, and developer; a SQL Server database and data warehouse developer; an author, mentor, engineer, and farmer.

Robbie Staples - Create, Deploy, & Run SSIS with Variables and Parameters

Have you ever wondered how to use variables and parameters in your SSIS packages? Would you like to take the automation of your SSIS packages to the fullest extent possible? Have you ever upgraded a server or your database and went through countless hours of updates to your suite of SSIS packages? If so, then this session is for you. Topics discussed in this session will include the SSIS Catalog, Environment Variables in SSMS as well as variables and parameters within SSIS packages. In addition, you will learn how to access variables and parameters outside of your SSIS package in SSMS.

About Robbie:
Robbie Staples has over 15 years of experience writing SQL queries and 5 years working with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS). He is a Microsoft Certified Systems Engineer (MCSE) in Data Management & Analytics as well as a Microsoft Certified Solutions Associate (MCSA) in SQL 2016 Database Development. He has worked in the power, banking, transportation, healthcare, and semiconductor industries with most of his experience being in the power industry. He has his Electrical Engineering degree from Virginia Commonwealth University and is a licensed Professional Engineer in Virginia and Texas. He is currently employed by Old Dominion Electric Cooperative as a Software Developer focused on automating manual processes and bringing data to the forefront of the company.

Kevin Feasel - Analyzing Business Data with T-SQL

Solvaria

Transact-SQL (T-SQL) is a powerful language for querying data but it can be a challenge for application developers and business analysts who are not already deeply familiar with the language to solve business problems. In this session, we will use a variety of T-SQL techniques to generate Key Performance Indicators (KPIs) for a common business scenario. We will see how to calculate measures like revenue, cost, profit, lifetime value, days between orders, and much more using techniques like common table expressions, date math, window functions, percentiles, and the APPLY operator. Come learn techniques to transform your business needs into SQL answers.

About Kevin:
Kevin Feasel is a Microsoft Data Platform MVP and CTO at FareGame Inc, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather's nice enough.

Kevin Hazzard - Intro to SQL Server in Docker Containers

VACO Technology

This highly interactive, demo-focused session is for folks who are curious about Docker and love SQL Server. You’ll learn how to pull a SQL image from the repository, instantiate a container, and restore databases. Once we have the perfectly configured database container that we can query successfully, we’ll learn how to convert it into a golden image and save it back to a private repo where it can be used on any Docker compatible platform. During Q&A, we can touch on topics like networking, performance, compatibility, storage, and licensing.

About Kevin:
Kevin Hazzard is the cloud strategist for Altria, based in central Virginia. He was a long-time C# MVP but he loves SQL Server and related database technologies more than anything else. When Kevin isn't playing with his grandkids, he likes to work outdoors and in the garden growing veggies.

Find us also at