Feed on
Posts
Comments

Archive for the ‘SQL Download’ Category

Organizations across the globe are being inundated with regulatory requirements. They also have a strong need to better manage their IT systems to ensure they are operating efficiently and staying secure. Microsoft is often asked to provide guidance and technology to assist organizations struggling with compliance. The SQL Server 2008 Compliance Guidance white paper was [...]

Read Full Post »

Yesterday I wrote about SQLAuthority News - Download RML Utilities for SQL Server. I received many emails where different developers requested how to find additional help regarding RML Utilities. Few users reported that they are not able to install RML Utilities because of some reporting service pre-requisite.
If RML Utilities are not being installed due to [...]

Read Full Post »

The RML utilities allow you to process SQL Server trace files and view reports showing how SQL Server is performing. For example, you can quickly see:
Which application, database or login is using the most resources, and which queries are responsible for that
Whether there were any plan changes for a batch during the time when the [...]

Read Full Post »

SQL Server 2008 Books Online is updated on 31 October 2008. I always bookmark latest BOL for my easy reference.
Getting Started: New and Updated Topics (31 October 2008)
Analysis Services - Multidimensional Data: New and Updated Topics (31 October 2008)
Database Engine: New and Updated Topics (31 October 2008)
Integration Services: New and Updated Topics (31 October 2008)
Analysis [...]

Read Full Post »

It was not possible to connect SQL Server 2008 to Visual Studio 2005 so far. Microsoft has released Service Pack once it is installed SQL Server 2008 can be connected to Visual Studio 2005.
Download Microsoft Visual Studio 2005 Service Pack 1 Update for Microsoft SQL Server 2008 Support
For connecting SQL Server 2008 to Visual Studio [...]

Read Full Post »

Microsoft has published following three security related white papers. I suggest to all my readers to read them. Read the summary know what is covered in thoseĀ  white papers.

Engine Separation of Duties for the Application Developer - Separation of duties is an important consideration for databases and database applications. By properly defining schemas and roles, [...]

Read Full Post »

The SQL Server Management Pack provides the capabilities for Operations Manager 2007 to discover SQL Server 2000, 2005 and 2008 installations and components and to monitor them, primarily from the perspective of availability and performance. The availability and performance monitoring is done using a combination of scripts and native Operations Manager capabilities.

Feature Bullet Summary:
The following [...]

Read Full Post »

The CTP version of SQL Server 2005 Service Pack 3 (SP3) is now available. You can use these packages to upgrade any of the following SQL Server 2005 editions:

Enterprise
Enterprise Evaluation
Developer
Standard
Workgroup

For a summary list of What’s new in SQL Server 2005 SP3 CTP, review the What’s New document.
These packages have been made available for general testing [...]

Read Full Post »

Microsoft ADOMD.NET
ADOMD.NET is a Microsoft .NET Framework object model that enables software developers to create client-side applications that browse metadata and query data stored in Microsoft SQL Server 2008 Analysis Services. ADOMD.NET is a Microsoft ADO.NET provider with enhancements for online analytical processing (OLAP) and data mining.
Microsoft Analysis Management Objects
Analysis Management Objects (AMO) is a [...]

Read Full Post »

Recently I have got many many request for SQL Server Interview Questions and Answers as well related articles. It seems many people are looking for Job or appearing for interview at this time of the year. I have included list of the my top downloads in side bar of the blog, still I receive many [...]

Read Full Post »

Hyper-V in Windows Server 2008 is a powerful virtualization technology that can be used by corporate IT to consolidate under-utilized servers, lowering TCO and maintaining or improving Quality of Service. Through a series of test scenarios that are representative of SQL Server application fundamentals, this document provides best practice recommendations on running SQL Server in [...]

Read Full Post »

Download the 2008 Feature Pack for Microsoft SQL Server 2008, a collection of stand-alone install packages that provide additional value for SQL Server 2008.
The Feature Pack is a collection of stand-alone install packages that provide additional value for SQL Server 2008. It includes the latest versions of:

Redistributable components for SQL Server 2008.
Add-on providers for SQL [...]

Read Full Post »

I previously wrote article SQL SERVER - 2008 - Fix Connection Error with Visual Studio 2008 - Server Version is not supported where I discussed how downloading Visual Studio SP1 will fix the error of Visual Studio 2008 connecting to SQL Server 2008. I have provided link to SP1 which was downloading only installer and [...]

Read Full Post »

Cumulative update package 1 for SQL Server 2008 is released.
Click on link : http://support.microsoft.com/kb/956717/en-us
Update : I have received few emails where developer did not find where to click on the support page to download the update package. Following image describes the link which is on very top of the page.

Reference : Pinal Dave (http://www.SQLAuthority.com)

Read Full Post »

In addition to providing support for SQL Server 2008 database projects, this release incorporates many previously released Power Tools as well as several new features. The new features include distinct Build and Deploy phases, Static Code Analysis and improved integration with SQL CLR projects. Database Edition no longer requires a Design Database. Therefore, it is [...]

Read Full Post »

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 [...]

Read Full Post »

Very frequently I have been asked to create a page, post or article where in one page all the important concepts of SQL Server are covered. SQL Server 2008 is very large subject and can not be even covered 1000 of pages. In daily life of DBA there are few commands very frequently used and [...]

Read Full Post »

Developers who are using SQL Server Service Pack 2 must install this security patch for it. A security issue has been identified in the SQL Server 2005 Service Pack 2 that could allow an attacker to compromise your system and gain control over it. You can help protect your computer by installing this update from [...]

Read Full Post »

SQL SERVER - Guidelines and Coding Standards complete List Download
Coding standards and guidelines are very important for any developer on the path of successful career. A coding standard is a set of guidelines, rules and regulations on how to write code. Coding standards should be flexible enough or should take care of the situation where [...]

Read Full Post »

On September 20, 2008 was one of the best day so far for Ahmedabad SQL Server User Group Meeting. We had two very interesting sessions by two SQL Server MVPs. SQL Server MVP Jacob Sebastian had began the meeting with very interesting introduction note.
Along with many news Usergroup President Jacob Sebastian announced that SQL Server [...]

Read Full Post »

Older Posts »