IW on Facebook
After the amazing show Tableau Software put on for us at this year's Tableau Customer Conference, the BI community was abuzz with excitement about the upcoming Tableau 8. Fortunately, we weren't kept...[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 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