SQL Server Magazine

PowerPivot Alpha Geek Challenge #2

The PowerPivot Team wants to see what you're made of! Win a $250 Microsoft Store shopping spree and a chance for a free trip to 2010 Microsoft BI Conference!

SQL Server PowerPivot: My Thoughts

Derek provides his thoughts on SQL Server PowerPivot and why the product is a game changer

Facebook’s New Settings Raise Data Privacy Questions

Brian discusses how Facebook's new privacy settings open up opportunities for marketers and criminals to use people's Facebook information to target them.

Top 5 Reasons Your Company Should Consider SQL Server PowerPivot

Derek provides a list of key SQL Server PowerPivot features that will propel the upcoming SSBI product beyond its competitors.

Gathering Deadlock Information with Deadlock Graph

Using the Deadlock graph event class lets you easily gather information on SQL Server deadlocks that you can display graphically in SQL Server Profiler or SQL Server Management Studio or review in XML for more detailed information.

Handling the Tree Path Request

Learn why the intuitive queries that address a common tree path request are optimized inefficiently, and discover alternative solutions with improved performance.

Are You Ready for Report Builder 2.0?

Report Builder 2.0

This reincarnated tool is easy to use but creates certain security risks when users modify reports.

Report Builder 2.0 Security

Report Builder vs. ReportViewer

2010 Microsoft BI Conference Details Surface

Derek provides an update on the elusive Microsoft BI 2010 Conference

Build a Policy-Based Management System for SQL Server 2008

Deal with the limitations of SQL Server 2008’s built-in policies by creating a table-driven solution that lets you insert policy exceptions and regulate policy execution.

MySpace Answers the Question: Why SQL Server?

MySpace executives give an inside look at how they implemented and scaled SQL Server to handle more than 400 databases.

Properties of Relations on Sets

The author discusses a fundamental topic in mathematical set theory to determine the properties of a relation represented by a table called R on a set represented by a table called V.

Installing Client Tools on a SQL Server 2008 Failover Cluster

Review: Enzo Audit 2009

Find poor-performing queries early in the development process using this security and performance monitoring tool from Pyn Logic.

Security Reporting for SQL Server Analysis Services

Implement this solution to provide data owners with a way to audit access to data they’re responsible for.

Managing Service Broker Conversations

Prevent data loss and improve performance by using this method to reduce conversation management overhead.

Upgrading a SQL Server 2005 Cluster to a SQL Server 2008

Minimize downtime when patching clusters by upgrading your SQL Server 2005 clusters to SQL Server 2008 to take advantage of its rolling upgrade functionality.

Microsoft PowerPivot Resources

Derek shares a wealth of valuable Microsoft PowerPivot resources to help kick-start your evaluations of the upcoming self-service BI platform.