February 2014 – www.myw0.com

Understanding Microsoft SQL Server System Databases

02/28/2014

A database server application such as Microsoft SQL Server uses a lot of information in order to operate. Considering the purpose of a database is to store information, it only makes sense that SQL Server dips into its own technology for storing and accessing the information required for operating in a set of its own databases. Each of the databases used plays a specific role in the operation of the SQL Server. The system databases use the same components…

Trigger That Will Remove All Blanks Spaces From a Field

02/21/2014

| No Comments

| MySQL, SQL

If you are importing data into a table and some of the data like a customer fields has blank spaces on it and you want to get rid of then a trigger for Insert event may a quick solution. Here is a request: “ Is it possible to create a trigger that will remove all blanks from a field? They have an check number and when we read it through Import process, it keeps putting random spaces in the…

Disable IE Enhanced Security in Windows Server 2012

02/11/2014

| No Comments

| Windows 2012

This is just a quick guide to disabling the setting that makes Internet Explorer less secure or it could be done in a test environment. When IE ESC is enabled, you get popups all the time and you are asked to add every new url to the IE trusted sites zone. So, on a dev, test or lab server, it is ok to disable it, at least if you ask me. As long as you are aware of what you are doing…

Month: February 2014

Understanding Microsoft SQL Server System Databases

Trigger That Will Remove All Blanks Spaces From a Field

Disable IE Enhanced Security in Windows Server 2012

Menu

Contact Info

–