InterWorks Blog: Sql Server
Seeing as we're the experts, we thought we'd share some of our intel. But beware, this level of inside information may cause extreme shock and awe. If you get lost, just fire up a flare - we'll come and get you.
Dec 21
2012
In this video I describe the concept of Source Code Control and demonstrate how you can use source code control (in this case Redgate’s SQL Source Control) to manage changes in your SQL Server...[more]
0 comments | 
Jun 08
2012
I was writing a query today and came across a set of data with an annoying leading space. Or what I thought was a leading space. My first instinct was to throw this around my field:
LTRIM(RTRIM([SKU...[more]
May 01
2012
Last year, Microsoft unveiled the new core licensing model for SQL Server 2012 Enterprise Edition. It's a sensible change, but they are also doing away with user licensing, that's where I throw my...[more]
May 10
2010
If you've managed production database servers for any amount of time, you may have run into this error message in your maintenance plan logs. "The index "[IndexName]" on table "[TableName]" cannot be...[more]
Jan 15
2010
In SQL Server 2005 and 2008 it's possible to start an agent job with T-SQL syntax. This is frequently useful. For example, you may have a job that you'd like to have an outside application invoke....[more]
Jan 05
2010
A few weeks ago we had a very odd problem our LANDBOSS nightly build site. Every time we tried to access the reports it would asks us for authentication. This would be the HTTP...[more]
Dec 14
2009
A client recently requested that we add Reporting Services to his existing install of SQL Server 2005. I didn't think much of this task until I ran the setup and found that the checkbox for Reporting...[more]
Sep 30
2009
SQL Server User Defined Function Synchronization: The "yo dawg" method.
A client we've worked with for some time had an interesting SQL problem for me recently. These guys usually have interesting...[more]
