SQL Server

Development Lifecycle with SQL Server Data Tools (John Flannery)

in SQL Server

Monday, May 20, 2013, 6:00 PM to 8:30 PM

Register Now!

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 Data Architect at Evolution 1 in Simsbury Connecticut – and Adjunct Professor at Quinnipiac University in Hamden, Connecticut. He has 32 years industry experience; working with SQL server since version 4.2 on OS/2, Oracle since 7.3.4. John holds a Master of Science – Computer Science degree from Rensselaer (1995). John is co-organizer of the Hartford SQL User Group.

{ 0 comments }

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 →

Mysteries of the Query Optimizer (Daniel Buskirk)

Find out why some query plans work so much better than others, and how the SQL Server Query Optimizer goes about finding the best plan for queries.

Read the full article →

Basics of Change Data Capture (CDC) (Kevin S. Goff)

Thursday, October 14, 2010, 6:00 PM to 8:30 PM In this session, Kevin will be conveying an understanding of CDC terminology and configuring a database for Change Data Capture. He will explain how to read CDC log tables, and show CDC code samples. He will discuss CDC and SQL Server Agent jobs, and the use [...]

Read the full article →

SQL Server Performance Analysis: “Why Is It Slow?” (Linchi Shea)

Thursday, September 9, 2010, 6:00 PM to 8:30 PM Why is my query slow? This is the most frequently asked question in virtually all the real-world SQL Server environments, and it is the question any SQL Server professional must be prepared to answer. The presentation does not focus on any specific SQL Server product features, [...]

Read the full article →

High Availability Using SQL Server Failover Clustering (Farzan Ratistari)

Thursday, August 12, 2010, 6:00 PM to 8:30 PM In this session we will discuss high availability using SQL Server 2008 failover clustering and how to setup, and install SQL Server 2008 clusters as well as how to upgrade legacy SQL Server clusters. This session will be complemented with demo. Farzan Ratistari is a Database [...]

Read the full article →

Developing and Testing Databases with Visual Studio 2010 (Andrew Novick)

Thursday, July 8, 2010, 6:00 PM to 8:30 PM Database development has been a hodgepodge of ad hoc techniques from the beginning. The Visual Studio Database Professional Edition, a.k.a. The Data Dude, gives us a new tool for developing and testing databases. Visual Studio 2010 is the third iteration of Data Dude technology and database [...]

Read the full article →

← Previous Entries