T-SQL Tuesday #65 – Learning Computed Columns for XML

It’s T-SQL Tuesday time again, and this month the invite comes from Mike Donnelly (@sqlmd). The topic is Teach Something...

The May Blogger Challenge–Continuing On

Last month I participated in Ed Leighton-Dick’s April Challenge. My four posts were tagged the April Challenge, and this month...

Security Through Chaos

A company Steve Jones knows uses a diverse network infrastructure to help provide security.

Illegal CTEs

Windows Phone – What Should Microsoft Do?

I’ve been intrigued by Windows Phone as a platform. I’ve never owned one, and while I considered getting one, the...

QA for Data

Often DBAs and developers might make quick data changes to correct user problems or application shortfalls. Steve Jones notes that we can make mistakes, and perhaps we should ensure we QA, or at least log, our changes.

Have you tried DLM Dashboard?

DLM Dashboard is a new product from Redgate Software that’s free. Free as in beer, which should be attractive to...

SQL Prompt – Killing the Detail Box

I love SQL Prompt and use it constantly. When I don’t have it, my code writing process slows to spurts...

Pre-built or Ad Hoc

Steve Jones talks about the ad hoc nature of some NoSQL databases and whether that's something that most users want.

Temp Table Names