Additional Articles

All authors

External Article

Introduction to MSSQL Server Analysis Services: Presentation Nuances:

In this article, we will examine a subject that is near and dear to broadly focused report authors - the use of cube structure to create desired cosmetic effects - in the Cube Browser, and more importantly, in a reporting environment. I constantly get e-mails, and see questions in forums and elsewhere, asking how to achieve effects that are not apparently "available" in "intuitive" cube structures, such as any of those that we see in the sample cubes. One of the apparent "shortfalls" that frustrate users is their inability to display the same dimension on both the "x-" and "y-" axes for presentation purposes.

2005-04-29

2,701 reads

Technical Article

The Advent of E3

A few months ago we ran a series of columns dedicated to defining each of the major disciplines of data integration: extract, transformation and load (ETL); enterprise application interchange (EAI); and enterprise information integration (EII). We also asked for input as to which method or methods of integration are in use, or planned to be used, in your organizations.

2005-04-27

1,232 reads

External Article

Formatted emails from SQL Server

Collaboration Data Objects, also called CDO, is designed to simplify writing programs that create or manipulate Internet messages. CDO for Windows 2000 is an integral part of the Windows 2000 and higher series of operating systems. It is easy to send SMTP email from SQL Server using CDOsys. It is an alternate method to SQLMail. This article illustrates how to use CDOSys to send formatted emails from Query Analyzer and SQL Server Alerts.

2005-04-25

4,639 reads

Technical Article

Managing the "Surface Area" of SQL Server 2005

As every developer knows by now, Microsoft has focused renewed attention on security in recent product releases. One of the important concepts in this effort is surface area. Roughly speaking, a piece of software has a smaller surface area if there are fewer ways to attack it: fewer open ports, fewer APIs, fewer protocols, and so on. OSQL Server 2005 takes this concept to the next level by letting you explicitly manage the software's surface area.

2005-04-21

3,226 reads

Technical Article

Using Ranking and Windowing Functions in SQL Server 2005

SQL Server 2005 is chock full of new features. You may have heard that you can write stored procedures in a CLR language like C# or VB .NET, but TSQL is here to stay. One new great feature adds the functionality of a Ranking expression that can be added to your result set that is based on a ranking algorithm being applied to a column that you specify. This will come in handy in .NET applications for paging and sorting in a grid as well as many other scenarios. We are going to take a look at the Ranking functions new to SQL Server 2005 using the new AdventureWorks database on the February 2005 Community Tech Preview.

2005-04-18

1,674 reads

External Article

Maintained by man and dog

As the online news service called NewsScape moves into its sixth year, it exhibits a lot of the characteristics of a child at the same age: It has a huge appetite for information, grows by leaps and bounds each year, and makes those who oversee it wonder if they can maintain control as it gets bigger. It is maintained by "a man and a dog – an aging golden retriever named Sambucus," according to the man, Andrew Clarke.

2005-04-15

1,744 reads

All authors

Blogs

Scooby Dooing Episode 9: The Case of the Artificially Intelligent Villain

By

Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton...

The Book of Redgate: Don’t be an a**hole

By

This was one of the original values: The facing page has this text: No...

Beyond Pipelines: How Fabric Reinvents Data Movement for the Modern Enterprise

By

For decades, enterprises have thought about data like plumbers think about water: you build...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

Are things getting beyond reason?

By skeleton567

My wife apparently ask her phone a question and below is what she sent...

I Love Editorials

By Grant Fritchey

Comments posted to this topic are about the item I Love Editorials

Visit the forum

Question of the Day

A Common Split

What happens when I run this code: 

DECLARE @s VARCHAR(1000) = 'apple, pear, peach'
SELECT *
FROM STRING_SPLIT(@s, ', ')

See possible answers