Download SQL Server 2008 SP1

Download SQL Server 2008 SP1.

SQL Server 2008 Service Pack 1 (SP1) is now available. You can use these packages to upgrade any SQL Server 2008 edition.

Note: Microsoft remain committed to their plans to keep service packs contained, focusing on essential updates only, primarily a Roll-up of Cumulative Update 1 to 3, Quick Fix Engineering (QFE) updates, as well as fixes to issues reported through the SQL Server community. While keeping product changes contained, Microsoft have made significant investments to ease deployment and management of Service Packs:

Slipstream - You are now able to integrate the base installation with service packs (or Hotfixes) and install in a single step.

Service Pack Uninstall - You are now able to uninstall only the Service Pack (without removing the whole instance)

Report Builder 2.0 Click Once capability

For more information about SQL Server 2008 Service Pack 1, please review the Release Notes.

Download SQL Server 2008 SP1.

Microsoft SQL Server 2008 Books Online (July 2009)

Download SQLServer2008_BOL_Aug2009.msi

Download the documentation and tutorials for Microsoft SQL Server 2008.

SQL Server 2008, the latest release of Microsoft SQL Server, provides a comprehensive data platform. Books Online is the primary documentation for SQL Server 2008.

Books Online includes the following types of information:

• Setup and upgrade instructions.


• Information about new features and backward compatibility.


• Conceptual descriptions of the technologies and features in SQL Server 2008.


• Procedural topics describing how to use the various features in SQL Server 2008.


• Tutorials that guide you through common tasks.


• Reference documentation for the graphical tools, command prompt utilities, programming languages, and application programming interfaces (APIs) that are supported by SQL Server 2008.


• Descriptions of the sample databases and applications that are available with SQL Server 2008. You can download the sample databases from the SQL Server Community Projects and Samples page on CodePlex.

NOTE: Non-English installs of Books Online may encounter minor issues. To address these issues try rerunning the installation.

Download SQLServer2008_BOL_Aug2009.msi

Filter the EventLog Entries thru C# Code

To Read & Write Event Log thru C#, System.Diagnostics.EventLog class will help. When we read from Eventlog, the following code will helps

EventLog EvLog = new EventLog("Application", ".");
foreach (System.Diagnostics.EventLogEntry entry in EvLog.Entries)
{
.....
}

This code will read all the Entries from Event Log, here there is no option to filter the entries of Event log.To implement the filter on the Eventlog, we have to check the value one by one in the for each loop, as given below

foreach (System.Diagnostics.EventLogEntry entry in EvLog.Entries)
{
if (entry.TimeWritten > DateTime.Now.AddDays(-1))
{
.....
}
}

If the list of entries are more in the Event log, then this is not proper way. It will leads to performance issue.To avoid this, we can use WMI Query Language. this Query Language is same as SQL Query structure, we can filter the data in the same way of SQL.

Win32_NTLogEvent is a WMI class which is used to translate instances from the Windowsevent log.

