Email Alerts
-
SQL Server 2012 Guide
SQL Server 2012 Guide
-
DAX formulas expand BI’s reach in PowerPivot
Data Analysis Expressions (DAX) in PowerPivot lets users work with large data sets and perform sophisticated analytics in Excel. Learn to use DAX formulas to create calculated columns and measures. Feature
-
Take BI up a notch with SQL Azure Reporting
Microsoft’s cloud-based SQL Azure Reporting lets companies publish and view reports without having to maintain hardware. Get an overview of the service, now in a community technology preview. Feature
-
Microsoft’s ‘big data’ push targets familiar products, new capabilities
In this interview, Microsoft executive Mark Kromer discusses newly unveiled Microsoft ‘big data’ features and products announced at last month’s PASS Summit 2011. SQL in Five
-
Sound policy key to data quality management in Microsoft PowerPivot
Microsoft PowerPivot lets users do data analysis without IT’s help, but too much access can pose serious data quality management issues. Feature
-
Three tips for tweaking SQL Server’s SharePoint performance
Trying to get Microsoft SQL Server to play nice with SharePoint? Get some expert advice on improving SQL Server-SharePoint performance. Feature
-
Blend Microsoft SQL Server, SharePoint, Office for ‘BI lite’
A business intelligence (BI) suite isn’t the only delivery system for BI insight. Get some expert advice and blend Microsoft SQL Server, SharePoint, Office for your own DIY system. Feature
-
As Microsoft’s SQL Azure gains altitude, industry eyes chances of reign
As independent software vendors begin to roll out core business systems on Microsoft SQL Azure cloud service, larger enterprises are slower to migrate. Feature
-
Baffled by decision-support systems for SQL Server? You’re not alone
Many looking into decision-support systems for SQL Server are overwhelmed with choices -- BI system? Data warehouse? In-memory analytics? Get expert advice on what is what. Feature
-
SQL Server Denali on its way, Microsoft shares insights on upgrades
With the SQL Server Denali release date still down the road, would it do businesses any good to upgrade? Microsoft’s Mark Kromer gives advice to businesses itching to move up. Feature
- See More: Essential Knowledge on SQL Server Business Intelligence Strategies
-
Big data a big deal for SQL Server 2012, users say
SQL Server 2012 is here, and the Apache Hadoop integration is making the biggest wave, according to some users. News | 11 Apr 2012
-
SQL Server 2012 ‘virtually’ out, Microsoft talks features, licensing
With SQL Server 2012 released in a “virtual launch” this month, Microsoft data platform specialist Mark Kromer tells us what his favorite features of the new release are. News | 14 Mar 2012
-
Cloaked in secrecy, Microsoft project aims to wed SQL, NoSQL databases
Microsoft technical fellow David DeWitt is secretly developing a data management system that can do the jobs of both SQL and NoSQL databases. Can he bring the two sides together? News | 01 Mar 2012
-
Microsoft SQL Server 2012 goes big -- data, that is
Microsoft database platform specialist Mark Kromer talks in this Q&A about Microsoft SQL Server 2012 “big data” capabilities, as well as what SQL Server has in store for open source and cloud computing this year. Q&A | 14 Feb 2012
-
SQL Server 2012, cloud, ‘big data’ driving momentum in 2012
With SQL Server 2012 coming out and the growing influence of the SQL Azure cloud and “big data,” the SQL Server landscape could see some major changes in the coming months. News | 13 Feb 2012
-
Microsoft StreamInsight charts course in unfamiliar waters
Microsoft StreamInsight, a complex event processing product, is a stab at a whole new space for the company, and not a bad one at that, experts say. News | 20 Oct 2011
-
Microsoft retooling SQL Server Master Data Services after 'vexing' debut
Microsoft’s master data management product in SQL Server, Master Data Services, drew tepid reviews from users, but the company has high hopes for a revamped release. News | 19 Oct 2011
-
Microsoft SQL Server, PDW reach out to Hadoop for big data processing
In this Q&A, Microsoft’s Mark Kromer discusses the company’s preview of SQL Server connectors for Hadoop and the shift to the Open Database Connectivity interface for data access. Q&A | 13 Sep 2011
-
Upgrade SQL Server; your BI system will thank you
Better performing BI systems are invaluable to businesses itching to get ahead. Upgrade SQL Server to a newer version, Don Jones says, and you’ll be a step closer. News | 09 Jun 2011
-
Q&A: With SQL Azure, Microsoft eyes giant leap to the cloud
It was cloud, cloud, cloud at Microsoft TechEd 2011. Microsoft’s Mark Kromer discusses the SQL Azure, what’s new with the cloud database offering and what’s to come. News | 07 Jun 2011
- See More: News on SQL Server Business Intelligence Strategies
-
More T-SQL statements in SQL Server 2012 you need to know about
In this second article of a two-part series on new T-SQL statements, expert Serdar Yegulalp reviews command changes to sequencing, date values and more. Tip
-
Three new T-SQL commands in SQL Server 2012 to make your life easier
Each release of SQL Server brings changes to Transact SQL. In this tip, expert Serdar Yegulalp gives a walkthrough of tweaks like WITH RESULT SETS for renaming columns and THROW for catching errors. Tip
-
Is cloud-based business intelligence a safe bet?
Cloud-based business intelligence has its attractions, especially for SMBs having a hard time supporting any BI in-house. But don’t forget to ask some crucial questions. Tip
-
Microsoft tailors BI capabilities for users, IT in SQL Server 2012
Industry watchers weigh in on Microsoft SQL Server 2012, which offers added business intelligence capabilities for end users and IT. Features include Power View and master data management. Tip
-
With familiar tools, new toys, Microsoft BI stack casts wide net
The Microsoft BI stack gains a few additions with release of SQL Server 2012, with new Excel-based Power View for business users and old standbys like Reporting Services. Tip
-
Scenarios abound for SQL Server Master Data Services
SQL Server Master Data Services, Microsoft’s master data management service, can be put to a number of different uses in businesses concerned about data quality and consistency. Tip
-
Map data flow from Microsoft PowerPivot to Excel, SharePoint
Microsoft PowerPivot, when used with Excel and SharePoint, lets business users manipulate data in Excel workbooks. But how do PowerPivot components fit into those environments? Tip
-
For SMBs, the data expedition starts with BI integration
The first step in any business intelligence (BI) implementation, according to consultant Don Jones is BI integration -- getting both BI and business systems in sync. BI for the SMB
-
SQL Server-Hadoop highway to 'big data' ventures into new territory
Microsoft’s SQL Server-Hadoop connectors bridge the structured, relational database world with the unstructured universe of big data. For DBAs, there’s a whole lot to get used to. Tip
-
With SQL Server data warehouse tables, think big
Along with the popularity of SQL Server data warehouses come huge data warehouse tables. To handle them, database administrators may need to tweak the traditional approach. Tip
- See More: Tips on SQL Server Business Intelligence Strategies
-
Problems exporting to Excel
SQL Server expert Eric Brown helps troubleshoots an issue encountered when exporting to Excel. Ask the Expert
-
Decreasing the size of a datafile
Business Intelligence expert Eric Brown offers advice on decreasing the size of a datafile. Ask the Expert
-
Visual Studio report processing error
SQL Server expert Eric Brown sheds light on an error message received when trying to run a Visual Studio report in Windows. Ask the Expert
-
database
A database is a collection of information that is organized so that it can easily be accessed, managed, and updated. In one view, databases can be classified according to types of content: bibliographic, full-text, numeric, and images. (Continued...)... Definition
-
intelligent database
An intelligent database is a full-text database that employs artficial intelligence (AI), interacting with users to ensure that returned items (hits) contain the most relevant information possible. This is in contrast to a traditional database, which... Definition
-
Customers react to Microsoft SQL Server preview
Microsoft previewed some of the features of its next SQL Server release, code-named Denali, at the PASS Summit 2010. SearchSQLServer.com got reaction from attendees. Video
-
Cloud efforts advance, SQL Server evolves
MVPs Brent Ozar and Kevin Kline discuss the implications of Microsoft’s latest cloud computing efforts and what they mean to SQL Server BI, virtualization and more. Podcast
-
More T-SQL statements in SQL Server 2012 you need to know about
In this second article of a two-part series on new T-SQL statements, expert Serdar Yegulalp reviews command changes to sequencing, date values and more. Tip
-
Three new T-SQL commands in SQL Server 2012 to make your life easier
Each release of SQL Server brings changes to Transact SQL. In this tip, expert Serdar Yegulalp gives a walkthrough of tweaks like WITH RESULT SETS for renaming columns and THROW for catching errors. Tip
-
Big data a big deal for SQL Server 2012, users say
SQL Server 2012 is here, and the Apache Hadoop integration is making the biggest wave, according to some users. News
-
Is cloud-based business intelligence a safe bet?
Cloud-based business intelligence has its attractions, especially for SMBs having a hard time supporting any BI in-house. But don’t forget to ask some crucial questions. Tip
-
SQL Server 2012 ‘virtually’ out, Microsoft talks features, licensing
With SQL Server 2012 released in a “virtual launch” this month, Microsoft data platform specialist Mark Kromer tells us what his favorite features of the new release are. News
-
SQL Server 2012 Guide
SQL Server 2012 Guide
-
Microsoft tailors BI capabilities for users, IT in SQL Server 2012
Industry watchers weigh in on Microsoft SQL Server 2012, which offers added business intelligence capabilities for end users and IT. Features include Power View and master data management. Tip
-
With familiar tools, new toys, Microsoft BI stack casts wide net
The Microsoft BI stack gains a few additions with release of SQL Server 2012, with new Excel-based Power View for business users and old standbys like Reporting Services. Tip
-
Cloaked in secrecy, Microsoft project aims to wed SQL, NoSQL databases
Microsoft technical fellow David DeWitt is secretly developing a data management system that can do the jobs of both SQL and NoSQL databases. Can he bring the two sides together? News
-
Scenarios abound for SQL Server Master Data Services
SQL Server Master Data Services, Microsoft’s master data management service, can be put to a number of different uses in businesses concerned about data quality and consistency. Tip
- See More: All on SQL Server Business Intelligence Strategies
About SQL Server Business Intelligence Strategies
For SQL Server DBAs and developers, business intelligence (BI) is far more than just a job function – it's a career opportunity. The growing reliance on critical data has made business intelligence an in-demand specialty, and IT professionals working with Microsoft SQL Server are best served by gaining experience in all facets of business intelligence strategies. This includes becoming familiar with not only the main SQL Server tools like SQL Server Analysis Services, Integration Services and Reporting Services, but also third-party alternatives and new Microsoft technologies like Master Data Services with SQL Server 2008 R2. This Microsoft SQL Server business intelligence strategies topic page features best practices, tutorials and other resources for DBAs and developers looking to improve their careers by focusing on the implementation of BI in SQL Server environments.