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.
Click to get started.01
May 2012
0 comments |
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]
10
May 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]
15
Jan 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]
05
Jan 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]
14
Dec 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]
30
Sep 2009
code, function, meme, sql, sql server, stored procedure, synchronization, synchronize, t-sql, triggers, yo dawg
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]
