PASS AppDev Presents: SQL Server Indexing

  • Article

While indexing traditionally has been the concern of the DBA, it's important for developers to understand both the usefulness and the impact of indexes in your relational database. With the right indexes your application will perform like a Formula One racer, without them performance will better resemble a Model T. This presentation will explain how indexes work, what options are available to you in SQL Server 2008, and how to tune your application and your database for the best performance.By Allen White, 2/9/2010, 1:00EST


584 reads

SQL Server Consolidation : how to decide on the right approach

  • Article

The PASS DBA VC hosts this session today that will focus on helping to choose between using a virtualization, instance, or database consolidation option. We will highlight a few of the key areas to consider as well as some of the important differentiators to keep in mind. We will provide a decision tree to help guide administrators through the process of selecting a consolidation option.

1 (3)


1,101 reads

What Do We Want from PASS?

  • Article

With the election of the Board of Directors complete for 2009, Steve Jones takes a step back to examine what we might want from a professional organization. If you care about having an organization for SQL Server professionals, read this and let us know if you agree or disagree.


531 reads


VMworld 2020 – Top 10 Database Sessions (Part 1)


Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...

Daily Coping 24 Sep 2020


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

VMworld 2020 SQL Server session preview


Join me, David Klee, Microsoft Data Platform MVP and VMware vExpert, for a preview...

Read the latest Blogs


Polybase and HA

By Admingod

I am planning for HA environment and we are using Polybase and would like...

Where do I start from ?

By Corobori

Following with a user complain about SQL timeout I bumped into one issue with...

Function Code

By sizal0234

Hi, I have a fn with below code I want to understand the highlighted...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers