SQL Server Magazine

		Options
Donald Farmer on Managed Self-Service BI SQL Server 2008 R2 unveils Gemini, a technology that Donald Farmer calls "the next generation of business intelligence technology." Gemini offers self-service BI, breaking down the walls between information workers and knowledge workers.		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

Donald Farmer Discusses the Benefits of Managed Self-Service BI

Microsoft’s Donald Farmer explains how SQL Server 2008 R2’s Gemini will benefit both end users and IT pros.
By Michael Otey  , et al.

Checking Backup Status on Multiple SQL Server Systems

Use this method to generate a simple backup status report that you can use to ensure all your SQL Server systems are backed up when they’re suppose to be.
By Sivakumar Mahalingam 

How SQL Server CLR and C# Can Solve a Common Problem

Ever need to create temp tables with cursors in T-SQL to mimic the utility of an array? You can use the array in C# to easily provide a solution to a common need: the transposition of a query’s result set.
By Leo Flores 

Monitor SQL Server 2008 with OpsMgr

The SQL Server management pack in Microsoft System Center Operations Manager 2007 can help you monitor SQL Server 2008 locks, space utilization, backup jobs, and more.
By Kerrie Meyler 

Use SSIS to Access WMI Data on Multiple Servers

Using SSIS's WMI Data Reader task, you can collect a lot of useful information about the hardware and software installed on your servers.
By Gabriela Nanau 

Getting Started with BI

Despite the fact that SQL Server’s BI capabilities have been around for more than 10 years many SQL Pros don't use them. So what’s so hard about BI? I think you can sum it up with the three Ts: terminology, technology, and tools.
By Michael Otey 

Stored Procedure Retrieves Information About Partitioned Tables

SQL Server Management Studio (SSMS) doesn't have a GUI that lets you easily obtain information about partitioned tables. Here's a stored procedure that helps fill this gap.
By Shaunt Khaldtiance 

Date and Time Support in SQL Server 2008

Four new date- and time-related data types in SQL Server 2008 address the limitations of previous versions’ DATETIME and SMALLDATETIME data types.
By Itzik Ben-Gan 

SQL Server 2008 R2: 5 Cool New Features

Support for 256 logical processors, a new Master Data Services feature, and BI-oriented Project Gemini are some of the SQL Server 2008 R2 features in our top five list.
By Michael Otey 

AbaPerls

Automate and script SQL Server database tasks and schema objects quickly and easily using this set of command-line tools.
By Kevin Kline 

Review: DBMoto 6.6

DBMoto 6.6 solves the problem of cross-platform communication through real-time database replication between almost all popular database platforms
By Michael Otey