I was generating scripts in the Management Studio for all objects. Everything looked great; I created my new database with same structure. Before I let
Author: Mohit
Microsoft Data, Analytics & AI - Sr Cloud Solution Architect - Engineering
.SQL Files Being Perceived as Text Files
When trying to open SQL File on the web through Internet Explore (IE) sometimes it will show the file right in IE because it thinks
Error 14274: Cannot add, update, or delete a job (or its steps or schedule) that originated from an MSX server.
You can get this error when trying to modify the properties of a Job after the SQL Server has been renamed or cloned into another
Schema Binding: Views
Schema Binding is there to stop the accidentally removal of required columns from a table. If SCHEMABINDING is in the create statement of an object
MCITP: Database Administrator
Just come from writing my 70-444 exam. I have to say I am glad I wrote the 70-443 first, because that test was ALOT of
Database Mirroring: Fully Quanlified Domain Name (FQDN) Error
If you are trying to setup Database Mirroring, it prefers to see a FQDN for the servers when entering partner information. If you don’t you’ll
SQL Canada (SQLCAN) 