Have a look at the following sample code, (written in C# and windows application)

string SomeDateTime = "20090817000000.000000+000";
string Query = String.Format("SELECT * FROM Win32_NTLogEvent WHERE Logfile = 'Application' AND TimeGenerated > '{0}'", SomeDateTime);

ManagementObjectSearcher mos = new ManagementObjectSearcher(Query);
object o;
foreach (ManagementObject mo in mos.Get())
{
foreach (PropertyData pd in mo.Properties)
{
o = mo[pd.Name];
if (o != null)
{
listBox1.Items.Add(String.Format("{0}: {1}", pd.Name,mo[pd.Name].ToString()));
}
}
listBox1.Items.Add("---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
}

In this sample code, we are using following Query

SELECT * FROM Win32_NTLogEvent WHERE Logfile = 'Application' AND TimeGenerated > 20090817000000.000000+000

This query will fetch the data from Application Log, where the log created on or after 17-Aug-2008This is code display the filtered output in listbox control as shown below

SQL Server Driver for PHP 1.1 - Preview

Version 1.1 of the SQL Server Driver for PHP is under development. A community technology preview is now available for you to evaluate. Refer to the documentation that is installed with the driver for a description of the new features in this release. The SQL Server Driver for PHP download is available to all SQL Server users at no additional charge. The SQL Server Driver for PHP is a PHP 5 extension that allows for the reading and writing of SQL Server data from within PHP scripts. The extension provides a procedural interface for accessing data in all editions of SQL Server 2005 and SQL Server 2008.

Peer-to-peer support is available in the SQL Server Driver for PHP forum. To submit feedback on this release, visit the SQL Server Feedback Center.

Download SQLServerDriverForPHP.EXE

Windows Azure Platform Training Kit - August Update

Download WindowsAzurePlatformKitAugust2009.exe

The Windows Azure Platform Training Kit includes a comprehensive set of technical content including hands-on labs, presentations, and demos that are designed to help you learn how to use the Windows Azure platform including: Windows Azure, SQL Azure and .NET Services. The August release includes the following content:

Presentations

• Azure Platform Overview


• What is Windows Azure?


• Windows Azure Storage Overview


• Introduction to Windows Azure


• Building Services using Windows Azure


• Introduction to SQL Azure


• Building Applications using SQL Azure


• Scaling Out with SQL Azure


• Introduction to .NET Services


• Building Applications Using the .NET Service Bus

Demos

• Deploying Windows Azure Services


• Hello Windows Azure


• Windows Azure Guestbook Demo


• Windows Azure Logging and Configuration Demo


• Windows Azure using Blobs Demo


• Windows Azure Worker Role Demo


• Windows Azure Using Queues Demoo


• Windows Azure Using Tables Demo


• Preparing your SQL Azure Account


• Connecting to SQL Azure


• Managing Logins and Security in SQL Azure


• Creating Objects in SQL Azure


• Migrating a Database Schema to SQL Azure


• Moving Data Into and Out Of SQL Azure using SSIS


• Building a Simple SQL Azure App


• Scaling Out SQL Azure with Database Sharding


• .NET Services Service Bus Direct Connection Demo


• .NET Services Service Bus webHttpRelayBinding


• .NET Services Service Bus Publish and Subscribe


• .NET Services Service Registry


• .NET Services Service Bus NetOneWayRelayBinding

Hands On Labs

• Building Windows Azure Services


• Windows Azure Native Code


• Windows Azure and PHP


• Getting Started with Windows Azure Storage


• Using Windows Azure Tables


• Building ASP.NET MVC Applications with Windows Azure


• Building ASP.NET Web Form Applications with Windows Azure


• Migrating Applications to Windows Azure


• Introduction to SQL Azure


• Migrating Databases to SQL Azure


• Building Your First SQL Azure App


• Introduction to the .NET Service Bus


• Building Hybrid Applications

Samples and Tools

• Windows Azure MMC


• PhluffyFotos


• Bid Now


• Contoso Cycles

System Requirements :
Supported Operating Systems: Windows Server 2008; Windows Vista; Windows Vista Service Pack 1, .NET Framework 3.5 SP1,Visual Studio 2008 SP1 ,Windows Powershell

Download WindowsAzurePlatformKitAugust2009.exe

Read Event Log using C#

The Following sample code helps to Read Data from Event Log. This is a sample windows application written by using C#.

In the following sample code, I used 2 controls, Listbox and EventLog Controls.

Set the Log Property of Eventlog control to name of the log to read or write. I selected System Log to test this code

In the Form Load Event, I written the following code,

foreach (System.Diagnostics.EventLogEntry entry in eventLog1.Entries)
{
listBox1.Items.Add(entry.EntryType.ToString() + " - " + entry.TimeWritten + " - " + entry.Source + " - " + entry.UserName);
}

This code, read the Data from Log file and written display in to listbox control.

Now if run the code, it will display as shown in screen shot

Risk and Health Assessment Program for Microsoft SQL Server – Scoping Tool v1.1

Risk and Health Assessment Program includes all of the scoping tools necessary to prepare and qualify your environment to receive a Risk and Health Assessment Program for Microsoft SQL Server.

Note: This download package is intended for Microsoft Premier Customers Only.

Download SQLRAPScoping.zip

SQL Server Reporting Services (SSRS) Report - Fix for Firefox

When SQL Server Reporting Services (SSRS) Report is viewed in Report viewer control in Firefox Browser, it won't display properly. But the same report displays properly in IE.

Have a look at the following sample report in Firefox and IE.

Reports in Firefox:

In Firefox, report is not displayed in full size, instead of that, it displays minimal size, but IE shows proper size

Reports in IE:

Reason is, Browser displays SSRS report data thru IFrame. In Firefox, the IFRAME's height defaults to a few hundred pixels, so that you can see the top 2 inches of the report. In IE, IFrames automatically fixed to Data height, so it works fine in IE.

To Fix the Issue in Firefox, hope any one the following 2 ways will help us.

Step1:

1. Go to the following Location, where SQL Server is installed
..\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\Pages

2. Open ReportViewer.aspx File

3. add the style property marked in bold and blue color, Then try this
style="display:table; margin: 0px; overflow: hidden" ID="ReportViewerControl" runat="server" />

If not Helps the first step, then try the step 2.

Step2:

ADD the following code to the ReportingServices.css file (by default, it's found in "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\Styles\"):

.DocMapAndReportFrame{ min-height: 860px;}

If you want Width also, then use this code

.DocMapAndReportFrame
{
min-height: 860px;
min-width: 1000px;
}

Put this code at bottom of the ReportingServices.css file. After you added this code, Close your browser and clear your cookies then try again

Visual Studio 2008 Service Pack 1 ATL for Smart Devices Security Update

security issue has been identified that could allow an attacker to compromise your Windows-based system with Visual Studio 2008 Service Pack 1 and gain complete control over it. You can help protect your computer by installing this update from Microsoft.

Note: This is available in Microsoft Update also

Download VS90SP1-KB973675-x86.exe

No template information found - Visual Studio

When I'm trying to create a new project in Visual Studio, I got the following Error Message.

"No template information found. See the application log in Event Viewer for more details. To open Event Viewer, click Start, click Control Panel, double-click Administrative Tools, and then double-click Event Viewer."

Then I checked My Event Viewer, here i found a warning message logged by Visual Studio Application with following description.

The global template information is out of date. Regenerate the templates by running 'devenv.exe /installvstemplates' or reinstalling the application. Note: corrective action requires Administrator privileges.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

To Fix My Error, I run the command devenv.exe /installvstemplates thru command prompt, as suggested in the Log. It helps me to fix my problem. Now i can able to create a projects thru Visual studio.

Hope it helps you too. still if you face the same problem, then you've to re install the application

Microsoft SQL Server protocol documentation - Download

The Microsoft SQL Server protocol documentation provides detailed technical specifications for Microsoft proprietary protocols (including extensions to industry-standard or other published protocols) that are implemented and used in Microsoft SQL Server 2008 to interoperate or communicate with Microsoft products.

The documentation includes a set of companion overview and reference documents that supplement the technical specifications with conceptual background, overviews of inter-protocol relationships and interactions, and technical reference information.

Download Microsoft SQL Server Protocol Documentation

Find All Tables and its Count from a Database

The Following Query Helps you to list out all the table available in a database along with it’s(table’s) count

select object_name(id) as Table_Name, rowcnt as Rows_count

from sysindexes WHERE id in (select OBJECT_ID(table_name) from information_schema.tables) AND

indid < 2

Have a look at the sample result of this Query:

Microsoft Silverlight 3 Offline Documentation

This package contains the developer documentation for Silverlight 3.

This document provides complete reference of the followings

• .NET Framework Class Library for Silverlight


• Silverlight Overview


• Getting started Silverlight


• Application and Programming Models


• Layout, Text and Input


• Controls


• Graphics, Animation and Media


• XAML


• Integrating Silverlight with webpage


• Types, Properties, Methods, and Events


• Data Access and Data Structures


• Networking and Communication


• Debugging, Error Handling, and Exceptions


• Deployment and Localization


• Performance


• Security


• General Reference information related to Silverlight.

Download Silverlight_Docs_7_28_09.zip

Visual Studio 2008 Service Pack 1 ATL Security Update

A security issue has been identified that could allow an attacker to compromise your Windows-based system with Visual Studio 2008 Service Pack 1 and gain complete control over it. You can help protect your computer by installing this update from Microsoft. Download security update from the followinh link, or you can get it thru Microsoft update as well

Download VS90SP1-KB971092-x86.exe

Microsoft SQL Server 2005 SP3 Release Notes

The Microsoft SQL Server 2005 Service Pack 3 (SP3) Release Notes describe known issues that you should read about before you install or troubleshoot SQL Server 2005 SP3. These release notes provide important information that you should know before deploying and using SQL Server 2005 SP3. You should familiarize yourself with all the known issues in this document before you install the software.

Download ReleaseNotesSQL2005SP3.htm