Email Alerts
-
Understanding Microsoft SQL Server business intelligence options
Microsoft has made a great effort to turn SQL Server into a viable enterprise database platform, and part of that has been boosting its business intelligence capabilities. In this handbook, read about recent BI updates in SQL Server 2012. See how Mic... E-Handbook
-
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
-
Intel boosts Moore's Law with SQL 2012 business intelligence
Intel is keeping Moore's Law on track with the self-service BI features of SQL 2012 business intelligence. Feature
-
When to consider SQL Server Enterprise Edition
Is SQL Server Enterprise Edition the right choice for you? Expert Robert Sheldon explains the advantages to consider when making your selection. Feature
-
Little-known features of Microsoft SQL Server 2012
When it comes to Microsoft SQL Server 2012, it's easy to think you've seen it all. Andrew Novick shows Microsoft still has surprises up their sleeve. Feature
-
More predictions on 2013 SQL Server trends from Denny Cherry
What can you expect from Microsoft in 2013? Find out which SQL Server trends can be anticipated this year from SQL Server expert Denny Cherry. Feature
-
Denny Cherry's 2013 predictions (and wishes) for SQL Server trends
What new developments will SQL Server users see in 2013? Expert Denny Cherry predicts SQL Server trends to expect this year. Feature
-
Brian Larson talks SQL Server business intelligence
Author Brian Larson shares his wisdom and insight regarding SQL Server business intelligence and makes some suggestions for companies new to BI. Q & A
-
Excerpt: The many levels of SQL Server 2012 business intelligence
Business intelligence allows you to analyze your data and effectively make decisions with it. Read this excerpt from Brian Larson to learn more. Excerpt
-
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
- See more Essential Knowledge on SQL Server Business Intelligence Strategies
-
Microsoft unveils GeoFlow 3-D SQL Server mapping tool
Microsoft GeoFlow gives premium Excel users the ability to do 3-D mapping with SQL Server on the back end. News | 15 Apr 2013
-
SQL Server big data technologies should be a major DBA focus
Microsoft platform architect Mark Kromer says in this Q&A; that DBAs need to start focusing on SQL Server big data technologies to stay up-to-date. Q&A; | 25 Mar 2013
-
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
- See more News on SQL Server Business Intelligence Strategies
-
In-memory SQL Server: The implications of integration
How is in-memory SQL Server different from SQL Server with a bunch of RAM? SQL Server guru Serdar Yegulalp explains what to know before you install. Tip
-
BI as a Service: Tips for scaling your BI system...in human terms
BI systems are great...if you can get your employees to use them. How do you make your system scalable? Read this tip from Don Jones to find out. Tip
-
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
- 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
-
Understanding Microsoft SQL Server business intelligence options
Microsoft has made a great effort to turn SQL Server into a viable enterprise database platform, and part of that has been boosting its business intelligence capabilities. In this handbook, read about recent BI updates in SQL Server 2012. See how Mic... E-Handbook
-
Intel boosts Moore's Law with SQL 2012 business intelligence
Intel is keeping Moore's Law on track with the self-service BI features of SQL 2012 business intelligence. Feature
-
Microsoft unveils GeoFlow 3-D SQL Server mapping tool
Microsoft GeoFlow gives premium Excel users the ability to do 3-D mapping with SQL Server on the back end. News
-
SQL Server big data technologies should be a major DBA focus
Microsoft platform architect Mark Kromer says in this Q&A; that DBAs need to start focusing on SQL Server big data technologies to stay up-to-date. Q&A;
-
When to consider SQL Server Enterprise Edition
Is SQL Server Enterprise Edition the right choice for you? Expert Robert Sheldon explains the advantages to consider when making your selection. Feature
-
Little-known features of Microsoft SQL Server 2012
When it comes to Microsoft SQL Server 2012, it's easy to think you've seen it all. Andrew Novick shows Microsoft still has surprises up their sleeve. Feature
-
More predictions on 2013 SQL Server trends from Denny Cherry
What can you expect from Microsoft in 2013? Find out which SQL Server trends can be anticipated this year from SQL Server expert Denny Cherry. Feature
-
Denny Cherry's 2013 predictions (and wishes) for SQL Server trends
What new developments will SQL Server users see in 2013? Expert Denny Cherry predicts SQL Server trends to expect this year. Feature
-
Brian Larson talks SQL Server business intelligence
Author Brian Larson shares his wisdom and insight regarding SQL Server business intelligence and makes some suggestions for companies new to BI. Q & A
-
Excerpt: The many levels of SQL Server 2012 business intelligence
Business intelligence allows you to analyze your data and effectively make decisions with it. Read this excerpt from Brian Larson to learn more. Excerpt
- 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.