SQL Server

Thursday, August 11, 2015, 6:00 PM to 8:30 PM

Register Now!

You are a DBA familiar with some basic Windows clustering and database mirroring concepts, and now you are considering AlwaysOn Availability Groups. This session will cover the pros and cons of four typical configurations of AlwaysOn Availability Groups; stand-alone instances, fail-over cluster instances, multi-subnet, and a hybrid approach that I call disaster-recovery-on-the-cheap. It will also include their exclusive features such as read-only routing and backup off-loading. In addition, you’ll learn how to use the Availability Group Listener correctly and why you should be using Windows Server 2012 R2 or above, along with some of my own personal lessons learned.

Speaker Bio:
I am currently working as a Production / Traditional DBA with Ascension Information Services. Server configuration, architecture, disaster recovery, high-availability, performance tuning, and maintenance automation form the bulk of my responsibilities. Previous positions have landed me as Head of Database Operations followed by Data Architect at Liberty Tax Service. I also spend as much time as I can spare attending SQL Server community functions. Currently chapter leader for FairfieldPASS.

SQL Sentry Plan Explorer PRO


Round-table discussion: Backup Management (Derik Hammer)

Tuesday, July 14, 2015, 6:00 PM to 8:30 PM Topic: In this meeting we will address the topic of backup management and then hand the discussion over to all of the attendees. We will focus on every part of backup management from performance and recovery strategies to 3rd party vendor software and everything in between. […]

Read the full article →

How isolated are your sessions? (John Miner)

Monday, December 16, 2013, 6:00 PM to 8:30 PM Topic: Have you ever executed a T-SQL program that crashed due to an integrity error? Upon inspecting the job history, the error code states you have duplicate key values. However; re-running the job does not reproduce the error. You probably had an transaction isolation level issue […]

Read the full article →

Windows Azure SQL Databases (Kevin S. Goff)

Monday, November 11, 2013, 6:00 PM to 8:30 PM Topic: Are you brand new to Azure, and are not sure where to start? If so, this session is for you. I will assume the attendees have no prior exposure to Azure, and I’ll start at the very beginning – how to create an Azure account, […]

Read the full article →

Stress testing SQL Server (Hillary Cotter)

Monday, October 21, 2013, 6:00 PM to 8:30 PM Topic: How high can we go? Frequently in your career as a DBA you will be asked how much load can your SQL Server support. In this session, SQL Server MVP Hilary Cotter, shows you how to Microsoft tools to stress test your application and determine […]

Read the full article →

A Dive Into Data Quality Services (Steve Simon)

Monday, September 23, 2013, 6:00 PM to 8:30 PM Topic: Data quality and data cleansing have always been major challenges to any enterprise that deals with data. For those of us who have dealt with Data Profiler Tasks in SQL Server 2008, we were shocked yet pleasantly surprised with the great advances that Microsoft has […]

Read the full article →

Big Data – What the heck is it? (Dennis Perlot)

Monday, June 17, 2013, 6:00 PM to 8:30 PM Topic: In this talk, Dennis will cover a number of topics related to Big Data. First we will look at just what is Big Data and the 3 V’s that define it. We will cover the technologies, Microsoft’s and others, in the space and dive into […]

Read the full article →

Development Lifecycle with SQL Server Data Tools (John Flannery)

Monday, May 20, 2013, 6:00 PM to 8:30 PM Topic: We will discuss customization possible with SSDT (templates and snippets) to produce artifacts that conform to your standards. We’ll also look at limits of localdb and strategies to deal with them. Finally – we’ll look at Enterprise deployment strategies. About the Speaker: John is the […]

Read the full article →

T-SQL Enhancements in SQL Server 2012 (Lenni Lobel)

Thursday, April 12, 2012, 6:00 PM to 8:30 PM In this informative and demo-packed session, Lenni will guide you through the T-SQL enhancements in the very latest release of SQL Server. We’ll dive into powerful new windowing enhancements with the OVER clause, new T-SQL functions (all 22 of them!), improved error handling with THROW, server-side […]

Read the full article →

Scaling SQL Server using Service Broker (Hilary Cotter)

