Email Alerts
-
Is self-service BI the answer?
Business intelligence is a hot topic in 2010, especially with the upcoming release of Microsoft's SQL Server 2008 R2 being dubbed as the "BI release." In this e-zine, one SQL Server expert breaks down exactly what goes into self-service BI, where it ... E-Zine
-
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
-
SQL Server DBAs must get ready to take on 'big data' and more roles
Leaders of the Professional Association for SQL Server say today's DBAs have to handle 'big data' and more types of tasks than ever before. News | 14 Nov 2012
-
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
- See More: News on SQL Server Business Intelligence Strategies
-
Three tricky questions BI systems can answer
Should a small or medium-sized business 'trust its gut' or get a BI system? Don Jones shows three examples of things you can't determine without BI. Tip
-
BI for the SMB: Don't give away business intelligence
With the various challenges SMBs face, securing their business intelligence efforts may seem unimportant. Not so, says expert Don Jones. Find out why. Tip
-
Great new SSIS features for BI developers
SQL Server 2012 has many features, but a few make SSIS much easier for BI developers. Check out this tip by expert Robert Sheldon to learn more. Tip
-
Ramp up your SMB's BI skills
The next frontier of BI skills is undoubtedly the SMB. Read this tip from expert Don Jones to start preparing now. Tip
-
Power View packs ample ways of seeing SQL Server business intelligence
Data can be viewed in any number of ways using Microsoft’s new BI tool, according to expert Robert Sheldon. But the application does have its limitations. Tip
-
SQL Server Power View makes BI reporting look simple
SQL Server 2012’s business intelligence tool puts report building in users’ hands. Read this tip from expert Robert Sheldon to how to get started. Tip
-
SQL Server BI for the SMB: Prepackaged BI tools vs. do-it-yourself
Since several companies have geared business intelligence tools toward midmarket companies recently, options for SMBs are growing. Should you buy a SQL Server BI tool out of the box, or create one in -house? Tip
-
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
- 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
-
SQL Server DBAs must get ready to take on 'big data' and more roles
Leaders of the Professional Association for SQL Server say today's DBAs have to handle 'big data' and more types of tasks than ever before. News
-
Three tricky questions BI systems can answer
Should a small or medium-sized business 'trust its gut' or get a BI system? Don Jones shows three examples of things you can't determine without BI. Tip
-
BI for the SMB: Don't give away business intelligence
With the various challenges SMBs face, securing their business intelligence efforts may seem unimportant. Not so, says expert Don Jones. Find out why. Tip
-
Great new SSIS features for BI developers
SQL Server 2012 has many features, but a few make SSIS much easier for BI developers. Check out this tip by expert Robert Sheldon to learn more. Tip
-
Ramp up your SMB's BI skills
The next frontier of BI skills is undoubtedly the SMB. Read this tip from expert Don Jones to start preparing now. Tip
-
Power View packs ample ways of seeing SQL Server business intelligence
Data can be viewed in any number of ways using Microsoft’s new BI tool, according to expert Robert Sheldon. But the application does have its limitations. Tip
-
SQL Server Power View makes BI reporting look simple
SQL Server 2012’s business intelligence tool puts report building in users’ hands. Read this tip from expert Robert Sheldon to how to get started. Tip
-
SQL Server BI for the SMB: Prepackaged BI tools vs. do-it-yourself
Since several companies have geared business intelligence tools toward midmarket companies recently, options for SMBs are growing. Should you buy a SQL Server BI tool out of the box, or create one in -house? Tip
-
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
- 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.