Latest Posts

How To: Backup SQL Server Databases to Azure


Adding “the cloud” to your data center’s high availability/disaster recovery scheme is a bewitchingly tempting proposition. An infinitely scalable product that is always being replicated to datacenters across the globe for your protection? Who wouldn’t want that? Answer: folks on a budget. Today I’m going to show you the simplest — possibly most inexpensive —…

Read More

What does the -n parameter of the bcp command specify?


Question: “What does the -n parameter of the bcp command specify?” Answer: “Use native format.” The bcp utility is used to perform bulk copies between Microsoft SQL Server and flat data files. It is often used to insert large numbers of new rows into tables, or to run large exports into .csv (or other format)…

Read More

Allow Drop and Create in the SQL2014 Table Editor


Q:  I went to change a column to a Primary Key with an Identity specification on a table in SSMS, but when I hit save I got an error message saying the table would have to be dropped then recreated. I’m ok with this. How can I set SSMS to allow drop and create in…

Read More