Free eBooks for Microsoft SQL Server 2008 R2 and Visual Studio 2010

If you are a Dynamics CRM developer, you most likely utilize Microsoft SQL Server and Microsoft Visual Studio. Reading about the numerous enhancements and additions made to Microsoft SQL Server 2008 R2 and Visual Studio 2010 Professional will have a positive impact on the applications you design. If you would like to expand your knowledge of either of these products, we have located some free resources for your enjoyment.

Introducing Microsoft SQL Server 2008 R2 by Ross Mistry and Stacia Misner contains 10 chapters spanning 216 pages. This eBook highlights the capabilities of SQL Server 2008 R2. The material in this eBook is intended for readers with some familiarity with SQL Server. The eBook is available in two forms, “Introducing Microsoft SQL Server 2008 R2 (in PDF)” and “Introducing Microsoft SQL Server 2008 R2 (in XPS)”. Please encourage Microsoft to continue producing free eBooks by downloading Introducing Microsoft SQL Server 2008 R2 via these links so they can count readership.

Moving to Microsoft Visual Studio 2010 by Patrice Pelland and Pascal Paré is a 10-chapter eBook as well, spanning 336 pages. This book is for developers using prior versions of Visual Studio who are looking to upgrade to Visual Studio 2010 Professional. The eBook is available in two forms, “Moving to Microsoft Visual Studio 2010 (in PDF)” and “Moving to Microsoft Visual Studio 2010 (in XPS)”. As mentioned above, let’s all use these links so Microsoft can count readership and keep giving us free eBooks.

Summaries of the content of each eBook below:

Introducing Microsoft SQL Server 2008 R2

Part I: “Database Administration”
This part introduces readers to several of the innovations in SQL Server 2008 R2. It contains five chapters, which include step-by-step instructions, optimal upgrade strategies, and explanations of visual tools like dashboards.

  • Chapter 1: SQL Server 2008 R2 Editions and Enhancements
  • Chapter 2: Multi-Server Administration
  • Chapter 3: Data-Tier Applications
  • Chapter 4: High Availability and Virtualization Enhancements
  • Chapter 5: Consolidation and Monitoring

Part II: “Business Intelligence Development”
This part covers new components to the SQL Server data platform. It also goes over the significant enhancements that have been made to the reporting component of the platform.

  • Chapter 6: Scalable Data Warehousing
  • Chapter 7: Master Data Services
  • Chapter 8: Complex Event Processing with StreamInsight
  • Chapter 9: Reporting Services Enhancements
  • Chapter 10: Self-Service Analysis with PowerPivot

Moving to Microsoft Visual Studio 2010

Divided into three parts, Moving to Microsoft Visual Studio 2010 is written from the perspective of a developer upgrading from an older version of Visual Studio to Visual Studio 2010 Professional. To maintain a sense of continuity and consistency, the authors walk through the steps of building and running a real application that requires a wide array of the product features. The application is called Plan My Night, and is recreated in each part of the eBook. The three parts are similar, each addressing a different earlier version of Visual Studio. You’ll only need to read the part about the version you use.

Part I: “Moving from Microsoft Visual Studio 2003 to Visual Studio 2010”

  • Chapter 1: From 2003 to 2010: Business Logic and Data
  • Chapter 2: From 2003 to 2010: Designing the Look and Feel
  • Chapter 3: From 2003 to 2010: Debugging an Application
  • Chapter 4: From 2003 to 2010: Deploying an Application

Part II: “Moving from Microsoft Visual Studio 2005 to Visual Studio 2010”

  • Chapter 1: From 2005 to 2010: Business Logic and Data
  • Chapter 2: From 2005 to 2010: Designing the Look and Feel
  • Chapter 3: From 2005 to 2010: Debugging an Application

Part III: “Moving from Microsoft Visual Studio 2008 to Visual Studio 2010”

  • Chapter 1: From 2008 to 2010: Business Logic and Data
  • Chapter 2: From 2008 to 2010: Designing the Look and Feel
  • Chapter 3: From 2008 to 2010: Debugging an Application

Read More

Microsoft Dynamics CRM 4.0: Displaying more than 50 records per page

Displaying more than 50 Records per Page

This is for the list view for Microsoft Dynamics CRM 4.0.

  • 1. Dynamics CRM for Outlook: Click CRM from the top menu.
  • Web Version: Click Tools from the top menu
  • 2. From the drop down menu click Options


  • 3. Select the number of records you would like to display. Click OK

