Another set of Cumulative Update package is ready for review on SQL Server 2008 - this package contains hotfixes for the issues that have been fixed since the release of SQL Server 2008. Earlier posting on Cumulative Update Package 1 for SQL 2008 one...

How many tools do you (need/use0 to monitor the performance of your SQL Server instance(s)? Well, I'm not asking any count on the x number of tools you require to monitor the SQL Server instances within your environment, and Performance Tuning using...

TechNet Webcast: SQL Server 2008 (Part 3 of 3): Integrate Growing Data Volumes (Level 300) Attend this session to learn how to integrate growing volumes of data with the new enhancements in Microsoft SQL Server 2008. We cover new technologies, like Change...

In continuation to the SQL2008-InstallationVows on Windows Server 2008 there was a brief notes on pre-requisite of Visual Studio 2008 Service Pack when you are trying to install the SQL setup. The release notes were bit confusing that you have got with...

From the blog of Technical Rollup mail that we receive from Microsoft here is the list of SQL Server Migration Assistant tools available from Microsoft to migrate/upgrade data from other data sources such as Access, Sybase & Oracle. _________________________________________________________________________________________________________________________...

Within the IT organisations it has been a huge expansion of increased challenges with regard to number of office locations and keep up the data consistent across the Enterprise. Travelling around the globe is a olden day myth and now even by sitting at...

See this exciting news release at Tech-ed Developers week conference on Microsoft Project Codename "Velocity" and Sync Framework News information....( read more ) Read More...

DMV - has got very special place for DBAs since the inception of SQL Server 2005. In this case one of the thme is very important to find out the index statistics within your database, such as sys.dm_db_index_physical_stats statement. Recently one of the...

Have you looked at the Activity Monitor screen within the Managment Studio? I feel this is somewhat surprise features included from February CTP (or was it there before?). This is more useful to the DBAs to have a look at resource activity and locking...

You all might know this SQL-HomePage would take you to the SQL Server webpages on Microsoft and now with recent launch 2008 wave another new site created specific to SQL Server 2008, which is SQL-Server-2008 . Nothing major difference here as the first...

As blogged here before Virtual Labs are very handy for the new users and existing professionals to test out new features without disturbing their own platform. In this scenario Microsoft events are helping the users by providing access to their virtual...

How many SQL Server licenses you need to fix the number of CPUs on the server? The answer it depends on the number! Well having hyper-threading (i.e. multiple threads execute on a single physical CPU appearing as 2 logical CPUs) and dual-core technology...

How many SQL Server licenses you need to fix the number of CPUs on the server? The answer it depends on the number! Well having hyper-threading (i.e. multiple threads execute on a single physical CPU appearing as 2 logical CPUs) and dual-core technology...

Its nearly 90 days from SQL Server 2008 November CTP and as per the CTP release cycle (90 days) the next instalment of SQL 2008 may be ready by end of this month. I feel that may be the last one before the RTM or as per the communication from Microsoft...

You all know that it is a best practice to use the schema qualified tables or views for the better management and performance (sometimes). As the Best Practices Analyzer tool which will be a part of SQL engine from 2008 version onwards confirms that this...

Use the following TSQL SELECT SERVERPROPERTY('Collation') Collation, SERVERPROPERTY('Edition') Edition, SERVERPROPERTY('Engine Edition') EngineEdition, SERVERPROPERTY('InstanceName') InstanceName, SERVERPROPERTY('IsClustered'...

Using SELECT @@VERSION statement you can get simply get information of SQL Server you are running , when connected to that SQL Server instance. What if to know same for the Analysis Services components, we don't have such an easy way to find out!...

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...

JDBC driver for SQL Server is not part of the Java SDK. To set the classpath to include the sqljdbc.jar file if you want to use it. The sqljdbc.jar file is installed in the following location: < installation directory >\sqljdbc_< version >...

No doubt that as compare to previous version the current SQL Server 2005 provides more new language constructs and primitives for the T-SQL language than can be utilized. Still there are many out there not entirely ready to upgrade from SQL Server 2000...