I was working in a test enviroment on a Windows 2003 Server with SQL Server 2005 and the views I created run fine. Now I have moved over to our production enviroment and I am receiving an error.
Error converting data type DBTYPE_DBTIMESTAMP to datetime.
There are no bad dates in the table however there is a date of 1/15/1905. I cannot figure out what is the bad date. Is there a setting in SQL I can change? I am running queries against a linked server.
by Mark Wills
Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server... So if you are the accidental DBA, or, simp…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so.
This will be demonstrated using Adobe Premiere Pro CS6.
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"!
Step 1: Open a new google tab
Step 2: Go to the left hand upper corn…