Virtual Lab for Data Tier Applications in SQL Server 2008 R2 and Visual Studio 2010

 

Today I found the virtual lab for Data Tier Applications in SQL Server 2008 R2 and Visual Studio 2010 on the Teched 2011 – Pre Event website. So thought to share with you all.

Following is the link to Virtual Lab: https://cmg.vlabcenter.com/default.aspx?moduleid=4961fec7-46a4-42d3-b37d-f1f3b1112ee1

Note: Before you proceed with the virtual Lab , be sure to check the system requirement link available on the same link.

Check current Isolation level in SQL Server

Often we wanted to know the current isolation level set for the SQL Server database. This can be easily checked with the following DBCC command.

DBCC USEROPTIONS;

This command returns the SET options active/configured for the current connection.

Result:

How to get the list of all the databases in SQL Server

To get the list of all the databases in SQL Server use the following system stored procedure

exec sp_databases;

Result:

DATABASE_NAME	DATABASE_SIZE	REMARKS
master	5120	NULL
model	2816	NULL
msdb	11264	NULL
ReportServer$SQL2008DEV	10240	NULL
ReportServer$SQL2008DEVTempDB	3072	NULL
SQLThreads	4096	NULL
tempdb	8704	NULL

Alternatively you can also use SQL Query as given below.

SELECT * FROM sys.databases;

Download Free E-Book - Introducing Microsoft SQL Server 2008 R2

Dear Readers, today I came across a very good Free eBook on SQL Server 2008 R2. This a free ebook from Microsoft and you can download it from here – Introducing Microsoft SQL Server 2008 R2

The book contains following chapters

1. SQL Server 2008 R2 Editions and Enhancements
2. Multi-Server Administration
3. Data-Tier Applications
4. High Availability and Virtualization Enhancements
5. Consolidation and Monitoring
6. Scalable Data Warehousing
7. Master Data Services
8. Complex Event Processing with StreamInsight
9. Reporting Services Enhancements
10. Self-Service Analysis with PowerPivot

Happy Learning !!!

Download SQL Server 2008 R2 Guide

The SQL Server 2008 R2 Guide provides key information and resources on evaluating the product,installation instructions and a guided tour. This seems to be very useful document as it gives quick information SQL Server 2008 R2 capabilities.

Download the document here

Download SQL Server 2008 R2 Developers Training Kit (April 2010 Update)

Dear Readers,

We now have the SQL Server 2008 R2 Developers Training Kit update – April 2010 and it is available for download at :http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=fffaad6a-0153-4d41-b289-a3ed1d637c0d

The training kit offers the following benefits:

• Learn how to build applications that exploit the unique features and capabilities of SQL Server 2008 and SQL Server 2008 R2.
• Provides a comprehensive set of videos, presentations, demos and hands-on labs
• Contains new content for developers who are new to SQL Server.
• Contains new content for SQL Server 2008 R2.
• Contains all of the existing content from the SQL Server 2008 Developer Training Kit.
• Easy to download and install.

Please visit the above mentioned link for more information on the updated Training Kit.

Happy Learning !!!