InterWorks Blog: Sql
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 | 
Dec 13
2012
A common question I've received from new Vertica users is, "How do I enter newlines into a string literal, or use other backslash sequences like '\t'?" This is especially common from users...[more]
Jul 07
2012
Loading data into Teradata can be done quickly and fairly easily using the Teradata FastLoad utility, but the utility isn’t exactly friendly to new users. This article provides a quick introduction...[more]
Apr 19
2012
Summary/Purpose
The purpose of this article is to explain a few instances of how an “Object Server Not Found Error” may occur and to show how to modify your Veeam database to fix your jobs in the...[more]
Feb 20
2012
Let me tell you a secret about working with SQL Server. Anyone can do it. I’m not going to imply that it’s easy. You can’t do it in 24 hours and it’s certainly not for dummies … but...[more]
Jul 14
2011
I ran across this multiple times over the last two years or so. This issue started with the introduction of the AMD tri-core processors, and continued when Intel released the hexa-core processors....[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 13
2010
With the advent of C# 3.0, Microsoft introduced the Language Integrated Query (LINQ) feature to provide .NET developers the ability to query and transform data using any .NET language. This...[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]
