Category: SQL Server

0

Find SQL Database Owner with T-SQL

One thing that on occasion bugs me about PDW or APS or whatever it happens to be called this week is the lack of a UI to do things. I’m not one of those...

0

SQl Server 2014 CTP1

CTP 1 of SQL Server 2014 was released this evening. If you have an MSDN or TechNet account you can go grab it now! If you are curious about some of the features here...

SSIS 2012 Deadlock When Running SSIS from SQL Agent Job 7

SSIS 2012 Deadlock When Running SSIS from SQL Agent Job

I recently had an interesting situation where an SSIS package was scheduled to run at 1 AM but failed with a deadlock message. This seems a bit strange given that it was a deadlock...

3

Exporting Data Using BCP

BCP, or bulk copy program, has been around in SQL Server for a long time. It is a great way to export large quantities of data very quickly from SQL Server. It can be...