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.
SQLServerCentral.com Site Migration
A short look and some notes from the SQLServerCentral.com site migration.
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.
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.
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.
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.
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.
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.
PowerSMO At Work Part I: DBA Scripts and Functions
Dan Sullivan delves deeper into PowerSMO, the versatile command line utility for managing SQL Server databases. Using a certificate strategy, he provides a step-by-step guide to creating and deploying secure, signed DBA scripts. He then describes how to use PowerSMO functions to manage the extended properties of SQL Server objects.
An Introduction to Dynamic Management Views and Functions in SQL Serve
The purpose of this article is to introduce you to Dynamic Management Views (DMVs) and Dynamic Management Functions (DMFs) at a high level; in later articles, I will drill down into how specific DMVs and DMFs can be used to help you performance tune your servers and databases.
Blogs
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers