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
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,901 reads
A short look and some notes from the SQLServerCentral.com site migration.
2007-03-20
2,364 reads
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
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
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
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
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,744 reads
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
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.
2007-03-13
3,271 reads
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
By Steve Jones
A customer wanted a report they could email to their boss about jobs, something...
By Chris Yates
In the world of modern data infrastructure, SQL databases remain the backbone of enterprise...
Comments posted to this topic are about the item Single User SQL Server on...
Comments posted to this topic are about the item All the Costs of Downtime
Comments posted to this topic are about the item How Well Does the MSSQL...
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers