What does it mean when a file is modified?

Does date modified mean date saved? Read more →

How can I execute t-sql with a Proxy account

SQL Server Agent job failures with tighter security upon server migration Read more →

How to fix operating system error code 80(The file exists.) in SQL Agent Job during BULK LOAD

SQL Server Agent job failure with an Operating system error code 80(The file exists.) error Read more →

How to bcp export file with encoding ascii

Question: I have a bcp command exporting a sql query which outputs to a file . The problem is the file is being saved as Unicode type - causing a subsequent ETL process to fail. How can I fix? I want the file to export as ascii encoding bcp "select * FROM myTable" queryout E:\mytable.csv -w -t, -T -S SERVER\MYINST1 Answer: The quick answer is to ask you to add the -c and -C switches. From SQL Server Books Online "-c Performs the operation using a character data type. This option does not prompt for each field; it uses char... Read more →

A great way to Link SQL Server and MongoDB with BI Connector

Step 1 - Ensure MongoDB BI Connector is installed and configured . This will support the access to the MongoDB server. How to unlock the secrets of MongoDB BI Connector Step 2 - Install MongoDB ODBC Driver for BI Connector - provides connectivity between a SQL client and the MongoDB Connector for BI More details on https://docs.mongodb.com/bi-connector/master/reference/odbc-driver/ Step 3 - Create the System DSN You'll need the following base information to connect to the MongoDB BI Connector Server Name\Port User. Password Read further for full details of the Create System DSN options Step 4 - Create the Linked Server This... Read more →