Cross database ownership chaining is a security risk. But, what’s a poor DBA to do when they need to provide data access between two databases? Luckily, there is an [...]
Cursors. Many database developers have to suppress a shudder of horror when they open up a stored procedure only to find a cursor lurking inside. They certainly have their place in the database developer’s arsenal of tools, but they can usually be rewritten as an easily understood set operation.
I’ve spent the first three [...]
That’s right, now you too can use T-SQL to get dates quickly!
Today at the client I came across the following chunk of SQL in a where clause:
dateadd(m,-24,(cast(datepart(m,getdate()) as varchar(2))+’/1/’+cast(datepart(yyyy,getdate()) as varchar(4))))
It’s used to return the first of the month two years ago. So, for today, this would return 2006-09-01
What’s wrong with this? [...]
My amazing co-worker pointed out a great post from Justin Etheredge on strategies for becoming a better developer.
Self-improvement is a huge thing for me, both personally and professionally. I like both Justin and Rick’s ideas – Emulate, Get Involved, Read, and Stretch.
My strategies tie these all together and are pretty simple, really: Learn [...]
I was catching up on the Information Architecture Institute mailing list and some feed reader backlog when I came across the concept of shingling. Seeing as how I have never heard of this term in the 8+ years I’ve been working, I decided it was high time that I learned about it.
In essence, shingling [...]
