Browse by Tags

Cumulative Update 7 available for SQL Server 2005 SP2 - get it now to test and apply (if needed)

Published 15 April 8 3:58 PM | SSQA.net

Here is another candidate of 7 within Cumulative Update service for SQL Server 2005 SP2. SQL Server Release Services team has announced (yesterday) that another instalment of Cumulative Update ( series here ) for SQL Server 2005 on Service Pack 2, it...

Filed under: sql server, microsoft, blogs, download, kba, service pack, cumulative update, downgrade, cu7, affected, releases

Various blog links for sharepoint and office products

Published 19 March 8 7:32 AM | SSQA.net

Though I'm an expert within SQL Server arena, sometimes I find it bit difficult when the sharepoint database are involved with an added flavour of performance issues within this farm. So in this regard recently I have been searching through the web...

Filed under: sql server, microsoft, blogs, sharepoint, resources, links

Few hours to go for Windows Server, Visual Studio and SQL Server 2008 launch, here is big deal on SQL release date!

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

I have been following Dan Jones's blog on " Launch_T-1 , Launch_T-3 & Launch_T-5 " series about SQL Server Launch in US (PST), as a Development Program Manager they have huge task ahead to complete and its not that easy to manage as...

Filed under: sql server, msdn, microsoft, blogs, 2008, 2005, visual studio, launch, windows server, product release

Security best practices - personally & technically

Published 26 January 8 8:12 AM | SSQA.net

See this awesome post about how best you can adopt security and beaware about which is right and which is wrong Avoiding the bad guys - detecting potentially malicious advertising campaigns that is applicable on both personal security & techinical...

Filed under: business continuity, sql server, microsoft, blogs, integration, security

SQL Server 2005 Cumulative Update 5 for Service Pack 2 - available for download with a request to CSS!

Published 24 December 7 4:42 AM | SSQA.net

From the series of the SQL Server 2005 Service Pack2 Cumulative Update packages blogs and for instance we blogged about SQL2005SP2CU5 earlier, it is available to download now and before that there is a catch to obtain this package. It is not that easy...

Filed under: sql server, package, msdn, microsoft, blogs, support, service pack2, testing, online, cumulative update, pss, css, installallation

SQL Server 2008 Data Compression, what it is - how does it work?

Published 3 December 7 7:54 AM | SSQA.net

As you know data compression facility is added onto the SQL Server 2008 version, though this is not a new feature and I would call it as an enhanced feature in SQL Server. This subject of data compression has already been introduced in SQL Server 2005...

Filed under: sql server, performance, microsoft, blogs, security, 2008, ctp, data capture, 2005, compress, data compression

SQL Server: How do I identify the queries that are worth tuning?

Published 16 November 7 7:2 AM | SSQA.net

Have you ever asked this question about how do I identify the queries that worth tuning? The simple answer it is neither easy or hard to obtain such information if you have managed your SQL Server by deploying industry best practices (wherever possible...

Filed under: sql server, performance, management, microsoft, blogs, technet, dmv, dba, best practice, slow query

How to find whether that service pack file is a 32 bit or 64 bit?

Published 1 November 7 6:44 AM | SSQA.net

Whenever a service pack is released it will be available for 32-bit and 64-bit that also includes for SQL Express 2005 edition too, as it was for MSDE earlier. Since last year (I think) Microsoft Development team has adopted a standard in naming schema...

Filed under: sql server, msdn, microsoft, blogs, technet, download, kba, best practices, x64, testing, begin

Here it goes again - cumulative update package 5 for SQL Server Service Pack 2?

Published 23 October 7 4:23 PM | SSQA.net

If you remember we have blogged about release of Cumulative Update 4 for SQL Server Service Pack 2 since it has been declared to be available on download, CUpdate4-SQL2005SP2 is the one I'm referring. So is it is available for download (released recently...

Filed under: sql server, package, microsoft, blogs, download, service pack2, servicing model, cumulative update

Learn LINQ in relation to TSQL, Orcas and many more

Published 25 July 7 5:4 AM | SSQA.net

In continuation to my post on Linq-TSQL I was drowing on web to know more about LINQ and how-to in relation to TSQL. Here comes the resources I have used and using so far in getting information about LINQ: First, MSDNForum link on "What is LINQ?...

Filed under: microsoft, blogs, linq, location, tsql, learning, backups

Recover the corupt databases with the features in backup & restore - SQL Server 2005

Published 6 May 7 4:50 AM | SqlServer-QA.net (SSQA)

Have you ever wondered you can recover a corrupted database when you have optimum backup & restore strategy in place, well I'm not talking about usage of third party tools or use high-end hardware. With simple backup and restore features in SQL...

Filed under: sql server, msdn, microsoft, high availability, backup, blogs