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

Here is the list of information which is a Technical Rollup email we receive from TRM team. The list is ongoing and I have outlined the important ones that I feel and fits for 'generic' SQL Server environment. Make sure to review, download, test and apply to your production environment.  SQL Server 2008 Report Builder 2.0 ...

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

You may be aware that or seen within your Database platform about slower disk performance than expect having multiple disks in Windows Server 2003 environment when you use a hardware-based redundant array of independent disks (RAID) or a software-based RAID. This could be due to one of the reasons such as starting location of partition is ...

You may be aware that Database Mirroring is an important High Availability [HA] option available within SQL Server 2005 version. Having this HA option within your Sharepoint farm where the databases are associated to failover, then you must note few issues that might crop up in this case. Also you should be cautious when you have reporting ...

Can I rename an instance of SQL Server after I have already installed it on the computer?  Simple answer is Yes and you can change the name of an instance as long as the server is not clustered. There is a little catch between 2000 and 2005 version, by default when you change the name of the computer that is running SQL 2000 version, the ...

Sometime ago I have blogged about MSDN labs- SQL Server Virtual Labs - fully featured virtual environment for testing! and I recommend and encourage all of my users to use Virtual labs and webcasts - use them for a better practice on product. Similar to this fashion recently I have been using the labs to get better understanding on how to ...

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

No doubt that as compare to previous version the current SQL Server 2005 provides more new language constructs and primitives for the T-SQL language than can be utilized. Still there are many out there not entirely ready to upgrade from SQL Server 2000 to 2005. In this case you can take few advantages of SQL 2005 by keeping the user databases in ...