SqlServer-QA.net

Here is the advisory guidelines email from Microsoft Security that I would like to share: Microsoft is aware of public exploit code released that impacts customers using Internet Explorer 6. Customers using Internet Explorer 8 are not affected by currently known attacks and exploits due to the improved security protections in IE8.  To ...

List of upcoming MSDN webcasts on SQL Server 2008 R2 (StreamInsight) and SQLAzure platform.: MSDN Webcast: Overview of SQL Server StreamInsight (Level 200) Wednesday, December 02, 2009 1:00 PM Pacific Time (US & Canada) In this webcast, we explore how you can build event-driven applications to gain insight from high data rate event stream ...

If you remember about SQL Server 2005 installation & feature documentation SQL-DMO has been referred as backward compatibility, and that feature will be removed in a future version of SQL Server. So the documentation has been heavy on users to avoid using this feature in new development work, and plan to modify applications that currently ...

It is a public news on the availability of the first community technology preview (CTP) of SQL Server 2008 R2 for MSDN and TechNet subscribers, including the general availability. So what's new with SQL Server 2008 R2? To find out that you need to download the CTP which provides the first opportunity to explore the features of R2 ...

As a part of Microsoft MVP programme every now and then set of email communication will be received from MVP leads (thanks to Akim & Vicki). Most of them are already available/posted on MSDN & Technet blogs by MSFT professionals and for few of them I'm keen to blog on here too. Being I'm an IT PRO I would like to share the ...

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