Suggest: Want a SQL Server Session?

As an Evangelist I get an opportunity to do a variety of sessions for the India sub and I am sure I would have met quite a few of you who read my post via the events channel. As much as I try to keep the sessions content loaded, I would like to take this opportunity to also solicit your views on what will be your top 5 session requests. In otherwords, what would be the sessions that will help YOU in your day-today activities(SQL2005) and help YOU prep-up on future products(SQL2008).

What I want from you -

  • Categorize as SQL Server 2005 and SQL Server 2008 topics
  • Your session requests can be on various tracks like: SQL Administration, SQL Standards, SQL Developer, SQL Data Modelling, SQL Scripting, SQL Performance, SQL Tuning, SQL BI, Data Warehousing, VLDB, High Availability, Security, Data Loading, Best practices etc

Now you can see I have tons of ideas and variety of sessions that I want to take on various tracks. But if YOU had to priortize and suggest which would be those 5 topics on SQL 2005 and Top 5 on SQL 2008 - Which ones would they be?

You can drop a comment on this post or you can drop me a line on ITPro[at]ExtremeExperts.com and I will consolidate it as part of this post.

Lastly, you have my commitment and I will surely *try* to address them during the course of this year.

Published 28 April 2008 04:24 AM by vinodkumar
Filed under: , ,

Comments

# Ambati Sreedhar said on 23 April, 2008 09:17 PM

Hi Vinod,

I want a session which explains all the new features came in BI and Sqlserver. That session should be from you not from others.They may not understood what a developer wants better than you.

Thanks

Sreedhar A

# Viking said on 24 April, 2008 02:57 AM

How about capacity planning - CPU, for a new application db running on SQL Server 2005?

# Simi Sreedharan said on 25 April, 2008 01:16 AM

Hi,

I would like to have a session on SQL Performance and tuning. Also interested in  BI.

Thanks

Simi Sreedharan

# George said on 26 April, 2008 08:39 PM

Hi Vinod,

I woudl like a session on Data Warehousing in SQL Server 2008.

# Kusuma said on 28 April, 2008 01:03 AM

Please provide the information on How to  work on SQL.

Regards,

Kusuma

# Manod said on 28 April, 2008 02:54 AM

SQL Server vitualisation in production

thanks,

Manod

# vinodkumar said on 28 April, 2008 09:45 AM

Thanks for the comments. Is this ALL that you folks want? I thought there will be a biggg list of topics for this post :) ... Keep those comments flowing people. Request you to pass the word and let your friends also vote their requests.

Vinod Kumar

# TrackBack said on 28 April, 2008 09:49 AM
# TrackBack said on 28 April, 2008 09:51 AM
# TrackBack said on 28 April, 2008 09:51 AM
# TrackBack said on 29 April, 2008 01:19 AM
# Deepa said on 29 April, 2008 01:41 AM

My interest is in following topics.

Administration

Performance & Tuning

BI

# Phani said on 30 April, 2008 04:39 AM

I would like to have the following topics

1) VLDB

2) Best practices Performance tuning

3) Table partitioning and its role in application performance

4) High Availability

5) Security

# Navaneeth said on 05 May, 2008 04:01 AM

Hi Vinod,

I would like to see a session on SQL server internals like

1 - Query processing

2 - Query executions

3 - Caching and execution plans

And anything which speeks internal working of SQL server.

Thanks

# Nirmal said on 16 May, 2008 06:20 AM

Hi Vinod

I would like to see a session on

BI and Data Warehousing

Thanks

Nirmal

# Ashok said on 18 May, 2008 01:36 AM

Here is the rough list prepared quickly :o)

Database without SQL

Features and Enhancement in both SQL Server 2K5 and 2K8

- Major features & Editions

- Introducing SQL Server Management Studio

Overview of Performance Tuning and Glance to SQL Server Admin Activities

Secuirty Features

- SQL Injections and how to prevent

- Data Encryption

- Groups Roles, Rights and Permissions

Replication

Backup and Restore

Queries

Important Operators

Important Functions

Usage Multiple clauses

Complex Queries

Joins (types of and costs)

Unions and it's costs. How to replace them with joins (kind of refactoring for performance)

Indexes: How it works internally and the Right candidates of the table.

Views & When to use them

Sub Queries and it's Costs

Dynamic Queries and Procedures and Injection Patterns

T-SQL PROGRAMMING:

- Study of Programming Constructs

- T-SQL Enhancements in 2K5 and 2K8

- Stored Procedures

- Scalar & Functions Table Valued Functions

- Error Handling and Structured Error Handling using TRY-CATCH

- Execution Contexts

- Indepth Details on DDL and DML triggers

XML Programming Features

CLR Integration of .NET in SQL 2K5 and 2K8 and it's power. You can call a webservice even oooopch

Notification Services

Job Scheduling

Uisng Service Broker

Undertand and using SSIS - SSAS - SSRS

Using SQL Profiler

Query Tuning

Debugging and Traciing of the SQL Server Programmable objects like Stores Procs, Functions, Triggers

How to Refactor (replace query with view etc. spplit big query into small managemble)

the SQL Objects to tune the application deisign

Thanks

Ashok

Search

Go

This Blog

Tags

Community

Archives

My Web Site

External Sites

Other Misc Blog Links

Newsletter

Syndication

News


  • Disclaimer: The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

    Site Counter: Hit Counter

    My tree at Carbon Grove