Current Category Subscribe to the RSS feed for this category
SQL Server
Parent Categories
All Categories
Child Categories
Analysis Services
Bunch,

Concatenating output from a SELECT statement is a pretty basic thing to do in SQL. The main ways to perform this would be to use either the CONCAT() function, the || operator or the + operator. It really ...

Bunch,

When I am writing up stored procedures in SSMS sometimes I need to know what column types are used in a table. For instance I will know the table name but I might not remember exactly the length of a varchar ...

Paul Petrov,

When using WCF receive adapter with SQL binding in Polling mode please be aware of the following problem. Problem: At some regular but seemingly random intervals the application stops processing new requests, ...

ScottKlein,

One of the hotest technology topics of the day is Azure. Being a SQL guy, I am all over this technology, especially SQL Azure. So much so that Herve Roggero and I are currently writing a book for APress ...

ScottKlein,

One of the hotest technology topics of the day is Azure. Being a SQL guy, I am all over this technology, especially SQL Azure. So much so that Herve Roggero and I are currently writing a book for APress ...

Staff of Geeks,

Geekswithblogs.net - May 2010 Newsletter Was your newsletter messed up? If the first newsletter we sent was all white with links all over the place, I apologize. We haven’t sent a newsletter in quite some ...

Robert May,

I’m going to write my history with Agile here. That way, in future posts, I can refer back to it, instead of typing it out in the post that contains information you may actually want to read. Note that ...

Leonard Mwangi,

I recently had a client request to create an SSIS package that would loop through a set of data in SQL tables to allow them to complete their data transformation processes. Knowing that Integration Services ...

Dave Noderer,

Found an interesting thing that others have run across but it is the first time I’ve seen it. A customer emailed to say that the SQL 2008 db that I had helped him with seemed to be going into recovery ...

onefloridacoder,

I was installing TFS on my local laptop last week and just got around to setting up my initial collection using the TFS Console tool and “Bang!” I received a message that told me that my local database ...

Wes McClure,

After years of dabbling with different version control systems and techniques, I wanted to share some of what I like and dislike in a few blog posts. To start this out, I want to talk about how I use VCS ...