Search
Monday, February 17, 2020

ExWeeto

Friday, July 21, 2017

TurboDNN

Author: ExWeeto

TurboDNN is part of a set of SQL scripts for improving the performance and stability of websites running on DNN Platform.

Comments (0) Number of views (2378)
Read more

Categories: CMS, DNN, Database, MSSQL

Tags:

Monday, March 21, 2016

DNN SQL Database Housekeeping

Checking table sizes and truncating log files

Author: ExWeeto

Here are some key methods for keeping your DNN database (MS SQL Server) tidy.

Comments (0) Number of views (2793)
Read more

Categories: CMS, DNN, Database, MSSQL

Tags:

Saturday, September 05, 2015

Copy a Table from One Database to Another on Different Clients

Author: Exweeto

I wanted to copy the contents of a table of links from one database to another. Both databases are hosted on the cloud-based hosting platform where I host all my sites; they are the backends of DNN instances. Problem is, while I can access my databases from my local machine using MS SQL Server Management Studio (SMS), and I can connect to each database concurrently, I could not find any way to use standard SQL commands to copy the content of a table in one database to an equivalent table in another; it came up with permissions problems no matter what I tried. Here is my solution; there are probably other solutions (e.g. export to CSV, import CSV), and some may be better, but this is how I did it!

Comments (0) Number of views (1603)
Read more

Categories: Database, MSSQL

Tags:

Qualifications & Certifications

  • B.Sc. (Physics & Applied Maths)
  • M.Sc. (Astrophysics)
  • CompTIA A+
  • CompTIA Network+
  • CompTIA Security+

I also completed the EC-Council CEH (Certified Ethical Hacker) course in 2015 and, while I have since let the certification lapse, I am aware of the principles of ethical hacking / penetration testing and use many of these in-house where I work.

Experience & Interests

“If I had eight hours to chop down a tree, I'd spend the first six of them sharpening my axe.”

Abraham Lincoln

Copyright 2020 by Exweeto Terms Of Use Privacy Statement