Implementing Common Reference Data in a Data Warehouse
This article provides an architecture and process framework for implementing common reference data in a data-warehousing environment.
This article provides an architecture and process framework for implementing common reference data in a data-warehousing environment.
Indexes directly affect the performance of database applications. This article uses analogies to describe how indexes work. The estimated execution plan feature of the Query Window is utilized to compare the performance of two queries in a batch.
We often see ways to improve your career, but there's a flip side as well. In the spirit of our "worst practices" series, Steve Jones takes a look at ten skills that could cost you your job if you can't perform them.
A few notes and comments on the database news from the previous week.
An exploration of the process of translating a conceptual model to a logical model, and ultimately, a faithful implementation using T-SQL.
This article presents ten business analysis guidelines, representing best practices from successful projects.
The SQL Server 2005 merge replication engine introduced breaking changes that can cause data loss for both MSDE and SQL Server Express subscribers. Find out how this bug manifests itself in a real-world scenario.
The first part of a great video series from Chris Shaw of SQL Oncall that walks you through a mock interview and gives advice on how you can present yourself in the best light.
One of the most requested features from SQL Server developers is the integration of source control with T-SQL code. SQL Server Management Studio brings some integration with Visual Source Safe and longtime SQL Server author Raj Vasant explains it to us.
Dealing with NULL database values in ASP.NET.
Buckle up, database wranglers! Nowadays, SQL DBAs hold the keys to a company's most...
By DataOnWheels
Picture this, your data ingestion team has created a table that has the sales...
By Brian Kelley
I did a post last month titled RTO and RPO are myths unless you've...
I have the user Managed identity <myusermanagedidentity> , granted it carte blanche alter...
First off, my apologies for what could potentially be a bad title! I am...
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers