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.
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.
As we retain more and more data, it becomes important not just to decide how long to retain different types of data, but also to identify that data that can be removed. Steve Jones talks about some of the challenges of this with databases.
As we retain more and more data, it becomes important not just to decide how long to retain different types of data, but also to identify that data that can be removed. Steve Jones talks about some of the challenges of this with databases.
As we retain more and more data, it becomes important not just to decide how long to retain different types of data, but also to identify that data that can be removed. Steve Jones talks about some of the challenges of this with databases.
This video shows you how to perform one of the core functions of a DBA: performing a full backup. The use of Management Studio is shown in this video.
The PASS Summit is coming this November and SQLServerCentral.com is looking to throw another great party.
This article is about Resource Governor. A new feature introduced in SQL Server 2008. Special focus is placed on the T-SQL implementation of the new feature.
Coordinating the release of software among all the groups involved can be quite a chore. Steve Jones comments on some of the challenges.
In the latest articles of our series dedicated to SQL Server 2005 Express Edition, we have been discussing Service Broker. This article describes the initial setup of components required to demonstrate a distributed implementation, with initiator and target services residing on two separate computers.
By Steve Jones
A customer was testing Redgate Data Modeler and complained that it auto-generated PK names....
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
By Steve Jones
fawtle – n. a weird little flaw built into your partner that somehow only...
Hi all, I recently moved to a new employer who have their HA setup...
Comments posted to this topic are about the item Semantic Search in SQL Server...
Comments posted to this topic are about the item Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers