Ran across this little gem when needing to change the schema of all tables in a given database.
Obviously you’ll exchange “new_schema” with the schema of your choosing. From Ruslan Trifonov’s blog.
exec sp_MSforeachtable "ALTER SCHEMA new_schema TRANSFER ? PRINT '? modified' "
Needed a quick way to check if a key / value pair existed in an array of structures in Coldfusion.
Came up with this little number.
I’ve recently moved from Windows 7 to OS X. I’m keeping my PC keyboard though and one of the most disturbing differences I’ve found between the two OSes is the lack of support for the Home and End keys. So here’s the fix:
- Create the following file, if the directories don’t exist on your system, create them.
- You’ll want to add the following bindings. You’ll need to logout and in to see the bindings take effect.
Also note that these don’t work in terminal. There are other instructions online for that app, do some Googling.
"\UF729" = "moveToBeginningOfLine:";
"\UF72B" = "moveToEndOfLine:";
"$\UF729" = "moveToBeginningOfLineAndModifySelection:";
"$\UF72B" = "moveToEndOfLineAndModifySelection:";
There are some times when I’d like to view different parts of the same file while editing. This can be accomplished by setting up a multi-pane layout using View > Layout. Then when a file opened in a tab do File > New View Into File. This will create a second tabbed view of the file, you can then drag this tab into the second pane you opened earlier.
Each tabbed view will scroll independently, as it should, but changes to the file will show in both views.
So what is DSN Changer? For the layman, DNS is a translation service that runs on thousands of servers spread out all over the world. When you navigate to google.com, your browser first checks with a DNS server to translate that human readable google.com into an IP address — 220.127.116.11 in my case — and that address is what the browser actually uses to send it’s request for the page.
The DNS server you’re PC uses is normally set by your ISP automatically, although some advanced users choose to set their DNS themselves for various reasons.
So let’s say you got a virus, and that virus went and changed your DSN settings without your knowledge, what happens next? Since your DNS server address was changed to the bad guys DNS server, he can now give you a bad translation. So the next time you go to google.com, he might actually send you to another server not even owned by Google. He could do this for any website address out there including banks, health providers, the government, etc. You get the concept.
So do your research at www.dcwg.org and run a DNS check to make sure you’re not affected.