-
Thoughts on 20060704
The Declaration of Independence is a truly inspirational document. It signified the birth of a young, confident, and optimistic nation at the time. My son and I watched and participated Independence Day parade organized by the local government and other organizations on July 4th. On a personal level, I feel deeply, deeply grateful to America…
-
Grant user permissions to create jobs in Sql Server 2005
Security model for Sql Server Agent 2005 has been revamped. DBAs will have better granular control over job creation, execution, and browsing. There are newly created roles in msdb for those purposes: SQLAgentUserRole, SQLAgentReaderRole, and SQLAgentOperatorRole. For more information, go to this url in Book On Line: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/719ce56b-d6b2-414a-88a8-f43b725ebc79.htm A lot of times, you may want…
-
Defining NO ACTION foreign key constraints in Oracle
In both Oracle and Sql Server, when creating a foreign key constraint on a child table, the default option is NO ACTION, meaning that this constraint will prevent the deletion or update of a parent key if there is a row in the child table that references the key. One popular option is CASCADE, meaning…
-
DTA works against Sql Server 2000 databases
Index Tuning Wizard morphed into Database Engine Tuning Advisor (DTA) in Sql Server 2005. The idea is still the same. You feed it with some profiling results, and it will make some recommendations. Sql Server Profiler 2005 still has the same look and feel of Profiler 2000. It does have some enhancement when picking event…
-
Stop junk mail, save the environment
Credit card companies are sending junk credit card application offerings now to my first grader. Just unbelievable. I used this site, https://www.optoutprescreen.com/opt_form.cgi, a few years ago to stop unwanted mail for myself. It did get rid of a lot of my junk mails, although not all of them. Overall, it made a big difference and…