You may seem to find yourself in a predicament when you have a new server with a default set-up of PHP configuration. When you transfer your working website when it does not work as intended.
I was searching on the web how can this be? Does the new version, not accommodate the functions used previously. You might assume that, but the simple solution to the problem is the Date Timezone settings in the config or PHP.ini file. You just need to set it to your desired timezone. Once you have specified this, the functions should work as it used to before.
At least that what solved my problem.
Showing posts with label configuration. Show all posts
Showing posts with label configuration. Show all posts
Wednesday, December 11, 2013
Friday, February 8, 2013
MS SQL Roles
This is a good topic to discuss. MS SQL has made granular roles for specific tasks for each user, this is for security purposes of the Database Server.
You surely want certain database owner just to be able to access their database and nothing else. Or just allow them to do a backup of their own server, this is where the database or server level roles come in.
I'm familiar of some of the roles but not all of them and at times I also forget, which role overrides the other roles, or which role is not needed.
Microsoft has the list on their site on their server level role: http://msdn.microsoft.com/en-us/library/ms188659(v=sql.105).aspx
This looks an okay reference on which is the role needed and which is not.
There is also the database level role: http://msdn.microsoft.com/en-us/library/ms189121(v=sql.105).aspx
A little off topic, I found a great blog on MS SQL versions, the list is pretty good and you will also know which version you are using. Here is the link: http://sqlserverbuilds.blogspot.com/
You surely want certain database owner just to be able to access their database and nothing else. Or just allow them to do a backup of their own server, this is where the database or server level roles come in.
I'm familiar of some of the roles but not all of them and at times I also forget, which role overrides the other roles, or which role is not needed.
Microsoft has the list on their site on their server level role: http://msdn.microsoft.com/en-us/library/ms188659(v=sql.105).aspx
This looks an okay reference on which is the role needed and which is not.
There is also the database level role: http://msdn.microsoft.com/en-us/library/ms189121(v=sql.105).aspx
A little off topic, I found a great blog on MS SQL versions, the list is pretty good and you will also know which version you are using. Here is the link: http://sqlserverbuilds.blogspot.com/
Subscribe to:
Posts (Atom)