2007-03-21
1,074 reads
Articles
Introduction to Data Warehousing Part 1
In Part 1 of this extensive series, Wes Dumey starts some of the core concepts of data warehousing. In this video he covers what a data warehouse is, why companies use them and what are some of the key components.
2007-03-21
3,746 reads
More Problems with Data Warehousing
In response to the first part, new author Richard Gardner brings us a few more issues that you should be aware of when planning
your data warehouse.
2007-03-20
5,906 reads
SQLServerCentral.com Site Migration
A short look and some notes from the SQLServerCentral.com site migration.
2007-03-20
2,367 reads
Mastering Enterprise BI: Time Intelligence Pt. II
BI Architect Bill Pearson continues his introduction to enhanced features in Analysis Services 2005 for Time Intelligence support. In this session, we examine new, wizard-driven features that support the easy addition of Time Intelligence within our cube.
2007-03-20
2,669 reads
Designing A Data Warehouse: Part 1 Dimension Types
In this first part of a multiple part series, Brian Knight shows the different types of slowly changing dimensions you'll use and the business reason for using each type.
2007-03-19
4,753 reads
Different forms of CrossJoin
This article is about different syntactical ways to write CrossJoin in MDX, all of which are completely equivalent from the functional and performance standpoint. Therefore, the article doesn't convey any practical information, and can be ignored. Readers curious about history of MDX can keep reading, however.
2007-03-16
3,902 reads
Build Date Generators and Manipulate Date and Time Data in SQL
Learn how to build date generators without loops using SQL, and some useful techniques to help you manipulate date and time data.
2007-03-15
3,878 reads
SQLServerCentral.com Web Site Migration
We're moving our web server to the UK this weekend, so there will be a bit of downtime Friday night.
2007-03-14
1,745 reads
J2EE and SQL Server: Making a JDBC Connection
Using a SQL Server back end with a Java application server may sound like an unnatural proposition but there's no need to bow to such arbitrary limitations. In this article you'll get step-by-step instructions on making a JDBC connection between the four most popular Java application servers and Microsoft SQL Server.
2007-03-14
2,136 reads
Blogs
Flyway Tips: AI Helps with Commit Messages
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
Startup scripts in SQL Server containers
I was messing around performing investigative work on a pod running SQL Server 2025...
Using SQL Compare with Redgate Data Modeler
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Forums
What is Page Density
Comments posted to this topic are about the item What is Page Density
T-SQL in SQL Server 2025: Fuzzy String Search II
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Azure-SSIS, Self-Hosted Integration Runtime, & Data Gateway?
Looking to confirm my understanding of these three products and how they can be...
Question of the Day
What is Page Density
In SQL Server, there is a concept of page density. This is determined by how much data is stored on each page. What is a page density of 90%?
See possible answers