Technical Article

Face to Face

The cost of fuel is rising, telecommuting is becoming more widespread, and the advance of digital technologies has us often working virtually, even in the same office. Steve Jones thinks we shouldn't forget the value of a little face time and and then.

Technical Article

Build a Metadata-Driven ETL Platform by Extending Microsoft SQL Server Integration Services

SQL Server 2008 Integration Services (SSIS) provides a flexible and scalable architecture that enables high-performance data extract, transform, and load (ETL). The Microsoft Business Intelligence Center of Excellence has extended SSIS to a metadata-driven platform to more effectively build, deploy, and manage ETL processes in large data warehousing environments.

Technical Article

Data Warehouse Capacity Planning as Capacity Enforcement

Capacity planning is a problem for a data warehouse because it sets contrasting functional requirements against each other. On one hand, data warehouse customers consume data warehouse capacity as they query the data in the data warehouse business intelligence (BI) reporting. Meanwhile, applications consume data warehouse capacity as they load data into a data warehouse through the extract, transform and load (ETL) process.

Blogs

Monday Monitor Tips: Intelligent Alert Thresholds

By

At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert...

A New Word: los vidados

By

los vidados – n. the half-remembered acquaintances you knew years ago, who you might...

In-Person CISA Training – April 13-16, 2026

By

I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...

Read the latest Blogs

Forums

String_agg not working as needed

By DaveBriCam

I'm trying to get this string_agg to put all the 'comments' into one result...

Vectors in SQL Server 2025

By Daniel Calbimonte

Comments posted to this topic are about the item Vectors in SQL Server 2025

Odd Sequences

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Odd Sequences

Visit the forum

Question of the Day

Odd Sequences

What values are returned from this code?

CREATE SEQUENCE NumericSequence
    AS NUMERIC(5,1)
    START WITH 1.0
    INCREMENT BY 0.1;
GO
SELECT NEXT VALUE FOR NumericSequence
GO
SELECT NEXT VALUE FOR NumericSequence
GO

See possible answers