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.
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]
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]
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]
SQL Server: The index "[IndexName]" on table "[TableName]" cannot be reorganized because page level locking is disabled.
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]
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]
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]
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]
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]
code, function, meme, sql, sql server, stored procedure, synchronization, synchronize, t-sql, triggers, yo dawg