SqlServer-QA.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 is not easy decision for User Community to apply with CU than going Service Pack release which ...

I'm a keen follower of trying out new versions & products (IT), in this regard recently installed Internet Explorer 8 which is under Beta 1 at the moment. The referred link will already noted the known issues and workarounds, but not an easy out way to find to uninstall the installed version. Before that what I would like to give a ...

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 for relevant blogs & Technical articles from Microsoft to get more understanding on this ...

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 per the schedule. Also you may be aware about 'postponement' of SQL Server  2008 version release ...

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 security for your systems.  

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 version which is usage of VARDECIMAL with having table-level ...

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). Then it comes what kind of practice you should deploy in order to obtain the ...

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 for all service pack updates aka they call it now as a software update packages for ...

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), now here it comes another wait episode for cumulative update package 5 for SQL Server 2005 ...

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?  DLINQ?  XLINQ?''  Hands-On labs for LINQ MSDN-Blog featured ...