April 2017 Monthly Meeting – A Functional Review of Visual Studio Database Projects

Bio:

Cameron Snapp is a MCSE and PMP certified IT Consultant with 14 years of database architecture and development experience. He has worked on dozens of Microsoft SQL Server OLTP, Data Warehouse, and Business Intelligence projects. He holds a Computer Science degree from the University of Richmond and a Master’s degree in IT Management from the University of Virginia. Cameron specializes in IT Projects related to data strategy, modeling, integration and reporting.

Session Title:

A functional review of Visual Studio Database Projects with feature tips and demo

Abstract:

Visual Studio (VS) has finally delivered a great way to manage databases within the Software Development Lifecycle. While VS has offered a Database Project type for several years, to me, it was never really a sustainable way to create, manage, source control, schema compare, and deploy database objects. In this presentation, I’ll break down the feature set of database development in VS and offer some experience tips for SQL database developers to start working in what really is a great new way.

Posted in Uncategorized | Leave a comment

March 2017 Monthly Meeting -Automated SQL Server Installation and Configuration Using PowerShell

 

profileBio: Jamie Wick is the Systems & Database Engineer for The College of William & Mary and has been working with databases for the past 10+ years.  His background includes working for several years as a SQL SysAdmin for the University of Queensland (Australia), a Master’s degree in Computer Information Systems from Boston University, and assorted Microsoft SQL certifications.  He is a volunteer & speaker at regional SQL events (User Groups/SQLSaturdays), helps run the Richmond SQL Server Users Group and SQLSaturday RVA events, and is an avid photographer.

Session Title: Automated SQL Server Installation and Configuration Using PowerShell

Abstract: Using the SQL setup wizard and management studio (SSMS) to install and configure a new SQL server is a time-intensive process.  PowerShell scripts can greatly reduce the time required to complete the process.  They can also ensure build standardization throughout your SQL environment.  In this session we will look at PowerShell scripting, including the basic syntax and commandlets needed to automate the installation and post-install configuration of SQL Server (2016).

Download the presentation file

Posted in Meetings | Leave a comment

February Meeting 2017 Andy Mallon – Demystifying Data Compression

andyBio:

Andy is a SQL Server DBA that has managed databases in the healthcare, finance, e-commerce, and non-profit sectors. He has over 12 years of experience supporting high-volume, highly-available OLTP environments with demanding performance needs. As co-organizer of SQL Saturday Boston, and speaker at many SQL Server user groups & SQL Saturdays, Andy loves sharing his knowledge & experience with others.

He’s lazy: Andy loves scripting and automating repetitive tasks, and hates doing the same thing over and over.

He’s impatient: Andy loves looking at processes and figuring out a faster, more efficient way to accomplish the same goal. Sometimes this is performance-tuning a query, and sometimes it’s looking for fundamentally different ways to accomplish the same goal.

Abstract:

SQL Server 2016 SP1 makes data compression available in all editions. Data compression can reduce storage costs, and provide a performance boost—and now compression is available without the added cost of Enterprise Edition. Whether you are a developer or a DBA, it’s important to know how to use compression to save money and improve speed.

Come learn about how data compression actually works, the differences between ROW and PAGE compression, and learn how to pick the best compression level for your data. This session will cover the details of the compression algorithms, and the costs and benefits associated with each type of compression.

By the end of this session, you’ll have a better idea of how the different compression algorithms work, when compression is the right solution, as well as what type of compression to use.

Download the presentation files
 

Posted in Meetings | Leave a comment

January Meeting 2017

Speaker – Devin Jaiswal (view bio)

Session – Data Encryption

  • Dynamic Data Masking – Limit exposure of sensitive data by masking it to non-privileged users
  • Row Level Security – Keep multi-tenant databases secure from unauthorized access by other users who share the same tables
  • Always Encrypted – Client-side encryption of sensitive data using keys that are never revealed to the database system
  • Encryption-at-rest (TDE) Server-side encryption of the database content on physical storage, protecting against offline media attacks
Posted in Meetings | Leave a comment

December Meeting – 2016

In lieu of our normal meeting, we cordially invite you to our

Annual Holiday Networking Dinner

Gordon Biersch Town Center of Virginia Beach
4561 Virginia Beach Blvd, Virginia Beach, VA 23462
6pm – 8pm

Click on the Eventbrite button on the right to let us know you are attending
Map to Gordon Biersch

Posted in Meetings | Leave a comment