Saturday, January 22, 2011

SQL SERVER 2008 Business Inteligence Training


If you are new to SQL Server 2008 & interested to learn BI then here is a golden opportunity for each individual. Microsoft has released SQL Server 2008 R2 Developers Training kit that contains Free training course designed for developers on SQL Server 2008 R2.

The highlights of this newly added BI course containing demos, presentations and hands on labs, is as shown below:
  • Build Your First Microsoft BI Solution with SQL Server 2008 R2
  • Introduction to BI Modeling Techniques
  • Introduction to SQL Server 2008 R2 Integration Services
  • Introduction to SQL Server 2008 R2 Reporting Services
  • Publishing and Accessing SQL Server 2008 R2 Reporting Services Reports
  • Introduction to SQL Server 2008 R2 Analysis Services
  • Introduction to SQL Server 2008 R2 Analysis Services Query Syntax
  • Accessing SQL Server 2008 R2 Analysis Services Data
  • Introduction to SharePoint 2010 PerformancePoint Services
  • Introduction to Data Mining with SQL Server 2008 R2 Analysis Services
  • Introduction to Self-Service Reporting and Analysis with SQL Server 2008 R2
Apart from the new BI course stated above, the training kit also contains many other demos, HOL and presentations to understand SQL Server 2008 and SQL Server 2008 R2 improvements from a developer perspective. It’s a great free asset for someone who wants to learn SQL Server 2008 R2 at his/her own pace.



Friday, January 21, 2011

Download SQL Server Statistics Ebook


If you are big fan of SQL Server and want to understand Statistics deeply, Download ebook on SQL Server Statistics by Holger Schmeling.

There are 2 chapters which explain a lot of things on statistics, like

  • Queries, Damned Queries and Statistics
  • Statistics and execution plan generation
  • Obtaining information about statistics
  • General organization of statistics
  • A more detailed look at the utilization of statistics
  • Statistics generation and maintenance
  • Creation of statistics
  • Updating statistics
  • SQL Server Statistics: Problems and Solutions
  • Memory allocation problems
  •  etc....

Click here to visit Red-Gate website & download it.

Happy Learning


Thursday, January 20, 2011


SQL Server core concepts
View this entire SQL Server course and more in the Online Training Library®.

Free SQL Training [ SQL Server 2008 Essential Training ]

Hi Guys,

If you want to learn SQL Server, attend this SQL training [SQL Server 2008 Essential Training].

Topics include:
• SQL Server core concepts
• Post-installation checks
• Introduction to SQL Server Books Online
• Planning your database
• Data types in SQL Server
• Introduction to relationships and foreign keys
• Monitoring database size and integrity
• Creating backups
• Introduction to SQL Server Reporting Services

It's limited time offer, PDF version:
Free Download:

Register here



Tuesday, January 18, 2011

SSWUG Free Expo Event: SQL Server Performance Monitoring and Tuning


SSWUG.ORG’s organized a virtual expo that provide attendees with tips, tools and information to dramatically tune and monitor performance of SQL Server 2005 and 2008.

Sessions will cover the following topics:
  • SQL Statement Tuning with Indexing Strategies
  • Performance Tuning SQL Server Integration Services (SSIS)
  • Use DMVs to Monitor and Diagnose Performance Issues With High Volume OTLP Workloads
  • Using Resource Governor in SQL Server 2008
Here we can learn how to investigate tuning and monitoring techniques involving indexing strategies, SQL Server Integration Services (SSIS), Dynamic Management Views (DMVs) and Resource Governor. In-depth video explanations of the material is also given.

Click here to view details

This is extremely helpful.



5 Leverage Points for SQL Server Performance and Management

Hi, has come up with a session on 5 Leverage Points for SQL Server Performance and Management. Watch this session Stephen Wynkoop discuss about SQL Server Performance Management with Scott Walz.

Here is the agenda of the session:

When used wisely, there are five critical leverage points where SQL Server DBAs and Developers can reap disproportionally large gains in both productivity and SQL Server performance. During this lively conversation with real world examples, Stephen Wynkoop and Scott Walz will discuss the 5 leverage points every DBA and Developer needs to focus on to increase SQL Server Performance and Manageability.

The Five Leverage Points Just one example of what Stephen and Scott will demonstrate around each leverage point:
Object management How to reverse engineer objects in seconds and place them within a project framework
Managing database change from development through productionHow identifying database change doesn’t have to be like finding a needle in a haystack
Optimizing SQL through the use of Visual SQL Tuning (VST) DiagramsHow you can now do in minutes what used to take hours or days
Identify the “what if” scenarios and see their impact on database performanceHow to identify “what if” scenarios and load test them BEFORE promoting to production
Managing upgrades and multiple versions of SQL ServerHow to boost performance and productivity across all versions of SQL Server

You’ll also learn the one thing you should NEVER do as a SQL Server database professional. Both Stephen and Scott have seen veterans and novices alike make this mistake.

Click Here to view it.

Hopefully it will be useful.