Browse by Tags

SQL Server Web Edition - What is this new edition?

Published 26 September 8 2:27 AM | SqlServer-QA.net

If you remember about editions of SQL Server from 2000 onwards you will see Enterprise, Standard, Personal & Desktop Edition (MSDE) and when it comes to 2005 version Enterprise, Standard, Workgroup, Express & Express Advanced Services. So what's...

Filed under: sql server, high availability, web, data mining, intelligence, reporting services, business intelligence, integration services, data warehouse, scalability, editions

SQL Server BI - Managing Large Datawarehouse environment, guidelines

Published 17 September 8 3:24 AM | SqlServer-QA.net

What will be the main challenge for a DBA/User to manage a large Data Warehouse (DW) environment, size does matter and also think about downtime you need to deploy whenever any patches are required. Before that you need to be perfect or well-versed with...

Filed under: sql server, performance, management, databases, reporting, business intelligence, data warehouse, readonly

SQL Server Business Intelligence - handling data mining and mission critical applications

Published 22 July 8 4:31 AM | SSQA.net

Data, data and data everywhere: a typical scenario for an Enterprise DBA to handle the mission critical applications and comprehensive information across the organization using SQL Server technologies. Since the inception of SQL Server 2005 version Business...

Filed under: sql server, microsoft, data mining, learning, business intelligence, data providers

SQL Server Reporting Services: Resources and information - all in one place

Published 13 May 8 3:30 AM | SSQA.net

During a conference few users asked about resources and information to go through the Reporting Services, as it is a general assumption from the end-user community that referring to Books Online aka BOL doesn't get them anywhere. I always recommend...

Filed under: sql server, performance, reporting services, resources, information, books online, business intelligence, troubleshooting

New and Modified Knowledge Base article for SQL Server 2005 Reporting Services

Published 8 May 8 3:31 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: The hatch patterns are not consistent for all the groups between the legend and the data in a chart in a SQL Server...

Filed under: sql server, report builder, kba, object, .NET, reporting services, sap, business intelligence, character, data provider, null, parentNode

SQL Server Business Intelligence - adopt sustainable practices on ETL processes with SSIS

Published 24 April 8 6:14 AM | SSQA.net

Making best use of SQL Server Integration Services within your ETL processes is a flexible choice, which has a huge share within the Business Intelligence application platform. You may be aware that SSIS introduces several new and enhanced features and...

Filed under: sql server, ssis, ssas, ssrs, machine, bids, etl, administrator, biztalk, business intelligence, adapter

SQL Server BI and Performance Point Server 2007 - good match

Published 13 March 8 5:10 AM | SSQA.net

Another tool within BI platform to use when you have the huge farm of Analysis Services data warehousing & mining database setup at your end. So the provision of BI within SQL Server 2005 is a complete enterprise-ready and scalable data warehouse...

Filed under: sql server, management, webcast, bi, tools, reporting services, elearning, performancepoint, business intelligence, 2007, training, office

SQL Server 2008 BI enahncements - what you want is what you get!

Published 25 February 8 2:49 PM | SSQA.net

So far the SQL Server 2008 Analysis Services new features were included until October CTP, top features that Microsoft would like to include within RTM version: New Aggregation designer - to browse and modify aggregation designs that are now shown grouped...

Filed under: sql server, performance, ssis, bi, ssrs, 2008, new, reporting services, enhancement, samples, business intelligence, integration services

SQL Server OLAP - back to basics for Cube access from front-end application?

Published 11 February 8 3:38 AM | SSQA.net

One of the [SSP] forum user asked about what is OLAP, how the process flow occurrs when update happens to a fact table! It sounds like the basic question for Analysis Services user, OLAP - On-Line Analytical Processing for BI - Business Intelligence is...

Filed under: sql server, technet, bi, olap, dimension, table, whitepaper, cube, business intelligence, architecture, fact, what if

What is Business Intelligence? How to obtain complete tools suite to test?

Published 8 February 8 12:11 PM | SSQA.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...

Filed under: sql server, management, microsoft, bi, data mining, labs, development, testing, business intelligence, links, operation guide

SQL Server 2008 November CTP 5 - next instalment is available

Published 20 November 7 2:49 AM | SSQA.net

Here comes another instalment of SQL Server 2008 for the CTP fans. The SQL Server 2008 November CTP has been released to the connect.microsoft.com website and is available for download here . One of the improvements in this build is the ability to persist...

Filed under: sql server, microsoft, community, 2008, connect, spatial, best practice, business intelligence, filestream, ctp5

Business Intelligence & Application Platform Virtual Conference

Published 18 September 7 3:9 AM | SSQA.net

Business Intelligence & Application Platform Virtual Conference Thursday, October 4, 2007 - Online Event Learn How IT Can Drive Business Solutions Is your IT organization in lock step with your business leaders? To stay competitive, IT leaders are...

Filed under: sql server, webcast, microsoft, bi, event, business intelligence

Other blogs we recommend

Published 12 September 7 5:22 AM | SSQA.net

Today I have started a new section here "Other Blogs we recommend" to roll the blog posts from SQL Server Experts such as Kalen Delaney, Kimberley Tripp, Bob Beauchemin and Paul Randall that I follow regularly. Until now I used to blog roll...

Filed under: business continuity, sql server, msdn, high availability, blog, kalen, business intelligence, kimberly