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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
02-08-2008
Filed under: sql server, management, microsoft, bi, data mining, labs, development, testing, business intelligence, links, operation guide
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
12-19-2007
Filed under: sql server, package, management, microsoft, server, windows, best practices, 2008, consolidation, planning, x64, 2005, advantages, policies
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...
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"...
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
07-25-2007
Filed under: sql server, performance, management, memory, microsoft, security, server, windows, awe, /3gb, pae
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...
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
05-18-2007
Filed under: sql server, management, microsoft, ssis, security, ssas, ssms, ssrs, search, anti-virus, kba
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...
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...