Thursday, December 30, 2010

A few end of 2010 SQL BI thoughts

This blog tell us what happned and what will happen to SQL Server in 2010 and in 2011.

good one.

Friday, December 24, 2010

Top 9 New Features of SQL Server "Denali"

Denali still in her early age, but lots of talkings are around about her features.

This article tells you top 9 features of Denail

SQL Scripts Manager,Powerful, reliable, automated scripting by SQL Server experts, for the community

SQL Scripts Manager is a free tool that brings together must–have scripts from expert DBAs, SQL Server MVPs, and Red Gate developers to enable you to automate common troubleshooting, diagnostic, and maintenance tasks.

Get more info about the tool from here

Microsoft SQL Server 2005 Service Pack 4 RTM

Service Pack 4 (SP4) for Microsoft SQL Server 2005 is now available for download. SQL Server 2005 service packs are cumulative, and this service pack upgrades all service levels of SQL Server 2005 to SP4 .

SQL Server 2005 SP4 includes SQL Server 2005 SP3 cumulative update 1 to 11, customer requested fixes, along with instances of the SQL Server 2005 SP4 database Engine support for DAC operations.

For a list of the bugs that are fixed in SQL Server 2005 Service Pack 4 (SP4), see KB article 2463332. No new features or major changes were added to SP4.

Tuesday, December 14, 2010

Companies Have More SQL Server Databases than Oracle Databases

According to Embarcadero Technologies’ Database Survey Report, 83 percent of respondents are running SQL Server in their database environment. Oracle came in second with 76.6 percent of respondents saying they have Oracle databases inhouse.

The Database Survey Report revealed many other interesting facts, so I recommend taking a look at the full report. Are you and your company in line with what the survey reported or does your environment buck the trend

Thursday, December 9, 2010

SQL Server 2008 R2 System Views Map

The Microsoft SQL Server 2008 R2 System Views Map shows the key system views included in Microsoft SQL Server 2008 and SQL Server 2008 R2, and the relationships between them. The map is similar to the Microsoft SQL Server 2008 version and includes updates which are also applicable for the Microsoft SQL Server 2008.

Download from here