Using the OUTPUT Clause to Capture Identity Values on Multi-Row Insert
SQL Server 2005 introducted the OUTPUT clause which we can use to capture values from the inserted and deleted virtual tables.
2006-08-25
4,352 reads
Additional Articles
Other MDX Entities: Perspectives
Leverage Perspectives, new to Analysis Services 2005, through MDX. BI Architect Bill Pearson leads hands-on practice with this means of visually focusing data retrieved from the UDM.
2006-08-24
2,599 reads
How do I install SQL Server 2005 Express Edition and SQL Server Manag
With the release of SQL Server 2005 Express Edition and the SQL Server Management Studio Express, Microsoft has entered the small, free database market with a splash trumping even their own Microsoft SQL Desktop Edition. Although it is free, it is still important for you to install this application correctly, Scott Lowe shows you how.
2006-08-23
3,214 reads
Old Model DA Model
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
How Do I create an XML document from undefined legacy data?
This article explains how to transform a nebulous application requirement like "take a flat file that was produced by an upstream mainframe application and produce an XML document for a downstream application," into a flexible working solution.
2006-08-18
2,197 reads
Mastering Enterprise BI: Introduction to Perspectives
Support information consumers with easier navigation and more focused analysis choices. In this article, BI Architect Bill Pearson leads hands-on exposure to Perspectives, another new Analysis Services 2005 feature.
2006-08-17
2,516 reads
XBRL or Master Data Management?
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
Maintaining SQL Server 2005 Databases - Backups
In this presentation for SQL Server newbies, you'll learn how to maintain your SQL Server databases by backing them up regularly and reindexing them. This topic assumes you know nothing about SQL Server and also covers some of the decisions you'll have to make when you decide you want to backup your database through maintenance plans.
2006-08-15
2,658 reads
SQL Server 2005 – Unattended installation – Part V
In this section of this series, I am going to demonstrate how to install SQL server 2005 service pack 1, to update the server components using command line options.
2006-08-14
1,548 reads
Backup Basics Part 3: General Tips for a Backup Strategy
Knowing how to configure backup applications and select backup media is half the battle of designing a successful backup strategy. The other half is choosing how and when to back up the specific pieces of data that are stored on your servers, share points, and workstations. In this final article of his series on backup basics for new technicians and administrators, Ryan Faas offers some suggestions to help you make these important decisions.
2006-08-11
2,967 reads
Blogs
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Setting PK Names in Redgate Data Modeler
By Steve Jones
A customer was testing Redgate Data Modeler and complained that it auto-generated PK names....
Flyway Tips: AI Deployment Script Descriptions
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
Forums
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Semantic Search in SQL Server 2025
Comments posted to this topic are about the item Semantic Search in SQL Server...
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers