SQLServerCentral Editorial

Trade-offs

When working on a project, you have to make trade-offs. Unfortunately, some managers don't realize this. Steve Jones says we need to help them understand that doing things the right way, and working with trade-offs, makes for better systems.

External Article

Power View Infrastructure Configuration and Installation: Step-by-Step and Scripts

This document contains step-by-step instructions for installing and testing the Microsoft Business Intelligence infrastructure based on SQL Server 2012 and SharePoint 2010, focused on SQL Server 2012 Reporting Services with Power View. This document describes how to completely install the following scenarios: a standalone instance of SharePoint and Power View with all required components; a new SharePoint farm with the Power View infrastructure; a server with the Power View infrastructure joined to an existing SharePoint farm; installation on a separate computer of client tools; installation of a tabular instance of Analysis Services on a separate instance; and configuration of single sign-on access for double-hop scenarios with and without Kerberos. Scripts are provided for all/most scenarios.

Blogs

How AgentDBA Identifies Backup Failures

By

Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...

Tip: Expanding a SQL statement

By

In all recent versions of the database you can call DBMS_UTILITY.EXPAND_SQL_TEXT to get the...

AI Helps Me with My Sloppiness

By

I type fairly well. Well, I type fast, but I do wear out a...

Read the latest Blogs

Forums

From SQL Server On-Premises to Claude Desktop: How I built a Full MCP Pipeline

By Cláudio Tereso

Comments posted to this topic are about the item From SQL Server On-Premises to...

Independence Day 2026

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Independence Day 2026

Independence Day 2026

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Independence Day 2026

Visit the forum

Question of the Day

Independence Day 2026

In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.

See possible answers