Browse by Tags

MSDN & Technet webcast for SQL Server 2008 and SQL Server Compact 3.5 versions

Published 3 September 8 4:4 PM | SSQA.net

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

Filed under: sql server, msdn, webcast, microsoft, technet, community, version, best practices, comact

New versions new website - I am specific to SQL Server

Published 29 February 8 7:14 AM | SSQA.net

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

Filed under: sql server, microsoft, version, new, learning, website, links, launch

BI Virtual labs on MSDN - specific to data mining and top 10 classed in Tech-ed.

Published 26 February 8 4:45 AM | SSQA.net

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

Filed under: sql server, performance, microsoft, technet, data mining, version, virtual, labs, 2005, loading

SQL Server license with multi-core CPU technology, confusing concepts?

Published 20 February 8 2:47 AM | SSQA.net

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

Filed under: sql server, performance, microsoft, version, article, license, 2005, cpu, monitoring, administrator, value, costing

SQL Server licensing with having multi-core CPU technology, confusing concepts?

Published 19 February 8 2:47 AM | SSQA.net

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

Filed under: sql server, performance, microsoft, version, article, license, 2005, cpu, monitoring, administrator, value, costing

When is next CTP instalment of SQL Server 2008 set to released?

Published 14 February 8 1:27 AM | SSQA.net

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

Filed under: sql server, microsoft, download, version, 2008, ctp, install, whatsnew

How to find which version of Analysis Services you are running?

Published 5 November 7 11:54 PM | SSQA.net

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!...

Filed under: sql server, databases, microsoft, integration, ssis, ssas, version, Analysis Services

Behaviour of SP_READERRORLOG in SQL 2000 and 2005

Published 22 May 7 3:3 AM | SSQA.net

You may be aware that SP_READERRORLOG can be used from a query analyzer or query editor to read the error log contents without opening the file on the disk or from Management Studio (or Enterprise Manager). I'm not sure whether you have observed that...

Filed under: sql server, microsoft, error, read, log, version, BOL, documentation