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

This is not SQL Server related, more kind of Business Continuity related!  What's the best email management system for your business? What system is the most effective with virtually no downtime and is also easy to manage? Read this white paper to find out. Osterman Research surveyed organizations using Barracuda Spam Firewall, GFI Mail ...

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

Knowledge Base Articles (what I call them as KBA) are very useful to refer and resolve any issues you get on a particular  product. How about searching through the treasure of KBAs in this case? Well here are the links where you can get through the information: KBAlertz - One of the best resource to search for Microsoft products ...

I had a bit problem in opening few of my files on my desktop where I had Office 2003 installation, these files are created using Office 2007 on my laptop. Initially I was bemused to see every time I click on .docx file I had a message saying windows cannot open the file:  Hm, then I have realised that I need ''Microsoft Office ...