SQL Server

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 without knowing it.

I will be covering the following topics in this presentation.

1 – Maintaining the ACID quality of transactions.
2 – How SQL Server implements transaction durability?
3 – System versus User transactions
4 – Transaction basics
5 – Exploring the various transaction modes
6 – Exclusive versus Shared locks
7 – Blocking versus Deadlocks
8 – How to detect them with my free code.
9 – How Isolation levels affect transaction behavior.
10 – What is a dirty read versus a phantom read?

At the end of the talk, you will know how to fix the above scenario by changing the isolation level.

Speaker Bio:
I have twenty years of data processing and proven project management experience, specializing in the banking, health care, and government areas. My architecture expertise encompasses all phases of the project life cycle, including design, development, implementation, and maintenance of systems.

My credentials include a Masters degree in Computer Science from the University of Rhode Island with concentrations in database technologies and programming languages. I also have Microsoft Certificates for Database Administration (MCDBA) and System Admistration (MCSA).

John is currently a Senior SQL Developer in charge of Data Acquisition and Total Quality Management reporting for Sensata Technologies – Mechanization systems department. The underlying systems use the SQL Server 2008 R2 and Oracle 11i for housing data. When he is not busy informing the members of current events at a local PASS chapter, he spends time with his wife and daughter enjoying outdoor activities.

{ 0 comments }

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 →

Data in the Cloud (Peter Laudati)

Thursday, February 10, 2011, 6:00 PM to 8:30 PM When people talk about migrating their applications to the cloud, one of the primary topics discussed is storage.  How is the data stored?!  The Windows Azure platform offers different storage options, including SQL Azure for relational data.  As you’ll see in tonight’s talk, it’s pretty easy […]

Read the full article →

SQL Server 2008 Audit (Linchi Shea)

Thursday, January 13, 2011, 6:00 PM to 8:30 PM Download Presentation Material SQL Server 2008 introduced a richer and much less resource intensive feature for auditing all aspects of SQL Server. Unlike with the previous versions, SQL Server Audit liberates you from SQL Trace or SQL Profiler in your database auditing endeavour. In addition to helping meeting regulatory compliance […]

Read the full article →