SQL Server

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 →

Windows PowerShell for SQL Server DBA (Muthusamy Anantha Kumar)

Thursday, May 13, 2010, 6:00 PM to 8:30 PM This session will demonstrate how Learning Windows PowerShell makes the SQL Server DBAs life easier. It covers Windows PowerShell basics, SQL Server Providers, SQLPS etc. Practical examples walkthrough. Muthusamy Anantha Kumar, a.k.a. MAK, is a Microsoft Certified IT Professional – Database Administrator ( (MCITP: Database Administrator […]

Read the full article →

Discover Cloud Intelligence & BI Automation with SQL Server and CloudOlap (Kevin Ashley)

Thursday, April 8, 2010, 6:00 PM to 8:30 PM We will cover typical SQL Server 2008 business intelligence tasks, and see how business intelligence may be automated with tools and middleware such as RapidOlap throughout the enterprise. We will look at the data warehouse structure, datamarts, automation and load optimization of business intelligence in the […]

Read the full article →

Effective Database Administration with a Central Repository (Linchi Shea)

Thursday, March 11, 2010, 6:00 PM to 8:30 PM Many database administrative tasks, such as monitoring, capacity planning, policy enforcement, best practice checking, are essentially the same across all the databases and the servers. Many more tasks are at an aggregate level, requiring data from individual databases across your enterprise. They include various reporting tasks, […]

Read the full article →

Business Intelligence and the 2009 Microsoft PDC (Christian Holslin)

Thursday, February 11, 2010, 6:00 PM to 8:30 PM Christian Holslin attended the Microsoft 2009 Professional Developers Conference last year in November and learned a great deal about the current business intelligence features in SQL Server 2008 and some of the up-and-coming features in R2. This session seeks to educate its audience about the breadth […]

Read the full article →

Designing SQL Server Indexes for Query Performance (Daniel Buskirk)

Thursday, January 14, 2010, 6:00 PM to 8:30 PM Indexes are your “silver bullet” for good query performance, but there are many tricks and traps. We’ll look at the physical structure of an SQL Server index and how the optimizer decides to use, or not use, a particular index for a particular query. With that […]

Read the full article →

Self-Service Business Intelligence with Microsoft Gemini (Andrew Brust)

Thursday, October 8, 2009, 6:00 PM to 9:00 PM Ever wonder why there’s no “light” version of SQL Server Analysis Services (SSAS)?  Find yourself wishing that SSAS offered an in-memory operation model akin to some of its competitors?  And why are OLAP cubes nearly impossible for end-users to build while comparable capabilities have existed for […]

Read the full article →