Scary Questions
I spent most of my time at TechEd two weeks ago, volunteering to answer attendee's questions at Microsoft's SQL Server 2008 booth.
Create a computed column in SQL Server using XML data
Create a computed column in SQL Server using XML data and optimize SQL queries. Learn how to create a function for XQuery and use it within the computed column formula.
Taming Trees: B-Trees
Learn how to build a B-tree similar to those used by databases to implement indexes.
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.
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
Have you done a Mid year check in?
Comments posted to this topic are about the item Have you done a Mid...
From SQL Server On-Premises to Claude Desktop: How I built a Full MCP Pipeline
Comments posted to this topic are about the item From SQL Server On-Premises to...
Independence Day 2026
Comments posted to this topic are about the item Independence Day 2026
Question of the Day
Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers