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
Author: Mohit
Microsoft Data, Analytics & AI - Sr Cloud Solution Architect
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
Granting Execute Permissions
Following code can be used to Grant Execute Permissions to a Database Role, in a database. This is for SQL Server 2000; because in 2000
Normalizing-Denormalized Tables
I hope to write more article as time permits, but this is my first article that I posted on SQL Server Centrals :). I hope
Important Links for SQL Server 2008
Features Supported by the Editions of SQL Server 2008 http://msdn.microsoft.com/en-us/library/cc645993.aspx SQL Server 2008 Encryption Hierarchy http://msdn.microsoft.com/en-us/library/ms189586.aspx SQL Injection http://msdn.microsoft.com/en-us/library/ms161953.aspx Understanding and Manging the suspect_pages Table
SQL Canada (SQLCAN) 