Please note that this is per user. The maximum records that can be displayed is 250. You can increase the number of records beyond 250  through SQL but it is unsupported. The value is stored in the PagingLimit column of the user settings base table.  It can be updated to whatever value you want. It would be wise to set it back to a value from the drop down lists  before editing a user’s settings, or upgrading CRM


Read More

CRM Checklist

 Here is a brief but useful list of questions to consider when comparing the merits of hosted versus on-premise CRM implementations:


How quickly are you looking to deploy a CRM solution?

What is your total CRM budget?

Do you have the in-house IT resources to support an on-premise solution?

What kind of customization are you expecting from your CRM application?

Can you securely manage in-house datacenters?

Will your company be growing, say over the next five years?

Are you targeting top customers effectively?

How quickly are you responding to new customer inquiries?

How could your salespeople be better managing customer relations?

How can you improve your customer-support services and retention activities?

How easily can you generate reports?


To read more, click here

Read More

Shortcut Keys for Microsoft Dynamics CRM 4.0

Everybody is always looking for quicker ways to get things accomplished.  Shortcut keys always help. Here are few for Microsoft Dynamics CRM 4.0:

Function Shortcut
Copy  CTRL C
Paste CTRL V
Save and Close ALT S
Close CTRL F4
Delete without attaching to clipboard SHIFT DELETE
Move insertion point to start of next word CTRL RIGHT ARROW
Move insertion point to start of previous word CTRL LEFT ARROW
Display shortcut menu for selected item SHIFT F10
Close selected list/dialouge box ESC
Move up a list of records UP ARROW
Move down a list of records DOWN ARROW
Expand/Collapse preview in a list view SPACEBAR
Open selected record ENTER
Select all records on current page CTRL A
Move to next option TAB
Move to previous option SHIFT TAB
Cancel a command ESC
Delete a record CTRL D
Save and New CTRL SHIFT S

Read More

Streamline Solutions to Showcase Microsoft CRM Solution at the NAB Show on April 18-23 in Las Vegas, Nevada

Every year, a global community of media and entertainment professionals who are passionate about creating the next generation of audio, video and filmed content come together at the NAB Show. We are going to be showcasing our Microsoft CRM solution for the entertainment industry, focusing on Microsoft CRM as a rapid development platform, plus digital rights management and intelligence resource management.

From post-production to television distribution, this is an industry rife with complex tracking and operational needs that are best served by a unified platform. Streamline Solutions has delivered a number of high-profile, very effective Microsoft CRM implementations that have dramatically increased the efficiency and operational methods of some major corporations.

Make sure to visit us at the Microsoft Pavilion! If you are interested in attending this exciting event yourself, register here. Also, if you want more information about our Microsoft CRM solutions and how they can help your business, click here

Read More

Microsoft CRM – Convergence News – 1 week away!

There is still time to register for Convergence in New Orleans, LA. Convergence has always been a great place for our customers, partners and team members to share ideas, build skills and develop relationships.
We have a value packed four days including:
• Executive speakers Kirill Tatarinov, Kevin Schofield, and Chris Caren
• Eight general sessions that will provide you with insight to the current overall product strategy, as well as a peek into the future
• A new Business Leadership track with content designed for visionary business leaders who are challenged by managing a business and looking to share, learn and grow by discussing with others in the same situation. Sessions will be delivered by executives from Microsoft, our customer community as well as industry analysts
• 253 concurrent sessions where you’ll learn detailed tips and tricks on the software and processes you use, as well as new knowledge for your specific business needs
• 110 interactive discussions which are your opportunity to discuss and interact with Microsoft subject matter experts and other Convergence attendees around a specific Microsoft Dynamics topic
• 52 hands-on labs to try your hand at new technology
• Over 190 sponsors and exhibitors in our Expo & Microsoft Pavilion
• Not to mention abundant networking opportunities in the Community & Learning Center and at evening events
The Power of Possibilities are endless!

Convergence 2009

Read More

CrmDiagTool4 for Microsoft CRM 4.0 has been released

So, what does the tool in v4 do?

Microsoft CRM Server

 Enable/Disable Platform tracing, Zip the trace folder for you if needed.
 Enable/Disable DevErrors
 Generate Machine Report
NB: These 3 actions are now separated clearly, the Platform Tracing and DevErrors facilities shows now the current status of the option dynamically.

 Microsoft SRS Data Connector
 Generate Machine Report
 Microsoft CRM E-Mail Router
 Generate Machine Report
 (Next version will add tracing for the Email service as well.)

Learn more about the tool, and download from here

Read More