Stress
As a DBA, stress is probably a given in your career, but are you aware of the effects on others. Andy Warren takes a look at the effects of stress, how you can identify them and a few ways to cope.
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.
The Enterprise Library for .NET Framework 2.0
What does a SQL Server developer care about the Enterprise Library? SQL Server guru David Poole is starting to work with .NET and brings us his perspective on what this library is and how it benefits those who develop against SQL Server.
Executing a Package from Visual Basic
So you've created a SQL Server package and now you're ready to integrate it into your Visual Basic application? In this series, Brian Knight will show you how to use the DTS object model to execute a DTS package from Visual Basic.
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.
Read Only Tables
Do you know how to setup a read-only table in SQL Server. Steve Jones takes a look at a few methods to achieving this and examines the pros and cons of choosing different methods.
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.
Windows and SQL Server 2005 Clustering Architecture
Before you start learning how to cluster, this video will show you the basics on how clustering in Windows 2003 and SQL Server 2005 works. Brian shows the basic architecture on clustering as well as the checklist that you would want to follow before starting to cluster.
Considerations for Data Warehousing
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.
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.
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers