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 using SQL Server 2008’s new Data Profiling task, you can do a lot to ensure that data being imported via SSIS is valid, and you can develop a system that can take the necessary steps to correct the commonest problems. Bob Sheldon shows you how to get started with it.
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
I’m doing a small series on indexing basics for SQL Server, and on May...
Jl. Pantai Indah Selatan Blok DF No.1 & 2, Kapuk Muara, Kecamatan Penjaringan, Jkt...
By Quay thu XSMN hôm nay - quay thu MN - KETQUA.TV
Jl. KH.Moh.Mansyur No.15 F, Duri Pulo, Kecamatan Gambir, Kota Jakarta Pusat, Daerah Khusus Ibukota...
BCA KCU DAAN MOGOT Hub.0851•8812•0691 Jl. Daan Mogot No.95, Wijaya Kusuma, Kec. Grogol petamburan,...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers