Our vision is simple: We enhance Microsoft SQL Server and Microsoft Business Intelligence skills in organisations by providing expert consulting, mentoring and training services.


Books Minimize

Our mentors are constantly involved in book-related projects and in content development. Here are some recent links:

  Author(s)
Title
Description
Itzik Ben-Gan and Dejan Sarka
Inside Microsoft SQL Server 2008: T-SQL Programming
This book cover gives database developers and administrators best practices, expert techniques, and code samples to master the language and solve complex problems with real-world solutions.
Itzik Ben-Gan,Lubor Kollar, Dejan Sarka, Steve Kass
Inside Microsoft SQL Server 2008: T-SQL Querying (Microsoft Press)
This book cover advanced T-SQL querying, query tuning, and programming in Microsoft SQL Server 2008. They are designed for experienced programmers and DBAs who need to write and optimize code in SQL Server 2008.
Peter DeBetta and Dr Mark Whitehorn
Introduction to SQL Server 2008 (Microsoft Press)
Learn about major new features in SQL Server 2008 including security, administration, performance, high availability and business intelligence enhancements.
Alan Hirt
Pro SQL Server 2008 Failover Clustering
This book is dedicated to the planning, implementation, and administration of clustered SQL Server 2008 implementations.
Click here
In conjunction with Microsoft, Ron Talmage led the SolidQ's author team, joined by subject experts Steven Abraham, Pablo Ahumada, Herbert Albert, Larry Barnes, Allan Hirt, Aaron Johal, Dejan Sarka, Antonio Soto, Craig Utley, and Joe Webb.
SQL Server 2008 Upgrade Technical Reference Guide
A successful upgrade to SQL Server 2008 should be smooth and trouble-free. To achieve that smooth transition, you must devote plan sufficiently for the upgrade, and match the complexity of your database application. Otherwise, you risk costly and stressful errors and upgrade problems. Like all IT projects, planning for every contingency and then testing your plan gives you confidence that you will succeed. But if you ignore the planning process, you increase the chances of running into difficulties that can derail and delay your upgrade. This document covers the essential phases and steps involved in upgrading existing SQL Server 2000 and 2005 instances to SQL Server 2008 by using best practices. These include preparation tasks, upgrade tasks, and post-upgrade tasks.

Digital Media Minimize
Author(s) Title
Description
Download Media
Jessica Moss and Rushabh Mehta
Introduction to SQL Server Integration Services
In this session, Jessica and Rushabh will discuss the role that SQL Server Integration Services can play in an organization and in Business Intelligence solutions, and demonstrate the features in Microsoft SQL Server Integration Services. Rushabh will also briefly talk about the new features in SQL Server 2008 Integration Services.
Click here
Peter Myers
Introduction to SQL Server 2008 Reporting Services
In this session, Peter will introduce and demonstrate the upcoming SQL Server 2008 Reporting Services and talk about the new features that will allow organizations to fulfill reporting needs.
Click here
Craig Utley
Avoiding Common Analysis Services Design Problems
Analysis Services enables developers to create powerful cubes, but with this power comes complexity. After working with a wide array of customers, Craig has seen a number of common problems in the design and implementation of cubes. This session will examine some of these common problems and the solutions to them, enabling developers to avoid such issues in their Analysis Services projects.
Click here

Whitepapers Minimize
Author(s) Title
Description
Download Media
Ron Talmage
SQL Server 2008 R2 System Views Map
This handy new Microsoft SQL Server 2008 R2 System Views Map is an invaluable reference. This system views map, shows the key system views included in SQL Server 2008 and 2008 R2 and the relationships between them. ”
Click here
Ron Talmage
SQL Server 2008 R2 Upgrade Guide
The freely downloadable 15-chapter, 490-page guide carries on the rich tradition SolidQ began with the “SQL Server 2005 Upgrade Technical Reference Guide” to provide customers with the real-world information they need to make a smooth and successful move to a new SQL Server version. SolidQ also wrote the “SQL Server 2008 Upgrade Technical Reference Guide.”
Click here
Itzik Ben-Gan
Introduction to New T-SQL Programmability Features in SQL Server 2008
This white paper introduces key new Transact-SQL programmability features in Microsoft SQL Server 2008 as well as SQL/Common Language Runtime (CLR) enhancements. New Transact-SQL features provide improved performance, increased functionality, and enhanced globalization support. Transact-SQL programmability enhancements in SQL Server 2008 address the needs of both OLTP and data warehouse environments.
Click here
Mark Tabladillo
Why Use Microsoft Data Mining?
This white paper provides an introduction to data mining, and defines related terminology. The article provides examples from the daily news of questions that potentially can be answered by data mining, and broadly outlines the approach to creating and deploying data mining solutions in a business.
Click here
Ron Talmage
High Availability and Disaster Recovery at ServiceU: A SQL Server 2008 Technical Case Study
This technical case study shows how we use Windows failover clustering and SQL Server 2008 database mirroring to eliminate single points of failure in our data centers and enable fast recovery from a possible disaster at our primary data center.
Click here
Ron Talmage and Sanjay Mishra from Microsoft
Database Snapshot Performance Considerations Under I/O Intensive Workloads
This white paper summarizes the results of testing database snapshot performance under intense I/O activity on a large database. We measured the impact of creating a single database snapshot and multiple database snapshots under varying transaction loads as well as the performance effect of database snapshots on index creation and rebuild. This white paper provides some best practice recommendations for using database snapshots under I/O-intensive conditions.
Click here

Other publications Minimize
Author(s) Title
Description
Download Media
Itzik Ben-Gan
More SQL Server 2008 T-SQL Improvements
Microsoft SQL Server 2008 provides T-SQL enhancements that improve performance and reliability. Itzik discusses composable DML, the ability to declare and initialize variables in the same statement, compound assignment operators, and more reliable object dependency information.
Click here
Ron Talmage in conjunction with Microsoft
SQL Server 2008 System Views Map
The Microsoft SQL Server 2008 System Views Map shows the key system views included in SQL Server 2008, and the relationships between them. The map is similar to the Microsoft SQL Server 2005 version and includes updates for the new and updated Microsoft SQL Server 2008 features such as resource governor, extended events, full-text search and others.
Click here

Copyright 2012 by SolidQ Australia Pty Ltd Login