SqlServer-QA.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 Data Capture and MERGE SQL statement, in addition to scalability improvements in SQL ...

Ok its time to update your local copies of SQL Server 2008 Books OnLine (BOL) too, as we have RTM version in hand. You may have installed it during CTP releases and even during short-time of RC0 release, but as always it is a good practice to update as the current installation is latest and updated. MSDN Developer Center page provides wide range ...

As you may be aware all the Technical information roll-up on MSDN & Technet is sent out in email format, in this regard I wanted to share the important and interested links for you on SQL Server arena. Downloads   Source Code Analyzer for SQL Injection Microsoft Source Code Analyzer for SQL Injection is a static code analysis tool for ...

Have you ever wondered about flushing databases? Well not quite possible to flush it straight away and not a best practice too on the live server, so what it is about and you need to know about transactions state when they occur. Say when the changes occur in a database the changes are formed as transactions that are held in buffer pool ...

Microsoft has rolled out new program called - Empower Program that will enable the ISVs to receive software, support and additional resources designed to help you lower your development costs, test your software and speed your solution's time-to-market. Jason from MSFT/SSP quoted about this program as follows:    Empower ...

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

Re-organizing or rebuilding index would help the SQL optimizer to reduce the fragmentation for a better performance. In this case few users might have doubt that when to rebuild or reorganize (SQL Server 2005)? IN the series of Performance blog posts here I would like to suggest - How to Detect Table Fragmentation in SQL Server 2000 and ...

Usage of Temporary tables or variables is a common scenario in SQL Server world, since SQL Server 2005 usage of TEMPDB references to the blog posts here: http://sqlserver-qa.net/blogs/tools/archive/2007/04/05/sql-server-index-optimization-best-practices.aspx, ...

Got this update from SQLCAT blog on MSDN about new whitepaper on Analysis Services many-to-many dimensions that helps in MDX query performance  optimization steps you need to take care. Many-to-many dimension relationships in SQL Server 2005 Analysis Services (SSAS) enable you to easily model complex source schemas and provide great ...

What I like within the SQL Server Reporting Services is using RDL for own formatted reports, as this gives you the complete freedom to build your own reporting designer tool, if you are not experienced in using Visual Studio based report designer or crystal reports. So the benefit of beginners in Reporting Services I would like to refer the ...