Thursday, March 8, 2012, 6:00 PM to 8:30 PM Register Now! Boost the throughput of your SQL Server applications by using Service Broker! Service Broker is a native messaging framework within SQL Server which allows you to scale SQL Server processes, do asynchronous processing, fire and forget processing, inter server processing and to respond to events without continuous polling. […]

Read the full article →

SQL Server Performance: Evaluation of Various Features (Linchi Shea)

Thursday, February 2, 2012, 6:00 PM to 8:30 PM Before you use a new feature with SQL Server, you naturally would wonder about its performance implications. Will it improve or degrade performance, and by how much? You can search on the web for answers, or you can come to this session where we’ll discuss a […]

Read the full article →

Introducing SQL Server Data Tools (Lenni Lobel)

Thursday, January 12, 2012, 6:00 PM to 8:30 PM Get ready for a brand new development environment! With the upcoming release of SQL Server 2012, the new SQL Server Data Tools will serve as your primary development environment for building applications on top of SQL Server. While SQL Server Management Studio (SSMS) continues to serve […]

Read the full article →

Introducing SQL Server 2012 (Kevin S. Goff)

Thursday, December 8, 2011, 6:00 PM to 8:30 PM Presentation Material Have you ever gotten whiplash as you twist your head in fifty directions, trying to research all the new features in a product? In this session, I’ll go through all the new features in SQL Server Denali. I won’t focus excessively on any one […]

Read the full article →

Zoho Creator (Herb Wexler)

Thursday, November 10, 2011, 6:00 PM to 8:30 PM Presentation Material Zoho is a suite of online applications. The company offers apps for just about every conceivable productivity task, from word processing to meeting hosting to calendar tracking, presentations, and accounting. One of the applications is Zoho Creator. With Creator you can build online databases. […]

Read the full article →

Evolved BI with SQL Server “Denali” (Andrew Brust)

Thursday, October 13, 2011, 6:00 PM to 8:30 PM Direct Download SlideShare The next version of SQL Server, code-named “Denali,” steps up Microsoft’s BI game significantly. To start with, PowerPivot’s technology is now part of Analysis Services, in the form of BI Semantic Model (BISM) databases, and there are improvements to PowerPivot itself that everyone […]

Read the full article →

No September SQL Server Meeting

Unfortunately, the speaker we were trying to line up for September’s SQL Server meeting could not make it, and it was cutting it too close to schedule an alternate, so there will be no September SQL Server meeting. We do have speakers lined up for the rest of the year, though. Please keep an eye […]

Read the full article →

SQL Azure & SQL Server Migration and Integration (Bill Zack)

Thursday, July 14, 2011, 6:00 PM to 8:30 PM Download Presentation Material This talk will cover: SQL Server and SQL Azure differences Migration tools Synchronization tools Scaling SQL Azure Over the past three years, Bill Zack has been evangelizing Windows Azure and working with customers and partners to help them design, build and move applications […]

Read the full article →

Intro to PowerPivot and its Analysis Services Roots (Andrew Brust)

Thursday, June 9, 2011, 6:00 PM to 8:30 PM Download Presentation Material Part I: Learn the basics of building and querying a PowerPivot model, and publishing it to SharePoint Part II: Learn about VertiPaq, PowerPivot’s in-memory BI engine, how it works, and how it’s related to SQL Server Analysis Services Part III: Explore how to […]

Read the full article →

Developing Reporting Services Reports Against Analysis Services (Mark Frawley)

Thursday, May 12, 2011, 6:00 PM to 8:30 PM This presentation is primarily aimed at developers already familiar with Reporting Services against non-cube sources, and secondarily at developers familiar with Analysis Services but not Reporting Services.  I will demonstrate using Analysis Services as a report data source, in the process showing how this is in […]

Read the full article →

Using Analysis Services 2005+ as a Source for Reporting Services 2005+ (Mark Frawley)

Thursday, April 14, 2011, 6:00 PM to 8:30 PM Cancelled! We’re really sorry to report that due to illness, Mark Frawley will not be able to present this month, so we need to cancel the meeting. We are working with Mark to reschedule this presentation for a future month. Analysis Services as a multidimensional (cube) […]

Read the full article →

No March 2011 SQL Server Meeting

Sorry, but there will not be a SQL Server user group meeting this March (March 10th), because the school will be closed. We will have April meetings for both SQL Server and .NET.

Read the full article →