2006-10-13
1,555 reads
2006-10-13
1,555 reads
2006-10-12
1,458 reads
Is your company trying to accelerate cycle times, lower costs, improve responsiveness, ensure compliance with policies and best practices, and increase customer satisfaction? Well, of course! That's why you need a comprehensive approach to managing your organization's business rules
2006-10-05
2,259 reads
This article takes a look at SQL Server 2005 Reporting Solutions as applied to Business Intelligence systems.
2006-09-20
2,868 reads
What is data quality? How do you measure it and how does it affect your data warehouse? SQL Server warehousing expert Janet Wong brings us a look at what data quality is and what it means to you.
2006-09-18
8,489 reads
True business value lies in using the data model as an entry point for a program of data management that treasures data as the most valuable corporate asset.
2006-08-22
1,643 reads
What type of things do you need to look at when setting up a data warehouse? Hardware is a big one as well as the settings for the server, which may be substantially different than transactional systems most DBAs work with. Warehousing expert Vincent Rainardi brings us the next installment in his data warehousing series with some advice on what you should be looking for.
2006-08-16
11,633 reads
Master data management (MDM) and eXtensible Business Reporting Language (XBRL) are two key technologies that promise to address important information management issues. Ventana Research believes both will enable companies to reduce the cost, time and effort needed to collect, analyze and use information, whether for visibility, decision support or process execution. Some observers may see them as competing approaches, but in practice each has capabilities best suited to some applications and not others. Even where they overlap, the two may not be mutually exclusive. We advise companies that have not yet begun investigating XBRL and MDM to do so immediately, and all organizations should begin developing skills in using them.
2006-08-16
1,436 reads
In Part 2 of this series, Wes Dumey talks about some of the key tables in a data warehousing scenario. He covers fact tables, dimensions and some of the other tables you'll see in a data warehouse. Free registration required.
2006-08-02
2,444 reads
Continuing with his fantastic series on data warehousing. Vincent Rainardi brings us the next installment, which takes a look at upgrading the various components of your data warehousing system.
2006-07-31
16,287 reads
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Comments posted to this topic are about the item The Hidden Security Risks of...
Comments posted to this topic are about the item The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers