SqlServer-QA.net

Business Intelligence (BI) - is the new term from Microsoft for all Data Warehousing & Data Mining requirement since the SQL Server 2005 version is released. Say many organization face challenges with the Data Explode, this BI offers management and development tools for IT department and Business segment within your organization with ...

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

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

Last week I have been delegated to finalize the security standards within a set of SQL 2005 instances that are used by a customer, though it is usual chores for me to apply industry best practices. On these SQL 2005 instances in particular I was more keen on applying ''disabling SA account''! I was confronted by a Database developer that  ...

You might have come across a situation to have a better understanding on what /3GB or /PAE switch means that are referred in documentations and forums you go on. I will try my best to give you the notes what I have understood so far in this regard. From the available documentation on Technet & MSDN it is pretty informative that ...

As most of blogs in this section travels through usage of Dynamic Management Views (DMV) & Dynamic Management Functions (DMF) I have had an email asking What is DMV & DMF and how to find list of them from a SQL Server instance. The internal mechanism of DMV is totally relies on calls to a set of Dynamic Link Libraries that ...

Another common question in the forums asking about what are the best practices for using antivirus software on servers running SQL Server. In my experience if your SQL Server is not a internet-faced one then no need to have one installed on a SQL Server that is dedicated to databases, rather tighten the access on the file access and share on ...

Red-Gate software limitied has released another useful tool for the DBAs, SQL Backup that has impact of what a metamorphosis it has undergone! Many of you will know SQL Backup for its high performance  in creating and encrypting backups. The performance in SQL Backup 5 has improved still further, with multiple threads now available ...

Microsoft is investing a lot to help the Business Intelligence (BI) platform users with the content and get acquaintance to the platform. You are aware BI includes SQL Server Analysis Services, Integration Services and Reporting Services, you can get to know by referring to the media presentation and learn about the enhanced features since the ...

As you are aware SSIS is a newest technology within SQL 2005 version that has various enhanced features from its pre-decessor DTS. I believe still there is a little help available on Web for the users that are having genuine issues with SSIS installations, ofcourse BOL (SQL 2005 books online) has the content but not exactly what an user is ...