- Analysis Services
- Integration Services
- Reporting Services
- BI Strategies
- Data Warehousing
- Data Visualization
Email Alerts
-
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
-
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 | Thu Jun 09 00:00:00 EDT 2011
-
Q&A: Exploring what’s hot: SQL Server virtualization, PowerPivot, PDW
Want the inside scoop on SQL Server virtualization, PowerPivot, parallel data warehouse and the upcoming Denali? Microsoft database expert Mark Kromer discuss these year-driving trends and more.SQL in Five
-
Recommended practices for SQL Server Analysis Services aggregations
Aggregations produce faster queries, but they also increase the size of your Analysis Services database. See how to make the most of aggregations and what tools to experiment with.Tip
-
Creating and managing SQL Server Analysis Services partitions
Learn everything you need to know to build SSAS partitions from the ground up, with advice on binding, merging, and selecting partition data.Tip
-
Ensuring high availability of SSAS databases
In part three of this series, Baya Dewald hones in on the administrative side of SQL Server Analysis Services, with details on the various methods on high availability for SSAS.Video
-
Building a data warehousing and BI solution
In part two of his series, Baya Dewald breaks down the process of creating a data warehousing and business intelligence solution, with details on the SSAS objects and processing options involved.Video
-
An introduction to SQL Server data warehousing concepts
New to data warehousing? In this short presentation, SQL Server expert Baya Dewald offers an introduction to the basic components of data warehousing, with details on relational and multi-dimensional concepts for SQL Server Analysis Services (SSAS).Video
-
Sharing SSAS cube data in SharePoint with PerformancePoint Server 2007
Microsoft PerformancePoint Server 2007 turns SQL Server Analysis Services cube data into scorecards and dashboard applications that can be read company-wide in Microsoft SharePoint.Tip
- VIEW MORE ON : Analysis Services
-
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
-
Plan ahead for a smooth SQL Server migration
The thought of a SQL Server migration makes many organizations nervous, but they don’t have to be, writes consultant Don Jones. Get tips on making the switch simple.Tip
-
Microsoft SSIS basics: Tying it all together
SQL Server Integration Services (SSIS) is designed to make data integration between disparate systems easy. SQL Server expert Don Jones covers the Microsoft SSIS basics.The Reluctant DBA
-
How to execute scheduled tasks in SQL Azure: Use SSIS packages
Without SQL Agent in SQL Azure, it can be challenging to execute schedules tasks. But it’s not impossible. Learn how using SSIS packages to simulate SQL Agent functionality can help.Tip
-
Saving time with text data sources in SSIS
Text data sources are among the most common sources used with SQL Server Integration Services. Understanding how they work can help you avoid falling into the usual traps.Video
-
Using the Pivot transformation in SQL Server Integration Services
Pivoting is a useful way to transform data in SQL Server Integration Services (SSIS) -- but it's hardly intuitive.Video
-
Data Transformation Services vs. SSIS: The key differences
While SQL Server Integration Services 2008 is a major step up from the days of DTS, there are still some gotchas for developers to be aware of.Tip
-
Using package configurations in SQL Server Integration Services (SSIS)
Microsoft MVP Eric Johnson demonstrates how to use the Package Configurations option in SQL Server Integration Services and explains the value it brings to database developers.Video
- VIEW MORE ON : Integration Services
-
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
-
SSRS best practices for a trouble-free deployment
Running SQL Server Reporting Services requires skills ranging from administration to analytical. Get advice on how to keep deployments in top shape.Tip
-
Reporting Services 2008 R2 eases SQL Server report building
It’s true, Microsoft has put out a number of new BI technologies for SQL Server 2008 R2, but changes to existing tools like Reporting Services may hold the most value initially.Tip
-
Microsoft brings PHP integration to SQL Server Reporting Services
PHP isn’t just a Linux language anymore. With the help of a new SDK, developers can incorporate the scripting language with SQL Server reports.Tip
-
Creating matrix reports with Report Builder 3.0
Matrix tables display data similar to pivot tables, but setting them up for SQL Server requires an understanding of the basic components.Tip
-
Enter the matrix with Report Builder 3.0
Want to know what the matrix is? With SQL Server, just like the movie, it's best to see it for yourself.Tip
-
Geospatial mapping made simple with Microsoft SQL Server
The new spatial and analytic mapping functionality in Microsoft Report Builder is a great way to generate more dynamic SSRS reports – once you know how to create them.Tip
-
Adding a polygon layer to a map in Report Builder 3.0
The first step to putting a geospatial map in an SSRS report involves creating what's known as the polygon layer. This tip explains what that means and how to get started.Tip
- VIEW MORE ON : Reporting Services
-
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 | Wed Apr 11 12:49:58 EDT 2012
-
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 | Wed Mar 14 12:40:37 EDT 2012
-
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 | Thu Mar 01 13:33:49 EST 2012
-
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
- VIEW MORE ON : BI Strategies
-
In data warehousing, cost-benefit’s the issue with backup compression
Backup compression is well known to carry the benefit of cost savings to SQL Server shops, but organizations using SQL Server data warehouses may have a few more variables to consider.Tip
-
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 | Thu Mar 01 13:33:49 EST 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 | Tue Feb 14 10:35:08 EST 2012
-
Cost, proliferation power rise of SQL Server data warehousing
SQL Server data warehousing may have seemed a misnomer a few years ago. But many Microsoft shops with growing data needs are seeing the benefits of native products.News | Thu Jan 19 13:06:43 EST 2012
-
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
-
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
-
New to SQL Server PDW? First, tinker with client tools
Stepping into the SQL Server PDW environment means learning a whole new set of client tools. Learn about each as you take on Microsoft’s Parallel Data Warehouse.Tip
- VIEW MORE ON : Data Warehousing
-
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
-
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 | Mon Feb 13 12:04:42 EST 2012
-
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
-
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
-
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
-
Microsoft plays all the self-service BI angles with Project Crescent
Microsoft’s Project Crescent is still in development, but the company flaunted its flashy self-service BI tool at TechEd in Atlanta this spring, giving IT pros a good show of its abilities.Feature
-
Top reasons to get started with SQL Server Denali
The upcoming SQL Server Denali is chock-full of new features, such as super-fast column-store indexes and a new Web-based reporting tool. But what does it mean for businesses?Feature
-
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
- VIEW MORE ON : Data Visualization