SQL Server SELECT

A query that is slow that should be fast (e.g. underlying tables are not enormous, has been fast in the past, etc. - I'll let you dete...

Using OPENQUERY in a stored procedure in a Visual Studio SQL Server project will result in the following warning. SQL70558: The column de...

I recently had a requirement to "copy" the data between two identical database schemas. Actually the requirement was to "reb...

For those unfamiliar with TFVC it is one of the two version control engines shipped with Team Foundation Server, available with Visual Studi...

And...it's here! Looks like it was made available 12pm Eastern on June 1st, 2016.

For a long time I felt like a crazy person for constantly closing documents in SSMS just because I could not easily access the documents tha...

Pragmatic Works offers a Salesforce.com Source component as part of its Task Factory SSIS component library. Using this component along wit...