SQLAuthority News – Introduction to expressor Connectivity to Salesforce – expressor Data Integration Applications

This month, expressor software is releasing the newest version of their data integration product – expressor 3.5.  This release includes three significant enhancements to this powerful and adaptable product: an extensibility framework, integration with Melissa Data’s data quality tools, and operators to read from and write to Salesforce.com databases. As…
Read More

SQL SERVER – FIX – ERROR : Msg 3201, Level 16 Cannot open backup device.Operating system error 3 (The system cannot find the path specified.)

I had very interesting and frustrating experience. Recently I was attempting to backup one of my database and I end up on following error. Msg 3201, Level 16, State 1, Line 1 Cannot open backup device ‘D:\Backup\SQLAuthority.bak’. Operating system error 3(The system cannot find the path specified.). Msg 3013, Level…
Read More

SQL SERVER – Explain Error:166 : does not allow specifying the database name as a prefix to the object name – Puzzle to Win SQL Server Interview Questions and Answers Book

I was recently reading excellent Just Learned Tip regarding 3 part naming Cannot be used when dropping Views,Functions or Procedures. This is quite a well known tip however, every developer and DBA learns at sometime in their career with ‘hm…’ moment. To illustrate this further here is a simple case…
Read More