Additional Articles


External Article

Introduction to MSSQL Server Analysis Services: Named Sets Revisited

In this lesson, we revisit Named Sets, a subject that we undertook in my article MDX in Analysis Services: Named Sets in MDX: An Introduction, in March of 2004. There, we introduced Named Sets from the perspective of the MDX query language, having obtained brief exposure to the concept of Named Sets earlier in the MDX in Analysis Services series (Using Sets in MDX Queries). We examined Named Sets as they existed within Analysis Services 2000, touching upon them from the perspective of Analysis Manager, the Cube Editor, and related interfaces in Analysis Services.

2005-12-15

2,193 reads

External Article

Scripting Database Objects using SMO

With the introduction of SQL Server 2005, Microsoft has created a new .NET management API for SQL Server called SQL Management Objects (SMO). As I started working with SQL Server in earnest following its release I discovered a few limitations that I hoped to correct using SMO. This article describes those problems and how to use SMO to script database objects.

2005-12-14

2,552 reads

External Article

Database Geek of the Week - Scott Forsyth

After interviewing a number of database geeks, it struck me that many of them focus on one area of database development. Hilary Cotter specializes in replication, for example, while Itzik Ben-Gan focuses on Transact-SQL (see http://www.simple-talk.com/categories/sql-articles). Scott Forsyth is no different, but his area of expertise is more unusual: web hosting using .NET technology.

2005-12-09

2,034 reads

External Article

Secrets of successful IT projects

Some time ago, I worked on a team that was attempting to define an IT strategy for a large multinational company. Management incorrectly thought the company was unique in that it had a high number of failed IT projects. In fact, only one in four IT projects can be termed successful, if the benchmarks of success are adherence to scheduled completion time and budget, and realization of the project goal, whether that be saving money, growing the business, or what have you. I have to explain this because many of you may never have come across one.

2005-12-05

3,803 reads

External Article

Using SQL Server 2005 sqlcmd Utility

SQL Server 2005 provides some new command line utilities. One such utility is "sqlcmd". The sqlcmd utility is used to run adhoc queries interactively from a command prompt window, or can be used to execute a script containing T-SQL statements. The sqlcmd utility is a great improvement over osql and isql of older releases of SQL Server. In this article, I will explain some of the features this new command line utility brings to administering SQL Server.

2005-12-02

1,391 reads

Blogs

The Benefits of Teaching

By

Even preparing for a class or seminar with set materials takes a lot of...

Power BI, Excel, OneLake – Dreams Do Come True!

By

I can’t believe it’s finally here! A way to have Excel live in OneDrive...

The Book of Redgate: What Our Staff Says

By

This image is from 2010, and it goes along with my last post of...

Read the latest Blogs

Forums

Deny Connect problem

By Brandie Tarvin

I have a login I need to deny connect to on a server, but...

Website Stability 2025/12/05

By Steve Jones - SSC Editor

All week we've had issues with the site being up and down. There's been...

403 Forbidden

By Phil Parkin

I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's...

Visit the forum

Question of the Day

Fabric Mirroring

In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?

See possible answers