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

I found an interesting article by Kalen Delaney aka SQL Goddess (as I call) about a topic stating 'why do people bash Microsoft?'The article was printed in SQL Server Magazine: Last week, I read a post from one of my colleagues, which shared a coworker’s opinion that SQL Server isn't a ''real'' database system. That opinion was actually quite ...

Here is the hot news, SQL Server Global Release Services (GRS) has revised their schedule of releasing Service Packs for SQL Server product by stating 'changed approach to Service Packs'. Now the big question how far you can stretch in deploying these service pack releases within your Enterprise database platform to deploy frequent service pack ...

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

Wow, its almost one year for me to talk about SQL Server Open World! Last year I have given 2 presentations on Effective usage of Database Mirroring & Business Continuity mesaures & practices, blog posts here for a ...

Here is another new year gift from Microsoft for the SQL Server users, specifically for 2005 version - release of SQL Server 2005 Best Practices Analyzer (January 2008). BPA's job is to gather data from Windows and SQL Server configuration settings. There are pre-defined list of SQL Server 2005 recommendations and best practices to determine ...

Fais Your list of steps are simple and clear to follow and I hope you have tested them already. If not for a simulation make sure to go through on a virtual server (non0clustered) to give you more in hand experience. This is required to get a feel of how you are going to manage the upgarde tasks, as it may not be as easy it said, and I would like ...

May 25 2007-  From the snippet of Tibor Karaszi, SQL Server MVP I have raised a feedback form on Connect.Microsoft website to get newer version (SQL Server 2005) about Index Defragmentation Best practices information. Vote your interest to get newer documentation quickly for most of our benefit to attain the performance. Jan 04 2008 - ...

We have most of our database systems on 64-bit environment, but one of the application user asked the question what is the advantage of a 64-bit environment in relation to SQL Server application.  I would say with the evolution of SQL Server 2005 it has opened many more differentiation between 32- and 64-bit editions and bit hard for ...

This will be an interesting news for all the SQL Server users and any conference attendees about Paul Randal & Kimberly, may be you or your friend might have asked one of them whether they are writing a book or have any extracts of their presentation. Paul said: Every time we're at a conference, we get asked whether we're going to ...