Dataphor
Over the years, there have been several attempts to turn conventional RDBMSs into object relational databases, by inserting an intermediate layer. The driving force behind this was the generally-held assumption that the relational model could not handle complex data types.
Exporting and Versioning Lookup Data: A Real-World Use of the CLR
The CLR has not been well-received and most people use it for Regular Expressions and string functions. Here is an example that goes beyond trivial uses.
Parameterizing Number of “Look Back” Periods with the MDX LastPeriods() Function, Part I
Parameterization of MDX functions is one of those things that cannot be delivered solely via graphical MDX Editor – but then, you really didn’t think that you could avoid actually touching MDX at all, did you? BI Architect Bill Pearson demonstrates a way to parameterize the highly useful LastPeriods() function.
SQL Server Disasters with Preventive Measures
Have you seen disasters in your environment? I would bet you have at some point. Let's see if our top 13 disasters matches your experiences.
Rules, Defaults and the SQL Standard
I see, with some relief that the threatened removal of Rules and Defaults in SQL Server 2008 hasn’t happened. There has been a stay of execution. Even though they are documented, they still come with a dire warning that they are deprecated and will be removed in future versions. They have fallen foul of the SQL Standards committee, and we are now supposed to use check constraints instead.
The Back Door DBA
Steve Jones is taking well-earned break. In his guest editorial slot, Brad McGehee discusses three simple techniques to help DBAs manage their time more effectively.
T-SQL Data Processing
This article from new author Peter Kierstead shows us how to implement your own "fuzzy" dedup/merge logic without resorting to RBAR in T-SQL.
Execute SQL statements in Integration Services
This tutorial walks you through the process of adding SQL statements to your SSIS packages and bundling them into logical units of work if necessary.
Blogs
Data Céilí 2026 Call for Speakers!
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...
Streamlining Azure VM Moves Into Availability Zones
By John
One of the more frustrating aspects about creating an Azure virtual machine is that...
Monday Monitor Tips: Native Replication Monitoring
By Steve Jones
Redgate Monitor has been able to monitor replication for a long term, but it...
Forums
Cara Reschedule Tiket Pesawat Pelita Air
QBerikut cara Reschedule tiket Pelita Air, melalui WhatsApp 087.7576.449.51, Jelaskan alasan anda ingin melakukan...
Think LSNs Are Unique? Think Again - Preventing Data Loss in CDC ETL
Comments posted to this topic are about the item Think LSNs Are Unique? Think...
Question of the Day
A Big PK
In SQL Server 2025, how many columns can be included in a Primary Key constraint?
See possible answers